Overview

Axon Average Order Value (Axon AOV) calculates the average amount spent by customers per order, after shipping and taxes, as reported by Axon.

📘

Axon AOV = Axon-Reported CV ÷ Axon-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
• Axon Ads = where channel = 'applovin'

Insights and Actions

Axon Average Order Value (AOV) measures the average revenue generated per order from Axon-attributed conversions, helping you understand customer spending behavior and the impact of your campaigns:

• Evaluate Revenue Quality: Track AOV over time to see if the value of orders from Axon ads is growing or declining, indicating changes in purchase behavior.
• Refine Targeting Strategy: Use AOV data to focus on audience segments or creatives that consistently drive higher-value purchases.
• Enhance Upselling Techniques: Pair AOV with conversion metrics to identify opportunities for offering bundles or upsells to increase the average order size.

Related Metrics

• Axon Conversion Value (CV): Reflects the total revenue generated by Axon ads, forming the basis for calculating AOV.
• Axon Conversions: Tracks the total number of purchases, providing context for changes in AOV.
• Axon ROAS: Shows the revenue return for every dollar spent, complementing AOV by highlighting overall profitability.

Example Use

Prompt

What's my Axon (AppLovin) reported AOV for the last 90 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 = 'applovin'
  AND pjt.model = 'Triple Attribution';