Mining Your 5-Year Customer File for Revenue

Somewhere in your system — the field-service software, the old spreadsheets, the shoebox of invoices — there are 400, 800, maybe 2,000 names of people who once paid you money. They know your name, they know your work, and they haven't heard from you since the job ended. Every one of them is a warmer lead than any cold prospect you'll buy this year.

This post is the starting point of System 7 (reactivation) inside the broader Pillar D framework — the pillar post covers keeping the calendar full; this post covers refilling it from the customers you already won.

Why the file is the cheapest lead source you own

New-customer acquisition costs money: ads, lead marketplaces, estimator time on tire-kickers. Reactivation costs a text or an email to someone who already trusts you. The trust math is the whole argument: a past customer skips the shopping phase — they know your work, your techs, your pricing style. Your reactivation message isn't "hire a stranger"; it's "remember us?" That's a fundamentally easier sale, and it's why the dormant file should be worked before a dollar goes to new lead gen.

Step 1: Assemble the file

Before segmenting, gather. Pull customer records from everywhere they live:

• Your field-service software (field service management software — the software running your scheduling, dispatch, and job records) — the primary source: names, numbers, addresses, job history.
• Your CRM (customer relationship management system — the database where you track leads and customers) — if separate from the field-service software, merge it.
• Old systems: the spreadsheet era, the QuickBooks customer list, the paper invoices. One afternoon of data entry on the old records pays for itself for years.
• Dedupe ruthlessly. "Mike Johnson," "Michael Johnson," and "M. Johnson" at the same address are one customer. Duplicates are the #1 cause of the embarrassing double-text.

Step 2: Segment by recency (the reactivation order)

Not all dormant customers are equal. Segment into four tiers and work them in order — warmest first:

• Tier 1 — Recent (last 12 months), no repeat visit. The warmest. They remember you clearly; the relationship just went quiet. Reactivation message: the check-in + maintenance offer.
• Tier 2 — 1–2 years, single job. Warm but fading. They need a reason tied to time: the annual inspection, the seasonal tune-up, the "it's been a while" check.
• Tier 3 — 2–5 years. Cool. The reactivation needs a stronger hook: the equipment-age angle ("your unit is now X years old"), the seasonal checklist, or the win-back offer.
• Tier 4 — 5+ years or one tiny job long ago. Coldest. Worth one reactivation attempt per year — the seasonal email, the checklist content. Don't spend text-message effort here; email is the right channel.

Within each tier, prioritize by job value: past install customers before past repair customers. The install customer has the equipment relationship — and the replacement cycle — that makes them the highest lifetime value in the file.

Step 3: Clean before you send

A reactivation campaign to a dirty list does more harm than good. Before the first message:

• Remove the do-not-contacts: anyone who opted out, anyone who left angry, anyone marked "do not call." Texting an opted-out customer isn't just rude — it's a TCPA (federal telemarketing law) problem.
• Verify the channels: run the list through your texting platform's validation (dead numbers waste money and hurt deliverability) and your email tool's verification.
• Check consent: past customers who gave you their number for the job generally consented to transactional messages about that job — a reactivation marketing text is a different thing. The safe posture: email the colder tiers freely (with unsubscribe), text the warmer tiers where you have an established relationship, and always include opt-out. General information, not legal advice.

Step 4: The reactivation sequence

Work tier by tier, not all at once — a flood of replies you can't handle is worse than a slow campaign:

• Week 1–2: Tier 1 — the personal check-in text (see script below).
• Week 3–4: Tier 2 — the seasonal/annual reason text.
• Week 5–6: Tier 3 — the equipment-age or win-back message.
• Ongoing: Tier 4 — the quarterly email (checklist content, seasonal tips).

The ongoing system (not a one-time blast)

The dig is the project; the system is the asset. After the initial reactivation:

• Every completed job re-enters the file with a "next touch" date (12 months for maintenance-eligible, 24 for installs). The file never goes dormant again.
• Quarterly, the system surfaces the due tier — the customers hitting their reactivation window get the appropriate message automatically.
• Track reactivation revenue separately in your books: jobs booked from reactivation messages, by tier. When you can see the file producing revenue, you'll never let it go quiet again.

A worked example

Example: a plumbing shop assembles 640 past customers from its field-service software and old invoices, dedupes to 590, and segments: Tier 1 (140), Tier 2 (180), Tier 3 (170), Tier 4 (100). Cleaning removes 22 bad records and 8 do-not-contacts. The 6-week sequence runs tier by tier. Results are illustrative, not promised: Tier 1 books at the highest rate (the check-in text to recent customers), Tier 2 responds to the annual-inspection angle, Tier 3's water-heater-age messages surface several replacements, Tier 4 gets the quarterly email. The shop's owner starts tracking "reactivation revenue" as a line item — and within two quarters, it's the highest-ROI marketing the shop does, because the audience cost nothing to acquire. The file was always the asset. It just needed working.

Related guides in this series

This post opens System 7 — the reactivation deep dives continue with text vs. email channel strategy, win-back offers that don't train discount-seekers, and maintenance plan upsells. The pillar framework for the full calendar is the appointment confirmation system.

The done-for-you version

This post is System 7 from the Leveraged Owner Starter Pack — the done-for-you version with the full 5-step setup guide, every script, the worksheets, and click-by-click setup instructions for all 8 systems. The Starter Pack includes the segmentation worksheet and all four tier scripts.

Stats sourced as labeled: no third-party statistics used in this post; the worked example is illustrative, not a customer result. Compliance notes are general information, not legal advice.

Keep building your systems

Related guides from the Leveraged Owner blog: