The traffic on your website is high. The conversion rates are good. But are your order values great as well? The Average Order Value (AOV) is a useful metric that you should monitor as your business grows. Typically, this is one of the first KPIs you should try to improve to increase your revenue or optimize the return on your marketing efforts. But let's dig a little deeper into the AOV analysis and have a look at the impact of the first order's average value on the order count.
Definitions
First of all, let's define what Average Order Value (AOV) means: it is the sum of total Gross Revenue divided by the number of orders placed by the customer throughout their lifecycle.
AOV = ∑ Sum of Gross Revenue / Number of Orders
Using this report, you will find out if there is a correlation between the order value of the first order and the total number of orders your customers will make throughout their lifecycle, considering that AOV has a direct impact on their LTV.
But before diving into data analysis, let's make sure that we are on the same page:
AOV of the first order |
Percentiles of your customers' first-order value |
Total Orders | The average order count placed by customers within the percentile |
LTV |
Average current Lifetime Value of customers whose first-order value is within the percentile |
Customers | The number of customers within the percentile |
In the data table below the chart, you can see how the percentiles are defined, the average amount of orders within each percentile, and how many customers fall within each group, and their LTV:
How it Works
First of all, this report takes a look at all your customers' first orders and classifies their order values: it divides them into equal-sized groups, building percentiles. Then it numerically ranks a customer based on their first order value and it places them into the different percentiles according to their AOV.
Finally, it is only a matter of calculating the average number of orders for all the customers within each percentile.
Let's have a look at an example by considering a sample dataset of customer transactions:
Customer ID | First Order Value | Total Order Count |
1 | $10.54 | 1 |
2 | $50.23 | 1 |
3 | $27.98 | 1 |
4 | $8.97 | 2 |
5 | $34.20 | 2 |
6 | $29.60 | 2 |
7 | $65.52 | 3 |
8 | $17.35 | 3 |
9 | $38.17 | 1 |
10 | $47.33 | 2 |
11 | $45.99 | 3 |
12 | $12.90 | 1 |
13 | $89.25 | 4 |
14 | $70.02 | 3 |
15 | $21.76 | 1 |
16 | $56.88 | 3 |
17 | $120.99 | 4 |
18 | $76.50 | 4 |
19 | $10.93 | 1 |
20 | $54.90 | 3 |
For each percentile the average order count is calculated:
Use Cases
While searching for relevant KPIs, it is always a good idea to choose AOV as one of them: it provides a lot of insights and is focused on the customers that have already bought from your store.
So, by taking a look at this report you will get the answer to some of the most frequently asked questions:
- Is there a correlation between the initial basket size and the total number of orders a customer will make in his customer life cycle? If so, how big is it?
- Acquiring customers with higher AOV (for example, while setting a minimum amount for free shipping) is having an effect on retention? Or is it just causing one-time buyers that make a big first purchase and then churn?
- Does it make sense to have orders with small baskets?
- Customers with higher AOVs have more orders throughout their life cycle, but how many customers fall within this percentile? Is it a relevant part of my customer base?
Comments
0 comments
Please sign in to leave a comment.