Right Outer Join - Blended Data in Looker Studio
Blended Data in Looker Studio, we continue this topic.
Let's say we have a data table from Google Ads containing information for April 14th and 15th. Additionally, there's a Facebook Ads table with data for April 13th, 12th, and 14th.
Applying a Right Outer Join to these tables, with Google Ads as our left table, means all rows from the Facebook Ads table will be included in the result. For the dates where we have data from both sources, the information will be combined. However, for April 13th, 12th, 16th where there's no data from Google Ads, the corresponding Facebook Ads data will still be included.
For Google Ads costs the Null values appear where there is no match.
Blended Data in Looker Studio is not so complicated is it seems!
Don't forget to like this video if you found it helpful and subscribe to my channel to learn more tips about Google Sheets and Looker Studio!
#RightOuterJoin #DataMerge #GoogleAds #FacebookAds #DataIntegration #DataTables #DataAnalysis #DataVisualization #DataManipulation #DataJoining #DataQuery #DataInsights #GoogleSheets #LookerStudio