Data Unions: Looker Studio for Marketers
Learn an incredibly useful trick for combining two different data sources into one in Looker Studio. A "union" is SQL terminology for appending one dataset on to another - Looker Studio doesn't support unions per se, but you can accomplish the same thing with a full outer join and the coalesce function. We'll demonstrate how to use this powerful technique to built a cross-channel report that combines Google Ads and Microsoft Ads data into one beautiful table.