Create Visually Appealing Reports With Google Data Studio
July 20, 2016
When we talk about what tasks tend to eat up a significant chunk of time, reporting is surely mentioned. You find yourself slaving away day after day pulling numbers, calculating CPCs and CPLs, only to end up with a mediocre looking report.
But wait. There has to be a better way.
Let’s explore another option: Google Data Studio.
When you log in, you’ll see the following screen:
On the left, you’ll see where you can navigate between Reports and Data Sources – which are exactly what you’d expect, linked sources that Data Studio pulls information from.
If you find yourself needing some reporting inspiration, check out the sample reports that Google provides:
Pretty snazzy, huh?
Adding Data Sources
To add a data source, click the big round blue button in the lower right-hand corner. Then you’ll choose a connector.
If you are using third-party platforms, the Google Sheets functionality will be handy for you. Simply have that platform export to Google Sheets (if it has the ability) or copy and paste it in there to pull the information into Data Studio.
From there you’ll filter through accounts to choose the one you want, and then select a type of report. Note that if you select “Account Performance” you will not have campaign level data. You can, however, add more than one data source to a report. Lucky you.
Once you create the data source, to use it you must add it to a report.
When you open up a new report, this is what you’ll see. Not much to look at, right? Just a simple, white page.
Simply toggle the “Edit” button in the upper right corner, and suddenly a menu of reporting options appears along the top. The white page will now show a grid to help you place and align report elements.
The icons correspond to the type of graph/chart. Click the one that you’d like to add to your report, then click and drag in the body of the report to add. Here’s a snapshot of all the available elements:
Here’s an example of a Time Series graph.
Once you’ve got your graph placed, select the appropriate metrics on the right-hand menu.
You can also add a date selector to your report for the user to choose a date range. This icon looks like a little calendar. It will change the metrics in all report elements that have the date set to “auto.”
Adding a filter to any report element should feel very familiar if you’re used to working within Analytics:
Creating Custom Metrics
To create a custom metric, such as a calculated field, simply click “Create New Metric” under the Metric Picker. Once you click that, you can create your new metric. As you start to type in metrics, it will autofill for you.
Make sure you check the formatting of the number and set it to currency if needed. Then click “Create Field” and you’re done.
Style And Formatting
When you have an element of your report selected, click the Style tab on the right-hand menu to change colors, fonts, etc.
Note that when you add an item to your report, it doesn’t come with a header or a title. You’ll have to manually add in text boxes to title them. While it may be a little extra work, I recommend doing it so it remains clear what exactly you’re showing (example: what campaigns are you showing?).
If you give it the time and energy, Data Studio can create good looking reports.
- Very customizable
- Integration with Analytics & Google Sheets
- Appealing visuals
- Some bugs popped up here and there, configuration errors are common
- Can be time-consuming to make pretty (maybe too customizable?)
- Adding data sources isn’t always intuitive
While I did get some errors, this tool is still in beta. In time, I’m guessing Google will work out some of the kinks. If you’ve got a client that needs fresh reporting, or a particular report that you’ve been meaning to put together for some time, try Data Studio.
Browse By Category
5 Tips For The Travel PPC Marketer
I’m going to focus on 5 vital tips for travel marketers. From competitors to seasonality, we have experienced the ups and downs and want to share our experience with you.
Our All-PPC Schedule for LA is Now Live! Save $400 Now»
You can now get the info you need to register before our 25% off Early Bird pricing expires on 1/31. We're adding new sessions daily to our schedule for Hero Conf Los Angeles, and it includes updates that hard-working PPC-ers just can't miss.
Be Smart In 2017: Use Seasonal Budgeting
Spend more when you get more. That's the message that needs to get across. But how do you go about looking into it?
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
The Simple Beauty Of A PPC Bid Template
Sometimes the best answer is not only the simplest but also staring you in the face like. Enter the Excel template.
4 Strategies For Improving Your Click-To-Message Ad Extensions
Last year, Google heard the requests for better text tracking tools for text messages and developed the Click-To-Message mobile-only ad extension. Learn how to use!
Get The Lowdown On Amazon Vendor And Seller Central PPC Advertising
Amazon has taken the lead for first product searches amongst online shoppers. Learn about the different advertising options on Amazon and what each type offers.