Blended Ad Spend

spend

Overview

Blended Ad Spend represents the total advertising cost across all marketing channels, including any custom expenses marked as ad spend.

📘

Blended Ad Spend = Channel-Reported Ad Spend + Custom Ad Spend

The calculation is based on data in the Blended Stats table.

---

Detailed Breakdown

The formula above is derived from the following components:

• Channel-Reported Ad Spend = SUM(spend) --> Ads table
• Custom Ad Spend = SUM(IF(is_ad_spend, amount, 0)) --> Custom Spend table

Insights and Actions

Blended Ad Spend provides a comprehensive view of your total advertising investment across channels, helping to evaluate overall budget utilization and ROI:

• Evaluate Total Ad Spend: Use blended ad spend to understand the full scope of your marketing investment, including both channel-reported and custom ad expenses.
• Monitor Budget Efficiency: Pair this metric with ROAS to determine if your total spend aligns with revenue generation and profitability goals.
• Identify Overspending: If blended ad spend exceeds targets without corresponding performance metrics, review channel-level spending to identify areas for optimization.

Related Metrics

• Blended ROAS: Offers insights into the revenue generated relative to total ad spend, helping evaluate overall marketing efficiency.
• Channel-Specific Ad Spend: Breaks down spend by platform, providing granular insights into where budget adjustments might improve performance.
• Blended Conversion Value: Complements blended ad spend by showing total revenue, enabling a full ROI analysis.

Example Use

Prompt

What was my blended ad spend the past 7 days?

Response

Query

SQL

SELECT
  COALESCE(SUM(bst.spend), 0) AS blended_ad_spend
FROM
  blended_stats_tvf () AS bst
WHERE
  bst.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1;