campaign_id Is Different in the Destination Than in the X UI

Question

Why is the campaign_id in the destination different than in the X UI?

Environment

Connector: X Ads

Answer

According to X documentation, campaign identifiers (campaign_id) are the base-36 representation of the base-10 value that X presents in the X Ads UI.

For example, the campaign_id 25058204 in the X 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.