Net sales
$20,210
Avg transaction
$48
Conversion
24%
Retail Sales Tracker
Daily sales by channel with transactions, average basket and target progress.
SpreadsheetStore OperationsFree
Points earned with tier multipliers, balances, Bronze to Gold tiers from spend, lapsing members and your redemption liability.
Shown with sample data
Points earned with tier multipliers, balances, Bronze to Gold tiers from spend, lapsing members and your redemption liability.
Run a points-and-tiers loyalty programme from a spreadsheet and know what it costs you. Enter each member’s 12-month spend, points redeemed and points expired; the tracker assigns Bronze, Silver or Gold from spend thresholds, awards points with tier multipliers, calculates each balance and the redemption liability (outstanding points × value per point × expected redemption rate) and flags members who are lapsing. Rules live on the Settings sheet so you can model changes before you announce them.
Customers earn points for each dollar spent (often more in higher tiers) and redeem them for discounts or rewards. Each point has a cash value, so the programme’s cost is points redeemed × value per point.
The estimated value of points customers have earned but not yet used that you expect to be redeemed: outstanding points × value per point × expected redemption rate.
Base thresholds on your spend distribution: for example, the top 10% of customers reach Gold and the next 25% reach Silver. Give each tier a benefit customers notice, such as a points multiplier, early access or free delivery.
Download a copy
Downloads need a free account.