Appointments (Operations) · September 2026

Definition: leads with an appointment in the month, counted on the appointment date (appointment_at), status scheduled or held. Owner: Operations.

• By channel
• By canton
• By product
• By broker

select canton, count(*)
from leads
where appointment_status in ('scheduled', 'held')
  and appointment_at >= '2026-09-01' and appointment_at < '2026-10-01'  -- Europe/Zurich
group by canton
order by 2 desc;