Blending data is a great feature of Google Data Studio.
Below I’ll give a basic step by step example of how to combine two different data sources.
For this example, I created two separate worksheets in Google Sheets.
|Customer List||January Sales|
|Customer Name||Customer Name|
|Unique ID||Unique ID|
|Date of Birth||Date of Purchase|
|Favourite Colour||What Customer bought|
|Mode of Transport|
The sheets share two common columns, Customer Name and Unique ID.
The next step is to add both worksheets as separate data sources in Google Data Studio.
Let’s see if both worksheets are connected to the Data Studio report correctly.
We see that both Data sheets are connected properly. The next step is to create a blended data source.
Creating a Blended Data Source
Click Resource and then Manage blended data.
We will see that there are currently no blended data sources. That means we need to create one. To do this click Add a Data View.
We now have to select both worksheets as the two data sources we want to combine and blend together.
In this example, the first data source is the fictional ‘Customer List’.
The second is the January Sales List.
Now that we have both worksheets next to each other, we can connect using a Join Key and add the dimensions we want.
We will use the Unique ID dimension as the default key, as this lets us match customers from our Customer List to customers on our January Sales List.
We choose Unique ID as our Join Key, and now both data sources are connected.
We then add the dimensions from each worksheet. In this example I’ve only included dimensions and no metrics.
On the right of the screen we see our new data source (which I’ve named Blended Data) and the list of all the dimensions it contains.
With our two worksheets combined, we can use the Blended Data as a data source just like any other.
In the Data Studio report below I’ve created three tables. The first two show the information in each of the seperate sheets, and the third table below shows the data blended together.