Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Can Our Opticians See Test Room to Dispense Conversion by Branch and Optometrist Without Building a Spreadsheet?
Problems We Solve

How Can Our Opticians See Test Room to Dispense Conversion by Branch and Optometrist Without Building a Spreadsheet?

Opticians' test room to dispense conversion is usually a guess or a spreadsheet. We build a weekly view by branch and optometrist from your practice data.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Conversion figures are hard to get because sight tests and dispenses are separate records, sometimes on different days, and linking them needs rules about what counts. We write those rules down with you, link each test to any dispense that follows within your chosen window, and show conversion, average dispense value and reasons for no sale by branch and optometrist each week.

A question the owner cannot answer quickly

You run two or three branches. One seems busier on the dispensing side than the others, but you are not sure whether that is because it sees more patients or because more of its patients choose glasses there. A new optometrist has joined one branch, and you want to know how the handover from test room to dispensing desk is working. The practice system has reports for sight tests and reports for sales, but not one that joins them.

So the owner exports both, matches patients in a spreadsheet and tries to allow for patients who come back a week later to choose frames.

Why the figure is hard to produce

  • Tests and dispenses are separate records, sometimes created on different days.
  • Patients with no prescription change should usually be excluded, but that has to be defined.
  • Contact lens wearers, NHS voucher patients and private patients may need separate views.
  • Patients may dispense at a different branch from where they were tested.
  • Definitions change between people, so the numbers are never quite comparable.

What the missing figure costs

Without a reliable figure, it is hard to tell whether a branch or a handover process needs attention, whether training has made a difference, or whether a price change has affected choices. Discussions in team meetings rely on impressions. And the owner spends time assembling figures instead of acting on them.

QuestionWhat you need
Is branch A converting like branch B?The same definition applied to both
Did the new handover process help?A before and after view
Why do patients not buy?Reasons recorded consistently
Which patients should be excluded?Rules you choose, applied every time

How we build the conversion view

  1. We agree the definitions with you: which tests count, the window for a dispense to count, and how voucher, private and contact lens patients are treated.
  2. Tests and dispenses are read from your practice management system each night through its API or exports.
  3. Each test is linked to any dispense for the same patient within the window, at any branch.
  4. Where no dispense follows, staff can record a reason from a short list, such as no change, bought elsewhere, thinking about it or price.
  5. A weekly view shows conversion and average dispense value by branch and optometrist, with trends.
  6. Each figure clicks through to the underlying tests, so any number can be checked.

We do not set targets or suggest sales techniques. The view gives you consistent numbers to discuss with your team however you see fit.

What you can do with it

Branches are compared on the same basis. A change in the handover between test room and dispensing desk can be judged on evidence. Reasons for no sale point to specific issues, such as price concerns or a missing product range. And the owner gets Monday morning figures without a spreadsheet.

Many owners find the reasons list more useful than the conversion figure itself, because it tells you what to change.

The same data can answer other questions once it exists: which lens options are chosen most at each branch, how many patients buy a second pair, or how dispense value differs between NHS voucher patients and private patients. We add views like these only when you ask for them, so the dashboard stays focused on what you actually use.

Sound like you?

  • You cannot quickly see test to dispense conversion by branch.
  • Figures are produced by joining exports in a spreadsheet.
  • Different people calculate conversion differently.
  • Reasons for no sale are not recorded.
  • You want to see whether a change in process has made a difference.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Can it handle patients who dispense at another branch?

Yes. The link is by patient, so a dispense at any branch counts, if that is your rule.

Will optometrists feel judged?

How the figures are shared is your decision. Many practices look at branch and team figures before individual ones.

Does it work with our practice system?

It needs test and dispense records, which optical systems hold. We check how yours exposes them.

What affects the cost?

The number of branches, the complexity of your definitions and how your practice system provides data.

Keep reading

More on Problems We Solve

Start here

Tell us where your practice loses time

Walk us through a patient's journey from booking to collection, and name the practice system, labs and suppliers you use. We will tell you what we would build and what we would leave alone, and if a smaller change would fix it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →