A simple Google Analytics report template in Data Studio

In this post, I’ll just be sharing a simple Google Analytics report template I created in Google Data Studio.

It shows four main charts and tables showing;

  • A breakdown of the default channel groupings for each day
  • An overall breakdown of default channel groupings for the month
  • A list of top pages by sessions
  • A list of top source/mediums by sessions

I’ll also give a breakdown of some of various charts and how they are put together.

The first chart is a breakdown of the main date range chart showing a breakdown of the default channel groupings of sessions.

A date based bar chart in Google Data Studio using Google Analytics data

To set this up, choose a bar chart (not a time series) and set it up as the following;

Dimension = Date
Breakdown Dimension = Default Channel Grouping
Metric = Sessions
Sort = Date (ascending)

Then in the Style tab for the chart, make sure Stacked Bars is ticked. Also set the number of bars to more than the default 10 so that it can display the whole month. I’ve set it to 100.

The data and style tabs for a bar chart in Google Data Studio

The next chart we want to set up is an overall breakdown of default channel groupings.

A bar chart in Google Data Studio

For this chart we need to set it up as the following;

Dimension = Default Channel Grouping
Breakdown Dimension = Default Channel Grouping
Metric = Sessions
Sort = Sessions

The data for a bar chart in Google Data Studio

The other two charts are simply tables with heatmaps. One for Page Title and the other for Source/Medium.

And then we have our simple Google Analytics report. This one I made with the idea that it would be something I’d use to quickly check up on who’s been visiting my site. But without getting into too much nitty gritty detail.

A simple Google Analytics report template in Google Data Studio

If you liked this article you might like my other blog posts.

Or you can follow me on Twitter!

Michael Howe-Ely