How To Add & Blend Data Sources In Looker Studio

Learn how to add multiple data sources and how to create blended data sources in a single Looker Studio report. Adding multiple data sources lets you present different data using your charts, and blending data can be used to combine data from multiple sources to create new metrics. In this video, we will cover how to create a blended data source using data from two Google Analytics properties. Let's get started!

JUMP TO A TOPIC:
00:00 Introduction
00:54 Create a new report
01:58 Add multiple data sources
03:52 Combining data in Looker Studio
05:06 Creating a blended data source
07:01 Joining data
08:30 Using blended data in charts
09:36 Quickly blending data
11:26 Conclusion

YOUR EXTRA RESOURCES:

#LookerStudio
#LookerStudioTutorial
#BlendedData

[jaimecalderin]

Hi! I find the content of your channel very interesting with an excellent contribution to the community. I'm switching from Power BI and Tableau to Looker, what I find a bit tricky is date handling. For example; group the dataset by specific months and years. It would be nice to see a video on this topic.

[skewedmaker]

Thanks for this video, it helped me solve the issue I was having combining exported legacy UA data that I had exported into multiple Google Sheets.

[HielkeHeijink]

Nice, comparing apples with apples when blending data. But what about blending different data sources like GA + GAds into 1 graph?

[AndrewClark-ot]

Great info here! Liked and subscribed. Are you having trouble adding a data source like so many others? I'm not able to copy an existing report/create a new data source. A video on this would be very helpful.

[kaundasledge]

Thank you i am combining data sorces and feel more confident after watching. One question, will the data remain active post blend or is blening just a static snap shot of data.

[ClifHaley]

Is there a way to compare two data sources in a single graph without blending them? For example, I'd like a single line graph showing the different trend lines between Universal Analytics and the new GA4...instead of combining those two sets of data into a single line of data.

[RobertoFernandezSalamanca]

Muchísimas gracias por el video, el doblaje al español esta muy bueno

[Drewschen]

This is a very useful video. I am trying to do the same thing however, in my case, I am joining 2 tables which don't have consecutive days in each table. Therefore I created a date dimension table which has 1 row per date and joined the 2 tables on that using the Date from the Date Dimension table in the visuals. However, Looker fails to group correctly with this approach. Could you do a video on this topic please?

[skylightorder]

Thank you for this. Much needed. Could I please ask you- Is there a way to join data based on something else other than date ? I am doing a report where I want to have
UA and GA4 data blended and I was wondering if there is another '' primary key '' we could use instead of date. Cheers !

[les-fauxmonnayeurs]

Thanks for the video! When you have hundreds of data sources in GA4, is there a better automatic way to connect and retrieve all of them? Maybe changing BI tool?

[frankthedsigner]

Great video! I've realised that I've been combining multiple keys from multiple sources and clearly that messed with my results. Do you have any advice for combining GA4 and UA properties, seeing that both have a few different data points? Many of my clients I work with still require their UA performance reports and have GA4 but it makes it challenging to show page bounce rates for example in GA4.

[tienganhtuduy]

super new to this, but how do i blend data from google analytic and search consol, they're no common metric or dimention and what type of join do i pick?

[SindiSipat]

can I blend data from 6 different websites with diff GA4 properties?

[FranckPARIENTIfranck]

Hi, thanks for your videos. On looker studio how to combine several data source from different google ads accounts for get one columns with the data of the URLs of the all the google ads accounts ? If possible use source of Google ads and not google sheet Regards

[eduardoamodelafuente]

Hi, thanks for the video! how can you blend more than 5 data sources in looker studio? As the limit are 5 blend data, what are the solutions to this? Thanks

[rusthamyacoob]

hello...your vedios are much usefull. i have my data as multiple tabs in a same google sheet. can you help me how to crreate a time series chart with them?

[mawardi]

Hi, I am still learning about blending data in Looker. So questions are:

1. How do I break down date data in a table? since looker act a pivot table in default.
2. When I try to blend 2 tables from 2 different sources it doesn't sum up, how to fix it? thanks

[FranciscoJGH]

Me gustó tu video 👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼❤️👍🏻👍🏻👍🏻

[Melchisedech]

Hey, can Google Sheets with few different tabs be imported to Looker? or do I have to use 1 Google Sheet per Looker?

[sofiavinhas]

How do you blend categorical data though??