Yesterday, Kevin and I made an appearance on the Dentalpreneur Podcast with Dr. Mark Costes to kick off Metric Mondays, where we do quick discussions about various metrics and what you can do with it.
As promised, we are giving away the Open Dental Attrition Query code written by Kevin Rossen. Why is this valuable? Well, you can use it to pull a master list of active patients that have attritioned out of your office and use it for reactivation marketing.
If you want the code, send an email to firstname.lastname@example.org and put in the subject line “attrition code” and I will send to you as an attachment.
Here’s how to use it…
- Launch Open Dental
- Go to Reports
- Pull down User Query
- Cut and paste the code in the attached file
- Hit Submit
18 months is standard, but you can adjust to 24, 36, 72, or whatever you like.
What you can do with this list
- Create custom audience in Facebook and run ads
- Use MailChimp, Infusionsoft, Legwork, Hubspot, etc to do email follow ups
- Go old school and make phone calls
- Send postcards
Hope this helps!