Life invoiced leads, September 2026
1–15 of 15 · by invoice date
15 shown
More columns
| Lead | Canton | Broker | Status | Invoiced | Amount (CHF) |
|---|---|---|---|---|---|
| 2945 | BS | Aare Vorsorge AG | Held | 03.09.2026 | 640.00 |
| 2822 | TI | Rheinfall Assekuranz | Held | 04.09.2026 | 715.00 |
| 3022 | BE | Rheinfall Assekuranz | Held | 04.09.2026 | 630.00 |
| 3131 | SG | Aare Vorsorge AG | Held | 06.09.2026 | 615.00 |
| 3255 | FR | Seeufer Finanzplan | Held | 07.09.2026 | 625.00 |
| 3055 | SG | Bergsee Finanz | Held | 08.09.2026 | 645.00 |
| 3478 | FR | Alpenblick Broker GmbH | Held | 18.09.2026 | 620.00 |
| 3130 | BS | Aare Vorsorge AG | Held | 18.09.2026 | 655.00 |
| 3506 | ZH | Rheinfall Assekuranz | Held | 20.09.2026 | 680.00 |
| 3367 | GE | Säntis Partner | Held | 21.09.2026 | 675.00 |
| 3547 | ZH | Uetliberg Broker | Held | 23.09.2026 | 620.00 |
| 3484 | LU | Seeufer Finanzplan | Held | 24.09.2026 | 710.00 |
| 3270 | BE | Bergsee Finanz | Held | 24.09.2026 | 710.00 |
| 3838 | BS | Alpenblick Broker GmbH | Held | 24.09.2026 | 585.00 |
| 3912 | ZH | Alpenblick Broker GmbH | Held | 26.09.2026 | 645.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 product = 'Life'
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 product = 'Life'The app runs these queries with parameters; here the values are written in, so they can be read or pasted into psql.