Report Across Multiple Webpages Using Google Analytics

Run one report to get web analytics data from different accounts and web properties, all in the same spreadsheet.

All Tutorials


Requirements Not Met

Before continuing, you'll want to or with Blockspring.
Otherwise none of this is going to be any fun. Let us know if you need help in the chat window below.

Overview

If you're working with multiple webpages, you probably want to compare their performance to each other. Understanding which are performing well or poorly compared to the rest of the pack helps you focus your efforts in the right place and learn from your successes. To do this analysis, you may have been running multiple different Google Analytics report for each View you care about and copying the data into a single spreadsheet.

We're going to show you how to report across multiple webpages using Google Analytics using a single report. Your data with show up in a single spreadsheet tab without additional exporting or other work.

You will go through the following two steps:

  • Report across multiple webpages using Google Analytics
  • Use a pivot table to find the most and least trafficked landing pages across multiple webpages

Once you've gone through these steps, you'll be able to build other custom reports across multiple webpages, and gain valuable insights into how the performance of your individual webpages compare to each other.

Video Demo: Report across multiple webpages using Google Analytics

Let's say you have a number of different web properties, such as multiple different blogs or brand presences, and you want to identify the most and least trafficked landing pages. This will help you understand where to focus your ongoing optimization efforts.

We'll show you how to identify the best and worst performing landing pages across multiple webpages using Google Analytics in this video demo. The example we use is identifying the most and least trafficked landing pages across a number of web properties. Get started by opening a new Google Sheet, and following along here:


Next Steps

You've learned how to report across multiple webpages in a single Google Analytics report, and how this can be used to find the most and least trafficked landing pages in the pack. Here are some ideas on what to do now:

  • The more webpages you report across, the more data you are likely to have to sift through. Built-in spreadsheet functionality like charts and conditional formatting are great at making sense of everything. Want to quickly compare traffic across multiple landing pages? Try a bar chart. Curious about which sites are outliers? Try comparing bounce rates to sessions in a scatterplot for each landing page, and see if any jump out of the pack.
  • Another effective method to make sense of the data is to set up a "Top 5" or "Top 10" section of your report - for example, the Top 10 Landing Pages by Pageviews. You can use Blockspring's Filter functionality to do this directly, or apply a pivot table to your current data set. Try investigating what is working for the Top X and applying this knowledge to the bottom sites.
  • The "80/20" rule often applies to websites across a portfolio. Use the Top X section we describe above and compare it to the rest of your sites - for example, if you have 100 landing pages to look at, do the top 20 landing pages by pageviews make up 80% of your total pageviews?


That's a Wrap

Thanks for using this tutorial series - we'd love to hear your feedback!

  • Did something not make sense at all or think you have a better way to explain a concept?
  • Maybe you want some more information about how to make Blockspring work for you?
  • Or perhaps you use other tools or services that you’d like to see Blockspring explore?

Let us know in the chat window below or join the Blockspring Community Slack