Looker Studio is an amazing tool to display your data, but it can be a bit of a pain when you need to merge data from different platforms.
Here is a 2-steps tutorial to compare spend on 2 platforms with a blended data sources and a chart pie :
1 - Create a blended data source
2 - Create a custom fields to merge accounts and spends.
Go to Resource → Manage blends → Add a new blend.
Select both data sources required, put the Account Name in dimension and Spend in metrics then save.
Your blended data source should look like this :
Join should look like this :
In a pie chart, you need to create a new dimension and a new metric :
Formula :
Thanks to this formula, I aggregate and rename my Google Ads account name to "Google Ads" and my Facebook Ads account name to "Facebook Ads"
(you will need to change "GAds" and "pub" by text include in your Google Ads and Facebook Ads accounts names).
Formula :
Contact us on the chat or at johan@catchr.io, we can help you design great reports !
Get all your marketing data in your favorite data activation, database or reporting tools.