Ever wonder how offering coupons affects your business? Want to know which coupons are helping or hurting performance? In this article, we’ll explore analyses that’ll give you a good picture of your customers’ coupon usage by answering these questions:
Lets get started!
When analyzing coupon usage, consider using (or building) these metrics:
This metric shows you the number of orders with and without coupons over time. This shows if and how often customers are using your coupons, and how this changes over time.
This metric reveals the gross revenue you earn from orders that include a particular coupon. The gross revenue is a calculation of the full price of the items sold, before any discounts are applied. This can help determine which coupons are associated with the highest and lowest gross revenue.
This metric can show you the total discount amount applied from the coupons. It’s important to note that these orders may not have occurred without the coupons.
This metric shows the net revenue you earn from orders that include a particular coupon. The net revenue is a calculation of the price of the items sold after all discounts are applied. This can help determine which coupons are associated with the highest and lowest net revenue.
This shows the share of gross revenue that’s offset by discounts. For coupons that offer a percentage discount, this value is already known (ex: 10% off). Despite this, this measure provides insight and a method of comparison for coupons that are a fixed dollar discount.
This measure shows the average order value when a coupon is applied. You can analyze if orders with coupons consistently have a lower order value than orders without coupons.
This shows the average dollar value discounted from each order where coupons are applied. This displays the difference between the average net order value and average gross order value.
This metric displays the number of distinct buyers that use a certain coupon.
This metric helps evaluate the loyalty and average revenue generated by customers who use a certain coupon. When evaluating whether customers who use coupons are higher value than others, be sure to take into account the number of distinct buyers in each category to ensure that you have a significant sample size.
Now that we know what metrics to look at, lets take a look at an example involving three different coupons -- 10% off, $20 off $100 or more, and $10 off.
|Coupon||# of orders||Gross revenue||Gross discounts from coupons||Net revenue||Percent discounted|
|$20 off $100+||101||$13,928.91||$2,020.00||$11,908.91||14.50%|
|Coupon||Avg. net order value||Avg. order discount||Distinct buyers||Avg. lifetime revenue|
|$20 off $100+||$117.91||$20.00||95||$218.76|
About 80 orders were placed with the “10% off” coupon, 100 orders with the “$20 off $100 or more” coupon, and 200 orders with the “$10 off” coupon. The number of orders associated with each coupon could vary based on several factors, including:
While the gross discounts for all three coupons are very similar (around $2,000), the number of orders for each coupon are significantly different. Analyzing discounts on a per order basis helps explain the reasons for these contrasting numbers. The “10% off” coupon has the least number of orders, but an average order discount of about $25. Even though this coupon has a low number of orders, its high average discount value causes its gross discount amount to approach $2,000.
Gross and net revenue provide an overall idea of the full value of the orders associated with each coupon. However, this overall picture does not provide an understanding of the different behaviors related to each coupon. Once you look at a per order basis, you can see that the “10% off” coupon has a very high average net order value, which in turn leads to its high net revenue.
On the other hand, the “10% off” coupon has a very high average discount value ($25.01), but the lowest percent discounted. This makes sense when you take into account its average net order value of $225.08. The “10% off” coupon has a small percent discount of a large average net order value, so the average order discount is a large amount.
Let's take a look at the distinct buyers and average lifetime revenue for each coupon. The “10% off” coupon has the same number of orders as distinct buyers. This could be a result of each customer being limited to one coupon. On the other hand, the “$20 off $100 or more” and “$10 off” coupons have fewer distinct buyers than number of orders, which implies that some customers used these coupons multiple times.
For average lifetime revenue, you can see that the average lifetime revenue for each coupon is greater than the respective average net order value. This implies that either customers made repeat purchases, and/or their order value was much higher than the average net order value.
The analyses we touched on in this article can give you valuable insight into how your customers use your coupons, but there are a multitude of other analyses that allow you to dig a little deeper.
You could analyze your customer acquisitions from coupons.
Which coupons are encouraging customers to place orders? Are these coupons attracting one-time buyers or do they encourage customer loyalty (i.e. customer who make repeat purchases)?
You could analyze the time it takes for your customers to use your coupons.
Are your coupons used the day they are released or does a week or two elapse before the majority of your customers use them?
You could uncover the optimal discount amount that increases customer loyalty and overall value.
What discount amount will encourage repeat buyers, higher average order value, and higher lifetime revenue?
Answering these questions will give you insights into your customers, their behavior, and the coupons that provide the most value to your business.
This best practice is provided by Magento BI Data Analysis Services (DAS). We’d love to help you answer any of your specific business questions! Contact support for more info.