Data Studio Tips + Tricks Series: Combining GA Properties

Estimated Reading Time: 2 minute

Creating a dashboard is sometimes like putting a puzzle together, specifically a data puzzle. Regardless of platform or data environment, I have found you will more often than not need to manipulate your data structures and reporting options to make everything fit perfectly into your dashboard. Perhaps your media agency is launching a campaign on a new platform, or there is a customer table not currently ETL'd into your data warehouse. Either way you're stuck without precisely what you need to build your dashboard, and of course, everyone wants to know how that new campaign is doing.

Data Studio is an incredibly powerful tool for creating a dashboard, but it does have limitations on which data sources it will natively work with and exactly how the data is visualized. The gap between what you have and what is being asked for will generally always exist and waiting on IT to engineer a solution could take months to a year to be implemented, which means we need to do a little work to put this puzzle together. To help with your creativity, I will share some of the tools I've used recently for Google Data Studio to overcome data limitations.

Help, my Google Analytics Data Lives in Different Accounts! 

Perhaps you just don't have a roll-up property for your sites, or maybe a new promotional site isn't integrated into your GA account. While Data Studio can connect to roughly 120 different types of data sources, I have found that a Google Sheet is sometimes a necessary buffer. It will help us in this example but could be used in many other use-cases. Perhaps you need to combine customer data sets to summarize data in a way that's not native to your existing reporting. In my example, I am combining multiple Google Analytics properties because data blending does not support this in Data Studio. To do this first pull in your data from GA using the sheets connector.

Image

My typical setup is to create a loading zone to capture all of my raw data. In case you're wondering, you can have up to 200 tabs in a single Google sheet. Depending on what you're summarizing that limit may be significant. You can see in the screenshot above I am grouping three distinct report sets across two different views, however scaling this solution out can leave you with a ton of tabs. I have reporting setup for a rolling 30-day period, which ensures it will always be loaded in exactly the same way when it is refreshed, which is essential. When combining data sets, think about how your data may change over time and build in plenty of room to grow, it's better to have it and not need it then to need it and have to create it 6 months from now.

That said you will then need to schedule your reports to run, below I am refreshing my data every hour.

Image

Lastly, create a summary tab to combine everything, there's not a lot of magic here just formulas that pull in and then summarize my data exactly how I need it. You could also consider using the ImportRange function in Google Sheets however I personally prefer to hard code cells to reference others.

Image

But Wait, What if You Don’t Need All that Data for Reporting that’s Being Loaded?

Sometimes you may need to be a little more specific about the data you're pulling in, rather than just grabbing everything that's loaded. Imagine you're picking a Device Category report with all of your metrics but really all you care about are the mobile metrics - pulling in everything would clearly be inefficient. This approach is also handy, as a back-end approach to applying segments to your reporting. To do this, I have successfully written a vlookup formula with multiple search conditions. You'll see below I make use of the Index and Match functions in google sheets.

In my example, I want to pull in data for a specific date and device from my ‘LoadingZone1' data tab

Image

First I reference all of the data in my loading zone, and then in my two match statements I reference the specific criteria I'm looking for. For instance, A1 could contain my current date while B1 is the ‘mobile' data I'm looking for. This formula can help you pare down the data you're loading into Data Studio into precisely what you need, making it far more responsive.

Ready to become a Data Studio wizard? Contact the Data Studio experts at InfoTrust today to discuss your data reporting needs.

Facebook
Twitter
LinkedIn
Email
Originally Published: January 16, 2019
May 31, 2023
Originally published on January 16, 2019

Other Articles You Will Enjoy

Beyond the Basics: Deep Dive into Google Analytics 4’s Bounce Rate, Engagement Rate, and Engaged Sessions

Beyond the Basics: Deep Dive into Google Analytics 4’s Bounce Rate, Engagement Rate, and Engaged Sessions

You’ve probably come across the notion that Google Analytics 4 (GA4) and Universal Analytics (UA) are distinct platforms, despite both being products of Google….

3-minute read
Unlocking Insights: Your Ultimate Google Analytics 4 Funnel Exploration Tutorial

Unlocking Insights: Your Ultimate Google Analytics 4 Funnel Exploration Tutorial

The funnel report is one of the most important reports available to digital marketers. Luckily, Google Analytics 4 (GA4) has made funnel reports more…

5-minute read
Navigating Conversions and Channel Paths in Google Analytics 4

Navigating Conversions and Channel Paths in Google Analytics 4

The shift from Universal Analytics to Google Analytics 4 (GA4) has brought a range of new capabilities and insights for marketers and analysts. Among…

3-minute read
Navigating the Complexity of Measuring Connected TV and OTT with Web Analytics Tools: A Privacy-Centric Perspective

Navigating the Complexity of Measuring Connected TV and OTT with Web Analytics Tools: A Privacy-Centric Perspective

Connected TV (CTV) devices and Over-The-Top (OTT) platforms have experienced significant growth in recent years, becoming a preferred choice for consuming content on various…

8-minute read
Universal Analytics and Google Analytics 4: A Comparison

Universal Analytics and Google Analytics 4: A Comparison

Universal Analytics (UA) is an earlier version of analytics and supports web measurement. It is built for a generation of online measurement that was…

5-minute read
How to Use Data Exploration Reports in Google Analytics 4 to Uncover Hidden Insights and Opportunities

How to Use Data Exploration Reports in Google Analytics 4 to Uncover Hidden Insights and Opportunities

Introduction Now that we have migrated away from Universal Analytics, you may be wondering to yourself, “How can I use Google Analytics 4 (GA4)…

7-minute read
Top 4 Considerations When Comparing Google Analytics 4 to Universal Analytics

Top 4 Considerations When Comparing Google Analytics 4 to Universal Analytics

In today’s digital landscape, understanding user behavior is crucial for businesses to optimize their online presence and drive growth. Google Analytics has been a…

5-minute read
Exporting Your Google Analytics 4 Data: File Download vs Google Analytics Data API (GA4) vs BigQuery Export

Exporting Your Google Analytics 4 Data: File Download vs Google Analytics Data API (GA4) vs BigQuery Export

As Google Analytics 4 (GA4) users continue to build out reporting and analytics assets, leveraging the correct product is key to ensuring success. There…

8-minute read
Google Analytics 4 Automigration Essentials

Google Analytics 4 Automigration Essentials

Introduction: Universal Analytics 360 Sunset Ladies and gentlemen, marketers, and data enthusiasts, the digital world is evolving faster than a cheetah on caffeine, and…

5-minute read

Get Your Assessment

Thank you! We will be in touch with your results soon.
{{ field.placeholder }}
{{ option.name }}

Talk To Us

Talk To Us

Receive Book Updates

Fill out this form to receive email announcements about Crawl, Walk, Run: Advancing Analytics Maturity with Google Marketing Platform. This includes pre-sale dates, official publishing dates, and more.

Search InfoTrust

Leave Us A Review

Leave a review and let us know how we’re doing. Only actual clients, please.