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.