Understanding Average Basket Value

josephmckeownjosephmckeown Moderator, Lightspeed Staff Posts: 86 moderator
edited July 2021 in Reporting & Analytics

Average Basket Value is a common measure in many kinds of reports.

Typically it follows a pretty predictable formula: total sales divided by number of sales.

If used this calculation against Average Basket Value by, say, the Store...

Or by the Month...

We find that the calculation holds

However, what happens if we try using Average Basket Value by Category?

Or by Brand?

There's a lot of variance between the Average Basket Value and the Calculation of Sales Total divided by number of Sales.

So what the reason for this variance?

Let's look for a sale that has multiple Items on it. I'm going to filter the report to just one sale, and add the Categories as Dimensions on the report:

Look what numbers are returned.

The calculation is the Sale Line divided by the number of Sales; in this case, the totals and calculation are identical because we are diving by 1.

But the Average Basket Value returns the value of the whole sale.

This is because Average Basket Value is a function of the whole sale that an item was on, not just the value of the item itself.

For this reason, we can actually leverage some interesting analyses.

Say, for example, that we want to measure the upsell-value in addition to a Bike on a Sale.

With our Calculation, we can illustrate the average bike value on these sales. If we subtract this from the Average Basket Value:

We can also measure the Average Upsell Value too!

So, Average Basket value should align identically when Sales are not split: by Store, by Day, by Register, etc. But they are not expected to align identically when they are split: by Item, by Brand, or by Discount.

Calculations Home

Joseph McKeown
Lightspeed Analytics and reporting consultant
Lightspeed HQ


  • meraleymeraley Member Posts: 8

    Is it possible to report on average basket value by employee?

  • rusto88rusto88 Member Posts: 2
    edited March 4

    I've put this together as a report but have found that the Average Upsell Value figure is skewed upwards by folks that purchased more than one bike. in other words, the additional bike is "counted" as part of the upsell... Is there a way to filter for transactions where only ONE bike was purchased?

    (I did filter OUT a few customers that I knew bought more than one bike, which helped but hope that there is a more automated way to eliminate them.)

Sign In or Register to comment.