Outbrain AOV

aov

Overview

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

๐Ÿ“˜

Outbrain AOV = Outbrain-Reported CV รท Outbrain-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

  • Outbrain Ads = where channel = 'outbrain'

Insights and Actions

Outbrain Average Order Value (AOV) measures the average revenue per order driven by Outbrain ads, offering insights into customer purchasing behavior and campaign impact:

  • Assess Campaign Revenue Quality: Monitor Outbrain AOV to understand the value of orders driven by your ads. A declining AOV may indicate a shift toward lower-value purchases.
  • Optimize Campaign Targeting: Use AOV to identify high-value customer segments. Refine targeting strategies to focus on audiences more likely to make larger purchases.
  • Enhance Upselling Strategies: Pair AOV with conversion data to evaluate the effectiveness of upselling or bundling offers, aiming to increase the average order size.

Related Metrics

  • Outbrain Conversion Value (CV): Provides the total revenue generated, a critical input for calculating and interpreting AOV.
  • Outbrain Conversions: Tracks the total number of orders, offering context for understanding AOV trends and customer behavior.
  • Outbrain ROAS: Complements AOV by showing revenue relative to ad spend, helping assess overall campaign profitability.

Example Use

Prompt

What's my Outbrain-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 = 'outbrain'
  AND pjt.model = 'Triple Attribution'