Overview

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

📘

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

Insights and Actions

AppLovin Average Order Value (AOV) measures the average revenue generated per order from AppLovin-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 AppLovin 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

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

Example Use

Prompt

What's my 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';