DEV Community

Graham McCann
Graham McCann

Posted on

How to see which private pharmacy services actually make money, using data you already have

Most pharmacies that sell private services can tell you which one is busiest. Far fewer can tell you which one makes the most money, which one is quietly slipping, or whether the money spent on ads is filling the diary. The data to answer all three usually exists already. It is just spread across four or five tools. Here is how to pull it together in a spreadsheet in about an hour a month.

1. List the services and what each one is worth (10 minutes)

Make one row per private service: travel vaccinations, weight management, earwax removal, private consultations, flu jabs, whatever you sell. Add the price, or the average price if it varies.

Keep the names exactly as they appear in your booking system. If the booking tool says "Microsuction ear wax removal" and your spreadsheet says "Ear care", nothing will match later.

2. Completed bookings per service (10 minutes)

Export last month's appointments from your booking system as CSV. Bookly, Acuity and most WooCommerce booking plugins can do this.

Count completed appointments only. Cancellations and no-shows tell you something too, so keep them in their own column, but they are not revenue.

Completed bookings multiplied by price gives you revenue per service. This is usually the first surprise: the busiest service is often not the one earning the most.

3. Search demand per service from Search Console (10 minutes)

In Google Search Console, open Performance, set the date to last month and filter queries with a regex per service. For example:

ear ?wax|microsuction|ear clean
Enter fullscreen mode Exit fullscreen mode

Note the impressions and clicks for each service. Impressions are a rough measure of how many people searched for it and saw you. Compare with the month before.

4. Which service pages turn visitors into bookings (10 minutes)

In GA4, look at landing pages with sessions and key events (booking started or booking completed, if you have them set up). Match each landing page to a service.

A service page with plenty of visits and few bookings has a page problem, not a demand problem. Missing prices, no booking button above the fold and vague wording are the usual causes.

5. Ad spend per service (10 minutes)

If you run Google Ads, split spend by campaign or ad group so each one maps to a service. Divide spend by completed bookings to get a rough cost per booking.

Be honest about attribution here. Someone may click an ad, leave, and book a week later after a Google search. Treat cost per booking as a guide, not an exact number.

6. Put it side by side and look for gaps

One row per service, these columns:

Service Revenue Completed Cancelled Search impressions Page conversion Ad cost per booking

Things worth acting on:

  • Search demand rising, bookings flat. People are looking and not booking. Fix the service page first.
  • High revenue, falling impressions. A ranking slipped. Check the page in Search Console before it shows in the takings.
  • Ad cost per booking higher than the margin on the service. Pause or rework that campaign.
  • Lots of cancellations on one service. Look at reminders, the booking questions or how the service is described.

A made-up example of the first one: earwax removal impressions up 40% over three months while bookings rise 3%. The demand is there, the page is losing it.

Doing it every month

The first month takes the longest because you are matching names across tools. After that it is mostly exports and copy and paste. The trend matters more than any single month, so keep the sheet going.

I got tired of doing this by hand for pharmacy clients, so I built Pharmivanta, which pulls the same figures from Search Console, GA4, Google Ads, WooCommerce and Bookly into one dashboard. The spreadsheet method above works fine on its own though, and it is the best way to understand what the numbers mean before you automate anything.

Top comments (0)