# Content Product Listing

## Data Availability & Refresh Schedule

### Data Refresh Schedule

Data for the product listing table is updated daily between 7:30 AM PST to 10:30 AM PST daily.

## **Data Source**

To enable Content Product Listing Report, the datasource: **Content Analytics** has to be enabled on the Intentwise Platform

## Content Product Listing

Table name: *listing*

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

| Column Name            | Data type | Description                                                                                     |
| ---------------------- | --------- | ----------------------------------------------------------------------------------------------- |
| account\_name          | String    | Intentwise account name                                                                         |
| account\_id            | Integer   | Intentwise account id                                                                           |
| channel\_id            | Integer   | <p>E-commerce marketing channel. </p><ul><li>1001 -> AMAZON</li><li>1002 -> INSTACART</li></ul> |
| channel\_name          | String    | <p>E-commerce marketing channel. </p><ul><li>AMAZON</li><li>INSTACART</li></ul>                 |
| country\_code          | String    | Country code of the advertising account                                                         |
| currency\_code         | String    | Currency code of the account                                                                    |
| report\_date           | Date      | Report date                                                                                     |
| product                | String    | listed product                                                                                  |
| best\_seller\_rank     | Integer   | Best seller rank                                                                                |
| best\_seller\_category | String    | Best seller rank category                                                                       |
| title\_length          | Integer   | Length of the product title                                                                     |
| description\_length    | Integer   | Product description length                                                                      |
| feature\_bullet\_count | Integer   | Number of feature bullets                                                                       |
| aplus\_page            | String    | Indicates if the page content is a+                                                             |
| image\_count           | Integer   | Number of images                                                                                |
| average\_rating        | Numeric   | Average customer rating of the product                                                          |
| seller\_company        | String    | Seller company of the product                                                                   |
| description            | String    | Product description                                                                             |
| rating\_count          | Integer   | Total number of customer ratings of the products                                                |

## **Content Product Listing Sub-Category**

Table name: *listing\_subcategory*

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

| Column Name         | Data type | Description                                                                                     |
| ------------------- | --------- | ----------------------------------------------------------------------------------------------- |
| account\_name       | String    | Intentwise account name                                                                         |
| account\_id         | Integer   | Intentwise account id                                                                           |
| channel\_id         | Integer   | <p>E-commerce marketing channel. </p><ul><li>1001 -> AMAZON</li><li>1002 -> INSTACART</li></ul> |
| channel\_name       | String    | <p>E-commerce marketing channel. </p><ul><li>AMAZON</li><li>INSTACART</li></ul>                 |
| country\_code       | String    | Country code of the advertising account                                                         |
| report\_date        | Date      | Report date                                                                                     |
| product             | String    | listed product                                                                                  |
| sub\_category       | String    | Sub category                                                                                    |
| sub\_category\_rank | Integer   | Sub category rank                                                                               |