• Stop being a LURKER - join our dealer community and get involved. Sign up and start a conversation.

Anybody here using Google Data Studio?

MarkRR

Boss
Sep 16, 2016
9
1
Awards
1
First Name
Mark
You read my mind. We have dozens of dealerships that we want to report on - AdWords-CTR, CPL, Spend, Impressions share, and Analytics-time on site, bounce rate, pages viewed, etc. etc.

It looks like I'm going down the same route you already forged! Thanks again. Big help.
 
Visit Generations Digital

Alexander Lau

Under the Bridge
Feb 11, 2015
2,492
764
First Name
Alex
Hi Mark, nope I'm just using the Supermetrics for Google Drive Pro plan for $49 /month:
https://supermetrics.com/product/supermetrics-for-google-drive/

The Supermetrics data grabber tools are a la carte and only work with Microsoft Excel which you won't be able to access from Data Studio. The price difference between the Google Drive and Excel versions is definitely crazy. Luckily you only need the less expensive Google Drive (Sheets) subscription.
Yes, that's all you need unless you are doing something very specific.
 
Apr 18, 2017
9
1
First Name
Minh
Thanks for the template Alex! Data Studio seems to gain more popularity. Yet I'm still waiting for more development (e.g: data sources, date format error, etc) as right now it is no where as dynamic as other visualization tools, like Klipfolio. But since now it's free, it's a good idea to start playing with the tool, plus I personally enjoy their interface and find it quite easy to create good-looking reports.

I just also shared a Google Data Studio template for Facebook Ads on another thread, would be great to hear your opinion on that:
https://forum.dealerrefresh.com/threads/using-google-data-studio-for-ppc-reporting.5235/
 
Mar 21, 2012
372
428
Awards
1
First Name
Ryan
Just thought I'd post a quick update on our progress with the report!

We have 18 pages to the report for each store, pulling in data from a myriad of sources like Google Analytics, Adwords, reputation, CRM, third party listing sites, etc.

It finally allows us to show everything in an easy to interpret format without needing an advanced degree in Google Analytics or compiling data from 5 different sources.

Also they have new interactive data filter dropdowns that allow you to really drill down the report even more. For example I could choose to only show the stats on paid search traffic or by device type.

PS: screenshots are sample data

autotrader.JPG reputation.jpg vdp-stats-model.JPG vdp.JPG
 

Karen Ann

Boss
Apr 21, 2009
129
26
Awards
1
First Name
Karen
Just thought I'd post a quick update on our progress with the report!

We have 18 pages to the report for each store, pulling in data from a myriad of sources like Google Analytics, Adwords, reputation, CRM, third party listing sites, etc.

It finally allows us to show everything in an easy to interpret format without needing an advanced degree in Google Analytics or compiling data from 5 different sources.

Also they have new interactive data filter dropdowns that allow you to really drill down the report even more. For example I could choose to only show the stats on paid search traffic or by device type.

PS: screenshots are sample data

View attachment 3317 View attachment 3318 View attachment 3319 View attachment 3320
That looks great!! Nice job.
 
Apr 24, 2017
11
5
First Name
Connor
Just thought I'd post a quick update on our progress with the report!

We have 18 pages to the report for each store, pulling in data from a myriad of sources like Google Analytics, Adwords, reputation, CRM, third party listing sites, etc.

It finally allows us to show everything in an easy to interpret format without needing an advanced degree in Google Analytics or compiling data from 5 different sources.

Also they have new interactive data filter dropdowns that allow you to really drill down the report even more. For example I could choose to only show the stats on paid search traffic or by device type.

PS: screenshots are sample data

View attachment 3317 View attachment 3318 View attachment 3319 View attachment 3320

How did you pull this all in? Is it possible to share your template so other people might be able to use it?
 
Mar 21, 2012
372
428
Awards
1
First Name
Ryan
How did you pull this all in? Is it possible to share your template so other people might be able to use it?
A combination of Google Analytics, Google Sheets scripts, and SuperMetrics. Some of the data (like Autotrader) is being inputted into Google Sheets manually by my team each month. Takes us just a few minutes to input it at the beginning of every month but worth the work because it puts it in a consistent easy to read format without all of the other extraneous stats Autotrader, Cars.com, etc like to push down our throats.

Below is what the Google Sheet looks like for Autotrader, then Data Studio pulls it from there

google sheets.JPG
 
Last edited:
Get Podium
Get Podium