Leveraging Tiered Membership & Customer Lifetime Value in OOPBuy's Gucci Resale Service
2025-07-04
OOPBuy, the premium luxury resale platform (www.oopbuy.run), employs a sophisticated spreadsheet system to segment clients based on purchase volume - optimizing both customer experience and marketing efficiency.
6-Tier VIP Hierarchy
The proprietary "OOPBuy Spreadsheet" dynamically categorizes buyers into:
- Super VIP
- VIP Gold
- Silver Tier
- VIP Gold
CLV-Driven Resource Allocation
The spreadsheet's advanced tracking reveals:
| Tier | Avg. Order Value | Retention Rate | Marketing ROI |
|---|---|---|---|
| Super VIP | ¥32,400 | 92% | x4.8 |
| VIP Gold | ¥18,700 | 84% | x3.1 |
"Our spreadsheet revealed Bull DIamond tier clients (lifetime above ¥1M) drive 53% of revenue despite being <9% of users - we now allocate 1 dedicated agent per 6 VVIP accounts."
The analytics dashboard tracking 12+ VIP behavior metrics