Every inbound lead in one place — work the list, the cost-per-patient math updates itself
Leads synced through Oct 6, 2026 · ad data through —
DS Prepared by Damaris Solutions
✓ All changes savedEverything you change here saves to the shared sheet automatically.
💾 Your changes save to the shared lead sheet. Change a status, log a call, set a service, insurance, visit count or note and everyone working these leads sees it — the front desk, Damaris, and the doctors. Watch the Saved indicator above the table: if it ever says NOT saved, stop and tell Jordyn. New ad leads merge in automatically. Use ⬇ CSV for a spreadsheet copy any time.
⚠ Leads sync automatically — ad spend does not. Update this from Ads Manager or cost-per-lead reads low.
0
Total Leads
—
Cost / Lead
Ad spend ÷ ad leads · spend is manual
0
Still to Call
Status = NEW
0
Appointments Booked
everyone who ever booked — incl. no-shows
—
Cost / Appointment
Ad spend ÷ booked ad leads
—
Show Rate
showed ÷ resolved appts
0
New Patients
—
$0
Revenue Earned
from attended visits
—
Return on Ad Spend
ad-driven revenue ÷ spend
—
Conversion Rate
leads that reached the schedule
💳 About this $157.14 — who paid it, and who pays from here.
This first flight ran on the Damaris Solutions card, so the $157.14 was charged to us and will be passed through to Axis Health on the next invoice. The Axis card is now attached to the ad account, so from here forward Meta bills Axis Health directly — no pass-through, no markup, and the charges land on your own statement as they happen.
🔎 What this batch is telling us
What they asked for
Insurance mix
Which campaign delivered
Read on it
🎯 Conversion funnel — where leads are actually lost
each bar is a share of all leads · the % on the right is stage-to-stage
🗓️ Appointment tracking — what the ads put on the schedule
Enter each patient's booked visits in the Visits column below. The clinic total is every appointment from every source — walk-ins, referrals, existing patients — so the share is honest.
0
Visits From Ads
booked across all ad leads
—
Ad Share Of Schedule
enter the clinic total →
—
Avg Visits / Patient
across patients with visits logged
—
Cost / Visit
ad spend ÷ visits from ads
—
Value / Visit
case value ÷ visits, once entered
0
Booked, No Visits Yet
on the schedule with 0 logged
📞 Follow-up effort — how many calls it takes
Hit + in the Touches column every time you call or text
—
Avg Calls to Book
across every booked lead
0
Total Calls Logged
—
—
Booked on 1st Call
share of bookings won immediately
—
Won by Persistence
booked on call 2 or later
0
Stalled, Still Open
called at least once, no booking yet
0
Never Called
zero touches logged
Where the bookings land
Open leads by calls made
What to do with it
Google Sheet sync not configuredWorking as not set
#
Date
Name
Phone
Email
Touches
Wants
Insurance
Lead Source
Visits
Case Value $
Status
Notes
Statuses run NEW → ATTEMPTED → CONTACTED → APPOINTMENT SET → SHOWED → PATIENT. ATTEMPTED means you called and left a message or got no answer; CONTACTED means you actually spoke to them — keeping those apart is what shows you how many leads die in voicemail, with NO SHOW for booked-but-didn't-arrive and DISQUALIFIED for out-of-area, bad numbers or services you don't offer. Wants and Insurance come straight off the Instant Form — correct them on the call, they're editable. Case Value is what the episode of care is worth: a cash visit package, an insured course of treatment, or a personal-injury case. Area-code tags flag numbers registered outside the 541/458 Southern Oregon footprint — treat those as "verify", not "reject." Website-form and phone leads can be added manually with + Add Lead.
Axis Health · Lead Tracker · maintained by Damaris Solutions