Question
Why is the campaign_id in the destination different than in Twitter's UI?
Environment
Connector: Twitter Ads
Answer
According to Twitter's Documentation, campaign identifiers (campaign_id) are the base-36 representation of the base-10 value they present in the Twitter Ads UI.
So for example, the campaign_id, 25058204, (in Twitter UI) is actually relayed as ex318 to the destination.
Possible fixes:
- Fivetran Transformations
- Functions/Views in Destination (client-side solution)