MNTN CV
conversion_value
Overview
MNTN Conversion Value (MNTN CV) refers to the total conversion value as reported by MNTN.
MNTN CV = Total MNTN-Reported Conversion Value
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
MNTN Ads = where channel = 'mountain'
Insights and Actions
MNTN Conversion Value (CV) provides the total revenue generated from MNTN-reported conversions, giving insight into the financial impact of your ad campaigns:
- Assess Campaign Revenue Impact: A high conversion value indicates strong revenue generation from your ads. If conversion value is low, consider optimizing your ad targeting to reach a more profitable audience.
- Identify High-Performing Campaigns: Compare conversion values across campaigns to focus on those delivering the most revenue, helping to inform budget allocation.
- Optimize Ad Content: If conversion value is lower than expected, try experimenting with different ad creatives or offers that might resonate better with your audience.
Related Metrics
- MNTN ROAS: Evaluates revenue relative to ad spend, helping assess the efficiency and profitability of your campaigns.
- MNTN Conversions: Tracks the total number of purchases, providing context to understand if high conversion value results from many conversions or high individual purchase amounts.
- MNTN Clicks: Shows engagement levels, offering insight into whether high click engagement aligns with high conversion value.
Example Use
Prompt
What's my total MNTN-reported conversion value over the last 7 days?
Response
Query
SELECT
pjt.channel AS channel,
SUM(pjt.channel_reported_conversion_value) AS total_conversion_value
FROM
pixel_joined_tvf () AS pjt
WHERE
pjt.model = 'Triple Attribution'
AND pjt.channel = 'mountain'
AND pjt.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE() - 1
GROUP BY
pjt.channel;
Updated 25 days ago