> For the complete documentation index, see [llms.txt](https://docs.intentwise.com/iac-source-data/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/brand-analytics-reports.md).

# Brand Analytics Reports

## Data Source

To enable Brand Analytics Promotion Performance, Brand Analytics Market Basket Analysis & Brand Analytics Repeat Purchase Reports, the datasource: **Amazon Vendor Central** has to be enabled on the Intentwise Platform

## Brand Analytics Promotion Performance

Table name: brandanalytics\_promotionperformance\_report

The Promotion Performance report contains data to help vendors/sellers optimize their promotions and adjust their advertising strategies. Currently, three promotion types are supported: Best Deal, Lightning Deal, and Price Discount.

Frequency*: Daily*

*Note:* The promotion's start date in the request is always the beginning of the current year, and the end date is the previous day. Essentially, year-to-date data is retrieved daily*.*  Using the most recent report date for reporting purposes would be ideal*.*

| Column Name                   | Data Type | Description                                                                                                                         |
| ----------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------- |
| account\_id                   | Integer   | Intentwise account id                                                                                                               |
| account\_name                 | String    | Intentwise account name                                                                                                             |
| currency\_code                | String    | Currency code                                                                                                                       |
| report\_date                  | date      | Date for which the metrics belongs                                                                                                  |
| promotion\_id                 | String    | The unique identifier of the promotion                                                                                              |
| promotion\_name               | String    | The customer facing name of the promotion                                                                                           |
| vendor\_code                  | String    | The vendor code associated with the promotion funding agreement. For vendors only.                                                  |
| amount\_spent\_currency\_code | String    | The ISO 4217 currency code of amountSpent                                                                                           |
| revenue\_currency\_code       | String    | The ISO 4217 currency code of revenue.                                                                                              |
| type                          | String    | The type of the promotion                                                                                                           |
| status                        | String    | The state that the promotion is in.                                                                                                 |
| funding\_agreement\_id        | String    | The ID for the funding agreement. For vendors only.                                                                                 |
| start\_date\_time             | Timestamp | Promotion start date-time in ISO 8601 format in UTC.                                                                                |
| end\_date\_time               | Timestamp | Promotion end date-time in ISO 8601 format in UTC.                                                                                  |
| created\_date\_time           | Timestamp | The promotion creation date-time in ISO 8601 format in UTC.                                                                         |
| last\_updated\_date\_time     | Timestamp | The promotion last updated date-time in ISO 8601 format in UTC.                                                                     |
| asin                          | String    | Amazon Standard Identification Number. The unique identifier given to a product                                                     |
| product\_name                 | String    | Name of the Product                                                                                                                 |
| product\_glance\_views        | Integer   | The number of customer views of the product detail page.                                                                            |
| product\_units\_sold          | Integer   | The number of units sold at the promotional price                                                                                   |
| product\_amount\_spent        | Numeric   | Total funding provided across all ASINs in the promotion. For vendors only.                                                         |
| product\_revenue              | Numeric   | The total revenue generated across all ASINs in the promotion. For sellers, this is equivalent to "sales" in the Seller Central UI. |
| download\_date                | Date      | Download Date                                                                                                                       |

## Brand Analytics Market Basket Analysis

Table name: brandanalytics\_marketbasket\_report

Vendor Central Console Report : [Market Basket Analysis](https://vendorcentral.amazon.com/analytics/dashboard/marketBasketAnalysis)

Frequency: Daily

| Column Name           | Data type      | Description                                                                                                                                                                                      |
| --------------------- | -------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| account\_id           | int8           | Intentwise account id                                                                                                                                                                            |
| account\_name         | varchar(1020)  | Intentwise account name                                                                                                                                                                          |
| report\_date          | date           | Date for which the metrics belongs                                                                                                                                                               |
| asin                  | varchar(255)   | Amazon Standard Identification Number. The unique identifier given to a product                                                                                                                  |
| purchased\_with\_asin | varchar(255)   | The ASIN of the product that is 2nd most frequently purchased with your product.                                                                                                                 |
| purchased\_with\_rank | int4           | Purchased with Rank                                                                                                                                                                              |
| combination\_pct      | numeric(12, 2) | Percentage of orders that contain both your product and the #1 purchased product in comparison to the total number of orders that contained at least two different items including your product. |
| download\_date        | date           | Report downloaded date                                                                                                                                                                           |

## Brand Analytics Repeat Purchase

Table name: brandanalytics\_repeatpurchase\_report

Vendor Central Console Report : [Repeat Purchase Behavior](https://vendorcentral.amazon.com/analytics/dashboard/repeatPurchaseBehavior)

Frequency: Weekly (Friday)

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                               | Data type | Description                                                                                             |
| ----------------------------------------- | --------- | ------------------------------------------------------------------------------------------------------- |
| account\_id                               | Integer   | Intentwise account id                                                                                   |
| account\_name                             | String    | Intentwise account name                                                                                 |
| currency\_code                            | String    | Currency Code                                                                                           |
| start\_date                               | Date      | Week start date                                                                                         |
| end\_date                                 | Date      | Week end date                                                                                           |
| asin                                      | String    | Amazon Standard Identification Number. The unique identifier given to a product                         |
| orders                                    | Integer   | Number of orders. An order may include multiple quantities of a product and differs from ordered units. |
| unique\_customers                         | Integer   | Number of unique customers who placed an order in the selected reporting time frame.                    |
| repeat\_customers\_pct\_total             | Numeric   | Displayed percent of total.                                                                             |
| repeat\_purchase\_revenue\_amount         | Numeric   | Ordered revenue from repeat customers. Returns are not reflected.                                       |
| repeat\_purchase\_revenue\_currency\_code | String    | Currency Code                                                                                           |
| repeat\_purchase\_revenue\_pct\_total     | Numeric   | Displayed percent of total.                                                                             |
| download\_date                            | Date      | Download date of report                                                                                 |

## Brand Analytics Search Terms Report

Table name: brandanalytics\_searchterms\_report

Vendor Central Console Report: [Amazon Search Terms](https://vendorcentral.amazon.com/analytics/dashboard/searchTerms)

Frequency: Weekly (Wednesday)

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*\
\
**Data Source**

To enable Brand Analytics Search Terms Report, the datasource: **Amazon Brand Search Term Report** has to be enabled on the Intentwise Platform

| Column Name             | Data type | Description                                                                                                                         |
| ----------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------- |
| country\_code           | String    | Country Code                                                                                                                        |
| marketplace\_id         | String    | Amazon marketplace Id                                                                                                               |
| department\_name        | String    | Amazon department - Amazon.com, Amazon.co.uk etc                                                                                    |
| search\_term            | String    | Keyword searched by Amazon customers                                                                                                |
| search\_frequency\_rank | Integer   | Ranking based on search frequency                                                                                                   |
| clicked\_asin           | String    | Most clicked ASIN based on the search results in the selected time frame                                                            |
| clicked\_item\_name     | String    | Name of the Product                                                                                                                 |
| click\_share\_rank      | Integer   | Click Share Rank                                                                                                                    |
| click\_share            | Numeric   | Clicks that the product received in comparison to the total clicks based on the search results in the selected time frame           |
| conversion\_share       | Numeric   | Conversions that the product achieved in comparison to the total conversions based on the search results in the selected time frame |
| report\_start\_date     | Date      | Report Start Date                                                                                                                   |
| report\_end\_date       | Date      | Report End Date                                                                                                                     |

## Brand Analytics Search Query Performance Report

Table name: brandanalytics\_searchqueryperformance\_report

For Details on the description and console report, click [here](https://sellercentral.amazon.com/brand-analytics/metric-glossary)

Frequency*: Weekly*

**Availability**: Sellers with the Brand Analytics Selling Partner API role are registered in the [Amazon Brand Registry](https://brandservices.amazon.com/).

*Note:* This provides overall query performance, such as impressions, clicks, cart adds, and purchases, for a given ASIN and specified date range. 

**Data Source**

To enable Brand Analytics Search Query Performance Report, the datasource: **Amazon Search Analytics** has to be enabled on the Intentwise Platform

| Column Name                                     | Data type | Description                                              |
| ----------------------------------------------- | --------- | -------------------------------------------------------- |
| account\_id                                     | Integer   | Intentwise Account Id                                    |
| account\_name                                   | String    | Intentwise Account Name                                  |
| currency\_code                                  | String    | Currency Code                                            |
| id                                              | Integer   | ID                                                       |
| start\_date                                     | Date      | Report Start Date                                        |
| end\_date                                       | Date      | Report End Date                                          |
| asin                                            | String    | A list of Amazon Standard Identification Numbers (ASINs) |
| search\_query                                   | String    | Search Query                                             |
| search\_query\_score                            | Integer   | Score based on search query                              |
| search\_query\_volume                           | Integer   | Volume based on search query                             |
| total\_query\_impression\_count                 | Integer   | Total Query Impression Count                             |
| asin\_impression\_count                         | Integer   | Asin Impression Count                                    |
| asin\_impression\_share                         | Integer   | Asin Impression Share                                    |
| total\_click\_count                             | Integer   | Total Click Count                                        |
| total\_click\_rate                              | Integer   | Total Click Rate                                         |
| asin\_click\_count                              | Integer   | Asin Click Count                                         |
| asin\_click\_share                              | Integer   | Asin Click Share                                         |
| total\_median\_click\_price\_amount             | Integer   | Total Median Click Price Amount                          |
| total\_median\_click\_price\_currency\_code     | String    | Total Median Click Price Currency Code                   |
| asin\_median\_click\_price\_amount              | Integer   | Asin Median Click Price Amount                           |
| asin\_median\_click\_price\_currency\_code      | String    | Asin Median Click Price Currency Code                    |
| total\_same\_day\_shipping\_click\_count        | Integer   | Total Same Day Shipping Click Count                      |
| total\_one\_day\_shipping\_click\_count         | Integer   | Total One Day Shipping Click Count                       |
| total\_two\_day\_shipping\_click\_count         | Integer   | Total Two Day Shipping Click Count                       |
| total\_cart\_add\_count                         | Integer   | Total Cart Add Count                                     |
| total\_cart\_add\_rate                          | Integer   | Total Cart Add Rate                                      |
| asin\_cart\_add\_count                          | Integer   | Asin Cart Add Count                                      |
| asin\_cart\_add\_share                          | Integer   | Asin Cart Add Share                                      |
| total\_median\_cart\_add\_price\_amount         | Integer   | Total Median Cart Add Price Amount                       |
| total\_median\_cart\_add\_price\_currency\_code | String    | Total Median Cart Add Price Currency Code                |
| asin\_median\_cart\_add\_price\_amount          | Integer   | Asin Median Cart Add Price Amount                        |
| asin\_median\_cart\_add\_price\_currency\_code  | String    | Asin Median Cart Add Price Currency Code                 |
| total\_same\_day\_shipping\_cart\_add\_count    | Integer   | Total Same Day Shipping Cart Add Count                   |
| total\_one\_day\_shipping\_cart\_add\_count     | Integer   | Total One Day Shipping Cart Add Count                    |
| total\_two\_day\_shipping\_cart\_add\_count     | Integer   | Total Two Day Shipping Cart Add Count                    |
| total\_purchase\_count                          | Integer   | Total Purchase Count                                     |
| total\_purchase\_rate                           | Integer   | Total Purchase Rate                                      |
| asin\_purchase\_count                           | Integer   | Asin Purchase Count                                      |
| asin\_purchase\_share                           | Integer   | Asin Purchase Share                                      |
| total\_median\_purchase\_price\_amount          | Integer   | Total Median Purchase Price Amount                       |
| total\_median\_purchase\_price\_currency\_code  | String    | Total Median Purchase Price Currency Code                |
| asin\_median\_purchase\_price\_amount           | Integer   | Asin Median Purchase Price Amount                        |
| asin\_median\_purchase\_price\_currency\_code   | String    | Asin Median Purchase Price Currency Code                 |
| total\_same\_day\_shipping\_purchase\_count     | Integer   | Total Same Day Shipping Purchase Count                   |
| total\_one\_day\_shipping\_purchase\_count      | Integer   | Total One Day Shipping Purchase Count                    |
| total\_two\_day\_shipping\_purchase\_count      | Integer   | Total Two Day Shipping Purchase Count                    |
| seller\_id                                      | String    | Selling Partner ID                                       |
| download\_date                                  | Date      | Download Date                                            |

## Brand Analytics Search Catalog Performance Report

Table name: brandanalytics\_searchcatalogperformance\_report

For Details on the description and console report, click [here](https://developer-docs.amazon.com/sp-api/docs/report-type-values-analytics#search-catalog-performance-report)

Frequency*: Weekly*

**Availability**: Sellers with the Brand Analytics Selling Partner API role are registered in the [Amazon Brand Registry](https://brandservices.amazon.com/).

*Note:* Provides search engagement metrics such as impressions, clicks, cart adds, and purchases for a specified date range. 

| Column Name                                | Data Type | Description                                              |
| ------------------------------------------ | --------- | -------------------------------------------------------- |
| account\_id                                | Integer   | Intentwise account id                                    |
| account name                               | String    | Intentwise account name                                  |
| asin                                       | String    | A list of Amazon Standard Identification Numbers (ASINs) |
| cart\_add\_count                           | Integer   | Cart Add Count                                           |
| cart\_added\_median\_price\_amount         | Numeric   | Cart Added Median Price Amount                           |
| cart\_added\_median\_price\_currency\_code | String    | Cart Added Median Price Currency Code                    |
| click\_count                               | Integer   | Click Count                                              |
| click\_rate                                | Numeric   | Click Rate                                               |
| clicked\_median\_price\_amount             | Numeric   | Clicked Median Price Amount                              |
| clicked\_median\_price\_currency\_code     | String    | Clicked Median Price Currency Code                       |
| conversion\_rate                           | Numeric   | Conversion Rate                                          |
| download\_date                             | Date      | Download Date                                            |
| end\_date                                  | Date      | End Date                                                 |
| id                                         | Integer   | Id                                                       |
| impression\_count                          | Integer   | Impression Count                                         |
| impression\_median\_price\_amount          | Numeric   | Impression Median Price Amount                           |
| impression\_median\_price\_currency\_code  | String    | Impression Median Price Currency Code                    |
| one\_day\_shipping\_cart\_add\_count       | Integer   | One Day Shipping Cart Add Count                          |
| one\_day\_shipping\_click\_count           | Integer   | One Day Shipping Click Count                             |
| one\_day\_shipping\_impression\_count      | Integer   | One Day Shipping Impression Count                        |
| one\_day\_shipping\_purchase\_count        | Integer   | One Day Shipping Purchase Count                          |
| purchase\_count                            | Integer   | Purchase Count                                           |
| purchase\_median\_price\_amount            | Numeric   | Purchase Median Price Amount                             |
| purchase\_median\_price\_currency\_code    | String    | Purchase Median Price Currency Code                      |
| report\_period                             | String    | Report Period                                            |
| same\_day\_shipping\_cart\_add\_count      | Integer   | Same Day Shipping Cart Add Count                         |
| same\_day\_shipping\_click\_count          | Integer   | Same Day Shipping Click Count                            |
| same\_day\_shipping\_impression\_count     | Integer   | Same Day Shipping Impression Count                       |
| same\_day\_shipping\_purchase\_count       | Integer   | Same Day Shipping Purchase Count                         |
| search\_traffic\_sales\_amount             | Numeric   | Search Traffic Sales Amount                              |
| search\_traffic\_sales\_currency\_code     | String    | Search Traffic Sales Currency Code                       |
| seller\_id                                 | String    | Selling Partner ID                                       |
| start\_date                                | Date      | Start Date                                               |
| two\_day\_shipping\_cart\_add\_count       | Integer   | Two Day Shipping Cart Add Count                          |
| two\_day\_shipping\_click\_count           | Integer   | Two Day Shipping Click Count                             |
| two\_day\_shipping\_impression\_count      | Integer   | Two Day Shipping Impression Count                        |
| two\_day\_shipping\_purchase\_count        | Integer   | Two Day Shipping Purchase Count                          |

### Replenishment Reports

Replenishment Reports are available for both Seller and Vendor accounts

### Replenishment Offer

Table name: replenishment\_offer

Download Frequency: WEEKLY

Report Documentation: [Replenishment Report API](https://developer-docs.amazon.com/sp-api/docs/replenishment-api-v2022-11-07-model)

<table><thead><tr><th width="319">Column Name</th><th width="132">Data Type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise Account Id</td></tr><tr><td>account_name</td><td>String</td><td>Intentwise Account Name</td></tr><tr><td>marketplace_id</td><td>String</td><td>Marketplace ID</td></tr><tr><td>auto_enrollment</td><td>String</td><td>The auto-enrollment preference indicates whether the offer is opted-in to or opted-out of Amazon's auto-enrollment feature.</td></tr><tr><td>asin</td><td>String</td><td>A list of Amazon Standard Identification Numbers (ASINs)</td></tr><tr><td>sku</td><td>String</td><td>The SKU. This property is only supported for sellers and not for vendors.</td></tr><tr><td>selling_partner_funded_base_discount_percentage</td><td>numeric</td><td>A base discount set by the selling partner on the offer.</td></tr><tr><td>selling_partner_funded_tiered_discount_percentage</td><td>numeric</td><td>A tiered discount set by the selling partner on the offer.</td></tr><tr><td>amazon_funded_base_discount_percentage</td><td>numeric</td><td>A base discount set by Amazon on the offer.</td></tr><tr><td>amazon_funded_tiered_discount_percentage</td><td>numeric</td><td>A tiered discount set by Amazon on the offer.</td></tr><tr><td>enrollment_method</td><td>String</td><td>Determines whether the offer was automatically or manually enrolled in the program. This property is only supported for sellers and not vendors.</td></tr><tr><td>program_type</td><td>String</td><td>The replenishment program type Ex: <strong>SUBSCRIBE_AND_SAVE</strong></td></tr><tr><td>eligibility</td><td>String</td><td>The current eligibility status of an offer.</td></tr><tr><td>vendor_codes</td><td>String</td><td>A list of vendor codes associated with the offer</td></tr><tr><td>download_date</td><td>Date</td><td>Download date</td></tr><tr><td>fulfillment_network_id_type</td><td>String</td><td>The fulfillment network identifier type for the offer, indicating how the offer is fulfilled.</td></tr><tr><td>delivery_condition</td><td>String</td><td>A list of delivery conditions for the offer, indicating the health of upcoming deliveries.</td></tr><tr><td>delivery_condition_next_30_days_deliveries</td><td>String</td><td>The condition type of upcoming deliveries for the offer.</td></tr><tr><td>price</td><td>numeric</td><td>The current price of the offer. This is the listed price amount for the item.</td></tr><tr><td>price_currency_code</td><td>String</td><td>The currency code in ISO 4217 format for the price. For example, <code>USD</code> for US dollars.</td></tr><tr><td>inventory</td><td>Integer</td><td>The available inventory count for the offer.</td></tr><tr><td>next_15_days_forecast_deliveries</td><td>Integer</td><td>An object which contains the projected subscriber demand for the offer over different time horizons.</td></tr><tr><td>next_30_days_forecast_deliveries</td><td>Integer</td><td>An object which contains the projected subscriber demand for the offer over different time horizons.</td></tr><tr><td>next_60_days_forecast_deliveries</td><td>Integer</td><td>An object which contains the projected subscriber demand for the offer over different time horizons.</td></tr><tr><td>next_90_days_forecast_deliveries</td><td>Integer</td><td>An object which contains the projected subscriber demand for the offer over different time horizons.</td></tr></tbody></table>

### Replenishment Offer Metrics

Table name: replenishment\_offer\_metrics

Download Frequency: Weekly

Report Documentation: [Replenishment Report API](https://developer-docs.amazon.com/sp-api/docs/replenishment-api-v2022-11-07-model)

<table><thead><tr><th width="256">Column Name</th><th width="188.4000244140625">Data Type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise Account Id</td></tr><tr><td>account_name</td><td>String</td><td>Intentwise Account Name</td></tr><tr><td>marketplace_id</td><td>String</td><td>Marketplace ID</td></tr><tr><td>program_type</td><td>String</td><td>The replenishment program type Ex: <strong>SUBSCRIBE_AND_SAVE</strong></td></tr><tr><td>aggregation_frequency</td><td>String</td><td>Aggreation frequency - Week.</td></tr><tr><td>time_period_type</td><td>String</td><td>The time period type - PERFORMANCE</td></tr><tr><td>asin</td><td>String</td><td>A list of Amazon Standard Identification Numbers (ASINs)</td></tr><tr><td>sku</td><td>String</td><td>The SKU. This property is only supported for sellers and not for vendors.</td></tr><tr><td>not_delivered_due_to_oos</td><td>numeric</td><td>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 <code>PERFORMANCE</code> <code>timePeriodType</code>.<br><strong>Minimum value</strong> : <code>0</code><br><strong>Maximum value</strong> : <code>100</code></td></tr><tr><td>total_subscriptions_revenue</td><td>numeric</td><td>The revenue generated from subscriptions over a period of time. Applicable only for the <code>PERFORMANCE</code> <code>timePeriodType</code>.<br><strong>Minimum value</strong> : <code>0</code></td></tr><tr><td>shipped_subscription_units</td><td>numeric</td><td>The number of units shipped to the subscribers over a period of time. Applicable only for the <code>PERFORMANCE</code> <code>timePeriodType</code>.<br><strong>Minimum value</strong> : <code>0</code></td></tr><tr><td>active_subscriptions</td><td>numeric</td><td>The number of active subscriptions present at the end of the period. Applicable only for the <code>PERFORMANCE</code> <code>timePeriodType</code>.<br><strong>Minimum value</strong> : <code>0</code></td></tr><tr><td>revenue_penetration</td><td>numeric</td><td>The percentage of total program revenue out of total product revenue. Applicable only for the <code>PERFORMANCE</code> <code>timePeriodType</code>.<br><strong>Minimum value</strong> : <code>0</code><br><strong>Maximum value</strong> : <code>100</code></td></tr><tr><td>start_date</td><td>date</td><td>Start Date of the week</td></tr><tr><td>end_date</td><td>date</td><td>End Date of the week</td></tr><tr><td>download_date</td><td>date</td><td>Download Date</td></tr><tr><td>fulfillment_channel_type</td><td>String</td><td>The fulfillment channel type of an offer. Note that this is only valid for sellers and not for vendors.</td></tr><tr><td>lost_revenue_due_to_oos</td><td>Numeric</td><td>The revenue that would have been generated had there not been out of stock. Applicable to <code>PERFORMANCE</code> <code>timePeriodType</code>.</td></tr><tr><td>coupons_revenue_penetration</td><td>Numeric</td><td>The percentage of revenue from ASINs with coupons out of total revenue from all ASINs</td></tr><tr><td>share_of_coupon_subscriptions</td><td>Numeric</td><td>The percentage of new subscriptions acquired through coupons</td></tr></tbody></table>

### Replenishment Offer Metrics Monthly

Table name: replenishment\_offer\_metrics\_monthly

Download Frequency: Monthly

Report Documentation: [Replenishment Report API](https://developer-docs.amazon.com/sp-api/docs/replenishment-api-v2022-11-07-model)

<table><thead><tr><th width="256">Column Name</th><th width="188.4000244140625">Data Type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise Account Id</td></tr><tr><td>account_name</td><td>String</td><td>Intentwise Account Name</td></tr><tr><td>marketplace_id</td><td>String</td><td>Marketplace ID</td></tr><tr><td>program_type</td><td>String</td><td>The replenishment program type Ex: <strong>SUBSCRIBE_AND_SAVE</strong></td></tr><tr><td>aggregation_frequency</td><td>String</td><td>Aggreation frequency - Month.</td></tr><tr><td>time_period_type</td><td>String</td><td>The time period type - PERFORMANCE</td></tr><tr><td>asin</td><td>String</td><td>A list of Amazon Standard Identification Numbers (ASINs)</td></tr><tr><td>sku</td><td>String</td><td>The SKU. This property is only supported for sellers and not for vendors.</td></tr><tr><td>not_delivered_due_to_oos</td><td>numeric</td><td>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 <code>PERFORMANCE</code> <code>timePeriodType</code>.<br><strong>Minimum value</strong> : <code>0</code><br><strong>Maximum value</strong> : <code>100</code></td></tr><tr><td>total_subscriptions_revenue</td><td>numeric</td><td>The revenue generated from subscriptions over a period of time. Applicable only for the <code>PERFORMANCE</code> <code>timePeriodType</code>.<br><strong>Minimum value</strong> : <code>0</code></td></tr><tr><td>shipped_subscription_units</td><td>numeric</td><td>The number of units shipped to the subscribers over a period of time. Applicable only for the <code>PERFORMANCE</code> <code>timePeriodType</code>.<br><strong>Minimum value</strong> : <code>0</code></td></tr><tr><td>active_subscriptions</td><td>numeric</td><td>The number of active subscriptions present at the end of the period. Applicable only for the <code>PERFORMANCE</code> <code>timePeriodType</code>.<br><strong>Minimum value</strong> : <code>0</code></td></tr><tr><td>revenue_penetration</td><td>numeric</td><td>The percentage of total program revenue out of total product revenue. Applicable only for the <code>PERFORMANCE</code> <code>timePeriodType</code>.<br><strong>Minimum value</strong> : <code>0</code><br><strong>Maximum value</strong> : <code>100</code></td></tr><tr><td>start_date</td><td>date</td><td>Start Date of the week</td></tr><tr><td>end_date</td><td>date</td><td>End Date of the week</td></tr><tr><td>download_date</td><td>date</td><td>Download Date</td></tr><tr><td>fulfillment_channel_type</td><td>String</td><td>The fulfillment channel type of an offer. Note that this is only valid for sellers and not for vendors.</td></tr><tr><td>lost_revenue_due_to_oos</td><td>Numeric</td><td>The revenue that would have been generated had there not been out of stock. Applicable to <code>PERFORMANCE</code> <code>timePeriodType</code>.</td></tr><tr><td>coupons_revenue_penetration</td><td>Numeric</td><td>The percentage of revenue from ASINs with coupons out of total revenue from all ASINs</td></tr><tr><td>share_of_coupon_subscriptions</td><td>Numeric</td><td>The percentage of new subscriptions acquired through coupons</td></tr></tbody></table>

### Replenishment Offer Metrics Forecast

Table name: replenishment\_offer\_metrics\_forecast

Download Frequency: WEEKLY

Report Documentation: [Replenishment Report API](https://developer-docs.amazon.com/sp-api/docs/replenishment-api-v2022-11-07-model)

<table><thead><tr><th width="319">Column Name</th><th width="132">Data Type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise Account Id</td></tr><tr><td>account_name</td><td>String</td><td>Intentwise Account Name</td></tr><tr><td>currency_code</td><td>String</td><td>Currency Code</td></tr><tr><td>program_type</td><td>String</td><td>The replenishment program type Ex: <strong>SUBSCRIBE_AND_SAVE</strong></td></tr><tr><td>time_period_type</td><td>String</td><td>The time period type - FORECAST</td></tr><tr><td>fulfillment_channel_type</td><td>String</td><td>The fulfillment channel type of an offer. Note that this is only valid for sellers and not for vendors.</td></tr><tr><td>asin</td><td>String</td><td>A list of Amazon Standard Identification Numbers (ASINs)</td></tr><tr><td>sku</td><td>String</td><td>The SKU. This property is only supported for sellers and not for vendors.</td></tr><tr><td>next_30_day_total_subscriptions_revenue</td><td>numeric</td><td>The projected total revenue expected from active and renewing subscriptions over the next 30 days, based on current customer subscription patterns and pricing</td></tr><tr><td>next_60_day_total_subscriptions_revenue</td><td>numeric</td><td>The projected total revenue expected from active and renewing subscriptions over the next 60 days, based on current customer subscription patterns and pricing</td></tr><tr><td>next_90_day_total_subscriptions_revenue</td><td>numeric</td><td>The projected total revenue expected from active and renewing subscriptions over the next 90 days, based on current customer subscription patterns and pricing</td></tr><tr><td>next_30_day_shipped_subscription_units</td><td>numeric</td><td>The forecasted number of subscription-based product units expected to be shipped in the next 30 days</td></tr><tr><td>next_60_day_shipped_subscription_units</td><td>numeric</td><td>The forecasted number of subscription-based product units expected to be shipped in the next 60 days</td></tr><tr><td>next_90_day_shipped_subscription_units</td><td>numeric</td><td>The forecasted number of subscription-based product units expected to be shipped in the next 90 days</td></tr><tr><td>start_date</td><td>date</td><td>Start Date</td></tr><tr><td>end_date</td><td>date</td><td>End Date</td></tr><tr><td>download_date</td><td>date</td><td>Download date</td></tr></tbody></table>