Skip to main content

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​

AssetComponentPartitions
stellantis/us/transformed/inventory_api_offersStellantisInventoryOffersComponentdaily, one per inventory_api_inventory partition
stellantis/us/consolidated/offersConsolidatedComponent (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:

ColumnVehicles counted
model_vinsthe model's population
eligible_vinsvehicles eligible for the program
applied_vinsvehicles whose shown price includes the program

scope classifies how the program targets the model:

scopeCondition
insufficientmodel_vins is below min_model_vins
modeleligible_vins / model_vins is at least model_coverage
targetedNeither 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:

  • scope is model.
  • discount_type is amount.
  • inventory_api_last_seen equals the partition date.
  • valid_to is on or after the partition date.

A standalone percent offer cannot be combined with that cash.