Data Driven Business Audit

Context to the Audit + Analysis

A friend of mine and business partner is running some AdWords campaigns for a local business. He is doing a great job at it.

However, I wanted to see just how great...and match that up with their sales data, and formulate both an audit of what they are doing right now, and an action plan for what they could be doing after some analysis.

Cleaning up the data in Power Query

Google Sheets Housing the Data for Data Studio

Breakdown of the Google Stack


Google's very powerful dashboarding tool. 

We use Data Studio because its the best out there. Also, why go away from the Google Stack when we've used all the other steps leading up to the visualization tool with Google? 

Data Studio has many built in connections, like Google Ads, Analytics, and even Facebook (through third party, Supermetrics add-on). 

However, we use Google Sheets and Google Data Studio's "calculated fields" (formerly, calculated metrics) to calculate custom metrics, like ROI of the Google Ads, for example. 

This way the data is updated in real time, and the client can filter by date range and store location (in the scenario) to self serve on the metrics and know their numbers up to the minute.

The Dashboard Run-Down

Actionable Next Steps

We don't do all this work to make a pretty dashboard. It needs to be actionable!

This is why we customized it for their business, in order to gain useful truths and actionable next steps.

Ready to Finally Know Your Business Numbers?

Start the conversation now, Ryan only takes on select and limited clients.