Analytics Custom Building: eCom Average Basket Size

josephmckeownjosephmckeown Moderator, Lightspeed Staff Posts: 59 moderator
edited November 1 in Reporting & Analytics

This report is one in a series of five discussing ways to measure performance of your eCom shop. To see other ideas, check out 5 Lightspeed Analytics eCom Reports for Optimizing Online Sales

How does your eCom store average sale compare to that in your brick and mortar store? We could find this out using Analytics to see how both platforms compare.

To begin, launch the Recent Sales report, which will show you daily totals for this week. Instead of leaving the totals for just this week though, let's open the filters to go back over the past three months...

Then, to get a high-level view, let's remove the Dimension of Sale Complete Date:


...and add the Dimension of Sale Month...

Next, let's look for the Sale Dimension: Is Ecom (Yes / No), and we'll pivot on it...


So now, our table looks a bit like this...


Finally, let's remove the measure of Sale Line Total


and add the Measure of Sale Average Basket Size

...and finally, let's run the report!

When we see the report, it will show us on average how many products are on a customer's sale, showing us if our upsell strategy is working well.

The visualization will add to our analysis too...


Next Report: eCom Sales trajectory

Go back to Blog post: 5 Lightspeed Analytics eCom Reports for Optimizing Online Sales

Analytics Calculations Home

Post edited by josephmckeown on
Joseph McKeown
Lightspeed Analytics and reporting consultant
Lightspeed HQ
Sign In or Register to comment.