Leads (Marketing)

Every lead, counted on the day it arrived. Owner: Marketing.

Why other departments count differently →

name: leads_marketing
label: Leads
noun: leads
description: Every lead, counted on the day it arrived.
measure: lead_count
time_basis: created_at
owner: marketing
certified: true

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

select to_char(created_at at time zone 'Europe/Zurich', 'YYYY-MM') as period,
       count(distinct lead_id) as value
from leads
where created_at >= timestamp '2026-04-01 00:00:00' at time zone 'Europe/Zurich'
  and created_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 created_at >= timestamp '2026-09-01 00:00:00' at time zone 'Europe/Zurich'
  and created_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.