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:

1. Facebook Ads cost per day, fetched using Supermetrics in a Google Sheet.
2. Google Ads cost per day, fetched using Supermetrics in another Google Sheet.
3. 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.

In this chapter:

→ 10.2. Left Outer Join in Looker Studio

→ 10.3. Data Blending: Data Enrichment

→ 10.4. Data Blending: Paid Ads Cost

→ 10.5. Data Blending: De-Aggregation

→ 10.6. Right Outer Join

→ 10.7. Inner Join

→ 10.8. Full Outer Join

→ 10.9. UNION (with Full Outer Join)

→ 10.10. Cross Join

Enroll in the updated & extended Looker Studio Masterclass 2024 →

📩 Receive my weekly Looker Studio tips

🎥  Subscribe to my YouTube channel

🖇 Connect with me on LinkedIn