Customers by Orders Total

See which customers spent the most in any day, month or year.

The Customers by Orders Total report ranks customers by how much they ordered in each day, month or year.

Use it to:

  • Find your top customers this month, quarter or year.
  • See how many orders each top customer placed, and their average order.
📘

Customers or Accounts?

This report ranks individual customers (contacts). To rank B2B Accounts, use Accounts by Orders Total. To rank customers by how often they ordered, use Customers by Number of Orders.

Open the Report

  1. In the Zoey Admin, click Reports.
  2. Type "orders total" in Find a report.
  3. Click Open next to Customers by Orders Total. It's in the Customers category.

Set the Filters

FilterWhat it does
From / ToThe dates to report on.
Show ByShows the top customers for each Day, Month or Year.

If your store has more than one website, choose one in the website menu at the top of the report, or leave it on all websites.

Click Refresh to run the report.

Customers by Orders Total report results

Report Columns

ColumnWhat it shows
Customer NameThe customer
Number of OrdersHow many orders the customer placed in the period
Average Order AmountThe customer's average order in the period
Total Order AmountWhat the customer ordered, after refunds and cancellations
Total Items Ordered QtyHow many items the customer ordered
📘

How Total Order Amount is worked out

Each order counts as the larger of its grand total and the amount paid, minus anything refunded or canceled.

Export the Report

Choose CSV or Excel XML next to Export to and click Export.

Ask Zoey AI

💬

Ask about your top customers

Click Ask next to Customers by Orders Total on the Reports page, or press Ctrl+J (Cmd+J on Mac), and try:

  • "Who are our top 10 customers this quarter?"
  • "Which of last year's top customers haven't ordered this year?"

See Running Reports with Zoey AI.


Did this page help you?