Inferred Sales
For each market in the table below, <oem>/<market>/composite/public_inferred_sales records the
vehicles that left the market's composite inventory, one row per sale.
Inferred Sales describes the windows, the thresholds and the output
columns.
| Market | First partition | Look-back | Look-ahead | Presence sources |
|---|---|---|---|---|
mercedes/mbusa | 2026-09-16 | 14 days, 0.7, at least 2 present | 7 days, at least 4 observed | every source group |
stellantis/us | 2026-11-04 | 14 days, 0.7, at least 2 present | 7 days, at least 4 observed | every source group |
bmw/au | 2025-04-06 | 14 days, 0.7, at least 2 present | 7 days, at least 4 observed | every source group |
Each market's first partition is its composite's first partition plus look_back_days - 1 days,
so every partition's look-back lies within the composite. The last partition is 7 days before
today, the look-ahead.
In bmw/au, the Stolo feed reports a vehicle as sold, and the composite records it in
sources_reporting_sold; see Reported sales. A
bmw/au sale is dated on the last day the vehicle was listed without the sold flag.
is_reported_sale is true when the vehicle was still listed, flagged sold, on the next observed
day. A vehicle that Stolo lists as sold from its first appearance is never present, so it has no
sale.
A custom order is a sale like any other vehicle. The composite's is_custom_order marks it on
public_inventory; join a sale to that table on vin and inferred_sold_date to tell a custom
order from a stock sale. See Custom orders.
mercedes/mbusa and stellantis/us have no source that reports a vehicle as sold or marks a
custom order, so every sale there is a disappearance from the composite, and is_reported_sale is
false.
Every source group counts as presence in every market, and each sale's presence_sources column
lists all of the market's groups. In mercedes/mbusa and stellantis/us a day therefore counts as
observed when any source collected something. A single dealer website that fails to scrape for
some days, while the OEM feed and the other sites are collected, makes the vehicles that only that
site lists absent on those days, and they can be inferred sold.
dealer_code comes from the composite; see Composite Inventory for
which sources supply it.
days_on_lot uses the composite's arrival_date. See
Composite Inventory for which arrival dates each market has.