What active customer definition is your count using?
The short answer
An active customer definition sets the time window, what counts as a purchase and who is excluded. A common version is any identified customer with at least one completed purchase in the past 12 months, net of full returns, excluding staff and test accounts. Write the rule down and check every count against it.
Why it matters
Different teams often count active customers differently, so marketing, finance and the board see different numbers for the same business. A written, checkable definition ends the debate and makes churn, retention and spend-per-customer figures comparable over time.
The question to ask
Copy this into Lexi as written.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for a beauty retailer. It shows the definition behind the active customer count, then the count it produces.
- Includes identified customers with a purchase in the past 12 months, online or in store.
- Excludes fully returned orders, plus staff, test and wholesale accounts.
- Counts each person once after matching email, phone and loyalty number.
What the data shows
The rule gives 318,000 active customers. The email platform reported 402,000 and finance reported 287,000.
What it means
The email figure counts duplicates and anyone who opened an email. Finance left out store customers without a loyalty number.
What to do
Agree one definition across teams and use it in every report.
The definition can be edited, and every figure updates to match. Would you like the count split by channel?
Frequently asked questions
How do I calculate active customers?
Count unique, identified customers with at least one qualifying purchase in your chosen window, after matching duplicate records across channels. Remove fully returned orders and staff, test and wholesale accounts. The result depends heavily on the window and matching rules, so state both whenever you report the number.
Why do different systems report different active customer counts?
Each system counts what it sees. An email platform may count anyone who opened an email, an ecommerce platform only online buyers and a point of sale (POS) system only identified store customers. Duplicate records inflate some counts, and missing store customers deflate others. A single resolved customer view with one written rule gives one answer.
Should the active window match my purchase cycle?
Yes. A 12-month window suits many retail categories, but a brand whose customers buy monthly may want six months, and a furniture brand may need 24. Look at the typical gap between purchases and set the window so most regular customers fall inside it.