How to Segment Your Patient Database Before Sending a Campaign
Short answer: Segment your patient database into mutually exclusive groups before any campaign, such as recently active, due for clinician recall, lapsed 6–12 months, incomplete plans and opted out. Each patient should sit in exactly one group. Then run quality checks (duplicates, missing consent, outdated contact details) so each group gets one appropriate message.
Key takeaways
- Every patient belongs to exactly one segment.
- Remove opt-outs and missing-consent records first.
- Check for duplicates and outdated contact details.
- Write one message per segment, not one message for everyone.
Why segment before sending a campaign?
A single message to everyone is easy, but it means a patient with a booking next week gets the same invitation as someone who left a year ago. That creates confusion, duplicate bookings and unnecessary opt-outs.
Segmenting lets you match the message to the patient's situation and measure results by group.
How do you build mutually exclusive segments?
Apply rules in order, and once a patient is placed, remove them from later groups:
- Opted out or no consent: exclude
- Future booking: exclude from promotional outreach
- Incomplete clinician-recommended plan
- Due for clinician recall
- Lapsed 6–12 months
- Lapsed more than 12 months
Record the count in each segment and confirm the totals add up to your starting list.
How does the database segmentation worksheet help?
The segmentation worksheet sets out a table for building mutually exclusive segments and a set of quality checks to complete before anything is sent.
Resource 015 is organized into these sections:
- Build mutually exclusive segments
- Quality checks
Download Resource 015: Database segmentation worksheet →
Frequently asked questions
How many segments should a clinic use?
Four to six is usually enough. More segments mean more messages to write and manage.
What if a patient fits two segments?
Your rule order decides. Place them in the first segment they match and remove them from the rest.
Do I need special software?
No. A spreadsheet export from your booking system is enough for most clinics, provided you handle patient data securely.
What should you do next?
Download the free database segmentation worksheet and complete it with your team this week.
Bring your numbers, team and growth plan together.
The Revenue Room by Aesthetic Intelligence combines clinic management tools, customisable dashboards, branded resources and AI-assisted planning in one membership. Organise recall, follow-up and patient experience with team tools, branded resources and practical growth planning.
Monthly expert strategy consulting and a personalised strategy plan help you turn that insight into practical action. $129/month per clinic. One membership. Complete access.
Launching November 2026. Join the free waitlist, no payment today.
Download the resource → · Join the Revenue Room waitlist →
Related reading
- Seven Patient Reactivation Messages You Can Adapt for Your Clinic (Resource 014)
- How to Reconnect With Patients Who Never Completed Their Treatment Plan (Resource 016)
- Instagram DM to Appointment: A Practical Workflow for Your Front Desk (Resource 025)
About Aesthetic Intelligence. Aesthetic Intelligence helps aesthetic clinic owners and managers in Canada and the United States find missed revenue and turn it into practical action through strategy, operations systems, front-desk workflows and training. Founded by Chantel Allen, a former clinic COO with more than seven years of operations, AI and business-systems experience in Canadian medical aesthetics and longevity clinics.
Examples in this article are hypothetical. This is general operational guidance, not legal, financial, tax or medical advice. Clinical decisions belong with qualified clinicians, and advertising, privacy and consent requirements vary by province and state.