Where intelligence is put to the test.

Data Engineering & Reporting for a Regional Bank

John Crenshaw in

Mar 06

Summary: 🚀 We helped a regional bank pipe marketing data to a BigQuery data warehouse so it could be used in a unified reporting dashboard, providing executives a level of transparency and insight in reporting that possible before.


 

In 2023, Google will shut down Universal Analytics, taking all historic data from UA accounts with it.

This regional banking client needed to preserve that historic data, setup GA4, and integrate both into executive reporting dashboards.

We setup BigQuery as a data warehouse to house the historic Universal Analytics data and setup event and goal tracking in GA4.

We designed executive dashboards in Looker Studio to merge both of those data sources to preserve continuity of reporting.

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