Setting up a custom traffic report with Google Analytics

Learn how to build a custom traffic report using Google Analytics

Intro

Making an internet business succeed is very much about deeply understanding the so-called ‘user journey’, that is how people interact and engage with your product along the whole funnel: from approaching the website and engaging with your content, to using your features and coming back.

The American cancer society is one of the world's leading institutions in cancer research. It's been working for more than a century, and after having converted part of its business - especially the lead generation - to online, they have soon realized the need to know how users consume its website, with the ultimate aim of channelizing its marketing efforts and reaching their revenue goal.

As a first step, they classified their website users into three buckets: information seekers, event participants, and potential donors. They then use analytics tools to introduce a scoring system for each dimension using custom metrics to check whether they have met their goals. Finally, they focused on retention, designing specific remarketing campaigns for these audiences. Thanks to this approach, revenues have soared by 5.4% year over year.

What is Google Analytics

Google Analytics is the web analytics tool offered by Google, that allows marketing and product managers to map the flow of visitors to a set of specific funnel steps that result in conversions or signups. Along this flow, many KPIs can be evaluated to infer how your users used or perceived specific parts of their journey.

Despite being a powerful dashboard, every time you need the flexibility of a spreadsheet you find yourself exporting/importing .csv files.

In this short guide, we’ll walk you through everything you need to create a dynamic custom Google Analytics report directly in Rows. Here’s a sneak peek at what you will get:

Screenshot 2022-09-09 at 13.28.56

Let's go!

To understand how we’re going to build it, let’s go step by step.

First of all, you need to enable the Google Analytics integration.

Click on the Connect button and follow the instructions. The Google Auth page will open: enter your Google credentials and authorize Rows to retrieve your data.

Screenshot 2022-08-19 at 12.42.24

Now you are ready to build your report. Click on the Create spreadsheet button at the top of your dashboard.

Once you land on your spreadsheet, first of all, rename it: click on its title in the top left corner and type the new name. Use it also as a title for the first page, by pasting it on the page title. It'll be easier to find it later on.

Screenshot 2022-09-09 at 09.30.22

Rows allows you to have multiple tables on the same page, giving you a neat view of your data. Select cell A1, click on the Actions menu in the toolbar, and look for our ANALYTICS_GOOGLE() functions: many are available, depending on your ultimate goal, for example: CUSTOM_ANALYTICS_GOOGLE(), PAGE_ANALYTICS_GOOGLE() or SESSION_ANALYTICS_GOOGLE()

For the purpose of this guide, we choose to retrieve data using Rows' CUSTOM_ANALYTICS_GOOGLE() and build a simple view of the typical traffic metrics, aggregated per week. On the right-hand side of your display, the function wizard shows up. At the top, you can see the name of the integration you turned on in the first steps of this guide. Let's go through all the fields together:

  • Id. Pick here your profile Id from the drop down list
  • Date range. Use it to filter your data within the specified timeframe
  • Metrics. These are the key metrics you want to display in your report, such as pageViews, session, Average time on page, etc. To know more, please have a look at Google metrics and dimensions explorer
  • Set page path. Use it to filter your data for specific page paths, i.e. /pricing
  • Set dimensions. Use it to break down your data according to some specific variable, i.e. time, browsers, location. Google supports up to 7 dimensions. To know more, please have a look at Google metrics and dimensions explorer
  • Set sort. Use it to sort your data asc or desc
  • Set segment. Use it to filter your data for a specific segment of users

Screenshot 2022-09-27 at 17.41.16

Clicking on the button Next step, Rows will guides you through the creation of the output table, to display all data retrieved from the integration. Choose the table headers from the first drop down, and hit Create Data Table.

Screenshot 2022-09-27 at 17.41.35

You can rename the table's columns by simply double-clicking on the column label and following the instructions in the popup.

In case you need to reorder or remove some of the table's columns, just click on the ... icon in the table's top right corner and drag and drop the headers in the right-hand side wizard

If you followed all the above points, you now have a summary table showing aggregated metrics for each week in the selected time frame. Of course, you can choose to pull data only for specific pages - e.g. your /pricing page - and breaking down per country or device -, the goal being to understand how users from different countries, using mobile vs. desktop devices interact with your pricing page.

All you need to do is to go back to your Google data cell and click on the ... icon and then Edit function. This is just one of the endless opportunities you can leverage the power of Google Analytics within the flexibility of a spreadsheet

Embed into documents

Finally, if you are using Notion or any other internal tools that support iframes to build a report, you can embed any table or chart of this spreadsheet in your document. Just click on the ... icon in the top right corner of the table and pick Embed. A modal will open, as follows:

Screenshot 2022-09-07 at 10.20.26

Before embedding any table or chart of a spreadsheet, you need to grant access to it. Follow the yellow message, and toggle on the Share privately option in the Share tab, as follows:

ezgif-4-ff406c1d5a

Once the spreadsheet's sharing option has been enabled, you just need to hit Copy URL from the Embed tab and paste the link into your document.

Screenshot 2022-09-07 at 10.20.26

This is how Rows embed looks on Notion:

ezgif-4-87d865e2b5

You might also like