Why Your Active Patient List Is the Starting Point for Every Reactivation Campaign

Launching outreach without verifying your active patient list wastes effort on records that no longer belong in your campaign. Practices often pull outdated exports or rely on assumptions, only to discover archived, deceased, or non-patient contacts mixed in—undermining both response rates and professional credibility. This misstep isn’t just inefficient; it risks damaging patient trust when outreach reaches individuals who’ve long since left the practice or passed away.

Verifying PatStatus = "Patient" in Open Dental’s Patients-Raw report is the essential first step to protect revenue and reputation. As noted in the software’s official documentation, this filter explicitly identifies active patients, excluding statuses like Archived, Deceased, or Inactive that represent non-viable outreach targets. Starting with a clean, verified list ensures your team focuses only on those who are genuinely part of your current patient base.

The economics of reactivation make this verification step non-negotiable. Industry research shows that reactivating an existing patient costs approximately five times less than acquiring a new one, turning list hygiene into a direct leverage point for profitability. For a typical 2,000-patient practice, 25–40% of active patients are overdue for hygiene appointments—equating to 500–800 individuals representing $150,000–$240,000 in untapped annual production. Contacting inactive or incorrect records dilutes efforts that could otherwise recover this significant revenue stream.

Beyond immediate financial impact, list accuracy affects long-term practice health. Practices with strong recall and reactivation systems maintain retention rates above 85%, while those with unreliable lists see retention fall below 60%. This gap isn’t just about missed appointments—it reflects whether patients feel consistently seen and valued. When outreach respects a patient’s actual status, it reinforces trust; when it doesn’t, it signals disorganization.

Before launching any campaign, take these steps in Open Dental: access Reports > Standard > Lists > Patients-Raw, select fields for names, contact details, and Guarantor, then apply the PatStatus = "Patient" filter in the WHERE tab. Add Billing Type = "Standard" to focus on patients in good standing, and include PriProv if targeting a specific provider’s panel. Export the result for use in your outreach workflow—whether feeding into a spreadsheet, CRM, or directly to a service like CallMyCustomers for managed reactivation.

This verification process transforms outreach from a shot in the dark into a precision tool. By ensuring every contact on your list is an active, current patient, you protect your team’s time, uphold your practice’s standards, and unlock the full economic potential of reactivation—where the next booked appointment often starts with a simple, well-targeted message to someone who already knows your care.

The Built-In Tool: Open Dental's Patients-Raw Report

Verifying your active patient list in Open Dental is the essential first step before launching any outreach campaign, ensuring you're reaching the right people with relevant messages. The software provides a dedicated tool for this purpose: the Patients-Raw report, accessible via Reports > Standard > Lists > Patients-Raw. This built-in report is explicitly documented as the official method for extracting patient data and is version-supported in Open Dental 24.1. The Open Dental blog confirms that Patients-Raw is designed specifically for pulling active patient lists, making it the reliable starting point for outreach preparation.

To identify active patients, the critical filter is PatStatus = "Patient" in the WHERE tab of the report. Active patients are explicitly defined by this status in the system, distinguishing them from other categories like Inactive, Archived, Deceased, Prospective, NonPatient, or Deleted. The official Open Dental manual reinforces that PatStatus is the key determinant for active status, and applying this filter ensures your list includes only those patients currently engaged with your practice. This step is non-negotiable for accurate list verification before any communication effort.

Refining your active patient list further improves outreach relevance and efficiency. You can add filters for Billing Type (e.g., selecting "Standard" to target patients in good financial standing) and PriProv (Primary Provider) to create provider-specific segments for tailored messaging. Selecting the right fields in the SELECT tab—such as patient names, addresses, phone numbers, and the Guarantor field (which identifies the responsible party for family communications)—ensures your exported data contains all necessary information for mail merge or call list use. Once the query is configured, running the report and exporting the results prepares a verified list ready for outreach, whether for recall, reactivation, or appointment reminders. Access to this report can be managed through Report Setup Security Permissions, allowing practices to control who can view or export sensitive patient data. For service businesses using patient lists to drive repeat revenue—like those partnering with CallMyCustomers for done-for-you reactivation campaigns—starting with a clean, verified active patient list ensures outreach efforts are both compliant and effective, turning dormant relationships into booked work without wasted effort on outdated or incorrect contacts.

Step-by-Step: Filtering, Building, and Exporting Your Active Patient List

Before launching any outreach campaign, verifying your active patient list in Open Dental ensures you're communicating with the right people—those who are truly engaged with your practice and more likely to respond. The Patients-Raw report is the built-in tool designed specifically for this purpose, allowing you to extract accurate, actionable data for mail merge or call lists. Start by navigating to Reports > Standard > Lists section > Patients-Raw to open the User Query window where you’ll build your list.

In the SELECT tab, choose the fields essential for outreach: patient names, addresses, phone numbers, and the Guarantor field to ensure communications reach the correct household contact. Then, move to the WHERE tab to apply your filters. The most critical condition is PatStatus = 'Patient', which identifies active patients as defined in Open Dental. To focus on patients in good standing, add Billing Type = 'Standard'. For provider-specific outreach—such as recall efforts tied to a particular hygienist—include PriProv to isolate patients assigned to that clinician.

Once your filters are set, run the query to generate the list. For effective segmentation, consider recency: patients seen within the last 6–12 months are ideal for recall campaigns, while those inactive for 12–24+ months represent reactivation opportunities. This distinction aligns with industry insights showing that personalized messaging yields 29% better return on reactivation efforts. Export the results for use in mail merge tools or as a call list, ready for your outreach team or a service like CallMyCustomers to execute approved, permission-based campaigns that re-engage patients without feeling pushy.

From Verified List to Booked Appointments: Running the Outreach

A verified list is only as valuable as what you do with it. Once your Patients-Raw export cleanly separates active patients (PatStatus = "Patient") from inactive ones, you're holding the raw material for a reactivation campaign — and research suggests it's worth serious money.

The numbers make the case. According to recall system benchmarks, 25–40% of active patients in a typical practice are overdue for hygiene appointments — for a 2,000-patient practice, that's 500–800 people representing $150,000–$240,000 in untapped annual production. And since industry guidelines put the cost of acquiring a new patient at roughly five times more than retaining an existing one, the list you already own is your cheapest growth channel.

Segmentation drives the strategy. Your Open Dental export isn't one list — it's several campaigns waiting to happen:

• Recall list — active patients due for care within 6–12 months, best contacted 2–4 weeks before their ideal next visit
• Reactivation list — patients inactive 12–24+ months who need a reason to return
• Patients in good standing (Billing Type = "Standard") for provider-specific outreach via the PriProv filter
• Treatment-plan follow-up — unscheduled treatment campaigns recover 10–15% of that production within 30 days

This is where a done-for-you service like CallMyCustomers turns the list into appointments. The process starts with a free list review: you see your rate, setup, and what the list can realistically produce before spending a dollar. From there, the campaign is planned together — you approve every script, offer, and message before anything goes out.

Execution is multi-channel for a reason. Coordinated call, text, and email sequences improve response rates by 2–3x over single-channel outreach, recall research shows, because patients simply prefer different channels. Personalization matters too: dental marketing guidance finds personalized messaging delivers 29% better returns, using patient names, family references, and treatment history.

When patients reply, responses route directly into your existing booking process — confirmations, scheduling, and no-show follow-up all happen in your workflow, not a separate system. For dental clinics, outreach runs under the required privacy and messaging agreements (HIPAA, TCPA, A2P 10DLC), opt-outs are honored immediately, and booking collects explicit consent. Real people handle the judgment calls; automation handles the scale.

The result: your verified Open Dental list stops being a report someone runs once a quarter and starts functioning as a second revenue engine — one appointment at a time.