Repeat rate is your survival metric. Here's how to move it
How to calculate your travel agency's repeat booking rate in Excel, benchmark it honestly against industry norms, and build a 12-month system to raise it.
Uluwatu · 18:25Every rupee you spend on a Meta ad or an OTA listing buys you a stranger. Every repeat client walks in already knowing your rates, your reliability and your WhatsApp number. Yet most Indian agencies can't tell you their repeat rate, the share of past travellers who book with them again, because nobody's ever sat down to count it.
That's a problem, because acquisition is getting more expensive every quarter while your actual growth engine, repeat and referral business, sits uncounted and unmanaged in an old Excel sheet. You cannot improve a number you don't measure. This post gives you the 30-minute method to calculate your repeat rate, an honest benchmark to judge it against, and a 12-month system built specifically for how Indian families travel, so the number moves.
None of this needs new software. It needs 30 minutes with your booking history and a plan for the next 12 months.
What "repeat rate" actually means for an agency with no CRM
Skip the fancy loyalty-program definitions. For a small agency, define it simply:
Repeat rate = unique repeat travellers ÷ total unique travellers, over a trailing 24-month window.
A few clarifications that matter:
- Count unique travellers or households, not bookings. If the Sharma family booked Kerala in February and Bali in November, that's one repeat traveller, not two separate "new" bookings.
- Use a 24-month window, not a calendar year. Indian leisure travel is seasonal and irregular. A family that went to Kashmir last May and books Vietnam this December is a repeat client, even though the two trips straddle a financial year boundary.
- A "repeat" traveller is anyone in your books more than once in that window, regardless of who referred whom.
This is deliberately looser than what a corporate CRM report would give you. That's fine. The point isn't statistical precision. It's having a number you trust enough to act on.
The 30-minute method to calculate yours in Excel
You almost certainly already have the raw material: a booking register, a WhatsApp broadcast list, or a folder of PDF invoices. Here's how to turn it into one number.
- Pull every booking from the trailing 24 months into one sheet, one row per booking, with client name, mobile number and travel date.
- Sort by mobile number (it's a more reliable unique key than name: spellings vary, numbers don't).
- Use
COUNTIFon the mobile number column to flag how many times each number appears. Anything counted 2+ times is a repeat traveller. - Count unique mobile numbers with a duplicate flag, then count how many of those uniques have a count of 2 or more.
- Divide. Repeat travellers ÷ total unique travellers = your repeat rate.
Example: An agency pulls 24 months of bookings and finds 340 unique client mobile numbers. Of those, 54 appear more than once in the sheet. Repeat rate = 54 ÷ 340 = 15.9%. That's a real number this agency can now track quarter over quarter, and a baseline to beat.
Careful: Don't count a family's second traveller (spouse, child) added to the same booking as a separate "repeat." That inflates the number without reflecting an actual second sale. Repeat rate should track people or households who came back and paid again, not headcount on one invoice.
What's actually a good number
This is where most operators either fool themselves or give up. Neither is useful. Here's the honest range.
| Segment | Typical repeat rate |
|---|---|
| Leisure travel, industry average | ~15% |
| Business/corporate travel | ~20-25% |
| Agencies using a CRM across sales, accounts and service | 50%+ retention |
| Leisure agencies specifically, full CRM use vs sales-only use | 74% vs 59% |
| Realistic 12-month target for a small agency running a system | 25-30% |
The 15% leisure baseline and the 20-25% business-travel figure are the honest industry benchmark against which a small agency should measure itself, and 25-30% is a realistic stretch target rather than a fantasy (source). Separately, agencies that use a WhatsApp CRM properly across sales, account management and service report retention above 50%, and in leisure specifically the gap between full CRM use and sales-only use is 74% versus 59% (source). You don't need to buy anything to close most of that gap. You need a system, which is what the rest of this post is.
If your number comes out below 15%, don't panic. Most agencies never measured it before, so there's no shame baseline to fall below. If you're already above 25% without trying, you're doing something right; go find out what it is and do more of it deliberately.
Why retention math beats acquisition math
The industry-wide ratio of acquiring a new customer versus retaining an existing one runs 5-7x, and Bain & Company's well-known finding is that a 5-percentage-point increase in retention lifts profits by 25-95% (source). Put rupee numbers on that for your own business.
Example: Say your average package margin is ₹18,000 per booking and you run 200 bookings a year, split 170 new clients and 30 repeat. A Meta ad campaign to acquire 30 new equivalent clients, at a realistic ₹3,000–₹5,000 cost per booked lead in a competitive leisure category, costs you roughly ₹90,000–₹1,50,000 before you've delivered a single trip. Getting 30 existing clients to rebook, through a WhatsApp nudge, an anniversary call, a referral credit, costs closer to nothing beyond your own time and maybe a small referral incentive. The margin is identical; the acquisition cost is not.
There's a second, quieter number worth knowing: your most engaged repeat travellers, those with 7 or more bookings, rebook roughly every 146 days, against an average traveller's ~312-day gap (source). Engagement compounds. The family that trusts you enough to book twice books a third time much sooner than the first-timer does. That's the economic argument for treating a handful of loyal households as a distinct segment worth real attention, not just names on a broadcast list.
It also helps that the pool you're fishing in keeps growing. Indian outbound departures hit a record 32.7 million in 2025, up 6.6% year on year (source). More of your past clients are travelling more often; the question is only whether it's with you.
The khandaan strategy: mapping the family graph
Here's the single highest-leverage idea in this post, and the one most agencies never formalise: your client isn't a person, it's a family. Indian family travel decisions run through a khandaan: spouse, parents, kids, in-laws, and the friend circle that travels with them. Track only the primary booker's name and you're throwing away most of the account's lifetime value.
For every client who's booked with you twice, spend five minutes building their family graph:
- Spouse and immediate family: who else travels with them, always?
- Parents: are they a separate travelling unit with different needs (pilgrimage, comfort-paced itineraries, shorter flights)?
- Kids and their school calendar: what are the fixed windows (summer break, Diwali, winter break) this family must travel in?
- Friend circle: does this couple travel with the same 2-3 other couples? That's a group departure waiting to be quoted.
Once you have the graph, you stop selling one trip at a time and start selling the next-trip ladder:
- Honeymoon: the entry point, often booked with urgency and less price sensitivity.
- Babymoon: 1-2 years later, shorter-haul, comfort-first.
- Family trip with young kids: Goa, Kerala, or a Southeast Asia beach break once the child is old enough to fly.
- Parents' pilgrimage: Char Dham, Vaishno Devi, or a spiritual circuit, often booked for the parents by the same client who did their own honeymoon with you years earlier.
- Friend-group departure: once the couple trusts you enough to vouch for you to their circle, a fixed-departure group trip follows.
This is exactly the model Veena World has scaled to more than 5 lakh guests within roughly eight years of founding, built substantially on Maharashtrian family repeat-and-referral culture rather than paid acquisition (source). You don't need their scale to copy the mechanic: track the family, not the file.
Careful: A family graph is only useful if you actually use it to time your outreach. A spreadsheet of relationships nobody looks at before quoting is just clutter. Set a monthly 30-minute slot to scan it for upcoming school holidays, anniversaries and "it's been 18 months since their last trip" flags.
The TCS cut as your 2026 re-activation script
You now have a genuine, factual reason to call every outbound client from 2023-25 that has nothing to do with asking for business. You're bringing them good news.
TCS on overseas tour packages dropped to a flat 2% from 1 April 2026, down from a structure that taxed the portion of the package above ₹10 lakh at 20% (source). That's a real, quotable change: a client who booked a ₹15 lakh Europe package in 2025 paid upwards of ₹1,50,000 in TCS under the old slab structure; the same package this year attracts roughly ₹30,000, a flat 2% on the full amount.
Example script: "Bhabhi, remember the Europe trip you did last year? The tax the government used to charge upfront on packages like that has dropped a lot this year. Same trip today would cost you almost a lakh less in TCS alone. Should I put together a quote for this winter?"
Careful: The exact old-regime TCS a specific client paid depends on how their package amount split across the prior slabs, so don't quote a precise "you'll save ₹X" figure without checking their actual TCS certificate from that booking. The direction and scale of the change are real and worth the call; the exact rupee figure for each family is not something to guess at out loud.
Pair this script with the destination ladder that's opened up alongside it. Thailand received 2.48 million Indian arrivals in 2025, up 16% year on year, and Vietnam saw 7,46,480 arrivals, up a striking 48.9% (source). For a family that did Europe in 2023 and hasn't travelled abroad since, "cheaper TCS plus a fresh, trending Southeast Asia option" is a complete pitch, not a vague check-in.
For the mechanics of the new TCS regime itself, what to change in your invoicing and client communication, see the full 2% TCS playbook.
The 12-month repeat-rate system
Individual scripts don't move a number by themselves. You need a calendar that runs without you remembering it every week.
1. Build the anniversary calendar. For every client, log two dates: their travel date (for a "one year since your Ladakh trip" nudge) and, where you know it, their wedding anniversary or a milestone (first honeymoon clients especially). A basic spreadsheet with a monthly filter does this. No software required.
2. Time seasonal nudges to school and festival calendars, not your convenience. Summer break, Diwali, and winter break are fixed decision windows for family travel. Reach out 6-8 weeks before each window opens, not after parents have already booked elsewhere.
3. Segment your WhatsApp broadcasts by trip type, not by "all clients." A broadcast to your entire list about a Bali offer wastes the attention of the Char Dham pilgrimage segment and vice versa. Three or four segments, honeymoon-stage, family-with-kids, parents/pilgrimage, group/friend-circle, is enough to make every message feel relevant instead of generic. For the real cost and reply-rate math behind broadcast segmentation, see WhatsApp broadcast economics.
4. Offer a referral credit, not just a referral request. "Send your friends our way" gets forgotten. "₹2,000 off your next trip when someone you refer books" gets acted on, because it converts word-of-mouth into something trackable and worth remembering. Loyalty-programme members book at roughly 15 times the repeat rate of non-members and spend about 79% more per trip (source). You don't need a formal programme, just a consistent, honoured credit.
5. Close the loop after every trip. The single highest-leverage 30 days in the whole system are the ones right after a client lands home, while the trip is still fresh and photos are still being shared in the family group. If you're not systematically working that window, start there: see the 30-day post-trip flow that prints repeat bookings.
6. Track the number quarterly. Rerun the Excel method above every quarter. A repeat rate that isn't measured on a schedule quietly reverts back to whatever it was before you started paying attention.
Run this system for four quarters against the honest 15% leisure baseline, and a small agency targeting 25-30% is not an unreasonable ask. It's the direct, arithmetic result of turning family history into a calendar instead of a memory. Compare that ongoing cost against what you'd spend chasing the same number of bookings from cold Instagram leads or OTA-dependent traffic, and the case for building this system before spending another rupee on acquisition makes itself.
The short version
- Repeat rate = unique repeat travellers ÷ total unique travellers over a trailing 24-month window; count households, not bookings.
- Calculate yours in Excel in 30 minutes with
COUNTIFon mobile numbers; rerun it every quarter. - Honest benchmark: leisure travel averages ~15% repeat, business travel 20-25%; a small agency running a real system can realistically target 25-30%.
- Acquiring a new client costs 5-7x more than retaining one, and a 5-point retention gain can lift profits 25-95%; do the rupee math on your own margin per booking.
- Map every repeat client's family graph, the khandaan strategy, and sell the natural next-trip ladder: honeymoon, babymoon, family trip, parents' pilgrimage, friend-group departure.
- The 2026 flat 2% TCS cut is a genuine, factual reason to call every 2023-25 outbound client this quarter; verify the exact rupee saving per client before quoting it.
- Build the system once: anniversary calendar, seasonal nudges timed to school holidays, segmented WhatsApp broadcasts, and a real referral credit. Then let it run on schedule instead of memory.