10.4. Data Blending: Paid Ads Cost
In this lesson, you'll learn how to blend data from multiple sources to find the total ad cost and visualize the trend. Let's assume you have cost data from Facebook Ads, Google Ads, and ad management, and you want to analyze the total cost and trend.
Data Sources
Your data sources include:
- Facebook Ads cost per day, fetched using Supermetrics in a Google Sheet.
- Google Ads cost per day, fetched using Supermetrics in another Google Sheet.
- Ad management cost, manually entered into a Google Sheet with the first date of each month.
Blending the Data
To blend the data, perform left joins on the date column. The resulting blend should display the ad costs from Facebook, Google, and ad management for each day.
Italic: To make the blend more meaningful, you could create a daily ad management cost instead of using monthly costs. This would give you daily ad management costs across the chart, along with Google Ads and Facebook Ads costs.
Now, to answer the question of what the total ad cost is, including ad management and the trend, create a chart with a trend line. The trend line will help visualize the story of your ad spending across different platforms.
Displaying the Total Ad Cost
To display the total ad cost in a single number, you can create a custom field that adds Facebook Ads cost and Google Ads cost. Then, use a scorecard to display the total ad cost across all platforms.
📩 Receive my weekly Looker Studio tips
🎥 Subscribe to my YouTube channel
🖇 Connect with me on LinkedIn