Magento Business Intelligence Help Center

Coupon code analysis

Understanding the coupon performance of your business is an interesting way to segment your orders and also better understand your customers. This article will walk you through the steps to create analyses to understand which customers you acquire through the use of coupons, how they perform, and track general coupon usage.

This analysis contains advanced calculated columns that can only be created by a Magento BI analyst. Once you've completed the Getting Started section, file a support request with the subject [COUPON ANALYSIS], before moving to the next section.

Customer's first order included a coupon (Coupon/No Coupon) = No coupon

Time period: X years ago to 90 days ago

Interval: None

Chart Type: Scalar

Average lifetime revenue by first order coupon

Metric A: Average lifetime revenue

Metric: Average lifetime revenue

Time period: All time

Interval: None

Group by: Customer's first order's coupon

Chart Type: Column

NOTE: If you have a large number of coupon codes, as many of our clients do, you will want to apply a Top/Bottom such as Top 10 sorted by Avg lifetime revenue

Repeat order probablility: Coupon acquisitions

Metric A: Number of orders

Metric: Number of orders

Filter:

Customer's first order included a coupon (Coupon/No Coupon) = Coupon

Metric B: Number of non last orders

Metric: Number of orders

Filter:

Customer's first order included a coupon (Coupon/No Coupon) = Coupon

Is customer's last order? = No

Formula: Repeat order probability

Formula: B/A

Format: Percentage %

Time period: All time

Interval: None

Group by: Customer's order number

Select statistically significant number from "Customer's by lifetime orders" chart. When looking at the chart, as a good rule we typically look for order numbers with 30 or more customers in the bucket. Depending on your data set, this may be a large number so feel free to add 1-10.

Chart Type: Bar chart

Repeat order probablility: Non-coupon acquisitions

Metric A: Number of orders

Metric: Number of orders

Filter:

Customer's first order included a coupon (Coupon/No Coupon) = No Coupon

Metric B: Number of non last orders

Metric: Number of orders

Filter:

Customer's first order included a coupon (Coupon/No Coupon) = No Coupon

Is customer's last order? = No

Formula: Repeat order probability

Formula: B/A

Format: Percentage %

Time period: All time

Interval: None

Group by: Customer's order number

Select statistically significant number from "Customer's by lifetime orders" chart or 1-5