Connector Improvement: Campaign Manager connector improvement
Completed
We’d like to see a star schema implemented for the Campaign Manager connector, similar to what’s already available on other connectors.
Separating entity attributes (campaigns, accounts, etc.) into dedicated dimension tables, with the fact table containing only IDs and measures, would greatly improve data consistency. This structure would help address the retroactivity issue where name changes aren’t always reflected historically, ensuring accurate and reliable historical reporting.
-
Official comment
Hi Lucas (great name!),
We are currently rolling out metadata tables for this connector. You can view the ERD here: https://fivetran.com/connector-erd/double_click_campaign_manager and read the release notes here: https://fivetran.com/docs/connectors/applications/google-campaign-manager-360/changelog#august2025.
We are unable to add these new tables to the legacy version of the connector. To sync these tables, you'll need to create a new Campaign Manager connection. We also support multiple reports on the same connections now.
Let me know if you have any questions, and feel free to contact our support team if you run into issues. I'm going to mark this request as completed.
Cheers,
Luke
Please sign in to leave a comment.
Comments
1 comment