How to Blend Data in Google Data Studio

By 30th Jan 2019Blog, Google Data Studio
Blending Data in Google Data Studio

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

Blending data in Google Data Studio.
Blending data in Google Data Studio.


Blending data in Google Data Studio.

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

Blending data in Google Data Studio.
Blending data in Google Data Studio.

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.

Blending data in Google Data Studio.

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.

Blending data in Google Data Studio.

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

Blending data in Google Data Studio.

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.

Blending data in Google Data Studio.

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.

Blending data in Google Data Studio.

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.

Michael

Author Michael

More posts by Michael

Leave a Reply