Customer List & Repeat Sales Tracker for Salons and Small Shops (Excel & Google Sheets)
Keep your regulars in one list. See who spends the most, who hasn't come back in a while, and whose birthday is this month.
What you get
- Visits, total spent and last visit for each customer, from your sales log
- At-risk flag when a customer hasn't returned in X days (you choose X)
- Birthday-this-month column for greetings or promos
- Top 10 customers by spending
- Where your customers come from: walk-in, Instagram, Google Maps, referral...
Good to know
- Works in Excel 2016 or newer, Google Sheets and LibreOffice. No macros.
- Green cells are for your input. Formula cells are locked so you can't break them by accident.
- Comes with sample data so you can see how it works. Clear the green cells and start.
- Labels in English and Chinese (简体中文).
- Instant download: one .xlsx file with a guide sheet inside.
- The file holds personal data. Keep it private and only message customers who agreed to hear from you (PDPA).
---
熟客放在一张表,谁花最多、谁很久没来、谁这个月生日,一看就知道。
内容
- 每位客人的来店次数、累计消费、最后来店日期自动算
- 超过几天没来标「流失风险」(天数你定)
- 本月生日一栏,方便发祝福或优惠
- 消费最多的前 10 位
- 客人从哪里来:路过、Instagram、Google 地图、朋友介绍……
说明
- Excel 2016 以上、Google Sheets、LibreOffice 都能开,没有宏。
- 浅绿色格子是你填的,公式格锁住了,不怕改坏。
- 里面有示例资料,先看懂怎么用,清掉浅绿色格子就能开始。
- 中英双语标题。
- 付款后马上下载:一个 .xlsx 档案,里面有说明页。
- 档案里有客人的个人资料,请自己保管好;只联络同意收讯息的客人(PDPA)。