If you’re migrating from Google Analytics Universal to Google Analytics 4, you’ll need to upgrade your reporting to a new data schema.
Analysts will have to write and rewrite multi-page SQL queries over and over again to achieve an exact match between Google Analytics Universal and Google Analytics 4 metrics. But you can avoid those challenges.
Instead of copying and pasting normalization logic across dozens of SQL queries, you can do it once during the data modeling phase. This selection of SQL templates for Google Analytics 360 and Google Analytics 4 schemas is definitely a go-to solution for those who have regular ad hoc reporting needs.
Get instant access. We'll also email you a copy.
Every number below comes straight from our customers — on camera. Click any card to watch them say it.
Hours → minutes
Something that used to take a couple of hours – pulling five or six reports from Shopify, Google Analytics, Klaviyo – I now do in minutes, and I know it's the correct answer.
For 10 years, we couldn't get a source of truth. Now we make very high-quality decisions quickly. Literally in five minutes.