In this blog you'll learn how to connect to multiple data sources to your Google Data Studio report. You can connect multiple data sources when you want to create a dashboard or report that includes multiple elements. For example, if you wanted to create a social media dashboard then you might want to include data from Instagram, Facebook, LinkedIn, and Twitter in a single snapshot. Or you want to combine multiple Google Analytics accounts to create a rollup report or you want to merge data you can do this by connecting multiple data sources.
Let's start by creating a new report. For example, you use a Google Analytics account as your first data source, connect the data source. Now keep things simple
for this report, change the default chart to a scorecard and change the metric to users. This scorecard will now show the total number of users on the website. Now if you wanted to also include data from your YouTube channel in the same dashboard
then you need to add another data source. To do this we can either select “resource” and, then manage added data sources and, travel through the steps or you can simply select the “add data” option. Now click “Add” and select “add to report.”
You can now use this new data source in your dashboard. To do this you need to add a chart. Let’s add another scorecard to the dashboard, selecting the data source for the chart lets you change between the different data sources you have connected. You will see for this report, where you connected Google Analytics and YouTube. You can change the metric for the scorecard. You now have a dashboard that includes data from two data sources.
Let’s look at how to merge data using a blended data source. You can use this if you have information in two different data sources that you want to combine. For example, if you had separate Google Analytics reporting views and you wanted to combine data to create a rollup report. To make a blended data source you'll need to start by ensuring you have a key that is available in both sources. This is basically a piece of information that is available in both sets of data. For example, you can use date to combine data. Once you add your data sources, add a time series to your report, use this time series to show the first data source and change the metric to users. Next copy this time series and change the data source to the second data source. Now you can select both charts then right-click and select “blend data.”
This is the quickest way to combine data from multiple sources for more control. You can use the “manage blended data” option under “resource.” These charts look identical to the others because you now have two separate metrics for users. You can see this in the right column. This means you will need to create our own metric to combine both of the user metrics. Before you do this we recommend renaming the
metrics so that you know you're combining them correctly. To do this click the “Edit” icon for the blended data source and then edit the names of the metrics. Then click “Save” and go back to the report. Now select add metric and then “create field.”
So that's how you can connect to multiple data sources to use in your Google Data Studio reports and dashboards. Although you might not need to connect multiple data sources for all of the reports you create, it's a great way to combine data from multiple platforms in a single snapshot. Remember you can even use the blended data option to join data from different sources if you have a key that is available in both sources.