# Sponsored Display

## Sponsored Display Campaign

Table name: *ad\_sponsoreddisplay\_campaign*

*For details on data availability and refresh schedule, please click* [*here*](/iac-source-data/data-models/amazon-source-data/sponsored-ads.md#data-availability-and-refresh-schedule)*.*

| Column Name     | Data type | Description                                                                                                                                                                                                                                                     |
| --------------- | --------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| profile\_id     | Integer   | Amazon advertising account id                                                                                                                                                                                                                                   |
| account\_id     | Integer   | Intentwise account id                                                                                                                                                                                                                                           |
| account\_name   | String    | Intentwise account name                                                                                                                                                                                                                                         |
| campaignid      | Integer   | Campaign id                                                                                                                                                                                                                                                     |
| name            | String    | Campaign name                                                                                                                                                                                                                                                   |
| tactic          | String    |                                                                                                                                                                                                                                                                 |
| budgettype      | String    | <p>The time period over which the amount specified in the <code>budget</code> property is allocated<br></p>                                                                                                                                                     |
| budget          | Numeric   | Budget set for the campaign                                                                                                                                                                                                                                     |
| startdate       | Date      | Start date of the campaign                                                                                                                                                                                                                                      |
| enddate         | Date      | End date of the campaign                                                                                                                                                                                                                                        |
| state           | String    | Campaign state                                                                                                                                                                                                                                                  |
| portfolioid     | Integer   | Amazon advertising account id                                                                                                                                                                                                                                   |
| servingstatus   | String    | <p>The status of the campaign<br>ADVERTISER\_STATUS\_ENABLED, STATUS\_UNAVAILABLE, ADVERTISER\_PAUSED, ACCOUNT\_OUT\_OF\_BUDGET, ADVERTISER\_PAYMENT\_FAILURE, CAMPAIGN\_PAUSED, CAMPAIGN\_ARCHIVED, PENDING\_START\_DATE, ENDED, CAMPAIGN\_OUT\_OF\_BUDGET</p> |
| costtype        | String    | Determines how the campaign will bid and charge                                                                                                                                                                                                                 |
| creationdate    | Date Time | Campaign created date                                                                                                                                                                                                                                           |
| lastupdateddate | Date Time | Campaign last updated date                                                                                                                                                                                                                                      |

## Sponsored Display Campaign Report

Table name: *ad\_sponsoreddisplay\_campaign\_report*

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

| Column Name                     | Data type | Description                                                                                                                                                                            |
| ------------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| profile\_id                     | integer   | Amazon advertising account id                                                                                                                                                          |
| account\_id                     | integer   | Intentwise account id                                                                                                                                                                  |
| account\_name                   | string    | Intentwise account name                                                                                                                                                                |
| reportdate                      | date      | Report date                                                                                                                                                                            |
| campaignid                      | integer   | Campaign id                                                                                                                                                                            |
| campaignname                    | string    | campaign name                                                                                                                                                                          |
| campaignstatus                  | string    | Campaign status                                                                                                                                                                        |
| campaignbudget                  | numeric   | Campaign budget                                                                                                                                                                        |
| impressions                     | integer   | Total ad impressions                                                                                                                                                                   |
| clicks                          | integer   | Total ad clicks                                                                                                                                                                        |
| cost                            | numeric   | Total cost of all clicks. Can be divided by clicks to obtain average CPC.                                                                                                              |
| attributedsales14dsamesku       | numeric   | Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised                                                 |
| attributedsales14d              | numeric   | Number of attributed sales occurring within 14 days of click on ad                                                                                                                     |
| attributedconversions14dsamesku | integer   | Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised                                              |
| attributedconversions14d        | integer   | Number of attributed conversion events occurring within 14 days of click on ad                                                                                                         |
| attributedunitsordered14d       | integer   | Number of attributed units ordered within 14 days of click on ad                                                                                                                       |
| viewimpressions                 | integer   | Total number of ad viewable impressions                                                                                                                                                |
| viewattributedconversions14d    | integer   | Total number of attributed conversion events occurring within 14 days of ad click or view                                                                                              |
| viewattributedsales14d          | numeric   | Total number of attributed sales occurring within 14 days of ad click or view                                                                                                          |
| viewattributedunitsordered14d   | integer   | Total number of attributed units ordered occurring within 14 days of ad click or view                                                                                                  |
| newtobranddetailpageviewclicks  | Integer   | Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.                                                                                      |
| newtobranddetailpageviewrate    | Numeric   | Calculated by dividing newToBrandDetailPageViews / impressions.                                                                                                                        |
| newtobranddetailpageviews       | Integer   | The number of new detail page views from shoppers who have not previously viewed a detail page with an ASIN of the same brand in past 365 days and who either clicked or viewed an ad. |
| newtobranddetailpageviewviews   | Integer   | Number of new-to-brand detail page views for all the brands' products, attributed to an ad view                                                                                        |
| newtobrandecpdetailpageview     | Numeric   | Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view.                                                                         |

## Sponsored Display AdGroup

Table name: *ad\_sponsoreddisplay\_adgroup*

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

| Column Name     | Data type      | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| --------------- | -------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| profile\_id     | integer        | Amazon advertising account id                                                                                                                                                                                                                                                                                                                                                                                                                              |
| account\_id     | integer        | Intentwise account id                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| account\_name   | string         | Intentwise account name                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| adgroupid       | integer        | Adgroup id                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| name            | string         | Adgroup name                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| campaignid      | integer        | Campaign id                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| defaultbid      | numeric        | Default bid set for the adgroup                                                                                                                                                                                                                                                                                                                                                                                                                            |
| state           | string         | Adgroup state                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| creationdate    | timestamptz(0) | Adgroup created date                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| lastupdateddate | timestamptz(0) | Adgroup last updated date                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| servingstatus   | string         | <p>The status of the ad group<br>ADVERTISER\_STATUS\_ENABLED, STATUS\_UNAVAILABLE, ADVERTISER\_PAUSED, ACCOUNT\_OUT\_OF\_BUDGET, ADVERTISER\_PAYMENT\_FAILURE, CAMPAIGN\_PAUSED, CAMPAIGN\_ARCHIVED, PENDING\_START\_DATE, ENDED, CAMPAIGN\_OUT\_OF\_BUDGET, AD\_GROUP\_STATUS\_ENABLED, AD\_GROUP\_PAUSED, AD\_GROUP\_ARCHIVED, AD\_GROUP\_INCOMPLETE, AD\_GROUP\_LOW\_BID, ADGROUP\_POLICING\_PENDING\_REVIEW, ADGROUP\_POLICING\_CREATIVE\_REJECTED</p> |

## Sponsored Display AdGroup Report

Table name: *ad\_sponsoreddisplay\_adgroup\_report*

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

| Column Name                     | Data type | Description                                                                                                                               |
| ------------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| profile\_id                     | integer   | Amazon advertising account id                                                                                                             |
| account\_id                     | integer   | Intentwise account id                                                                                                                     |
| account\_name                   | string    | Intentwise account name                                                                                                                   |
| reportdate                      | date      | Report date                                                                                                                               |
| adgroupid                       | integer   | Adgroup id                                                                                                                                |
| adgroupname                     | string    | Adgroup name                                                                                                                              |
| campaignid                      | integer   | Campaign id                                                                                                                               |
| campaignname                    | string    | Campaign name                                                                                                                             |
| impressions                     | integer   | Total ad impressions                                                                                                                      |
| clicks                          | integer   | Total ad clicks                                                                                                                           |
| cost                            | numeric   | Total cost of all clicks. Can be divided by clicks to obtain average CPC                                                                  |
| attributedsales14dsamesku       | numeric   | Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised    |
| attributedsales14d              | numeric   | Number of attributed sales occurring within 14 days of click on ad                                                                        |
| attributedconversions14dsamesku | integer   | Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised |
| attributedconversions14d        | integer   | Number of attributed conversion events occurring within 14 days of click on ad                                                            |
| attributedunitsordered14d       | integer   | Number of attributed units ordered within 14 days of click on ad                                                                          |
| viewimpressions                 | integer   | Total number of ad viewable impressions                                                                                                   |
| viewattributedconversions14d    | integer   | Total number of attributed conversion events occurring within 14 days of ad click or view                                                 |
| viewattributedsales14d          | numeric   | Total number of attributed sales occurring within 14 days of ad click or view                                                             |
| viewattributedunitsordered14d   | integer   | Total number of attributed units ordered occurring within 14 days of ad click or view                                                     |

## Sponsored Display Advertised Product

Table name: *ad\_sponsoreddisplay\_productad*\
\
*This metadata is* synced multiple times a day, resulting in accurate data as of most recent date.\
\
*Note - lastupdatedate* indicates the timestamp of the most recent update made to the ProductAd on Amazon

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

| Column Name     | Data type      | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| --------------- | -------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| profile\_id     | integer        | Amazon advertising account id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| account\_id     | integer        | Intentwise account id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| account\_name   | string         | Intentwise account name                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| adid            | integer        | Ad ID                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| adgroupid       | integer        | Adgroup id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| campaignid      | integer        | Campaign id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| asin            | string         | The ASIN that is being advertised.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| sku             | string         | The SKU that is being advertised. Not available for vendors.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| state           | string         | The ASIN that is being advertised.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| creationdate    | timestamptz(0) | Creation Date                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| lastupdateddate | timestamptz(0) | ASIN last updated date                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| servingstatus   | string         | <p>The status of the product ad.<br>ADVERTISER\_STATUS\_ENABLED, STATUS\_UNAVAILABLE, ADVERTISER\_PAUSED, ACCOUNT\_OUT\_OF\_BUDGET, ADVERTISER\_PAYMENT\_FAILURE, CAMPAIGN\_PAUSED, CAMPAIGN\_ARCHIVED, PENDING\_START\_DATE, ENDED, CAMPAIGN\_OUT\_OF\_BUDGET, AD\_GROUP\_STATUS\_ENABLED, AD\_GROUP\_PAUSED, AD\_GROUP\_ARCHIVED, AD\_GROUP\_INCOMPLETE, AD\_GROUP\_LOW\_BID, AD\_STATUS\_LIVE, AD\_STATUS\_PAUSED, AD\_STATUS\_ARCHIVED, MISSING\_IMAGE, MISSING\_DECORATION, NOT\_BUYABLE, NOT\_IN\_BUYBOX, OUT\_OF\_STOCK, NOT\_IN\_POLICY</p> |

## Sponsored Display Advertised Product Report

Table name: *ad\_sponsoreddisplay\_productad\_report*

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

| Column Name                         | Data type | Description                                                                                                                                                                            |
| ----------------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| profile\_id                         | Integer   | Amazon advertising account id                                                                                                                                                          |
| account\_id                         | Integer   | Intentwise account id                                                                                                                                                                  |
| account\_name                       | String    | Intentwise account name                                                                                                                                                                |
| reportdate                          | Date      | Report date                                                                                                                                                                            |
| adid                                | Integer   | Ad ID                                                                                                                                                                                  |
| adgroupid                           | Integer   | Adgroup id                                                                                                                                                                             |
| impressions                         | Integer   | Total ad impressions                                                                                                                                                                   |
| clicks                              | Integer   | Total ad clicks                                                                                                                                                                        |
| cost                                | Numeric   | Total cost of all clicks. Can be divided by clicks to obtain average CPC                                                                                                               |
| attributedsales14dsamesku           | Numeric   | Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised                                                 |
| attributedsales14d                  | Numeric   | Number of attributed sales occurring within 14 days of click on ad                                                                                                                     |
| attributedconversions14dsamesku     | Integer   | Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertise                                               |
| attributedconversions14d            | Integer   | Number of attributed conversion events occurring within 14 days of click on ad                                                                                                         |
| attributedunitsordered14d           | Integer   | Number of attributed units ordered within 14 days of click on ad                                                                                                                       |
| viewimpressions                     | Integer   | Total number of ad viewable impressions                                                                                                                                                |
| viewattributedconversions14d        | Integer   | Total number of attributed conversion events occurring within 14 days of ad click or view                                                                                              |
| viewattributedsales14d              | Numeric   | Total number of attributed sales occurring within 14 days of ad click or view                                                                                                          |
| viewattributedunitsordered14d       | Integer   | Total number of attributed units ordered occurring within 14 days of ad click or view                                                                                                  |
| newtobranddetailpageviewclicks      | Integer   | Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.                                                                                      |
| newtobranddetailpageviewrate        | Numeric   | Calculated by dividing newToBrandDetailPageViews / impressions.                                                                                                                        |
| newtobranddetailpageviews           | Integer   | The number of new detail page views from shoppers who have not previously viewed a detail page with an ASIN of the same brand in past 365 days and who either clicked or viewed an ad. |
| newtobranddetailpageviewviews       | Integer   | Number of new-to-brand detail page views for all the brands' products, attributed to an ad view                                                                                        |
| newtobrandecpdetailpageview         | Numeric   | Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view.                                                                         |
| attributedordersnewtobrand14d       | Integer   | The number of first-time orders for products within the brand over a one-year lookback window. Not available for search term report                                                    |
| attributedsalesnewtobrand14d        | Numeric   | The total sales of new-to-brand orders. Not available for search term report                                                                                                           |
| attributedunitsorderednewtobrand14d | Integer   | Total number of attributed units ordered as part of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors.                                        |

## Sponsored Display Target

Table name: *ad\_sponsoreddisplay\_target*

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

| Column Name                 | Data type      | Description                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| --------------------------- | -------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| profile\_id                 | integer        | Amazon advertising account id                                                                                                                                                                                                                                                                                                                                                                                                                          |
| account\_id                 | integer        | Intentwise account id                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| account\_name               | string         | Intentwise account name                                                                                                                                                                                                                                                                                                                                                                                                                                |
| targetid                    | integer        | Target id                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| adgroupid                   | integer        | Adgroup id                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| campaignid                  | integer        | campaign id                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| expressiontype              | string         |                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| state                       | string         | Target state                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| bid                         | numeric        |                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| creationdate                | timestamptz(0) | target created date                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| lastupdateddate             | timestamptz(0) | target  last updated date                                                                                                                                                                                                                                                                                                                                                                                                                              |
| autoexpressionvalue         | string         |                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| asinpricelessthan           | numeric        | Target a price that is less than the price expressed                                                                                                                                                                                                                                                                                                                                                                                                   |
| asinpricegreaterthan        | numeric        | Target a price that is greater than the price expressed                                                                                                                                                                                                                                                                                                                                                                                                |
| asinreviewratinglessthan    | numeric        | Target a review rating less than the review rating that is expressed                                                                                                                                                                                                                                                                                                                                                                                   |
| asinreviewratinggreaterthan | numeric        | Target a review rating that is greater than the review rating expressed                                                                                                                                                                                                                                                                                                                                                                                |
| asincategorysameas          | string         | Negatively Target the same category as the category expressed                                                                                                                                                                                                                                                                                                                                                                                          |
| asinbrandsameas             | string         | Target the brand that is the same as the brand expressed                                                                                                                                                                                                                                                                                                                                                                                               |
| asinpricebetween            | string         | Target a price that is between the prices expressed                                                                                                                                                                                                                                                                                                                                                                                                    |
| asinreviewratingbetween     | string         | Target a review rating that is between the review ratings expressed                                                                                                                                                                                                                                                                                                                                                                                    |
| asinsameas                  | string         | Target an ASIN that is the same as the ASIN expressed                                                                                                                                                                                                                                                                                                                                                                                                  |
| asinisprimeshippingeligible | string         | Target products that are Prime Shipping Eligible. This refinement can be applied at a category or brand level only                                                                                                                                                                                                                                                                                                                                     |
| asinagerangesameas          | string         | Target an age range that is in the expressed range. This refinement can be applied for toys and games categories only                                                                                                                                                                                                                                                                                                                                  |
| asingenresameas             | string         | Target products related to the expressed genre. This refinement can be applied for Books and eBooks categories only                                                                                                                                                                                                                                                                                                                                    |
| servingstatus               | string         | <p>The status of the target.<br>ADVERTISER\_STATUS\_ENABLED, STATUS\_UNAVAILABLE, ADVERTISER\_PAUSED, ACCOUNT\_OUT\_OF\_BUDGET, ADVERTISER\_PAYMENT\_FAILURE, CAMPAIGN\_PAUSED, CAMPAIGN\_ARCHIVED, PENDING\_START\_DATE, ENDED, CAMPAIGN\_OUT\_OF\_BUDGET, AD\_GROUP\_STATUS\_ENABLED, AD\_GROUP\_PAUSED, AD\_GROUP\_ARCHIVED, AD\_GROUP\_INCOMPLETE, AD\_GROUP\_LOW\_BID, TARGET\_STATUS\_LIVE, TARGET\_STATUS\_PAUSED, TARGET\_STATUS\_ARCHIVED</p> |
| lookback                    | integer        |                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| views                       | string         |                                                                                                                                                                                                                                                                                                                                                                                                                                                        |

## Sponsored Display Target Report

Table name: *ad\_sponsoreddisplay\_target\_report*

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

| Column Name                         | Data type | Description                                                                                                                               |
| ----------------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| profile\_id                         | integer   | Amazon advertising account id                                                                                                             |
| account\_id                         | integer   | Intentwise account id                                                                                                                     |
| account\_name                       | string    | Intentwise account name                                                                                                                   |
| reportdate                          | date      | Report date                                                                                                                               |
| report\_date                        | date      |                                                                                                                                           |
| targetid                            | integer   | Target id                                                                                                                                 |
| impressions                         | integer   | Total ad impressions                                                                                                                      |
| clicks                              | integer   | Total ad clicks                                                                                                                           |
| cost                                | numeric   | Total cost of all clicks. Can be divided by clicks to obtain average CPC                                                                  |
| attributedsales14dsamesku           | numeric   | Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised    |
| attributedsales14d                  | numeric   | Number of attributed sales occurring within 14 days of click on ad                                                                        |
| attributedconversions14dsamesku     | integer   | Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised |
| attributedconversions14d            | integer   | Number of attributed conversion events occurring within 14 days of click on ad                                                            |
| attributedunitsordered14d           | integer   | Number of attributed units ordered within 14 days of click on ad                                                                          |
| viewimpressions                     | integer   | Total number of ad viewable impressions                                                                                                   |
| viewattributedconversions14d        | integer   | Total number of attributed conversion events occurring within 14 days of ad click or view                                                 |
| viewattributedsales14d              | numeric   | Total number of attributed sales occurring within 14 days of ad click or view                                                             |
| viewattributedunitsordered14d       | integer   | Total number of attributed units ordered occurring within 14 days of ad click or view                                                     |
| attributedsalesnewtobrand14d        | Numeric   |                                                                                                                                           |
| attributedordersnewtobrand14d       | Integer   |                                                                                                                                           |
| attributedunitsorderednewtobrand14d | Integer   |                                                                                                                                           |
| newtobranddetailpageviews           | Integer   |                                                                                                                                           |
| newtobranddetailpageviewclicks      | Integer   |                                                                                                                                           |
| newtobranddetailpageviewrate        | Numeric   |                                                                                                                                           |
| newtobrandecpdetailpageview         | Numeric   |                                                                                                                                           |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/sponsored-ads/sponsored-display.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.