How to Add Multiple Data Sources to Google Data Studio Report

Josh Gladstone

Josh Gladstone
Product Manager

Max min read

In order to begin using Google Data Studio to report on paid advertising campaigns, the first thing you need to do is connect your data to Data Studio. Most marketers will need to connect data from more than one source into Data Studio. While this process can be a bit tricky, it’s fairly easy to choose your data sources, find the appropriate connectors needed, and attach each source to the report you’ll want to flow data into.

Why you should add multiple data sources to a data studio report

If you’re using Google Data Studio (GDS) to report on advertising campaigns, the first step to visualizing your paid campaign performance is to connect your ad data sources. Remember, your campaigns are more than likely composed of ads running on multiple platforms—so if you’re not connecting all of those separate platforms to your data studio report, you’re not reporting on the full ad campaign.

To gain a full understanding of how your cross-platform advertising campaigns are performing, make sure you have a composite list of everywhere your ads are running (or where that data is being stored) so that you can connect everything to Google Data Studio for reporting.

Here’s how to add multiple data sources into a Google Data Studio report:

 

Adding your first data source to Google Data Studio

To add in your first data source to your Google Data Studio report, follow these steps:

  1. From your report, click “Add Data”
  2. If you have already created the data source within Google Data Studio:
    • Click “My Data Sources”
    • Select the data source you want to add to the report
    • Click “Add”
  3. If you haven’t already created the data source within Google Data Studio:
    • In the “Connect to Data” tab, find the connector you want to use
    • Select the connector and follow the instructions to get it configured
    • Once configured, click “Add”

Graphic Of Adding Multiple Data Source Gds

 

Adding a second data source to Google Data Studio

To add an additional data source to your Google Data Studio report, follow these steps:

  1. From your report, click “Add Data”
  2. If you have already created the data source in Google Data Studio:
    • Click “My Data Sources”
    • Select the data source you want to add to the report
    • Click “Add”
  3. If you haven’t already created the data source in Google Data Studio:
    • In the “Connect to Data” tab, find the connector you want to use
    • Select the connector and follow the instructions to get it configured
    • Once configured, click “Add”

Add Secondary Data Source To Gds

 

Managing multiple data studio sources

You can add as many data sources as you want to your report, but keep in mind that the more data studio sources you add, the more data sources you must manage and maintain.

To manage your data sources, choose Resource > Manage Added Data Sources. This allows you to:

  • Remove a data source—this will remove the data studio source from the report. Any charts using this data source will break, but the data source will still exist within your Data Studio account
  • Duplicate a data source
  • Make a data source reusable—this allows the same data source to be used in multiple reports; good for sharing a single data set across an organization
  • Edit a data source—choosing to edit a data source allows you to:
    • Edit the name of the data source (which is helpful for keeping your data sources organized)
    • Edit the names of metrics and dimensions (which is helpful for stakeholders to understand how to interpret the report they’re reading)
    • Adjust the type, aggregation, and/or description your metrics and dimensions (this ensures accurate data calculations)

 

Unifying data prior to connecting to Google Data Studio

Of course, there is an easier way to report on cross-platform advertising campaigns without having to connect both Facebook and Google Ads to Google Data Studio separately. Instead of connecting and managing each set of data individually, consider using an app like Joinr to unify data into a single, clean set of data, and flowing that into your data studio report.

Marketers might also hear this process referred to as data blending or harmonization—however data unification takes the process one step further by passing each data set through it, stripping away unnecessary metrics from each source, and then blending the common, and most important data points together. This not only provides a cleaner set of data to use for ad performance analysis, but also creates a much easier and efficient way to connect multiple data sources to Google Data Studio and manage them over a period of time.

Next Chapter >>

Get a free, blended and unified data source with Joinr

Joinr delivers a single, blended data set to Google Data Studio for analysis, so you can save time adding multiple data sources manually.