report in google data studio

When working with Google Analytics, you do not continuously need to stay with simply a secondary dimension. Sometimes, you furthermore may need a third and fourth dimensions. However in Google Analytics’s normal reports that’s almost impossible. The custom reports you’ll be able to produce in Google Analytics are very satisfying to seem at. perhaps it’s my temperament talking, maybe not. However if i would like to make a report, i would like it to appear nice. Luckily, there’s this tool referred to as Google data Studio. And I love it!

What’s Google Data Studio?

If I’d had to clarify what it is: Google data Studio could be a tool within which you’ll be able to visualize your data. You’ll connect all sorts of information to Google data Studio, like Google Sheets. You’ll be able to upload CSV files and drumroll Google Analytics! And it connects extremely very easy with Google Analytics.

google data studio

You can produce all forms of reports with nice graphs, charts, and tables, changing your data and information to life. I’m not completely planning to deal with each form of Google data Studio here, you’ll be able to use Google for that. However my goal for this post is that you’re going to provide Google data Studio a try to produce a pleasant report with over 2 dimensions!

Connect Google Analytics to Google Data Studio

In order to induce Google Analytics information in Google data Studio, you wish to create a association between the two. The sole demand is that you just have a Google Analytics account and a Google data Studio account. Since they’re each Google merchandise, this association is straightforward to line up and thus shouldn’t hold you back from attempting Google data Studio. The steps are explained during this post concerning connecting your Google Analytics account.

google data studio

Recreate the Source/Medium report in Google Data Studio

When I initially tried Google data Studio, I was kind of shocked how good this tool was. Primarily to get familiar with the information tool I recreate one report among my favorite reports in Google Analytics: the source / Medium report. You begin with adding a chart, during this case, a table.

google play yard

It mechanically adds source and Sessions. Cool factor is that the excellence between dimensions and metrics is instantly visible. the size are green, the metrics are blue. It’s terribly cool to visualize the wide selection of dimensions and metrics Google Analytics has to provide.

It mechanically adds source and Sessions. Cool factor is that the difference between dimensions and metrics is instantly visible. The dimensions are green, the metrics are blue. It’s terribly cool to visualize the wide selection of dimensions and metrics Google Analytics has to provide.

If you click on ‘Source’ you’ll be able to replace that dimension by scrolling through the dimensions or if you already understand the name of the dimension, by writing the name within the search field, a similar goes for metrics. To recreate the source / Medium report, we’d like to feature a few of metrics.

  • Dimension: Source / Medium
  • Metric: Users
  • Metric: New users
  • Metric: Sessions
  • Metric: Bounce Rate
  • Metric: Pages / Session
  • Metric: Avg. Session Duration
  • Metric: Goal Conversion Rate (or E-commerce Conversion Rate)
  • Metric: Goal completions (or Transactions)
  • Metric: Goal value (or Revenue)

Customize the report

If you have used UTM tagging and use campaign, content and term tags, you’ll be able to add all of those in this report! Give it a attempt. Your initial reaction could be that it might be amazing to own all that information in one table. However you’ll quickly see that your report becomes too littered and obscure.

google data studio

Add some fun

Google data Studio offers filters that simply permit you to specify your information even more nicely. It offers you so much more background. You’ll be able to add source as a filter, Medium, Campaign, Country, you name it, you’ll be able to filter it. confirm it is sensible though. For me, this is such an amazing feature of Google data Studio!

google data filter

You can additionally add a date range filter, that permits you to regulate the date range to your own liking’s. This makes certain that your dashboard isn’t simply a one-time issue, however a dynamic dashboard you’ll be able to use in any respect times.

The first thing I continuously do once I produce a report is adding the date range filter. and that i really sit down and believe what kind of filters i need. I generally even extend the report I’d wish to see by hand on a chunk of paper then produce it in Google data Studio.

There are some cool options that you simply will add within the table itself. for example, you’ll be able to add heatmaps to your columns so you’ll be able to simply spot rows that stand out from others.

google data chart

You can even compare date ranges so you’ll be able to see if you’ve gotten, for instance, a lot of sessions from a selected source. And you’ll provide it all the colours and fonts you would like, keep the readability in mind though!



Starting with Google data Studio isn’t as laborious as you may suppose. And for me, it permits me to possess a lot of fun with Google Analytics data. If you catch yourself spending time on building identical reports, or adding identical secondary dimensions over and once again, it would be a decent plan to just additionally produce that report in Google data Studio. it’ll prevent time and also the cool factor is that you just can share your report with others.



Facebook Comments