The short answer
Six months of sign-ups, split by the store or channel where each member joined, is the starting point for loyalty program metrics on acquisition. Count joins per source, then check what share of each source's members bought again after joining. A store that signs up many members who never buy again is filling the list without growing loyalty.
Why it matters
Sign-up targets reward volume, so stores and channels can hit them with members who never return. Knowing which sources produce active members tells you where joining incentives pay for themselves and where they only add cost and email addresses.
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 pet retailer that signed up 26,000 members in six months. It groups members by joining source and checks who bought again within 90 days.
- In store at checkout: 15,600 members, 38% bought again
- Website: 6,500 members, 52%
- App: 2,600 members, 61%
- Adoption events: 1,300 members, 19%
What the data shows
Stores bring in 60% of new members, but the app and website produce members who come back far more often.
What it means
Two of the 24 stores account for a quarter of store joins, and only 22% of their members bought again. That pattern points to a staff contest more than customer interest.
What to do
Reward store teams on members who buy again, and promote the app at checkout.
Would you like the store sign-ups ranked by repeat rate?
Frequently asked questions
How do you measure loyalty program success?
Track three things together: how many active members you have, how much more they spend than comparable non-members, and what the program costs in points, discounts and running costs. Sign-up counts alone measure reach. A program succeeds when the extra margin from members exceeds what it costs to run.
Why do store sign-up targets inflate membership?
Targets reward the count, so staff sign up customers at checkout who have no plan to return, sometimes with made-up or shared email addresses. The list grows while activity falls. Pair sign-up targets with a quality measure, such as the share of new members who buy again within 90 days.
Which loyalty program enrollment sources should I track?
Track every place a customer can join: each store, the website, the app, events and partner promotions. Record the source on the member record at the moment of joining, since it cannot be reconstructed later. Group small sources together for reporting, but keep the raw detail for when a pattern needs checking.