Coupon Leak Detection & Dynamic Coupons
"Found that 43% of a public return-trip coupon's discount was going to people it was never meant for — then replaced it with personal, single-use coupons issued automatically after each booking."
Executive Summary
A public return-journey code was meant only for new users after their first trip. Matching three months of bookings against coupon history showed 43% of its discount going outside that intent — lakhs of rupees leaking every quarter. I built a service that issues a unique, expiring return coupon to each eligible booker the moment they book, reconciles redemptions against booking data, and lets the public code be switched off safely.
Key Outcomes
- Quantified a 43% coupon leak worth lakhs per quarter.
- Personal single-use return coupons issued automatically after every booking.
- Daily reconciliation against booking data, with reminders inside allowed send hours.
Next Case Study
Ravan Rush — Festive Game
A Dussehra archery game where every shot earns a real coupon — with a live coupon engine, a difficulty controller that steers the reward mix, and a tuning panel so marketing can change the game without a release.