Where intelligence is put to the test.

B2B Berkshire Hathaway Subsidiary

John Crenshaw in

Mar 06

Summary: 🚀We helped a B2B Berkshire Hathaway subsidiary backup and integrate historic analytics data into 3rd party executive reporting tools for 5 different websites.

 

This client needed to back up historic Google Analytics data from Universal Analytics to a BigQuery data warehouse before Google shut down UA and that data was lost.

They also needed to integrate that historic data with GA4 for continuity of reporting.

We developed a data schema for backing up historic UA data into BigQuery, then combined that with GA4 data and pulled it all into a Looker dashboard for executive reporting.

Key project tasks

  1. Backup and preserve historic universal analytics data in BigQuery
  2. Connect GA4 data to BigQuery to preserve client’s future data
  3. Connect dashboarding / reporting tools to pull from both historic and current GA data sources in BigQuery
  4. Build executive dashboards for reporting of that data and other connections
  5. Ongoing maintenance and support for that work

Written by John Crenshaw

More from John Crenshaw
Related Articles

Ready to talk? We’re listening.

If you have questions we have answers. And probably some questions for you, too.

Let’s get after it!

Let's Get Started