Referral appointments, September 2026

select lead_id, created_at, channel, canton, product, broker, appointment_at, appointment_status, contract_signed_at, invoiced_at, invoice_amount_chf
from leads
where appointment_at >= timestamp '2026-09-01 00:00:00' at time zone 'Europe/Zurich'
  and appointment_at < timestamp '2026-10-01 00:00:00' at time zone 'Europe/Zurich'
  and appointment_status in ('scheduled', 'held')
  and channel = 'Referral'
order by appointment_at, lead_id
limit 50 offset 0

select count(*) as total
from leads
where appointment_at >= timestamp '2026-09-01 00:00:00' at time zone 'Europe/Zurich'
  and appointment_at < timestamp '2026-10-01 00:00:00' at time zone 'Europe/Zurich'
  and appointment_status in ('scheduled', 'held')
  and channel = 'Referral'

The app runs these queries with parameters; here the values are written in, so they can be read or pasted into psql.