Google Data Studio: Revisited
February 13, 2017
Last year Google launched Data Studio in beta. We did a write up of our initial thoughts of the platform. While the idea behind it was good, there were some bugs that popped up here and there, especially when it came to adding data sources. You were also limited to only five reports with the free version. If you have more than a couple accounts to work with, this isn’t ideal. Doesn’t Google understand that we need to create ALL THE REPORTS?!
However, Google announced on February 2nd that Data Studio will be free for everyone. Data lovers rejoice!
No longer are we limited to five reports. Go ahead and create and share as many reports as your heart desires. Now we’ll go through a refresher, along with a couple tips to help you get the most out of the platform.
Data Studio Templates
Templates are very easy to use. As we noted in the previous blog post, Data Studio is ultra-customizable, and it can be a little overwhelming. If you find yourself struggling to organize your report and make it beautiful, a template may be a great option for you! These templates have all the bones of the report built out and organized, all you need to do is plug in your own data and tweak it as you wish. Here’s how.
Any report can be used as a template. This makes it easy to implement reports across many accounts. First, open the report and navigate to File > Make a copy…
This will open a menu like the one below. You’ll want to change the appropriate data sources for your new account.
From here, go ahead and change the formatting and styling of the report to suite your needs.
Report Formatting and Styles
Heatmaps are great for visualizing data, and we commonly use them in Excel for our PPC reports. If you love heatmaps, you’re in luck, because Data Studio can automatically heat map your reports. Cool, huh?
For line graphs, you also have some formatting options similar to what you find in Excel.
Linking with Google Sheets
While linking to AdWords and Analytics is great, as of right now it does not link to Bing Ads. It also does not pull in ad copy either. The solution for this is simple, link your Data Studio report with a Google Sheet (which is even easier if you use Supermetrics!). Data Studio will take the raw data and create a beautiful chart or graph.
Client Facing Dashboards
The easily sharable nature of these reports makes them great for dashboards. Is your client constantly hounding you for stats? Do they need to know RIGHT NOW? Try out a dashboard!
Here’s a sample Ecommerce dashboard.
Think about what your client cares about, and which metrics are relevant to their business. Then start putting those into an easily digestible format.
If you’re still lost, don’t worry, there are video tutorials to help guide you through report set up.
Overall I have been impressed with Data Studio. I was pleased to find the platform less buggy, and templates make report set up a snap. My clients love that they can manipulate the dates ranges within the report itself, and it can be shared in real-time. Whether you’re looking for a new weekly/monthly reporting platform, or just want some cool dashboards, Data Studio is worth looking into – especially now that it’s free!
Browse By Category
Vote Now For The 2017 Top 25 Influential PPC Experts!
The time to VOTE for PPC Hero's annual list of the Top 25 Most Influential PPC Experts for 2017 is now.
10 Alternatives To Google AdWords
A look at ten options available for those PPC managers who have run out of growth opportunities in Google.
How To Get Big Wins In Your AdWords Account
As AdWords advertisers, we tend to obsess over the big wins. However, many small wins can lead to significant improvements in performance over time.
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
Guide to Facebook Advertising for Big Brands
While many brands create pages, and run paid advertising within Facebook to promote their brand, they don’t always know where to turn to get the most value from those efforts. In this guide, a brand can expect a better understanding of how to create an...
4 Tips For Supporting A PPC Account Team
I’ve assembled a starting list of four pointers that have helped me provide better support to PPC team leads. Check them out and see if you agree!
How Marketing Executives Are Being Fed Bad Data
How a typical organization requests and interprets what’s happening with their marketing campaigns leads to unclean data, making its way to the c-suite. The concept of “Bad Data” has many definitions, but in this whitepaper, we focus on data that has been misrepresented or misinterpreted...