Tag Archive | "dashboard"

How to Create a Local Marketing Results Dashboard in Google Data Studio – Whiteboard Friday

Posted by DiTomaso

Showing 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 Transcription

Hi, 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, “Are we making money?” This is the big thing that people care about, and really every business cares about making money. Even charities, for example: money is important obviously because that’s what keeps the lights on, but there’s also perhaps a mission that they have.

But they still want to know: Are people filling out our donation form? Are people contacting us? These are important things for every business, organization, not-for-profit, whatever to understand and know. What we’ve tried to do in this dashboard is really boil it down to the absolute basics, one thing you can look at, see a couple of data points, know whether things are good or things are bad.

Are people contacting you?

Let’s start with this up here. The first thing is: Are people contacting you? Now you can break this out into separate columns. You can do phone calls and emails for example. Some of our clients prefer that. Some clients just want one mashed up number. So we’ll take the number of calls that people are getting.

If you’re using a call tracking tool, such as CallRail, you can import this in here. Emails, for example, or forms, just add it all together and then you have one single number of the number of times people contacted you. Usually this is a way bigger number than people think it is, which is also kind of cool.

Are people taking the action you want them to take?

The next thing is: Are people doing the thing that you want them to do? This is really going to decide on what’s meaningful to the client.

For example, if you have a client, again thinking about a charity, how many people filled out your donation form, your online donation form? For a psychologist client of ours, how many people booked an appointment? For a client of ours who offers property management, how many people booked a viewing of a property? What is the thing you want them to do? If they have online e-commerce, for example, then maybe this is how many sales did you have.

Maybe this will be two different things — people walking into the store versus sales. We’ve also represented in this field if a person has a people counter in their store, then we would pull that people counter data into here. Usually we can get the people counter data in a Google sheet and then we can pull it into Data Studio. It’s not the prettiest thing in the world, but it certainly represents all their data in one place, which is really the whole point of why we do these dashboards.

Where did visitors com from, and where are your customers coming from?

People contacting you, people doing the thing you want them to do, those are the two major metrics. Then we do have a little bit deeper further down. On this side here we start with: Where did visitors come from, and where are your customers coming from? Because they’re really two different things, right? Not every visitor to the website is going to become a customer. We all know that. No one has a 100% conversion rate, and if you do, you should just retire.

Filling out the dashboard

We really need to differentiate between the two. In this case we’re looking at channel, and there probably is a better word for channel. We’re always trying to think about, “What would clients call this?” But I feel like clients are kind of aware of the word “channel” and that’s how they’re getting there. But then the next column, by default this would be called users or sessions. Both of those are kind of cruddy. You can rename fields in Data Studio, and we can call this the number of people, for example, because that’s what it is.

Then you would use the users as the metric, and you would just call it number of people instead of users, because personally I hate the word “users.” It really boils down the humanity of a person to a user metric. Users are terrible. Call them people or visitors at least. Then unfortunately, in Data Studio, when you do a comparison field, you cannot rename and call it comparison. It does this nice percentage delta, which I hate.

It’s just like a programmer clearly came up with this. But for now, we have to deal with it. Although by the time this video comes out, maybe it will be something better, and then I can go back and correct myself in the comments. But for now it’s percentage delta. Then goal percentage and then again delta. They can sort by any of these columns in Data Studio, and it’s real live data.

Put a time period on this, and people can pick whatever time period they want and then they can look at this data as much as they want, which is delightful. If you’re not delivering great results, it may be a little terrifying for you, but really you shouldn’t be hiding that anyway, right? Like if things aren’t going well, be honest about it. That’s another talk for another time. But start with this kind of chart. Then on the other side, are you showing up on Google Maps?

We use the Supermetrics Google My Business plug-in to grab this kind of information. We hook it into the customer’s Google Maps account. Then we’re looking at branded searches and unbranded searches and how many times they came up in the map pack. Usually we’ll have a little explanation here. This is how many times you came up in the map pack and search results as well as Google Maps searches, because it’s all mashed in together.

Then what happens when they find you? So number of direction requests, number of website visits, number of phone calls. Now the tricky thing is phone calls here may be captured in phone calls here. You may not want to add these two pieces of data or just keep this off on its own separately, depending upon how your setup is. You could be using a tracking number, for example, in your Google My Business listing and that therefore would be captured up here.

Really just try to be honest about where that data comes from instead of double counting. You don’t want to have that happen. The last thing is if a client has messages set up, then you can pull that message information as well.

Tell your clients what to do

Then at the very bottom of the report we have a couple of columns, and usually this is a longer chart and this is shorter, so we have room down here to do this. Obviously, my drawing skills are not as good as as aligning things in Data Studio, so forgive me.

But we tell them what to do. Usually when we work with local clients, they can’t necessarily afford a monthly retainer to do stuff for clients forever. Instead, we tell them, “Here’s what you have to do this month.Here’s what you have to do next month. Hey, did you remember you’re supposed to be blogging?” That sort of thing. Just put it in here, because clients are looking at results, but they often forget the things that may get them those results. This is a really nice reminder of if you’re not happy with these numbers, maybe you should do these things.

Tell your clients how to use the report

Then the next thing is how to use. This is a good reference because if they only open it say once every couple months, they probably have forgotten how to do the stuff in this report or even things like up at the top make sure to set the time period for example. This is a good reminder of how to do that as well.

Because the report is totally editable by you at any time, you can always go in and change stuff later, and because the client can view the report at any time, they have a dashboard that is extremely useful to them and they don’t need to bug you every single time they want to see a report. It saves you time and money. It saves them time and money. Everybody is happy. Everybody is saving money. I really recommend setting up a really simple dashboard like this for your clients, and I bet you they’ll be impressed.

Thanks so much.

Video transcription by Speechpad.com

Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don’t have time to hunt down but want to read!


Moz Blog

Related Articles

Posted in Latest NewsComments Off

SearchCap: Google Search Console dashboard, SEO mistakes & more

Below is what happened in search today, as reported on Search Engine Land and from other places across the web.



Please visit Search Engine Land for the full article.


Search Engine Land: News & Info About SEO, PPC, SEM, Search Engines & Search Marketing

Posted in Latest NewsComments Off

Google launches new Google My Business API, new dashboard to manage multiple locations

Now a single registered account on GMB will be able to manage an unlimited number of locations.

The post Google launches new Google My Business API, new dashboard to manage multiple locations appeared first on Search Engine Land.



Please visit Search Engine Land for the full article.


Search Engine Land: News & Info About SEO, PPC, SEM, Search Engines & Search Marketing

Posted in Latest NewsComments Off

SearchCap: Google My Business dashboard & API, class action awards & clickbait

Below is what happened in search today, as reported on Search Engine Land and from other places across the web.

The post SearchCap: Google My Business dashboard & API, class action awards & clickbait appeared first on Search Engine Land.



Please visit Search Engine Land for the full article.


Search Engine Land: News & Info About SEO, PPC, SEM, Search Engines & Search Marketing

Posted in Latest NewsComments Off

Online Marketing News: AdWords Adds ‘Buy’, Dashing New Twitter Dashboard, WordPress Wows

Noob Guide To Online Marketing

The Noob Guide To Online Marketing [Infographic] – Unbounce decided to put together a noob guide to online marketing which teaches you how to market your product, service or website over a period of 6 months. It’s based on an article by Oli Gardner over at SEOMOZ.org, and it should shed some light on how to go about things. Check it out. Unbounce

Tumblr Adds New Data Partner as Marketers Race to Interpret Social Images – Crimson Hexagon has become the the latest social company to tap Tumblr’s firehose of real-time data, reinforcing the growing importance marketers are placing on understanding images, memes and GIFs of the sort that reign there. Ad Age

Report: How Social Spam Distorts Data Insights – Social media is riddled with spam. Up-and-coming networks attract spam as they grow quickly, and older networks have to deal with ever more sophisticated bots. A new report from Networked Insights examines how spam and bots distort the insights brands try to gain from social media. SocialTimes

Study: Mobile Campaigns Drive Twice the Sales of Desktop – A mobile ad platform releases what it claims is the first true benchmarking of the channel’s impact on in-store sales. Direct Marketing News

Report: 78.8% Of Site Owners Use WordPress For Content Management – CodeGuard’s “State of the Web Report” found a large majority of its 250,000 SMB sites use WordPress over Joomla, Drupal and others. Marketing Land

Demand for How-to Content on YouTube is On the Rise – Plenty of publications have taken advantage of the digital medium to provide how-to guides for the internet. However, video is one of the best mediums this type of content. SocialTimes

Digital Ad Spend to Near $ 60 Billion in 2015 – Marketers will spend $ 58.6 billion on digital advertising this year, paced by retailers who will account for about 22% of that total, according to eMarketers 2015 “Digital Ad Spending Benchmarks by Industry” report. Retail will lead spending in all three classes of digital spend measured by eMarketer: mobile, programmatic display, and video. Direct Marketing

Report: Calls Have 30 To 50 Percent Conversion Rates, Most Come From Mobile – A call is, generally speaking, a better lead than a click. But how much better is striking: calls have 30 to 50 percent conversion rates while clicks top out at 1 to 2 percent. That’s according to a new Call Intelligence Index report from Invoca. Marketing Land

STUDY: Majority of Global Brands Still Focus on Facebook – The results of a study by social media analytics provider Quintly on global interaction rates with social networks were no shock: Facebook remains at the top. SocialTimes

Twitter Announces A New Dashboard To Help Monitor and Manage Your Account – This week, Twitter is continuing to roll out to all users the Twitter data dashboard — a new tool to help you monitor and manage your account. Twitter

Google Adwords Introduces Anticipated ‘Buy’ Button – Google’s much anticipated ‘Buy’ button is finally here, at least in a some capacity. The new “Purchases on Google” feature was announced today, along with a number of other notable enhancements. Search Engine Journal

Report: Social Share Buttons Are Useless and Unused – When Web use was dominated by desktop and laptop browsers, social share buttons were an important part of social media campaigns. Now users are spending more time on mobile devices and more time in applications. Data from Moovweb, a mobile experience optimization firm, shows that social share buttons are practically useless on mobile. SocialTimes

From our Online Marketing Community:

In response to The Key to a Successful Digital Marketing Agency and Client Relationship, Josue Valles shared, “Hi Lee, great information about client relationship. It was very helpful to me! Thanks!”

On 5 Common Writing Clichés to Avoid for Better Content Marketing, Jacklin commented, “Great read! Really good point about “We All Know…” I definitely think that phrase comes off as sales-y and you’re right, it’s totally unnecessary. I’m guilty of a bunch of these too-eek!”

And Darryl Villacorta said about, Updated! A Master List of Social Media Marketing Management Tools, “Great list, Lee! Couldn’t agree with you more that it’s important for companies to choose a SMM tool that best suits their needs. Keep up the great work.”

What were the top online and digital marketing news stories for you this week?

Thanks for reading and have a great weekend!

Infographic: Unbounce


Email Newsletter
Gain a competitive advantage by subscribing to the
TopRank® Online Marketing Newsletter.

© Online Marketing Blog – TopRank®, 2015. |
Online Marketing News: AdWords Adds ‘Buy’, Dashing New Twitter Dashboard, WordPress Wows | http://www.toprankblog.com

The post Online Marketing News: AdWords Adds ‘Buy’, Dashing New Twitter Dashboard, WordPress Wows appeared first on Online Marketing Blog – TopRank®.

Online Marketing Blog – TopRank®

Posted in Latest NewsComments Off

B2B Social Media: 4 steps to get your listening dashboard started

Social media monitoring is a great way to gain customer intelligence that can be applied to generate leads. Learn four steps you can use to create a listening dashboard.
MarketingSherpa Blog

Related Articles

Posted in Latest NewsComments Off


Advert