Jan 23, 20233 min read

[VIDEO] - Business Coach Dashboard in Google Data Studio

Perfect for data-driven Business Coaches and Consultants that want to be able to see their clients' performance in an easy to understand dashboard.

This example in Google Data Studio is great!

[Video Transcript]

What's going on business coaches and consultants! This is Jack Tompkins from Pineapple Consulting Firm! We're going to walk through a really quick dashboard in Google Data Studio that you can show to your clients and really have a great conversation about their entire business with. Visuals make it easy to understand for everybody. Let's check it out!

All right, so here it is. This is the Google Data Studio dashboard, client facing, for business consultants or business coaches. As you can see, it's just a website here, nothing too crazy. It's Google based so you can share it pretty easily just like you do anything else. I'm going to go into presentation mode so we can get the full view of it. Awesome, so up here we kind of start off with just some basic KPIs. These could be whatever you want in your business or whatever you want in your clients businesses I should say. Revenue and profit, hopefully everybody's keeping track of that. You've got some year-over-year performance indicators below it as well. Pick whatever date range you want. This makes it super flexible. You can go pick whatever, April 14th to the end of June, doesn't matter. They've got a lot of preset time frames too so you could scroll through. If you want to see daily, you do today and yesterday. You could go by quarter, year to date, quarter to date, all this good stuff. For now I'm just going to leave it as June of 2021 since our data is as of July 24th 2021.

So we've got the two KPIs here. Let's see them in a trend, revenue and profit over time. Dark blue is revenue, light blue is profit. I'm just getting a sense of how things have been trending outside of this one time frame that we're really focusing on. Changing this kind of impacts a lot of these different graphs here. These middle ones are sort of that one layer deeper. Hourly rate by client (really important for service based businesses), conversions by marketing source, what's working, what's not working, the top 10 expenses, etc. So keeping an eye on that piece of the income statement as well. These could be changed out. This could be top 10 revenue sources. This could be profitability by revenue source. We can make this completely financial based. A whole lot of opportunity here.

The visuals make it pretty easy to understand what's happening, even for clients who may not be financially savvy or don't want to dive into the data at all. The visuals really help, especially with this last one here. Where are they spending their time. This is just billable versus non-billable hours but obviously you could get into a whole lot of stuff with this. For example, what is the time spent on this specific marketing source, etc and all sorts of stuff depending on whether or not you have great time tracking or decent time tracking. Much like marketing, if it's all held together in a good CRM, it is very easy to get this data. Given that this is web-based, it makes it incredibly simple to have an API connect and have some automatic data flow through. Especially if you're using QuickBooks, anything like that, the data is pretty easy to get at.

So there you go, that’s it! Everything in one place, super flexible, can do a whole lot of things with it, easy to get the data in. There is plenty more at the website if you want to check it out pineapplecf.com as in pineappleconsultingfirm.com. Check it out and let me know if you have any questions!

Take Your Business to the Next Level

Thank you so much for watching our video on Business Coach Dashboard in Google Data Studio. Are you ready to take your business coaching or consulting to the next level? Check out our business coach dashboards to help you package your clients' most important financial, operations and/or marketing data into a user-friendly, easy to understand dashboard. If you need a custom solution or have questions, do not hesitate to send us a message! Thanks again for visiting Pineapple Consulting Firm.