Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Account IDs for CM360

Completed
Marc Soares User

The CM360 connector currently returns the profileId (ID of the user profile) and the advertiserId (ID of the advertiser). We need to obtain the platform account ID, which is the ID of the client/organization account in CM360. This will allow us to differentiate between clients and map to other client data.

If the account ID cannot be added to the existing report tables, then it would be sufficient to include a separate metadata table in the schema that lists all the advertiser-account relationships. We could then join with the report table on the advertiserId to associate the account IDs with the CM360 data.

Please sign in to leave a comment.

Comments

4 comments

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi Marc,

    Luke from the Product team here. Thanks for submitting this request!

    We plan to add metadata tables to this connector in the upcoming quarter (ending in July). We need to make a few changes to the connector to support multiple reports/tables because right now it only syncs a single custom report.

    When we add those metadata tables, we'll add new account and advertiser tables. You'll be able to join reports using the advertiser table using the advertiserId, then to the account table using an accountId FK. 

    Let me know if that does not work for your use case. 

    Thanks,
    Luke

  • Marc Soares User

    Hi Luke,

    That's great news! It sounds like the metadata account and advertiser tables will give us the information we need. Looking forward to testing it out when it's available!

    Thanks,

    Marc

  • Lucas Alexander Fivetranner

    Hi Marc, 

    Just following up here to share that the connector now supports syncing metadata. You can read the release notes here: https://fivetran.com/docs/connectors/applications/google-campaign-manager-360/changelog.

    For a full list of metadata tables the connector syncs, see the Google Campaign Manager 360 ERD. Only connections created on and after August 11, 2025, support syncing metadata tables, so you'll need to create a new CM360 connection to sync the metadata tables. 

    Let me know if you have any questions.

    Luke

  • Marc Soares User

    Thanks Luke. We are now using the new metadata tables and it is working well for our use case.