Hi Supermetrics Community,
I’m currently on the 14-day free trial and need some urgent help with data blending. My core use case is connecting Google Analytics, Google Ads, Meta Ads, and Shopify to build marketing performance reports.
Shopify connection worked perfectly - built reports easily and very happy with that experience.
However, I’m stuck with blending ad platforms and analytics data. Here’s what I’ve tried:
1. Manual blending: Attempted inner join on date across Facebook Ads, Google Ads, and GA4. The results are completely off - seeing 5-10x the actual values for November. This duplication happens even when pulling single metrics like Facebook spend or Google Ads cost after the blend.
2. Ads + Analytics connector: Tried using this but the connector isn’t working at all - connection fails.
What I’m trying to achieve is straightforward: total ad spend across platforms, combined impressions, revenue from GA4, and calculated ROAS metrics. Essentially blending ad platform data with analytics data for funnel reporting.
I’m confident I’m not the first person trying to do this, and I really need to get this working in the next couple of days to build a case for moving to a paid plan.
Would really appreciate guidance on:
• Best approach to blend these data sources correctly
• Why I might be seeing duplicated data
• Alternative methods if manual blending isn’t the right solution
Thanks so much for any help you can provide!
Best,
Adhip