Connector Improvement: Account IDs for CM360
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.
-
Official comment
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 -
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
Please sign in to leave a comment.
Comments
2 comments