By default, Google Data Studio only allows you to blend up to five data sources at a time. While this is sufficient for smaller reporting ventures, it just doesn’t make the cut when you’re looking for aggregations across more than five Google Analytics accounts. This is a common issue for companies managing several brands or locations when it’s time to report on how the company is doing overall.
So how can you easily aggregate data from more than five Google Analytics accounts? Enter the Google Analytics add-on for Google Sheets! This is a free tool that pulls data straight from the Google Analytics API. You can pull in the data you need from each analytics account, set up calculated fields to aggregate it, and then push it into Data Studio. You can even set a schedule for the data to update so you really shouldn’t have to revisit your Google Sheet too often.
Here are the steps we’ll follow to accomplish this:
1. Install the Google Analytics add-on for Google Sheets
2. Create …