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
Choosing the Right Enterprise SEO Agency: 2026 Vetting Guide

Scaling organic search for a large organization is fundamentally different from small business SEO. You're not just optimizing a few dozen pages; you're managing tens of thousands, or even millions,…

How to Do a Website Audit That Actually Boosts Revenue

So, you need to do a website audit. At its core, this means systematically breaking down your site’s technical health, on-page content, and user experience to find out what’s holding…

7 Powerful YouTube Dashboard Examples to Master Your Channel in 2026

YouTube's native analytics are powerful, but they don't always tell the whole story or connect performance to your broader marketing goals. A well-designed dashboard transforms raw data into a strategic…

Data driven marketing strategies: A Practical Growth Guide

Data-driven marketing strategies live and die by the quality of your customer data. It's the bedrock. Without a solid foundation, you're just guessing. Confused about where to start? Get a…

How to Calculate Marketing ROI and Prove Your Real Impact

Let's cut right to the chase. The simplest way to figure out your marketing return on investment is with this formula: (Revenue - Marketing Investment) / Marketing Investment. This little…

The Ultimate 10-Point PPC Audit Checklist for 2025

Pouring money into PPC campaigns without regular, in-depth audits is like navigating a maze blindfolded. You're moving, but are you getting closer to your goal? Many businesses leak significant portions…

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