AndySimpson

Local Search Expert
Joined
Apr 6, 2016
Messages
225
Reaction score
267
I've been using Google Data Studio since it first launched well over 2 years ago and was immediately impressed on how easy it was to use for reports both in-house and for clients.

Every time I watch/read something about Google Data Studio (GDS) I get excited thinking "okay great...where's your report you've been discussing?", but very rarely is anything shared. I understand many reports contain private client data but with a few simple(ish) edits I feel more reports could be shared to help the SEO community.

So here's my first contribution. Below is a simplified report I use for various clients which shows me the types of questions users might be searching for and where my client's site might have an impression for such queries. I am not discussing the data, we can do that another day, this is just to show you how easy it is to visualize the data from Google Search Console and how GDS makes the data easier to understand and take actions from your findings.

...and because I do a lot of Local SEO, I thought I throw in some "Near Me" and city filters to perhaps get you thinking on how you might be able to use this report for your clients.

I have done 2 videos, the first showing you the report and how it can be easily edited, the second video shows you how you would apply the report to your GSC data. it's quite easy if you're familiar with GDS but if this is your first time then I thought a little extra help might be beneficial.

Note: if it is your first time using GDR then there are a few hoops you have to jump through first when you first start connecting GSC to GDR, agreements to connect accounts, data, etc, etc, just agree to the terms and then you're all sorted going forward.

===========​

Ever wondered what type of questions drive traffic to your website? You can hook up Google Search Console to Google Data Studio to see your data visually. Here's how:

Data Studio Report: bit.ly/WhatWhereDataStudio

Part 1
Data Studio Report for What Where Why When and How...and a little local SEO on the side


We'll start by showing an example using the GSC sample data from Googles merchandise store. Then I'll show you how to hook up your website data and create a visually stunning data studios report that you can share with your team, your boss, and even your clients!

Part 2
Connecting Data Studio Report to your GSC data



If you have any questions/feedback please comment below or contact me via Twitter.
 
Last edited:

JasonKhoo

Member
Joined
Sep 14, 2018
Messages
64
Reaction score
23
Wow! Great share Andy! I want to get better with Google Data Studio so bad and I just need to sit down and go through it! Will remember this for when I sit down!
 

AndySimpson

Local Search Expert
Joined
Apr 6, 2016
Messages
225
Reaction score
267
Thank you Jason, it's a simple but informative report and one you can easily play with by changing the filters. You can also try "Can" "Do" "Should" "Would" "Did" "Does". If you have any questions then please just let me know.
 

JasonKhoo

Member
Joined
Sep 14, 2018
Messages
64
Reaction score
23
Thanks Andy! Also I didn't put two in two together, but you were at Local Search Forum at Santa Monica. Nice to see you again!!
 

AndySimpson

Local Search Expert
Joined
Apr 6, 2016
Messages
225
Reaction score
267
...yes, that was me, it's okay, I was trying to keep a low profile on the day. Don't hesitate to reach out if you need help on Data Studio.

So much to put into practice after LocalU, such a rewarding conference!
 

Eric Rohrback

Moderator
Joined
Oct 3, 2012
Messages
1,021
Reaction score
343
Hey Andy, question for you.

Are you using Data Studio more for internal analysis or are these client facing reporting?

The biggest issue I've seen with using data studio for client reporting is that the client only looks at it when we review, but doesn't pay attention to it the rest of the time. Maybe I'm giving them a report that gets too in the weeds, where I should simplify? Just wondering how you've used data studio to provide the most impact.
 

AndySimpson

Local Search Expert
Joined
Apr 6, 2016
Messages
225
Reaction score
267
Hi Eric, so I was meaning to come back to you last week...so apologies for the delay.

Anyway, I think you've almost answered the question yourself, your report you provide "gets too in the weeds". I think too much data just sends most clients to sleep, unless they have a real interest in it. I am sure you've seen clients faces when you show them Google Analytics, they get that glazed look on their faces and the whole platform blows them away.

So when data studio came out, I found it such an easy way to show clients "simple" reports. For example, my local Chamber of Commerce just want to see which business pages are being viewed, how many views they are getting a month, which local towns are sending the traffic (as they target several local towns) and where is the traffic coming from, referral traffic, facebook, organic, etc. i.e. are their posts working, is the banner on the local news site sending traffic? That's it, if they want to know more, I can just add a new chart/table to the report but taking a report past 2 pages is usually a waste of time, unless again they want to dig into the data more (in which case I usually introduce clients to analytics).

On a different note, this simple data studio report was also a tester for the community to get Local SEOs to start using it. To hopefully show how easy it was to use AND how much data is available to them in GSC...you just have to know where/how to look.

I'm also using data studio for internal reports, I used this how, what, where report just today, when researching organic impressions/traffic my client gets for oil field accidents. I just love how data studio makes the data standout "pop" to help find what I am looking for.

Cheers

Andy
 
Similar threads
Thread starter Title Forum Replies Date
I Is there an uptick in keyword planner data being excluded for healthcare related terms? Paid Search and Local Service Ads 5
NickB-Tampa Should all the phone numbers on the landing page to our GMB listing be included in the structured data? Google My Business & Google Maps 2
B Compare/Contrast different GMB location's data? Google My Business & Google Maps 4
djbaxter Schema.org vs. Google's Structured Data Rich Results Organic SEO 0
Zhanna Which tracker shows correct data? Massive drop down in rankings in one of the trackers Help & Support for Google Local 3
H GMB - Dashboard data analysis longer than a quarter NAP, Categories, Dashboard Data 2
Nicole Basham How early can you pull data on GMB Insights? Google My Business & Google Maps 1
john wieber Mobile Local SERPS Location Data in Result Local Search 5
Andrew Scherer Google's Structured Data Testing Tool axed... Bing's Alternative Local Search 1
K Insight Data Stops June 22nd? Google My Business & Google Maps 1
L GMB Insights Data not Updating Properly Google My Business & Google Maps 2
Nikki Stine GMB Insights Data missing for May 4 - 6? NAP, Categories, Dashboard Data 5
P Data aggregator sites - Who to use? Citations 3
Lachlan_Wells GMB Insights data not updating for two weeks Google My Business & Google Maps 1
djbaxter Avast antivirus caught spying on user data - and selling it Websites, Software, and Security 1
djbaxter Google reminder: Structured Data Does Not Impact Ranking Organic SEO 0
P Data around Reserve with Google Google My Business & Google Maps 1
Chaddow Changes to Apple Maps data sources what will this mean ? Local Search 2
S Free tool for local businesses - update data on Google, Facebook, Yelp, etc. - would you use it? Local SEO Tools & Software 7
JSammon512 Better Data in Google Ads & Analytics for Local Pack Ads (Google Local Extensions) Help & Support for Google Local 1
Claire Carlile No 'message you' data showing in Customer actions Google My Business & Google Maps 3
Ellen GMB Dashboard Data Highly Inflated -- Related to Barry Schwartz Inflated Impressions Article NAP, Categories, Dashboard Data 1
Travis Van Slooten Where Does MapQuest Get Its Data? Local Search 9
M BrightLocal Data Aggregator push - Do you have to do it every year? Citations 17
T Data Aggregators and PO Boxes Local Search 2
M Including tracking number when you submit to data aggregators? Ex. BrightLocal NAP, Categories, Dashboard Data 3
N GMB | Intrepreting the Data Google My Business & Google Maps 4
D Does Google Save Data on Unclaimed Listings? Google My Business & Google Maps 2
dannanelli Are agencies allow to hold Google Analytics account data hostage? Local SEO Tools & Software 11
U Is Google creating more listings with data obtained from elsewhere Google My Business & Google Maps 6
Cory Agular Sourcing Movie Time Data on SERP Google My Business & Google Maps 1
Dan Foland Do you renew your data aggregator listings? Citations 11
Colan Nielsen [Missing Data Alert] Knowledge Panel Seems to Have Removed Physical City Data Local Search 9
Somsenater Import data from Google My Business in Bing Places for Business Local Search 11
L What service do you use for data aggregators? Citations 7
djbaxter Local search from mobile via wifi vs. via cellular data Local Search 9
C Any Evidence Structured Data Schema Makes A Difference? Local Search 3
AMF Incorrect Data Being Reported by D&B and YEXT. Citations 7
JoyHawkins New Structured Data Penalty for Reviews? Local Reviews 13
rosie.brightlocal New BrightLocal data: Online Reputation Management Survey Local Reviews 2
rosie.brightlocal SEO Citations Study - New data! Citations 3
rosie.brightlocal New data: BrightLocal's Voice Search for Local Business Study Local Search 1
djbaxter Google: Structured Data Isn't A Ranking Factor But Can Help Rankings Organic SEO 3
rosie.brightlocal New data: Local Citations Trust Report Citations 0
AndySimpson Are you using GSC for your local data? Tracking your utm's & "Near Me" Queries Local Search 13
D Seo data Local Search 0
L Is it possible to get more that a 3 months worth of data from google my business ? Local Search 3
Tim Colling Citation Data Aggregators List Local Search 1
Linda Buquet To All the Google My Business Data Geeks - Check your Dashboards, Cool Update Google My Business & Google Maps 1
O Best data (citation) aggregation service for SAB? Service Area Businesses 4

Similar threads

Login / Register

Already a member?   LOG IN
Not a member yet?   REGISTER

Most UpVoted Answers

LocalU Podcasts

  Promoted Posts

New advertising option: A review of your product or service posted by a Sterling Sky employee. This will also be shared on the Sterling Sky & LSF Twitter accounts, our Facebook group, LinkedIn, and both newsletters. More...
Google Product Exert


Top Bottom