Posted by DiTomasoShowing clients that you’re making them money is one of the most important things you can communicate to them, but it’s tough to know how to present your results in a way they can easily understand. That’s where Google Data Studio comes in. In this week’s edition of Whiteboard Friday, our friend Dana DiTomaso shares how to create a client-friendly local marketing results dashboard in Google Data Studio from start to finish.

Click on the whiteboard image above to open a high-resolution version in a new tab!
Video TranscriptionHi, Moz fans. My name is Dana DiTomaso. I’m President and partner of Kick Point. We’re a digital marketing agency way up in the frozen north of Edmonton, Alberta. We work with a lot of local businesses, both in Edmonton and around the world, and small local businesses usually have the same questions when it comes to reporting.
Are we making money?
What I’m going to share with you today is our local marketing dashboard that we share with clients. We build this in Google Data Studio because we love Google Data Studio. If you haven’t watched my Whiteboard Friday yet on how to do formulas in Google Data Studio, I recommend you hit Pause right now, go back and watch that, and then come back to this because I am going to talk about what happened there a little bit in this video.
The Google Data Studio dashboard
This is a Google Data Studio dashboard which I’ve tried to represent in the medium of whiteboard as best as I could. Picture it being a little bit better design than my left-handedness can represent on a whiteboard, but you get the idea. Every local business wants to know,