How to Blend Data in Google Data Studio

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 ListJanuary Sales
Customer NameCustomer Name
Unique IDUnique ID
Date of BirthDate of Purchase
Favourite ColourWhat 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.

The first set of information
the second set of information

Adding a data source to the data studio report

Let’s see if both worksheets are connected to the Data Studio report correctly.

Managing added data sources
two sheets - January sales and the customer list

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.

Clicking 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.

Blending data in Google Data Studio.

We now have to select both worksheets as the two data sources we want to combine and blend together.

Selecting a data source

In this example, the first data source is the fictional ‘Customer List’.

Adding the dimensions and metrics to the data source

The second is the January Sales List.

Blending data in Google Data Studio.

Now that we have both worksheets next to each other, we can connect using a Join Key and add the dimensions we want.

two sources of information in the program

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.

Adding unique ID to the data source

We choose Unique ID as our Join Key, and now both data sources are connected.

Blending data in Google Data Studio.

We then add the dimensions from each worksheet. In this example I’ve only included dimensions and no metrics.

Blending data in Google Data Studio.

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.

Blending data in Google Data Studio.

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.

Michael Howe-Ely