{"queries":[{"id":"build_info","compiledQueryString":"select build_timestamp_utc from as24ch.metadata","inputQueryString":"select build_timestamp_utc from as24ch.metadata","compiled":false,"inline":true},{"id":"brand_list","compiledQueryString":"select distinct brand from as24ch.listings where status = 'active' and brand is not null order by brand","inputQueryString":"select distinct brand from as24ch.listings where status = 'active' and brand is not null order by brand","compiled":false,"inline":true},{"id":"fuel_list","compiledQueryString":"select distinct fuel_type from as24ch.listings where status = 'active' and fuel_type is not null order by fuel_type","inputQueryString":"select distinct fuel_type from as24ch.listings where status = 'active' and fuel_type is not null order by fuel_type","compiled":false,"inline":true},{"id":"model_list","compiledQueryString":"select distinct model from as24ch.listings\nwhere status = 'active' and model is not null\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\norder by model","inputQueryString":"select distinct model from as24ch.listings\nwhere status = 'active' and model is not null\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\norder by model","compiled":false,"inline":true},{"id":"kpis","compiledQueryString":"select\n count(*) as active_count,\n avg(current_price)::int as avg_price_active\nfrom as24ch.listings\nwhere status = 'active'\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)","inputQueryString":"select\n count(*) as active_count,\n avg(current_price)::int as avg_price_active\nfrom as24ch.listings\nwhere status = 'active'\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)","compiled":false,"inline":true},{"id":"kpis_rotation","compiledQueryString":"select\n count(*) as rotation_sample,\n avg(rotation_days)::numeric(10,1) as avg_rotation_days,\n median(rotation_days)::numeric(10,1) as median_rotation_days\nfrom as24ch.listings\nwhere status != 'active'\n and rotation_days is not null and rotation_days > 0\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)","inputQueryString":"select\n count(*) as rotation_sample,\n avg(rotation_days)::numeric(10,1) as avg_rotation_days,\n median(rotation_days)::numeric(10,1) as median_rotation_days\nfrom as24ch.listings\nwhere status != 'active'\n and rotation_days is not null and rotation_days > 0\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)","compiled":false,"inline":true},{"id":"brand_counts","compiledQueryString":"select brand, count(*) as listings\nfrom as24ch.listings\nwhere status = 'active'\n and brand is not null\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\ngroup by brand\norder by listings desc\nlimit 25","inputQueryString":"select brand, count(*) as listings\nfrom as24ch.listings\nwhere status = 'active'\n and brand is not null\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\ngroup by brand\norder by listings desc\nlimit 25","compiled":false,"inline":true},{"id":"fuel_mix","compiledQueryString":"select fuel_type, count(*) as listings\nfrom as24ch.listings\nwhere status = 'active'\n and fuel_type is not null\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\ngroup by fuel_type\norder by listings desc","inputQueryString":"select fuel_type, count(*) as listings\nfrom as24ch.listings\nwhere status = 'active'\n and fuel_type is not null\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\ngroup by fuel_type\norder by listings desc","compiled":false,"inline":true},{"id":"price_dist","compiledQueryString":"select floor(current_price / 2500) * 2500 as bucket, count(*) as n\nfrom as24ch.listings\nwhere status = 'active'\n and current_price between 1000 and 200000\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\ngroup by 1 order by 1","inputQueryString":"select floor(current_price / 2500) * 2500 as bucket, count(*) as n\nfrom as24ch.listings\nwhere status = 'active'\n and current_price between 1000 and 200000\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\ngroup by 1 order by 1","compiled":false,"inline":true},{"id":"days_buckets","compiledQueryString":"with bucketed as (\n select\n case\n when days_on_platform < 15 then '0-15'\n when days_on_platform < 30 then '15-30'\n when days_on_platform < 45 then '30-45'\n when days_on_platform < 60 then '45-60'\n when days_on_platform < 90 then '60-90'\n when days_on_platform < 120 then '90-120'\n when days_on_platform < 180 then '120-180'\n else '180+'\n end as bucket,\n case\n when days_on_platform < 15 then 1\n when days_on_platform < 30 then 2\n when days_on_platform < 45 then 3\n when days_on_platform < 60 then 4\n when days_on_platform < 90 then 5\n when days_on_platform < 120 then 6\n when days_on_platform < 180 then 7\n else 8\n end as sort_order\n from as24ch.listings\n where status = 'active'\n and days_on_platform > 0\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\n)\nselect bucket, sort_order, count(*) as listings\nfrom bucketed\ngroup by bucket, sort_order\norder by sort_order","inputQueryString":"with bucketed as (\n select\n case\n when days_on_platform < 15 then '0-15'\n when days_on_platform < 30 then '15-30'\n when days_on_platform < 45 then '30-45'\n when days_on_platform < 60 then '45-60'\n when days_on_platform < 90 then '60-90'\n when days_on_platform < 120 then '90-120'\n when days_on_platform < 180 then '120-180'\n else '180+'\n end as bucket,\n case\n when days_on_platform < 15 then 1\n when days_on_platform < 30 then 2\n when days_on_platform < 45 then 3\n when days_on_platform < 60 then 4\n when days_on_platform < 90 then 5\n when days_on_platform < 120 then 6\n when days_on_platform < 180 then 7\n else 8\n end as sort_order\n from as24ch.listings\n where status = 'active'\n and days_on_platform > 0\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\n)\nselect bucket, sort_order, count(*) as listings\nfrom bucketed\ngroup by bucket, sort_order\norder by sort_order","compiled":false,"inline":true}]}

AS24 CH — Overview

AutoScout24 Switzerland — Market Overview

Brand distribution (active)

Fuel mix

Price distribution

Days on platform (active listings)