Implementing rollup reporting in Google Analytics

Google Analytics Developer, Google Analytics Premium

If your company run several websites, sub-domains and/or mobile apps to promote various brands/regional business units and you want to understand the overall performance of your company and also compare the performance of individual brands/ business units to each other then you need to set up rollup reporting in your Google Analytics account.

Rollup reporting is simply the reporting of data in aggregated form from multiple digital properties (websites, mobile apps).

For example, if you have setup separate websites for each country (abc.com, abc.co.uk, abc.com.au,abc.in etc) then through rollup reporting you can aggregate all of your websites data in one view and see aggregated global performance metrics and/or compare the performance of various country specific websites to each other.

Rollup reporting helps you in understanding the overall performance of all of your company’s websites and/or mobile apps.

Through rollup reporting you can see total unique visitor reach of all of your websites and/ or apps.

In other words you can determine the total number of unique people you are reaching to through your websites, apps and/or marketing campaigns.

There are two ways of setting up roll up reporting in Google Analytics:

#1 By using multiple trackers on each page of your website.

Let us call this method as ‘Standard rollup reporting‘ for easy reference.

#2 By using Google Analytics Premium.

Let us call this method as ‘Premium rollup reporting‘ for easy reference.

In this article I will explain both of these methods in great detail as well as outline their pros and cons.

Structure of a Google Analytics Account

In order to implement roll up reporting, you must know how a Google Analytics account is structured:

Google Analytics Set-up for business owners who own only one website.

Google Analytics Set-up for business owners who own multiple websites/sub-domains

Google Analytics Set-up for marketing consultants/agencies.

Unless you are a marketing consultant or an agency, you are most likely to have only one Google Analytics account and one property.

If you have got multiple Google Analytics account then each account is usually meant for one company/client.

Get the E-book (52 Pages)

Get the E-Book (37 Pages)

A GA account can contain one or more properties.

A property (also known as digital property) can be a website or a mobile application.

We usually create one property per website/app. But in case of rollup reporting we may need to create multiple properties for a single website. Each property is identified by a unique ID known as property ID. A property Id is in the format: UA-12345-21.

A property can contain one or more views (also known as profiles).

A view contains all/segmented data of a digital property.

Each view contains multiple reports for a property. So whenever you are looking at Google Analytics data, you are actually looking at one of the reports of a view and this view belongs to some property.

Introduction to Rollup Property

A roll up property is a special type of GA property whose hit data comes from other GA properties ( also known as source properties).

In other words, a roll up property is made up of two or more source properties.

In a ‘simple rollup property setup’, a company which owns multiple websites/subdomains create one rollup property and this rollup property contains hit data (pageview, screenview, event, transaction etc) from its other GA properties (also known as source properties in the context of rollup reporting):

Simple rollup property setup

Since a property generally represents a website, the ‘simple rollup property setup’ below is same as the one above:

Simple rollup property setup.

Sometimes because of unique measurement requirements, a company may need to create a new Google Analytics account just to handle rollup data. This account is called a rollup account and it contains mutiple rollup properties:

Advanced rollup properties setup

Rollup account in GA premium

Note: If you see the symbol ‘P’ next to a property then it means it is a premium property (available only to Google Analytics premium users).

You work with rollup account/property in the same way you work with any other GA account/property. So you can also create several views in a rollup property and these views are knowns as rollup views.

It is the presence of rollup property which makes rollup reporting possible in Google Analytics.

All of the reports in your rollup property show data that is aggregated from several source properties. So in rollup reports you see collective acquisition, collective behavior and collective conversion data for all of linked source properties.

For example lets say you have got two websites: website A and website B.

Website A got 100 visits and Website B got 200 visits.

Website A got 10 conversions and Website B got 20 conversions.

Now your rollup property (which includes traffic data of both website A and Website b), will show total visits (i.e. 100+200 = 300) for both websites in its default view. Similarly, you will see total conversions (i.e. 10+20 = 30) for both websites in your rollup property’s default view.

Rollup properties are listed along with your other properties on the admin page.

Name of the rollup property should contain the word ‘rollup’ so that it becomes easy to recognize it in a property list:

optimize smart rollup

The advantage of using rollup property is that, you don’t need to export data from different web properties and then aggregate them offline via spreadsheets in order to measure the overall performance. A rollup property can do all of these tasks for you automatically.

Planning Rollup properties Setup

Before you actually setup rollup properties, you need to plan out in advance how the rollup properties structure should look like. This structure will depend upon the number and type of digital properties you own and your measurement requirements.

For example if you have setup separate websites for each country (like: abc.com, abc.co.uk and abc.com.au) and you want to see aggregated global performance metrics in one view, then the structure of your roll up property would be something like the one below:

abc inc rollup If you have setup several sub-domains (like: music.abc.com, travel.abc.com, art.abc.com) and you want to measure the overall performance of the website, then the structure of your roll up property would be something like the one below:

abc inc rollup2

Tracking Object

Before you can implement rollup reporting, there is one more thing that you need to be aware of and that is tracking objects. I explained about tracking objects in the article: Understanding trackers in Google Analytics

Tracking object (also known as tracker) is used to send traffic data to a Google Analytics web property.

You can not send hit data to a GA property without first creating a tracking object.

For example, the following line of code, creates a default tracking object through Google Analytics ‘create’ command and then associate the tracking object with the web property whose id is ‘UA-12345-67’:

ga(‘create’, ‘UA-12345-67′, ‘auto’); // send data to the web property whose ID is ‘UA-12345-67’.

You can see this line of code in the Google Analytics tracking code:

ga tracking code

If you remove the highlighted code from your tracking code, then Google Analytics won’t be able to send any hit data to your web property and you won’t see any data in your reports, going forward.

Note: ‘auto’ is not the name of the tracking object. The default tracking object has got no name.

If you want to send data to multiple web properties from a single web page, then you need to create and use multiple tracking objects on the same web page.

So if you want to send your hit data to another property (whose ID is say: UA-12345-89) too, then set up one more tracking object:

ga(‘create’, ‘UA-12345-89′, {‘name’: ‘newTracker’}); // New tracker

Now in order to also send the pageview data to the new tracking object, you need to use the ‘newTracker.send’ Google Analytics command:

ga(‘newTracker.send’, ‘pageview’); // send pageview data to the new tracker

Your Google Analytics tracking code will now look like the one below:

ga tracking code2

Note: A tracking object represents a web property.

Sending data to multiple properties from a single web page is the primary requirement for setting up rollup reporting.

Setting up Rollup properties in Google Analytics

Step-1: Gather measurement requirements and then plan the structure of your rollup property.

Step-2:Create a new property in your GA account and name it your ‘Company_Name + Rollup’:

new property

Step-3: Note down the property ID (also known as tracking ID) for your new roll up property. You will need this ID later in order to set up rollup reporting.

Step-4: Edit the Google Analytics tracking code of the first website (i.e. source property) whose hit data you want to add to your new rollup property:

<script>
(function(i,s,o,g,r,a,m){i[‘GoogleAnalyticsObject’]=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,’script’,’//www.google-analytics.com/analytics.js’,’ga’);

ga(‘create’, ‘UA-12345-67’, ‘auto’);
ga(‘create’, ‘UA-12345-89’,{‘name’:’rollupProperty’}); // create a new tracking object and name it ‘rollupProperty’
ga(‘send’, ‘pageview’);
ga (‘rollupProperty.send’,’pageview’); //send pageview data to the roll up property
</script>

Note: Do not copy paste this code. It won’t work for you. Modify this code by using your own property IDs

Step-5: Copy-paste the modified Google Analytics tracking code to each page of your website and then check the real time reports of the default view in the rollup property to make sure that it is getting the traffic data. Also check the real time reports of the default view of the source property to make sure that it is still getting the traffic data.

Congratulations you have just implemented rollup tracking. But unfortunately this is just the beginning and more or less a baby step towards rollup reporting.

In order to full implement rollup reporting, you need to share much more than pageview data with the rollup property. You need to update all of your event tracking code, ecommerce tracking code and any other additional tracking code used on the source property’s website.

So for example if you want to share event tracking data of the source property’s website with the rollup property’s website then you need to add additional line of the code like the one below:

ga(‘rollupProperty.send’,’event’,’Profitable Engagement’,’time on page more than 3 minutes’)”,180000); // send event hit to the rollup property.

Step-6: Repeat step 4 and 5 for each source property.

Step-7: Create and apply a new filter in the rollup property’s default view, through which you can view the full page URLs in your rollup reports. You need this filter in order to differentiate between web pages of two different websites.

view full page urls in reports

Drawbacks of Standard Rollup Reporting

While standard rollup reporting is easy to implement, it has its own drawbacks:

#1 De-duplication of unique users is not possible in case of standard rollup reporting. What that means is that, you can’t see total unique visitor reach of all of your websites and/ or apps in a rollup view.

#2 You need to re-tag several websites in order to set up roll up property.

#3 You can not automatically share the data imported to a source property with the rollup property just by using multiple trackers. In other words, a rollup property does not automatically include either the data you manually imported into source properties (like cost data, user data, product data, custom dimensions or custom metrics) nor the data your source properties inherited by linking to corresponding Adwords, Adsense, google webmaster tools etc.

If you want imported data of various source properties in your roll up property then you need to link your rollup property to all the linked accounts of your source properties. So if one of your source property is linked to an adwords account then you also need to link that adwords account to your roll up property. Similarly you need to import all of the data you manually imported to various source properties, to your roll up property. Lot of work. I know.

#4 You can’t evaluate the performance of multiple source properties side by side.

#5 Your rollup property won’t collect data retroactively from the source properties.

If you want to overcome all of these limitations then you need to use Premium Rollup Reporting.

Rollup Reporting in Google Analytics Premium

If you are using Google Analytics premium then all you need to do to set up rollup reporting is, to contact the GA premium customer support. They can create new roll up properties for you.

They will ask you details like account number, time zone, the number of rollup properties you want to create and the source properties you want to include in your rollup properties etc.

Note: You won’t find a button like ‘create roll up property’ in your premium account.

Once the roll up properties are in place and you have got the ‘edit permission’ at the rollup property level, you can manage a rollup property (i.e. add or remove individual source properties or change the display names of the source property) by going to Admin and then clicking on the ‘Rollup management’ link under the ‘property’ column.

Advantages of Premium Rollup Reporting

#1 Premium rollup reporting allows de-duplication of unique users. What that means is that, you can see total unique visitor reach of all of your websites and/or apps in a rollup view.

#2 You don’t need to re-tag several websites in order to set up roll up property. Although re-tagging is still required but now it is the headache of the GA premium team and not yours.

#3 Premium rollup properties also don’t automatically inherit the data which was imported to source properties. This data includes the data you manually imported into source properties (like cost data, user data, product data, custom dimensions or custom metrics) and the data your source properties inherited by linking to corresponding Adwords, Adsense, google webmaster tools etc.

If you want imported data of various source properties in your roll up property then you need to link your rollup property to all the linked accounts of your source properties.

However GA premium makes it easier to share the data imported to a source property with a rollup property via a Dimensions mapping or Metric mapping:

Since rollup property does not automatically inherit custom dimension/metric data from source properties, you need to create new custom dimensions and metrics in your rollup property and then map them to the custom dimension and metrics you created for individual source properties. Such type of mapping is known as dimension mapping or metric mapping:

dimension mapping

Through dimension/metric mapping you can easily inherit custom dimension/custom metric data from source properties into your rollup account.

However you dont need to worry about uploading imported data of various source properties to your premium rollup property or carrying out dimension/metric mapping. Your GA premium account manager can do all of that for you.

Note: Dimension/Metric mapping feature is available only to GA premium users.

#4 You can evaluate the performance of multiple source properties side by side in a premium rollup property through ‘Source Properties’ report (under Audience > Roll-Up Reporting menu):

source properties report source properties report2

Through source properties report you can compare various brands and/or business units websites to each other and determine which are underperforming or outperforming. The primary dimension for this report is Source Property Display Name .

Note: Source properties report is available only to GA premium users.

Drawbacks of Premium Rollup reporting

#1 You can aggregate data from only those source properties which belong to the same GA account as the roll up property. So best time to set up a rollup account is when you are implementing Google Analytics for the first time on your website.

#2 You can not use a premium rollup property as a source property for another premium rollup property.

#3 Premium rollup properties don’t collect data retroactively from source properties.

Do you know the difference between Web Analytics and Google Analytics?

99.99% of course creators themselves don’t know the difference between Web analytics, Google Analytics (GA) and Google Tag Manager (GTM).

So they are teaching GA and GTM in the name of teaching Web analytics.

They just copy each other. Monkey see, monkey do.

But Web analytics is not about GA, GTM.

It is about analyzing and interpreting data, setting up goals, strategies and KPIs.

It’s about creating strategic roadmap for your business.

Web Analytics is the core skill. Google Analytics is just a tool used to implement ‘Web Analytics’.

You can also implement ‘Web analytics’ via other tools like ‘adobe analytics’, ‘kissmetrics’ etc.

Using Google Analytics without the good understanding of ‘Web analytics’ is like driving around in a car, in a big city without understanding the traffic rules and road signs.

You are either likely to end up somewhere other than your destination or you get involved in an accident.

You learn data analysis and interpretation from Web analytics and not from Google Analytics.

The direction in which your analysis will move, will determine the direction in which your marketing campaigns and eventually your company will move to get the highest possible return on investment.

You get that direction from ‘Web analytics’ and not from ‘Google Analytics’.

You learn to set up KPIs, strategies and measurement framework for your business from ‘Web analytics’ and not from ‘Google Analytics’.

So if you are taking a course only on 'Google Analytics’, you are learning to use one of the tools of ‘Web analytics’. You are not learning the ‘Web analytics’ itself.

Since any person can learn to use Google Analytics in couple of weeks, you do no get any competitive advantage in the marketplace just by knowing GA.

You need to know lot more than GA in order to work in Web analytics and marketing field.

So what I have done, if you are interested, is I have put together a completely free training that will teach you exactly how I have been able to leverage web/digital analytics to generate floods of news sales and customers and how you can literally copy what I have done to get similar results.

Here what You'll Learn On This FREE Web Class!

1) Why digital analytics is the key to online business success

2) The number 1 reason why most marketers are not able to scale their advertising and maximize sales.

3) Why Google and Facebook ads don’t work for most businesses & how to make them work.

4) Why you won’t get any competitive advantage in the marketplace just by knowing Google Analytics.

5) The number 1 reason why conversion optimization is not working for your business.

6) How to advertise on any marketing platform for FREE with an unlimited budget.

7) How to learn and master digital analytics and conversion optimization in record time.

My best selling books on Digital Analytics and Conversion Optimization

Maths and Stats for Web Analytics and Conversion Optimization

Master the Essentials of Email Marketing Analytics

Attribution Modelling in Google Analytics and Beyond

Attribution Modelling in Google Ads and Facebook

Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.

Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.

Attribution Modelling in Google Analytics and Beyond
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.

Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.

Himanshu Sharma

Digital Marketing Consultant and Founder of Optimizesmart.com

Himanshu helps business owners and marketing professionals in generating more sales and ROI by fixing their website tracking issues, helping them understand their true customers purchase journey and helping them determine the most effective marketing channels for investment.

He has over 12 years experience in digital analytics and digital marketing.

He was nominated for the Digital Analytics Association's Awards for Excellence.

The Digital Analytics Association is a world renowned not-for-profit association which helps organisations overcome the challenges of data acquisition and application.

He is the author of four best-selling books on analytics and conversion optimization: