Stellantis Inventory Offers
Stellantis publishes no offers feed. ai_stellantis derives its national offers from the
incentive programs on each vehicle of the public inventory search, described in
Public Inventory Source.
Assets
| Asset | Component | Partitions |
|---|---|---|
stellantis/us/transformed/inventory_api_offers | StellantisInventoryOffersComponent | daily, one per inventory_api_inventory partition |
stellantis/us/consolidated/offers | ConsolidatedComponent (offers) | daily |
Transformed offers
The transformed asset has the common offer columns except
model_id and valid_from, followed by the Stellantis model key and the counts below. It has
one row per national program, end date and model, keyed on offer_code (the program's
programCode), valid_to (the program's endDate), model_code, model_year and
trim_identifier. Regional
programs are excluded, since they vary by dealer region within a model. Conditional programs
are excluded too. A conditional program is one the buyer must qualify for, such as military or
first-responder cash.
A vehicle is eligible for a program when the program appears in either programs or
extraCashProgramList. A model's population is its vehicles that list at least one national
program. A vehicle that lists only conditional programs is part of the population. A vehicle
that lists no national program is treated as having missing incentive data. The counts on each
row are:
| Column | Vehicles counted |
|---|---|
model_vins | the model's population |
eligible_vins | vehicles eligible for the program |
applied_vins | vehicles whose shown price includes the program |
scope classifies how the program targets the model:
scope | Condition |
|---|---|
insufficient | model_vins is below min_model_vins |
model | eligible_vins / model_vins is at least model_coverage |
targeted | Neither of the above. Such a program applies to part of the model's stock, such as Select Inventory Bonus Cash, or to some packages or engines |
model_coverage and min_model_vins are set in the component's defs.yaml. No row has
scope brand, because every row comes from one model's vehicles.
offer_type is null. The programs in incentives.cash are rebates off the price, and the
response does not say whether they apply to a cash purchase, a finance contract or a lease.
discount_type is percent_off_msrp for a program with a nonzero percoffmsrp. Otherwise
it is amount. A percent offer has percent_off_msrp and no amount, since its dollar
amount depends on each vehicle's MSRP. When discount_type is amount, the amount column
is the most common amount among the offer's eligible vehicles. When several amounts are
equally common, amount is the largest of them. distinct_amounts is the number of
different amounts the eligible vehicles list. standalone is true for percent offers that
cannot be combined with the cash programs. apr, term_months, monthly_payment and
due_at_signing are null, because the response lists no finance or lease offers.
The transformed asset has no valid_from column, because the inventory search response has
no program start date.
Consolidated offers
consolidated/offers merges the transformed partitions by the same key and resolves
model_id from model_code, model_year and trim_identifier. inventory_api_first_seen
is the earliest partition date in the source group's history_days window on which the
transformed asset has the offer. valid_from is that date. inventory_api_last_seen equals
the partition date while the inventory search still lists the offer.
A model's national cash on a partition date is the sum of amount over its offers that meet
all of these conditions:
scopeismodel.discount_typeisamount.inventory_api_last_seenequals the partition date.valid_tois on or after the partition date.
A standalone percent offer cannot be combined with that cash.