Control Filters on Blended Data with a Full Outer Join (Looker Studio)

In this step-by-step tutorial, I’ll show you how to add a control field to a blended data source, which is using a full outer join. This will allow you to filter your data properly - no more missing records and you can find answers very easily. 00:16 Let's get started and explanation on what we want to achieve 1:22 How to add a control field to filter blended data 3:49 Explaining google_source and meta_source 6:04 How to fix the problem practically 13:30 How it looks like once it's solved 14:16 Showing that this is in fact a full outer join Also, huge credit to Arnaud Amaraggi for suggesting this solution. Here's a link to his post: https://lookerstudiobible.com/how-to-build-a-control-that-filters-blended-data-in-looker-studio-c640bb23dc2b 🔥 Don’t forget to: 👍 Like this video if you found it helpful! 💬 Comment below with any questions or challenges you’re facing. 📢 Share this video with fellow digital marketers and data analysts! 🔔 Subscribe for more advanced Looker Studio, GA, GTM or marketing tips: https://www.youtube.com/@CreateDigitalAI?sub_confirmation=1 Thanks for watching, and see you in the next one! 🚀