Campaign_ID Is Different in Destination Than Twitter UIlink

Questionlink

Why is the campaign_id in the destination different than in Twitter's UI?

Environmentlink

Connector: Twitter Ads

Answerlink

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 campaign_id 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).