HMC Sales CEO Report
HMC Dental · SalesUpdated 9 Oct 2026, 17:00

Overview

Leads and results

Leads receivedPlans acceptedBooked

From lead to patient

Team health

Score and the biggest problem per team. Click a team for details.

Where leads are now status of leads received in the period

Leads by source share and conversion

Needs attention

Grouped by where the lead is in the journey. Click any line to open those leads.

HMC Sales CEO Report · template v11 · live Sales CRM data (dates and times in Albania time). Grey percentages = fewer than 10 leads, too few to judge. Status names match the CRM (New, Callback, No answer, Qualified, Accepted, Converted, Lost). "Results" = accepted + converted. "Conversion rate" = converted ÷ leads received.
Call-quality alert rules
Working hours = Mon–Sat 09:00–18:00, Albania time. Thresholds are set in RULES at the top of the alerts code: first call 15 min · never called 2 h · minimum 4 attempts before giving up · 2 h between unanswered calls · best hours 17:00–20:00 · cold after 3 days · plan within 48 h of qualifying · chase a plan after 5 days · "answered" calls under 10 s flagged · pool limit 30 min.
Data sources (for the developer)
Leads report. CRM fields: leads.source · campaign_name · country · status · owner_id · last_contact_at · call_attempts · accepted_value · converted_at. Needs one new endpoint, GET /api/crm/reports/leads.
Extra lead detail and alerts (proposed fields): treatment_interest · language · email · patient_message · photos_received · ad_set · ad_name · landing_page · referral_agent · assigned_at · qualified_at · callback_at · quote_sent_at · quote_items · deposit_paid_at · visit_date · lost_reason · lead_notes · WhatsApp message count. Alerts are computed from these plus every call's time, outcome and talk seconds (call_cdr).
Calls report. CRM source: /api/crm/reports/activity (per agent) · /api/crm/reports/activity/days (per day) · call_cdr (talk time) · call outcomes from lead_activities.
Messages report (also agent page and lead popup). WhatsApp: wa_messages (direction, status) + sent-by-agent from lead_activities kind=whatsapp. SMS: sms_messages + sent-by-agent from lead_activities kind=sms. Email: email_messages (direction, member_id, opened_at). Received messages count for the lead owner. WhatsApp and email per agent already come from /api/crm/reports/activity (wa_out, wa_in, wa_unreplied, email_out, email_opened, email_in). SMS is not in that endpoint yet: add sms_out / sms_in to it.
Source reports. CRM fields: leads.source, campaign_name / utm_campaign, country, joined to status and owner. Ad spend and cost per lead need the Meta and Google ad accounts connected.

Use ↑ ↓ to go through the list one by one · Esc closes