CRM & Loyalty PlatformPRODUCTION● LIVEINDIA

Loyalty & Rewards Engine

PostgreSQL · Redis · BullMQ · 5M Buyers · 100K Sellers · 10M Orders

👥↑ 12.4%
5.0M
Active Buyers
⭐↑ 18.7%
₹84.2Cr
Points Issued
💰↑ 9.2%
₹12.4Cr
Wallet Balance
🎟️↑ 22.1%
2.84M
Active Coupons
🔗↑ 31.4%
4,82,910
Referrals
❤️↑ 14.8%
18.4M
Store Followers
💸↑ 8.9%
₹4.2Cr
Cashback Paid
🏪↑ 6.2%
1,00,000
Active Sellers
LOYALTY PIPELINE:Buyer Action→Event Trigger→BullMQ Queue→Rules Engine→Points Calc→Redis Cache→PostgreSQL→Wallet Update→Notification→Buyer Dashboard
TECH STACK:PostgreSQL: Primary DBRedis: Cache & SessionsBullMQ: Job QueuesNext.js API: REST APIWhatsApp API: CampaignsEmail SMTP: CampaignsPush FCM: NotificationsSegments: Customer Groups
⭐
₹84.2Cr
Points Issued (MTD)
842M points @ ₹0.10/pt
💎
₹31.4Cr
Points Redeemed
37.3% redemption rate
💰
18.4M
Wallet Transactions
₹12.4Cr total balance
💸
₹4.2Cr
Cashback Paid
2.8% avg cashback rate
🔗
₹2.84Cr
Referral Earnings
4,82,910 successful referrals
🎁
₹8.4Cr
Gift Cards Sold
84,291 cards active

Customer Segments

5.0M Total Buyers
💎PLATINUM
48,291
Platinum Members
₹24,800 avg
🥇GOLD
2,84,100
Gold Members
₹8,400 avg
🥈SILVER
8,42,000
Silver Members
₹2,800 avg
🌱NEW
12,84,000
New Buyers
₹840 avg
⚠️AT-RISK
4,82,000
At-Risk Buyers
₹420 avg
😴CHURNED
2,10,000
Churned Buyers
₹0 (30d)

Festival Calendar

🪔 Q4 2025
Diwali 2025
Oct 20 · Budget: ₹8.4Cr
Planning
Navratri
Oct 2 · Budget: ₹2.1Cr
Draft
Dussehra
Oct 12 · Budget: ₹1.4Cr
Draft
Karva Chauth
Oct 20 · Budget: ₹84L
Draft

Active Loyalty Programs

ProgramStatusActive UsersPoints EarnedPoints RedeemedRedemption Rate
⭐Reward Points
Active5.0M₹84.2Cr₹31.4Cr
37.3%
💸Cashback Program
Active3.2M₹4.2Cr₹4.2Cr
100%
🔗Referral Program
Active1.8M₹2.84Cr₹2.1Cr
74%
🎂Birthday Rewards
Active84,291₹42L₹38L
90.5%
🪔Festival Rewards
Active4.2M₹12.4Cr₹8.4Cr
67.7%
❤️Follow Store Rewards
Active2.1M₹84L₹62L
73.8%

System Architecture — Lightweight CRM Stack

Data Layer
PostgreSQL 15
Buyers, Points, Wallet, Coupons, Referrals, Segments
Cache Layer
Redis 7
Session data, leaderboards, rate limiting, real-time counters
Queue Layer
BullMQ
Points processing, campaign dispatch, birthday/festival jobs
API Layer
Next.js API Routes
REST endpoints, webhook handlers, campaign triggers