Looker Studio Blending Super Guide
The following article provides useful tips for how to blend data in Looker Studio.
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.
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.
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.
In Join configuration, select a Join operator to use.
Under Join conditions, click Add field for the left and right tables to add a field from each table. Note: A cross join does not accept any conditions.
Calculated Fields and Blending
Quite often the reason for blending is to create calculated fields that sum up metrics from 2 or more data sources or to do other math functions across metrics. For example, in the blend below, the metric "Total Qty Sold" is the summation of Miva Qty, eBay Qty and Amazon Qty:
The formula is as follows, to sum up these 3 quantities into 1 total quantity:
Advanced Blending
Ready to take blending to the next level? Here are some examples:
- Filtering one of the data sources in the blend to include or exclude certain data: This must be done in the blend:
Any filtering for blended data sources must be set up in the blend itself
Do not filter in the report outside the blend:
Blending Troubleshooting
See the following suggestions if you are not getting data or correct data in your blend.
No data:
- If you create separate reports with the 2 or more blended data sources, do you see identical values for the dimensions used as join keys? If not, that is the root cause.
- If you use "date" as the join key, does the leftmost data source have data for all dates?
Incorrect data:
- Are the calculated fields all wrapped in 'sum()'?
- If wrapping in 'sum()' still doesn't work, try wrapping in 'nary_max()':
Still Need Help?
Blending is difficult! Let the PMA team help you with our professional services. We can complete most blends in 1 hour and at reasonable rates.
Contact us with your questions and we will get your blending questions answered and offer solutions if your data cannot be blended.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
Looker Studio Demo Template Guide
When connecting to Looker Studio, there are a few best practices to keep in mind. From demo templates to customizations to troubleshooting, this guide will teach you some pro tips for using Power My Analytics data connectors. Use a Demo Power My ...
LinkedIn Companies Data Connector User Guide
LinkedIn Companies is a powerful data source that provides valuable insights into your company's LinkedIn page performance. This guide will walk you through the process of setting up and using the LinkedIn Companies data source in Power My Analytics, ...
Microsoft Advertising Data Connector User Guide
Microsoft Advertising (formerly known as Bing Ads) is a powerful platform for search advertising, keyword targeting, and more. This guide will walk you through how to connect Microsoft Advertising to Power My Analytics, create reports, and leverage ...
Instagram Ads Data Connector User Guide
Instagram Ads allows businesses to create and run paid advertisements on the Instagram platform. This guide will walk you through setting up Instagram Ads as a data source in Power My Analytics and creating reports in Looker Studio. Prerequisites ...
Facebook Ads Data Connector User Guide
Facebook Ads is a powerful advertising platform that allows businesses to reach their target audience on Facebook, Instagram, and across the web. This guide will walk you through how to connect your Facebook Ads account to Power My Analytics, create ...