<aside>
The following article provides useful tips for how to blend data in Looker Studio.
</aside>
What You Can Blend
A list of what you can blend in Looker Studio:
- Two data sources that share the exact same dimension. The keywords here are "dimension" and "exact". We rarely ever see a case for using metrics as join keys. Examples are:
- Same date: Both data sources have a date value of 2020-12-20.
- Same campaign name: Both data sources have a field (the field name doesn't need to be identical - just the values) with the value "holiday shopping 2021". This is a common join key when blending Google Analytics data with Facebook Ads, Microsoft Ads, Mailchimp and other data sources.
- Same region or country: Both data sources have a dimension that reports region (I.E. "Florida") or country (I.E. "Germany") identically.
<aside>
Punctuation and capitalization must be identical:
- If one data source reports "florida" and the other "Florida", they will not join.
- If one data source reports "united-states" and the other "united states", they will not join.
</aside>
What You Cannot Blend
A list of what you cannot blend in Looker Studio:
- Two or more different date ranges of data, by date: If you have data in one data source going up to Dec 31, 2020 and another data source starting Jan 1, 2021, there is no way to combine these data sources to report 2020 and 2021 data by date. You can report totals for the combined data sources across both timeframes, but cannot use the date dimensions as join keys.
- Two or more data sources using metrics as the join keys: We welcome feedback regarding this assertion! We have yet to see anyone joining 2 or more data sources when using metrics as the join keys, but there is always a first.
- Two or more data sources that have no identical values for at least 1 dimension of each: In order for blending to be successful, the join keys look for identical values (spelling and punctuation included - everything must be exactly the same).
Blending For Beginners
Blending is an advanced Looker Studio feature. There is a learning curve with Blending, but once you learn the concepts you should be equipped to join data sources to enhance your reports.
Before You Begin Blending:
Establish an objective: Why are you blending? To combine two data sources' total Impressions, such as Google Ads with Facebook Ads, in 1 scorecard? Or do you just need to report Google Ads and Facebook Ads on the same page? If you can get away with reporting without blending, we recommend you do so because blending increases the complexity and risk for reporting the error. If you do want to sum up multiple data sources' metrics or do the math on fields across multiple data sources, then proceed.
Identify the join condition (join key). At least one dimension must be used between the data sources that have identical values between data sources. The date is a very common join condition when one needs to sum up PPC metrics like Impressions, Clicks and Spend. The campaign is very common when trying to report total engagement with a Campaign that is identical across multiple data sources.
Under Blend Data, select a Table 1 and Table 2 and click Configure join.