BA ROAS

ba_roas

Overview

Blended Attributed Return on Ad Spend (Blended Attributed ROAS, BA ROAS) measures the total revenue attributed to marketing channels relative to the blended advertising spend (including custom ad spend) across all channels.

📘

BA ROAS = Blended Channel-Reported Conversion Value ÷ Blended Ad Spend

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

---

Detailed Breakdown

The formula above is derived from the following components:

• Blended Channel-Reported Conversion Value = SUM(channel_reported_conversion_value) --> Ads table

• Blended Ad Spend = spend + custom_ad_spend, where

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

Insights and Actions

Blended Attributed ROAS (BA ROAS) provides insight into the efficiency of your marketing spend by comparing attributed revenue to total ad costs across all channels.

• Evaluate Channel Performance: Use BA ROAS to identify which marketing channels are driving the most revenue relative to spend. A higher BA ROAS indicates greater efficiency.
• Optimize Budget Allocation: Compare BA ROAS across channels to shift budgets toward the most effective campaigns, improving overall ROI.
• Monitor Spend Efficiency: Regularly track BA ROAS to ensure advertising investments are generating sufficient attributed revenue to justify the costs.

Related Metrics

• Blended Ad Spend: Helps track the total cost of advertising, providing the denominator for BA ROAS calculations.
• Channel-Reported Conversion Value: Offers a detailed view of revenue attributed to specific channels, giving context to BA ROAS.
• Blended ROAS: Complements BA ROAS by including both attributed and non-attributed revenue, helping assess overall channel efficiency.

Example Use

Prompt

What was my BA ROAS over the last 7 days?

Response

Query

SQL

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