Database Reactivation
How to Segment a CRM for Reactivation
Three passes, in a specific order. Getting the order wrong is what turns a reactivation campaign into a list burn.
Spent 8 years running operations for a startup studio that launched more than a dozen companies. Leads CRM, automation, AI assistants, websites, and delivery infrastructure at Agency Logics.
Published
Why the order is the whole thing
Most people segment a database by date, because date is the field that is always populated. It is also the least useful of the three, and starting there guarantees rework.
Segmenting beautifully by service type and recency is wasted effort if a third of the list turns out to be third-party lead-seller data that cannot lawfully receive an automated marketing text. Doing consent first means every subsequent decision applies only to contacts you can actually message, and the campaign plan you build is one you can actually execute.
The three passes
Pass one: consent origin
Split by how each contact entered the database. First-party form with a marketing disclosure, first-party form without one, phone enquiry, past customer, third-party lead seller, purchased list, unknown. This pass determines what can lawfully be sent, so it comes before anything else and it can remove whole groups from the campaign.
Pass two: what they actually did
Within the contactable groups, split by behaviour. Unsold estimate, booked and completed, booked and cancelled, enquiry never answered, enquiry answered once, repeat customer. These are different people with different reasons for going quiet, and they need different messages.
Pass three: recency
Now apply time bands, roughly under 3 months, 3 to 12 months, 1 to 2 years, and older. Recency changes the wording rather than the eligibility: recent contacts can be referenced directly, older ones need to reintroduce the business first.
Cross-cut by service line and value
If you sell more than one thing, split again by what they enquired about and the value of that work. A $40,000 job and a $400 job justify very different amounts of follow-up effort, and mixing them dilutes both.
Scrub, then hold back a control group
Remove invalid numbers, duplicates, prior opt-outs and the internal do-not-contact list. Then hold back a slice of each segment from the first send. Without a holdout you cannot tell whether the campaign worked or whether those people were going to call anyway.
Sequence the sends, highest value first
Send the best-consented, highest-value segment first, in a throttled batch. Read the reply rate, the opt-out rate and the objections, adjust, then proceed. The first segment is both revenue and a test.
What each segment is worth, and what to say to it
| Segment | Why they went quiet | What the message should do |
|---|---|---|
| Unsold estimate | Price, timing, or they simply chose nobody and the project stalled | Reference the specific job. Remove the reason it stalled: financing, a revised scope, a scheduling window |
| Past customer | Nothing went wrong. Nobody asked them again | Offer the next logical service, or the maintenance interval that has now elapsed |
| Enquiry never answered | You never replied. This is the uncomfortable one | Acknowledge it briefly and directly, then make it easy to restart. Do not pretend it did not happen |
| Enquiry answered once | Follow-up stopped after the first attempt | Pick up the thread as if it were a conversation, because to them it was |
| Booked then cancelled | Circumstances changed, or something went wrong | Handle with care and check the notes first. Some of these should not be contacted at all |
The third row is worth sitting with. In most databases the largest single group is people who raised their hand and were never replied to, and research on lead response consistently finds a substantial share of online leads receive no response at all. That group is simultaneously the most embarrassing and the most recoverable.
The consent pass in practice
| Origin | Automated marketing SMS | |
|---|---|---|
| Your own form, with marketing disclosure | Generally yes, if not revoked | Yes |
| Your own form, no marketing disclosure | Treat as unusable for marketing texts | Yes |
| Phone enquiry, number given for a quote | Depends on what was said. Document it | Yes |
| Past customer, no marketing consent captured | Not for automated marketing texts | Yes |
| Third-party lead seller | Treat as unusable | Proceed carefully |
| Purchased list | No | No |
The row that catches people out most often is the past customer. A prior transaction is not consent to automated marketing texts, and the established business relationship exemption that people cite covers the Do Not Call rules for live calls, not autodialed messages. Full detail in the TCPA rules for texting old leads.
Where consent lives matters too
Opt-outs must be recorded on the contact record in the CRM, not only in whichever tool sent the message. That is correct practice now and becomes a hard requirement on 31 January 2027, when a single revocation will apply to all of your messaging to that number. Businesses running campaigns through a separate blast tool that does not write back are exactly the ones this catches.
Hold back a control group
This is the step everybody skips, and it is the difference between knowing the campaign worked and believing it did.
Hold back a random slice, five to ten percent, of each segment from the first send. Some of those people will call you anyway during the campaign window, because seasonality, referrals and life exist. Without a holdout, every one of those calls gets counted as a reactivation win, and the campaign looks better than it was. With one, you know the real lift, and you know whether to run it again.
- Randomise the holdout, do not take the bottom of the list. A non-random holdout measures nothing.
- Keep it small enough that you are not leaving real money unworked, then message them afterwards.
- Measure booked jobs, not replies. Reply rate is a vanity metric if the replies do not become work. See revenue operations.
Common questions
- How should I segment my CRM for a reactivation campaign?
- In three passes, in this order. First by consent origin, because that determines what you can lawfully send and to whom. Second by what the contact actually did, since an unsold estimate is a completely different prospect from a form fill that was never answered. Third by recency, which matters least of the three and is the one most people start with.
- Why segment by consent before anything else?
- Because it is the only pass that can disqualify a contact entirely. Segmenting a list beautifully by service type and recency is wasted work if half of it turns out to be third-party lead-seller data you cannot lawfully text. Doing consent first means every later decision applies only to contacts you can actually message.
- What is the highest-value segment in a typical database?
- Unsold estimates, by a distance. Those people described a job they wanted, received a price, and went quiet. They have already self-qualified on need, budget awareness, and service area. A cold contact has done none of that. If you only work one segment, work this one.
- How old is too old for a reactivation contact?
- Age matters far less than people assume, and it is not the legal constraint either, since the TCPA sets no expiry on prior express written consent. What changes with age is the message, not the eligibility. A three-month-old unsold estimate can be referenced directly. A three-year-old one needs to reintroduce who you are before it asks for anything.
- Should I message everyone at once?
- No, and this is the most expensive mistake in reactivation. One undifferentiated blast to the whole database produces complaints, carrier filtering, and opt-outs across contacts you would have converted later with a better message. Send segment by segment, starting with the highest-value and best-consented group, and use what you learn to adjust the rest.
- What do I do with contacts I cannot text?
- Email them. CAN-SPAM is a materially lower bar than the TCPA, and a reply re-establishes an active conversation you can then legitimately move to phone or text. For a segment with genuinely unclear consent, email-first is both the compliant route and usually the more effective one.
Not sure what is in your database?
The audit is the first thing we do on any reactivation engagement: how many contacts are usable, how consent was captured for each group, and which segments are worth working first. Often the useful finding is that one segment is worth everything and the rest can wait.
Apply For a Growth Partnership