Leads invoiced (Finance)

Every lead billed to a broker, counted on the invoice day. Owner: Finance.

Why other departments count differently →

name: leads_invoiced_finance
label: Leads invoiced
noun: invoiced leads
description: Every lead billed to a broker, counted on the invoice day.
measure: lead_count
time_basis: invoiced_at
owner: finance
certified: true

select count(distinct lead_id) as value
from leads
where invoiced_at >= timestamp '2026-09-01 00:00:00' at time zone 'Europe/Zurich'
  and invoiced_at < timestamp '2026-10-01 00:00:00' at time zone 'Europe/Zurich'

select to_char(invoiced_at at time zone 'Europe/Zurich', 'YYYY-MM') as period,
       count(distinct lead_id) as value
from leads
where invoiced_at >= timestamp '2026-04-01 00:00:00' at time zone 'Europe/Zurich'
  and invoiced_at < timestamp '2026-11-01 00:00:00' at time zone 'Europe/Zurich'
group by 1
order by 1

select canton as label,
       count(distinct lead_id) as value
from leads
where invoiced_at >= timestamp '2026-09-01 00:00:00' at time zone 'Europe/Zurich'
  and invoiced_at < timestamp '2026-10-01 00:00:00' at time zone 'Europe/Zurich'
group by 1
order by 2 desc, 1
limit 50

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