Blog post
Marketing Analytics
Looker Studio
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 !
Start analyzing your data with a Looker Studio template
Catchr provides free dashboard templates to help you start analyzing your data on Looker Studio — 100+ available templates!
See all the Looker Studio templatesStart analyzing your data with a Looker Studio template
Catchr provides free dashboard templates to help you start analyzing your data on Looker Studio — 100+ available templates!
See all the Looker Studio templatesStart analyzing your data with a Power BI template
Catchr provides free dashboard templates to help you start analyzing your data on Power BI — 20+ available templates!
See all the Power BI templatesStart analyzing your data with a Power BI template
Catchr provides free dashboard templates to help you start analyzing your data on Power BI — 20+ available templates!
See all the Power BI templatesStart analyzing your data with a Google Sheets template
Catchr provides free dashboard templates to help you start analyzing your data on Google Sheets — 20+ available templates!
See all the Google Sheets templatesStart analyzing your data with a Google Sheets template
Catchr provides free dashboard templates to help you start analyzing your data on Google Sheets — 20+ available templates!
See all the Google Sheets templates✔ 14 days free trial — No credit-card required
✔ 14 days free trial — No credit-card required
Move your Marketing data to your favorite tools
Simplify your data extraction and move all your Marketing data to dashboard tools, spreadsheets, database and more... No code required!
75+ connectors | 20+ destinations
✔ 14 days free trial — No credit-card required