Here’s a video where Juan shows you step-by-step how to blend data on Looker Studio. Alternatively, here’s an article we wrote on how to blend data using Looker Studio to show you how to get that done as soon as possible.
In this case, we blended our Facebook Ads Data with Google Merchandise Store using the left join option, and our preferred key is the Date column.
How To Transform Null Values
Into Zero on Looker Studio Now let’s say from the two data sources blended, which are Facebook B2B Email List ads and Google Merchandise Store, we want to – for whatever reason – See the total amount spent on Facebook ads and the purchases on the store platform each day.
So here goes first, we will need to sum the Amount
Spent Column and the Purchases field to see that number on our new column. How do you get that Cn Leads done, you asked? No worries, here’s how you can combine both columns using a calculated field and regular expressions.
Also, here’s an article on how to access and use calculated fields. Click on the blended chart or table chart type. Now to your right – under Metric, click on “Add Metric” and click on “Add Field” like the image below.