Context to the Audit + Analysis
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 TAG MANAGER
- GOOGLE ANALYTICS
- GOOGLE ADS
- GOOGLE SHEETS
- GOOGLE DATA STUDIO
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.