I'm trying to create a data extension with everyone who has ever opened or clicked on an email in it...
The challenge is, that we used to have a SFDC + ExactTarget integration prior to migrating to MarketingCloud fully.
The _Open and _Click tables have SubscriberKey data which was populated by SFDC and is a hexadecimal as well as SubscriberKey data populated by SFMC which is an email address (our primary identifier).
As such, the data is a bit useless using SubscriberKey as identifier and I want to use the Subscriber ID.
However, when creating a target data extension i'm running into an issue where it is not recognizing that i have specified the field type as being 'number' and is providing me with an error suggesting it isn't referencing a number field to the Subscriber ID...
Any idea how to resolve?