B2B Berkshire Hathaway Subsidiary
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
- Backup and preserve historic universal analytics data in BigQuery
- Connect GA4 data to BigQuery to preserve client's future data
- Connect dashboarding / reporting tools to pull from both historic and current GA data sources in BigQuery
- Build executive dashboards for reporting of that data and other connections
- Ongoing maintenance and support for that work
More recent projects
Using AI to filter spam leads and reclaim 20 hours a month
We helped a client reclaim 20 hours a month by using AI to automatically filter out spam leads.
Dashboarding and Reporting for a Leading Architecture Firm
We helped a leading architecture firm get the most out of GA4 and Looker Studio.
B2B Ecommerce SEO
We helped a B2B ecommerce client increase SEO traffic more than 1,700% in just a few years, increasing revenue from $800k to $3.4mm annually.
Want results like these?
Let's talk about where you are, where you want to go, and the smartest way to get there.
Contact Us