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
, wherespend
=SUM(spend)
--> Ads tablecustom_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
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;
Updated 17 days ago