Back to Portfolio
2026
ClickHousePythonCouponsn8n

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.