Rheinfall Assekuranz invoiced leads, September 2026
1–22 of 22 · by invoice date
22 shown
More columns
| Lead | Canton | Product | Status | Invoiced | Amount (CHF) |
|---|---|---|---|---|---|
| 2971 | BS | Car | Held | 01.09.2026 | 150.00 |
| 2876 | ZH | Basic health (KVG) | Held | 01.09.2026 | 185.00 |
| 3015 | LU | Basic health (KVG) | Held | 01.09.2026 | 175.00 |
| 2856 | AG | Basic health (KVG) | Held | 03.09.2026 | 195.00 |
| 2750 | ZH | Basic health (KVG) | Held | 04.09.2026 | 170.00 |
| 2822 | TI | Life | Held | 04.09.2026 | 715.00 |
| 3022 | BE | Life | Held | 04.09.2026 | 630.00 |
| 3089 | FR | Basic health (KVG) | Held | 04.09.2026 | 195.00 |
| 3204 | SG | Supplementary (VVG) | Held | 07.09.2026 | 350.00 |
| 2871 | VD | Basic health (KVG) | Held | 09.09.2026 | 190.00 |
| 3115 | FR | Supplementary (VVG) | Held | 16.09.2026 | 300.00 |
| 3576 | BE | Supplementary (VVG) | Held | 18.09.2026 | 310.00 |
| 3585 | ZH | Basic health (KVG) | Held | 19.09.2026 | 185.00 |
| 3506 | ZH | Life | Held | 20.09.2026 | 680.00 |
| 3401 | AG | Basic health (KVG) | Held | 21.09.2026 | 165.00 |
| 3514 | AG | Basic health (KVG) | Held | 24.09.2026 | 190.00 |
| 3605 | ZH | Basic health (KVG) | Held | 25.09.2026 | 185.00 |
| 3392 | LU | Car | Held | 25.09.2026 | 145.00 |
| 4045 | AG | Basic health (KVG) | Held | 26.09.2026 | 165.00 |
| 4029 | FR | Car | Held | 28.09.2026 | 130.00 |
| 3865 | ZH | Basic health (KVG) | Held | 29.09.2026 | 180.00 |
| 3329 | VD | Basic health (KVG) | Held | 30.09.2026 | 190.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 broker = 'Rheinfall Assekuranz'
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 broker = 'Rheinfall Assekuranz'The app runs these queries with parameters; here the values are written in, so they can be read or pasted into psql.