Recent Projects
B2B Berkshire Hathaway Subsidiary
Summary
š We helped a B2B Berkshire Hathaway subsidiary backup and integrate historic analytics data into 3rd party executive reporting tools for 5 different websites.
The project
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
Weāve been cited by
ā¦ and many more
Never miss an update
Get more training, case studies and ideas delivered directly to your inbox.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.