maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENmodelmarts

mart_promotion_performance

certified
mart table

How well are promo codes performing.

Lineage Builds
Definition

Per-day promo rollup. `total_discount` is the realised markdown — NOT incremental revenue lift (no counterfactual baseline). `net_order_amount` is gross minus discount, floored at 0. Pair with the `revenue` metric on a matched control window to estimate true lift.

What it means
Watch out for
  • highTreating `total_discount` as revenue lost

    Discount is the markdown applied; whether the order would have happened without it is a counterfactual question. For incrementality, compare `revenue` between matched windows with and without the promo.

  • mediumMixing `redemptions` with `redemptions_revenue_orders`

    `redemptions` counts all applied promos (including cancelled/refunded orders); `redemptions_revenue_orders` filters to revenue-eligible. The headline rate depends on which denominator you pair with.

Questions this answers
  • “Top 5 promo codes by redemptions last month.”
  • “Discount cost by discount type this quarter.”
Related metrics
  • revenue

    `net_order_amount` ties back to `revenue` over the same window.

  • customer_health

    Promo redeemers often differ in retention curve.

13 of 13
Column
Type
Description
Tests · PII
applied_day
Date
Date the promo was applied to an order.
1 test
promotion_code
String
Display code from the promotion catalog.
1 test
discount_type
String
`percent` / `flat` / `free_shipping`.
1 test
redemptions
UInt64
Row count — all promo applications in the bucket.
2 tests
redemptions_revenue_orders
UInt64
Of `redemptions`, those where order is revenue-eligible.
1 test
unique_orders
UInt64
Distinct order_id count.
1 test
unique_customers
UInt64
Distinct customer_id count.
1 test
total_discount
Decimal(14, 2)
Sum of `discount_amount` across all redemptions.
2 tests
revenue_order_discount
Decimal(14, 2)
Sum of `discount_amount` filtered to revenue-eligible orders.
1 test
gross_order_amount
Decimal(14, 2)
Sum of order totals BEFORE this discount.
1 test
net_order_amount
Decimal(14, 2)
Sum of `gross - discount` (floored at 0).
1 test
revenue_gross_order_amount
Decimal(14, 2)
Gross order total filtered to revenue-eligible orders.
1 test
revenue_net_order_amount
Decimal(14, 2)
Net order total filtered to revenue-eligible orders.
1 test