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

SQL

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'