MNTN ROAS
roas
Overview
MNTN Return on Ad Spend (MNTN ROAS) refers to the MNTN-reported conversion value divided by the MNTN-reported ad spend.
MNTN ROAS = MNTN Ads Conversion Value / MNTN Ad Spend
The calculation is based on data from the Ads table.
Detailed breakdown
The formula above is derived from the following components:
Conversion Value (CV) = SUM(conversion_value)
--> Ads table
Ad Spend = SUM(spend)
--> Ads table
MNTN Ads = where channel = 'mountain'
Insights and Actions
MNTN ROAS helps you assess the profitability of your MNTN ad campaigns by comparing revenue generated against ad spend:
- Evaluate Campaign Profitability: Track ROAS to understand which campaigns deliver the best return, allowing you to focus resources on high-performing ads.
- Optimize Budget Allocation: If ROAS is low, consider reallocating budget to other channels or adjusting your MNTN strategy for better returns.
- Analyze Ad Efficiency: A high ROAS suggests that your ads resonate with the audience; if ROAS is below target, experiment with ad creatives or targeting options to improve outcomes.
Related Metrics
- MNTN Conversion Value: Gives insight into the total revenue generated, helping assess the scale of conversions relative to ad spend.
- MNTN Ad Spend: Provides context for the ROAS calculation, showing how budget allocation aligns with returns.
- MNTN Conversions: Shows the number of successful actions, allowing you to understand if high ROAS correlates with conversion volume or high-value conversions.
Example Use
Prompt
What's my channel-reported MNTN ROAS the last 30 days?
Response
Query
SELECT
COALESCE(
SUM(pjt.channel_reported_conversion_value) / NULLIF(SUM(pjt.spend), 0),
0
) AS reported_roas
FROM
pixel_joined_tvf () AS pjt
WHERE
pjt.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE() - 1
AND pjt.channel = 'mountain'
AND pjt.model = 'Triple Attribution'
Updated 25 days ago