Table name: replenishment_offer
Download Frequency : WEEKLY
Report Documentation: Replenishment Report API
Table name: replenishment_offer_metrics
Download Frequency : Weekly
Last updated
| Column Name | Data Type | Description |
|---|---|---|
| Column Name | Data Type | Description |
|---|---|---|
account_id
Integer
Intentwise Account Id
account_name
String
Intentwise Account Name
marketplace_id
String
Marketplace ID
auto_enrollment
String
The auto-enrollment preference indicates whether the offer is opted-in to or opted-out of Amazon's auto-enrollment feature.
asin
String
A list of Amazon Standard Identification Numbers (ASINs)
sku
String
The SKU. This property is only supported for sellers and not for vendors.
selling_partner_funded_base_discount_percentage
numeric
A base discount set by the selling partner on the offer.
selling_partner_funded_tiered_discount_percentage
numeric
A tiered discount set by the selling partner on the offer.
amazon_funded_base_discount_percentage
numeric
A base discount set by Amazon on the offer.
amazon_funded_tiered_discount_percentage
numeric
A tiered discount set by Amazon on the offer.
enrollment_method
String
Determines whether the offer was automatically or manually enrolled in the program. This property is only supported for sellers and not vendors.
program_type
String
The replenishment program type Ex: SUBSCRIBE_AND_SAVE
eligibility
String
The current eligibility status of an offer.
vendor_codes
String
A list of vendor codes associated with the offer
download_date
date
Downloaded date
account_id
Integer
Intentwise Account Id
account_name
String
Intentwise Account Name
marketplace_id
String
Marketplace ID
program_type
String
The replenishment program type Ex: SUBSCRIBE_AND_SAVE
aggregation_frequency
String
Aggreation frequency - Week.
time_period_type
String
The time period type - PERFORMANCE
asin
String
A list of Amazon Standard Identification Numbers (ASINs)
not_delivered_due_to_oos
numeric
The percentage of items that were not shipped out of the total shipped units over a period of time due to being out of stock. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
Maximum value : 100
total_subscriptions_revenue
numeric
The revenue generated from subscriptions over a period of time. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
shipped_subscription_units
numeric
The number of units shipped to the subscribers over a period of time. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
active_subscriptions
numeric
The number of active subscriptions present at the end of the period. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
revenue_penetration
numeric
The percentage of total program revenue out of total product revenue. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
Maximum value : 100
start_date
date
Start Date of the week
end_date
date
End Date of the week
download_date
date
Downloaded Date
