- Mar 21, 2012
- 1,041
- 1,361
- Awards
- 10
- First Name
- Ryan
It's been almost 3 years since we've started using Data Studio and I'm excited to share some of our group's tips and tricks at Driving Sales in October!
Anybody here using Google Data Studio?
- Thread starter Alex.Lemoing
- Start date
- Apr 7, 2009
- 4,837
- 2,295
- Awards
- 10
- First Name
- Joe
Wow Ryan, the choreography/storyboarding was 1st class. Really great story telling and vid work too!
- Mar 21, 2012
- 1,041
- 1,361
- Awards
- 10
- First Name
- Ryan
Thanks! We winged it for the most part and our videographer knocked it out in about an hour. Turned out much better than expected!
- Mar 21, 2012
- 1,041
- 1,361
- Awards
- 10
- First Name
- Ryan
GOOGLE DATA STUDIO HACK
By default, Google Data Studio forces you to choose between either a Month over Month or Year over Year comparison (the up/down red/green arrows below each scorecard metric).
However, dealerships typically want to see how they compare to BOTH the prior month AND the prior year.
To accomplish this, all you have to do is:
1) Duplicate the scorecard metric
2) Change the comparison date range
3) Set the label font color to white so the only thing left visible is the second set of comparison up/down arrows
4) Add text below each comparison metric to distinguish between MoM vs YoY
By default, Google Data Studio forces you to choose between either a Month over Month or Year over Year comparison (the up/down red/green arrows below each scorecard metric).
However, dealerships typically want to see how they compare to BOTH the prior month AND the prior year.
To accomplish this, all you have to do is:
1) Duplicate the scorecard metric
2) Change the comparison date range
3) Set the label font color to white so the only thing left visible is the second set of comparison up/down arrows
4) Add text below each comparison metric to distinguish between MoM vs YoY
- Feb 7, 2019
- 64
- 41
- Awards
- 3
- First Name
- Anthony
- Jun 19, 2019
- 49
- 40
- First Name
- Joe
First, Ryan, great video! Dealerships definitely need more helpful information like that. Wishing you luck in your DSES session!
Second, another good way for dealers to display Google Ads information in Google Data Studio is by organizing data by High, Mid, and Low Funnels. Dealerships ultimately want to know one thing when it comes to digital marketing: does it sell cars? They want to know how their digital marketing translates to actions that lead to showroom visits and sales.
The image below is a good example because it shows true value to dealerships. Form submissions, click to calls, etc, are all good examples of valuable shopper actions that dealers want to know about.
- Oct 29, 2009
- 745
- 852
- Awards
- 8
- First Name
- Rick
I have two quick questions folks.
1) Any of you guys using Geocoding in GDS and taking it to the zipcode level? I'm looking at building a map with data points on it in GDS and I would like to take it down to the zipcode level. From what I've found so far, I would have to use Lat and Long coordinates in the data. Any of you guys doing anything like this currently???
2) Google Data Studio or Microsoft Power BI? From what I've read, Power BI has tons of more features. Just curious if any of you have used it.
1) Any of you guys using Geocoding in GDS and taking it to the zipcode level? I'm looking at building a map with data points on it in GDS and I would like to take it down to the zipcode level. From what I've found so far, I would have to use Lat and Long coordinates in the data. Any of you guys doing anything like this currently???
2) Google Data Studio or Microsoft Power BI? From what I've read, Power BI has tons of more features. Just curious if any of you have used it.
- Mar 21, 2012
- 1,041
- 1,361
- Awards
- 10
- First Name
- Ryan
That is definitely one area that Data Studio is lacking a little in.
We use BatchGeo to upload our sales data down to the address level and it allows us to easily filter by New vs Used, Make, salesperson, etc.
Then we insert the screenshot into Data Studio monthly and include a link to the interactive BatchGeo map.
- Feb 11, 2015
- 2,492
- 765
- First Name
- Alex
One click integration between Google Analytics and Data Studio.
Google Analytics integration - Looker Studio Help
View your Analytics data with a single click.You can view Google Analytics audiences, acquisition, and behavior data directly from within the Universal Analytics interface. Note: curren
support.google.com
- Mar 21, 2012
- 1,041
- 1,361
- Awards
- 10
- First Name
- Ryan
NEW GOOGLE DATA STUDIO FEATURE
Google just released a new feature that allows dealers to display their vehicle sales on an interactive filterable map!
Filter by new / used, make, body style, sales rep, etc - the possibilities are endless.
Did I mention it's free? Just copy and paste your CRM sold data into a Google Sheet each month (or automate the process using Zapier / Integromat).
