SDI Lab / BI cockpit Demo on a made-up Swiss insurance-lead business, data as of 28.10.2026 18:00. Names, brokers and numbers are invented.

Car invoiced leads, September 2026

1–20 of 20 · by invoice date

Download CSV
20 shown More columns
Car invoiced leads, September 2026
LeadCantonBrokerStatusInvoicedAmount (CHF)
2971BSRheinfall AssekuranzHeld01.09.2026150.00
2753VDAare Vorsorge AGHeld01.09.2026140.00
2460ZHAare Vorsorge AGHeld01.09.2026150.00
3105SGUetliberg BrokerHeld03.09.2026145.00
2893VDBergsee FinanzHeld03.09.2026135.00
3000ZHLindenhof BeratungHeld04.09.2026130.00
3160BSSeeufer FinanzplanHeld04.09.2026150.00
3164ZHUetliberg BrokerHeld05.09.2026150.00
2928TIUetliberg BrokerHeld07.09.2026145.00
2965LUUetliberg BrokerHeld09.09.2026135.00
3201VDAlpenblick Broker GmbHHeld11.09.2026125.00
2994ZHSeeufer FinanzplanHeld15.09.2026150.00
3346FRAlpenblick Broker GmbHHeld15.09.2026145.00
3333ZHUetliberg BrokerHeld18.09.2026145.00
3990ZHAlpenblick Broker GmbHHeld25.09.2026150.00
3392LURheinfall AssekuranzHeld25.09.2026145.00
3881AGUetliberg BrokerHeld26.09.2026140.00
4029FRRheinfall AssekuranzHeld28.09.2026130.00
4306FRAare Vorsorge AGHeld28.09.2026140.00
3757FRUetliberg BrokerHeld29.09.2026130.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 = 'Car'
order by invoiced_at, lead_id
limit 50 offset 0

The 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 = 'Car'

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