From ad click to booked consultation.
Nicholson’s forms, calls, ad platforms and CRM each counted leads their own way, so no report could follow an ad click to a booked consultation. We put every form path into one lead format, connected calls, analytics, ads and the CRM on the warehouse, and gave each lead an ID that carries through to the consultation. The clinic’s marketing team reports on it in Maven.

Leads by form pathLast 30 days
- Consultation requestfull_name, phonelead format104
- Contact pagename, email, msglead format59
- Callback requestphone onlylead format47
- Financing inquiryfirst, last, emaillead format33
- Seminar sign-upemail onlylead format28
- Live chatfree textlead format18
- Pricing pagename, ziplead format11
Five lead counts, and no path from click to consultation.
Forms, calls, ad platforms and the CRM each told a different story, so budget and sales-coaching decisions rested on five different lead counts, and no report could tie a consultation back to the ad that started it. Clinical details had to stay out of marketing systems and reports.
In the reports
- Form paths7 formats
Callscall logAd platformsplatform conversions
Analyticssite goals
CRMcontacts
Out of the reports
Full-funnel attribution, from click to consultation.
GoHighLevel, Piwik PRO, CallRail and the ad platforms feed one reporting layer on the warehouse. A lead ID links each click, lead and consultation.
Nicholson Clinic’s environment
Form paths + calls
Analytics + CRM
Advertising signals
Custom consultations dataset
- Consultation bookings
- Lead ID and form path
- Source and campaign
Maven
- One format7 form paths, one lead format
- ReconciledForms, calls, ads and CRM matched
- ReportingClick to consultation, by source
Warehouse
Marketing team workspacePowered by Maven
Reports built and edited by the clinic’s own team
Kept out of marketing systems and reports
Four steps to one funnel, from click to consultation.
From seven form paths capturing leads differently to every consultation traced back to its source.
- 01
One lead format
All seven live form paths now share one lead format, so a lead from any entry point arrives with the same fields.
BeforeSeven form paths, each capturing leads differently
AfterEvery form path produces leads in the same format
- 02
Connect every step
GoHighLevel (CRM), Piwik PRO (analytics), CallRail (calls) and the ad platforms, connected and modeled into one reporting layer on the warehouse.
BeforeForm, call, ad and CRM numbers that didn’t agree
AfterClicks, forms, calls and CRM records in one lead count
- 03
Tie click, lead and consultation together
Each lead gets an ID that carries its source and campaign, and the consultation keeps that ID, so a booked consultation traces back to the click that started it.
BeforeLead source lost before consultation
AfterEvery consultation tied to its source and campaign
- 04
Keep clinical details out
The funnel carries only the lead ID, source, campaign and whether a consultation was booked.
BeforeReporting stopped at the lead
AfterReports run to the booked consultation
Meta has the cheapest leads, at $75. Google has the cheapest consultations, at $400.
Read each platform from left to right to see what a click, a lead and a booked consultation cost.

Click to consultation, by platform
MetaFacebook + Instagram · $33,00015,000$2.20440$75Consultations matched to leads by lead ID.
Want to see what each consultation costs by platform? We’ll walk your team through it and map what your clinic’s data needs.
Book a walkthroughSee which ads book consultations.
Start with a free scan of your lead tracking, or have us connect forms, calls, ads and CRM from click to consultation.