Adding Multiple Data Sources in Google Data Studio

Learn how to add multiple data sources to a single report in Google Data Studio. Walk-through how to connect data sources and how to use the 'Data Blending' feature to combine data from different data sources.

EXTRA RESOURCES:

#GoogleDataStudio
#GoogleAnalytics

[moacirjunior]

4:50 man, I lost a 2 days trying to blend two different datas without success. Tha solve and save my day. thanks

[newangleanalytics]

Thank you so much for this! I wanted to combine two GA properties and analyze overall traffic via blended data. This was the perfect video to watch!

[jeanvaljean]

Thank you for this great tutorial. It works perfect ! It gives a good feeling learning something useful.

[pawaskaradam]

Hey Benjamin. Thank you for guiding on the Blending techniques applied on different data-source of same/different characteristics. However, I feel the data transformation process (data blending) would be too complex & time consuming if we are blending data from 2 data sources accounts from same platform, because there will be lot of dimensions/metrics to be considered for merging.

Also, would be helpful if you can guide on how to include same dimensions from 2 different accounts from same platform.
For e.g. If I am looking forward to roll-up data from 2 AdWords account, my blending key would be "Day", & I will add same dimensions & metrics under both the data sources and save it. (please correct me if I am wrong).

In this case, common metrics can be merged to form a "Combined" metric through formula, however, what I have doubts is on how to combine/roll-up common dimensions (considering the values under the dimension can be same or different for e.g. Account Name)

My query is not just regarding AdWords, but regarding merger of all those data-source which are sourced from same platform.

[tomijojo]

Thanks a lot, great quick and simple explanation! Didn't know you could just right click and blend data 👀

[Blueeyeda]

Thank you, this was exactly what I was looking for + somethings I didn't know I wanted to know :)

[wirot]

Could you please advise how to use same filter to view 2 tables from 2 data source. Thank you very much.

[nathandavidson]

Hi, thanks for the tutorial. Sadly I get a System Error when I try to blend two data sources together. I've followed your steps carefully and tried a few times. Would you be interested in taking a look?

[janniemuller]

Hi Benjamin, I have two fact tables (data sources), factACTUAL and factBUDGET, and two dimension tables, dimCOA and dimDate. I can link/blend one of the two dimension tables to both fact tables, but I can only link the second dimension table to one of the two fact tables. What would be the problem? Thanks Jannie.

[afridiattar]

How to connect 2 pages in one filter in data studio if I change something in page 1 it is not changing in page 2 plz give me answer or I should create dashboard in single page?

[mnLaaaa]

Hi! The platform doesn't add the numbers. It only shows a blue line but with 0, but in the separate charts both shows the curve with numbers. I want to combine the data from 1 property that was recollecting all 2020, and another one that starts recollecting data this year. Is this a problem?

[mdjavedfurquan]

Great info... Can we merge 2 different dashboards in single dashboard

[fabiogiuliani]

There is a way to show the sum of sessions of Site X + Site y? I don't understand which "join" I have o use to show it.

[samsongstudios]

what if I want to link two or multiple sheets with same data month on month, it should just be a source in continuation of next month and so on. But no master sheets. Please advise

[VrlHtzz]

Sir how can I add multiple tables form a single data source (postgresql). I am having 80+ tables so should I need to make 80+ connection for making a new report using new table every time???

[mariasaras]

How we can blend 2 google sheet with same format and header name into google data studio?
I try it but it always show just 1 file, it cant blend into 1 table. Can you help me? Thank you

[mdjavedfurquan]

Dear, my GDS is not picked up to additional columns which are inserted in Google sheet. Please help me...

[ajinchacko]

How to add Facebook and Instagram data