Hello everyone,
I hope you're doing well.
I have four separate Google Analytics accounts (Belgium, France, Germany, and NL) that I blended in Looker Studio using a Full Join. My goal is to calculate total metrics such as Total Users and Total Sessions across all four sources.
However, when I compare the blended total with the sum of the individual totals (calculated manually by adding up the values from each source separately), the numbers do not match.
I suspect it might be due to duplication, missing values, or the way aggregation works in Looker Studio, but I’m not sure. Here are some details:
- The blending key I used is Date.
- Each Google Analytics source tracks the same website but for different regions.
- Some channel groups (e.g., "Organic Shopping") exist in one source but not in others.
My questions:
- What could be causing the discrepancy between the blended data total and the manually summed values?
- Is Full Join the right approach, or should I use a different type of blending (e.g., Union or Left Join)?
- How does Looker Studio handle metric aggregation in blended sources, and is there a way to force it to sum correctly?
Any insights or best practices would be greatly appreciated.
Thank you in advance for your help!
Best regards,
LinkedIn
Twitter
