campaign_id Is Different in the Destination Than in Twitter's UI
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 that Twitter presents in the Twitter Ads UI.
For example, the campaign_id 25058204 in the Twitter UI is actually relayed as ex318 to the destination.
Fivetran Transformations and functions/views in the destination (client-side solution) can help fix the issue.