Three Easy-to-Keep Resolutions for a Clean Database in 2021

How confident are you that your database is clean? Can you make accurate assessments about your business’s health with the data it contains? If you’re not sure, don’t worry—you’re not alone – not everyone enjoys data crunching, plus, Consult YHN has your back!

The importance of a clean database is that it allows your practice to operate more efficiently. As the leader of the practice, it allows you to set key business goals and effectively benchmark your progress towards achieving them. A clean database will support increased revenue by efficiently spending and/or saving money and improve patient satisfaction.

Think of quality data as the backbone of your business—it’s the central pillar that connects and supports all the facets of your business. With accurate data and reporting, you will confidently make decisions that will move your business forward.

What’s considered “data” within your database? These would be your appointment types, referral sources, revenue sources, etc. For example, are you running a Consult Database Program, Consult Upgrade event, or want to see how well your marketing campaigns are performing? Referral sources play a critical role in capturing your marketing ROI (Return on Investment) and identifying where your revenue-generating leads and sales are coming from. Referral sources should be labeled and updated properly so we can track your results and identify units sold and revenue generated per sale. If referral sources are not updated and tracked, you’re essentially throwing marketing dollars out the window.

There multiple benefits of tracking your marketing initiatives, but it is impossible without clean, consistent data. To run a productive and profitable practice, it’s vital to identify incorrect data, understand the root, fix it, and develop a plan for maintaining a healthy, more reliable database.

As we prepare for 2021, below are three resolutions for cleaning up your database, which will ensure it stays clean even after your other New Year’s resolutions have been forgotten:

1. Data Entry

Of course, it all starts with the data that’s being entered into the system. If there’s one takeaway from this blog post, it should be this: your data is only as good as the data you enter. As the leader, it’s up to you to ensure your employees are properly trained and understand the importance of entering accurate information into your Practice Management System (PMS). Everyone on your team needs to be on the same page when it comes to activities such as labeling opportunity sources and what each referral source represents. Once you have a process in place, don’t assume everyone is following it, day in and day out. Periodically poke around your database to ensure that it’s kept nice and tidy.

2. Data Audit

Second, audit your data to reveal any inconsistencies and/or errors. You might be surprised by the number of inconsistencies and how far they go back. If you and your staff are regularly inputting incorrect or bad data, this will cause a snowball effect—and no one wants a database full of duds! Once corrected, this will establish trust within your data. Our Sales Analytics team can help you get started by performing a PMS Analysis. This will help you get the most out of your PMS software by ensuring accurate tracking reports, patient lists, and QuickBooks integration.

3. Data Upkeep

The last step is upkeep. As previously noted, ultimately, you are accountable for monitoring the accuracy of your data. It’s not a ‘set-and-forget-it’ activity—consistency is key! Luckily, you don’t have to do it all alone. Working closely with your Account Manager, our Sales Analytics team will provide the insights and tools necessary to execute these steps and contribute to your business’s collective success rather than hindering it.

Remember: the more time you spend tracking and auditing your data today, the less you’ll spend correcting errors in the future. The reward for your hard work is a sparkling database that delivers better insights, better reporting, and sound business decisions.

Click here to learn more about Consult YHN’s Business Services and Financial Analyses or talk to your Account Manager today to get started!

About the Author

Laura Kegelman joined Consult YHN in 2018 and currently serves as a Strategic Planning Analyst. Her diverse professional background includes supply chain, forecasting, and marketing. Laura holds a degree in marketing from West Chester University in Pennsylvania. When she’s not working, Laura loves exploring the city she lives in (Philadelphia) as well as traveling to new cities and countries.

Nine Marketing ROI Stats That Might Surprise You

Is your marketing working?

In other words, is it generating business in a profitable way?

If your answer is “no” or “I don’t know,” then read on to find out why it’s important to have a clear understanding of your marketing return on investment (ROI) and its impact on your business.

First, let’s define marketing ROI: It’s the practice of attributing profit and revenue growth to the impact of your marketing initiatives. Simply put, if you spend money on marketing, it measures your return.

Now, let’s discuss why your marketing ROI matters. Here are the top three reasons it’s a critical element of your overall business strategy:

  1. You can identify any “red flags” or missteps in your current marketing strategy so that you can make the necessary adjustments to drive greater results. For example, if your call response rate for your marketing initiative is below the industry benchmark, you might need to reevaluate your target audience.
  2. You can make informed decisions about allocating your marketing budget and creating your marketing plan for the coming year. If you don’t know what works and what doesn’t, then you’re essentially gambling with your investment.
  3. You can analyze your ROI data and know for certain if and how much your marketing efforts are contributing to revenue growth.

Now that you understand why marketing ROI is important, we can dive into the fun part—the data!

We reviewed a year and half of data from a select group of practices and below are some insights and benchmarks we uncovered. Some stats might surprise you or, more importantly, motivate you to take a closer look at your own marketing strategy and reevaluate your plan for 2020:
  1. Direct mail still works— in 2018 and 2019, our practices sent out 525 direct mail campaigns, yielding an average of $1,320 in profit per campaign. Find out if your own direct mail campaigns are successful with our Direct Mail Calculator.
  2. Thinking about advertising in your local magazine? You might want to give that a second thought! With a high cost-per-campaign and a negative return, magazine advertising serves more as a brand awareness tool than a true opportunity driver.
  3. Patients routinely check your digital properties before picking up the phone. 421 digital campaigns resulted in 2,935 calls with a total profit of $1,058 per campaign—a whopping 502 percent return!
  4. Over half (55 percent) of our Associates’ referrals come from physicians. This is encouraging because patients that come from a trusted opportunity source are more ready to buy. So, keep working to establish relationships with physicians in your area!
  5. Five thousand direct mail pieces resulted in 15 calls and 6 appointments with an average response rate of 31 percent. Although this appears low, the industry benchmark for response rates is 0.25-0.50 percent.
  6. Wouldn’t you like to make two months’ revenue in just three days? It’s possible with the Consult Upgrade Program! A total of 32 upgrade events averaged $58,000 in total revenue.
  7. Did you know that 40 percent of co-op dollars available are currently going unused? Every co-op dollar spent results in $5.39 in revenue for our Associates. If you’re not taking advantage of your co-op dollars, let our marketing team help you use them strategically.
  8. Calling Out of Warranty (OOW) patients generated an additional $215,000 in profits for our Associates while calling Tested Not Sold (TNS) patients yielded an extra $86,000 in profits. So, pick up the phone! Or, better yet, let Your Patient Contact Center do it for you.
  9. Due to blank categories in our Associates’ practice management systems, there was nearly $1.7 million in revenue unaccounted for. Meaning, many practices don’t know where all of their revenue is coming from each month. Don’t be one of those practices — let our marketing team help you establish an organized process for labeling opportunity sources in your practice management software.

*Based on the Marketing ROI data from a select group of practices between Jan. 2018 – June 2019

Consult YHN’s Quarterly Marketing ROI Reports offer invaluable insights that ensure every marketing dollar spent today is growing your practice for the future. If you don’t already receive a report, talk to your Account Manager to find out how you can!

About the Author

Laura Kegelman joined Consult YHN in 2018 and currently serves as a Strategic Planning Analyst. Her diverse professional background includes supply chain, forecasting, and marketing. Laura holds a degree in marketing from West Chester University in Pennsylvania. When she’s not working, Laura loves exploring the city she lives in (Philadelphia) as well as traveling to new cities and countries.