LU invoiced leads, September 2026
1–14 of 14 · by invoice date
14 shown
More columns
| Lead | Product | Broker | Status | Invoiced | Amount (CHF) |
|---|---|---|---|---|---|
| 3015 | Basic health (KVG) | Rheinfall Assekuranz | Held | 01.09.2026 | 175.00 |
| 3155 | Basic health (KVG) | Bergsee Finanz | Held | 04.09.2026 | 170.00 |
| 3129 | Basic health (KVG) | Bergsee Finanz | Held | 09.09.2026 | 185.00 |
| 2965 | Car | Uetliberg Broker | Held | 09.09.2026 | 135.00 |
| 2664 | Basic health (KVG) | Bergsee Finanz | Held | 10.09.2026 | 185.00 |
| 3197 | Basic health (KVG) | Uetliberg Broker | Held | 13.09.2026 | 180.00 |
| 3476 | Basic health (KVG) | Alpenblick Broker GmbH | Held | 13.09.2026 | 195.00 |
| 3319 | Supplementary (VVG) | Aare Vorsorge AG | Held | 15.09.2026 | 305.00 |
| 3073 | Basic health (KVG) | Alpenblick Broker GmbH | Held | 22.09.2026 | 200.00 |
| 3442 | Basic health (KVG) | Alpenblick Broker GmbH | Held | 23.09.2026 | 180.00 |
| 3484 | Life | Seeufer Finanzplan | Held | 24.09.2026 | 710.00 |
| 3392 | Car | Rheinfall Assekuranz | Held | 25.09.2026 | 145.00 |
| 3186 | Supplementary (VVG) | Uetliberg Broker | Held | 28.09.2026 | 340.00 |
| 3776 | Supplementary (VVG) | Säntis Partner | Held | 29.09.2026 | 290.00 |
How it's calculated
These rows
select lead_id, created_at, channel, canton, product, broker, appointment_at, appointment_status, contract_signed_at, invoiced_at, invoice_amount_chf
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'
and canton = 'LU'
order by invoiced_at, lead_id
limit 50 offset 0The row count
select count(*) as total
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'
and canton = 'LU'The app runs these queries with parameters; here the values are written in, so they can be read or pasted into psql.