In this post I’ll give a basic overview of how to blend data in Google Data Studio. Blending data is a very useful feature that will help you combine different data sets for your dashboard.

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.

My Other Blog Posts

Hope you enjoyed this post! Maybe you’d enjoy my other Blog Posts.