Campaign_ID Is Different in Destination Than Twitter UIlink
Why is the
campaign_id in the destination different than in Twitter's UI?
Connector: Twitter Ads
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.
For example, the
25058204 in the Twitter UI is actually relayed as
ex318 to the destination.
The two possible fixes are Fivetran Transformations and functions/views in the destination (client-side solution).