Competitive Edge Dashboard
Real-time performance · 3 clinics
LeadsLeadsNew inbound leads created in GoHighLevel during this period (cohort by lead creation date). Includes every source — website forms, ads, referrals, walk-in intakes. Excludes only Spam Leads and Invalid Contact stages.Source: GoHighLevel Contacts API · Sales Pipeline
—
DVs ShowedDVs ShowedDiscovery Visits that actually took place in the period. Every row in the clinic's DV Metrics tab counts — the sheet only records DVs that happened. Show rate = DVs Showed ÷ DVs Scheduled (scheduled total adds Appointment Forecast for upcoming dates).Source: DV Metrics sheet · COUNTIFS on col A (DOS)
—
Evals ShowedEvals ShowedEvaluations attended (PT + Regenerative Therapy combined) with DOS in the period. Mirrors Cockpit row “Evaluation Attended”. Show rate = Evals Showed ÷ Evals Scheduled (from ProspectsCalls booked evals + Appointment Forecast).Source: Evaluation Metrics + Regenerative Evaluations · col B (DOS)
—
Programs SoldPrograms SoldEvaluations that led to a new program purchase — the “New Program?”column is TRUE on the eval row. Attribution is by the eval's date, not the sale date (matches Cockpit). Conversion = Programs Sold ÷ Evals Showed.Source: Evaluation Metrics · "New Program?" boolean column
—
Loading…
Loading…
Paid Media
Total Ad SpendTotal Ad SpendSum of Meta + Google ad spend in the selected period, all campaigns, all clinics.Source: ad_metrics_daily · SUM(spend)
—
Cost per ProgramCost per ProgramTotal ad spend ÷ Programs Sold (all clinics, all sources, same period). Coarse-grained — mixes paid + walk-in + organic clients in the numerator against total ad spend (including brand campaigns) in the denominator. Useful directional signal, not lead-attributed.Source: ad_metrics_daily SUM(spend) ÷ eval_rows new_program=TRUE
—
ROASROASRevenue ÷ Ad Spend. Revenue = sum of program_sales.amount across all clinics. Coarse-grained — includes walk-in and organic revenue against total ad spend (incl. brand campaigns). Directional executive indicator, not attributed return.Source: program_sales SUM(amount) ÷ ad_metrics_daily SUM(spend)
—
Loading…
Loading…