MNTN AOV
aov
Overview
MNTN Average Order Value (MNTN AOV) calculates the average amount spent by customers per order, after shipping and taxes, as reported by MNTN.
MNTN AOV = MNTN-Reported CV รท MNTN-Reported Conversions
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 -
Conversions =
SUM(conversions)
--> Ads table -
MNTN Ads =
where channel = 'mountain'
Insights and Actions
MNTN Average Order Value (AOV) measures the average revenue generated per order from MNTN-reported conversions, providing insights into customer purchasing behavior and the performance of MNTN campaigns:
- Monitor Revenue Trends: Track MNTN AOV to identify changes in the average value of orders over time. A declining AOV might signal a need to adjust targeting or campaign strategies.
- Focus on High-Value Customers: Use AOV to pinpoint audience segments that contribute higher-value orders and refine targeting to prioritize these segments.
- Boost Marketing Effectiveness: Pair AOV with conversion data to evaluate the success of upselling or bundling strategies, aiming to increase order values and overall campaign ROI.
Related Metrics
- MNTN Conversion Value (CV): Represents the total revenue generated by MNTN campaigns, essential for calculating AOV and understanding revenue impact.
- MNTN Conversions: Tracks the total number of orders, providing context for AOV and offering insights into customer behavior.
- MNTN ROAS: Complements AOV by showing revenue efficiency relative to ad spend, helping assess overall campaign profitability.
Example Use
Prompt
What's my MNTN-reported AOV for the last 30 days?
Response
Query
SELECT
COALESCE(
SUM(pjt.channel_reported_conversion_value) / NULLIF(SUM(pjt.channel_reported_conversions), 0),
0
) AS channel_reported_aov
FROM
pixel_joined_tvf () AS pjt
WHERE
pjt.event_date BETWEEN CURRENT_DATE() - 90 AND CURRENT_DATE() - 1
AND pjt.channel = 'mountain'
AND pjt.model = 'Triple Attribution'
Updated 11 days ago