Data Dictionary

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 25 days ago