# Sponsored Brands

## Campaign

Table name: *ad\_sponsoredbrand\_campaign*

*For details on data availability and refresh schedule, please click* [*here*](https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/sponsored-ads/..#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   | The identifier of the campaign                                                        |
| name          | String    | The name of the campaign                                                              |
| budget        | Numeric   | Budget set for the campaign                                                           |
| startdate     | Date      | The starting date of the campaign. The format of the date is YYYY-MM-DD               |
| enddate       | Date      | The ending date of the campaign to stop running. The format of the date is YYYY-MM-DD |
| state         | String    | The current Campaign state                                                            |
| portfolioid   | Integer   | The identifier of an existing portfolio to which the campaign is associated           |

## Sponsored Brand Campaign Report

Table name: *ad\_sponsoredbrand\_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                                                                                                 |
| 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                              |
| attributedordersnewtobrandpercentage14d       | numeric   | The percentage of total sales of new-to-brand purchases. Not available for search term report                                                                    |
| attributedorderratenewtobrand14d              | numeric   | The number of new-to-brand orders relative to the number of clicks. New-to-brand order rate = new-to-brand orders / clicks. Not available for search term report |
| attributedsalesnewtobrandpercentage14d        | numeric   | The percentage of total sales of new-to-brand purchases. Not available for search term report                                                                    |
| attributedunitsorderednewtobrand14d           | integer   | The number of units from first-time orders for products within the brand over a one-year lookback window. Not available for search term report                   |
| attributedunitsorderednewtobrandpercentage14d | numeric   | The percentage of total units that are units from new-to-brand orders. Not available for search term report                                                      |
| attributedsalesnewtobrand14d                  | numeric   | The total sales of new-to-brand orders. Not available for search term report                                                                                     |
| viewableimpressions                           | integer   | Views is the number of impressions that met the MRC viewability standard (50% viewable with 2 seconds playback completed)                                        |
| videofirstquartileviews                       | integer   | The number of impressions where the video was viewed to 25%                                                                                                      |
| videomidpointviews                            | integer   | The number of impressions where the video was viewed to 50%                                                                                                      |
| videothirdquartileviews                       | integer   | The number of impressions where the video was viewed to 75%                                                                                                      |
| videocompleteviews                            | integer   | The number of impressions where the video was viewed to 100%                                                                                                     |
| video5secondviews                             | integer   | The number of impressions where the shopper watched the complete video or 5 seconds (whichever is shorter)                                                       |
| video5secondviewrate                          | numeric   | The percentage of impressions where the shopper watched the complete video or 5 seconds (whichever is shorter)                                                   |
| videounmutes                                  | integer   | The number of impressions where a shopper unmuted the video                                                                                                      |
| vtr                                           | numeric   | View-through-rate (views/impressions)                                                                                                                            |
| vctr                                          | numeric   | Clicks-through-rate for views (clicks/views)                                                                                                                     |
| unitssold14d                                  | integer   | Number of attributed units sold occurring within 14 days of click on an ad. Not available for search term report. Vendor only field                              |
| dpv14d                                        | integer   | Number of attributed detail page views occurring within 14 days of click on an ad. Not available for search term report. Vendor only field                       |

## Sponsored Brand Keyword

Table name: *ad\_sponsoredbrand\_keyword*

*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                                    |
| keywordid     | integer   | Keyword id                                                 |
| adgroupid     | integer   | Adgroup id                                                 |
| campaignid    | integer   | Campaign id                                                |
| state         | string    | Keyword status                                             |
| keywordtext   | string    | The text of the expression to match against a search query |
| matchtype     | string    | The type of match. ex: exact, phrase and broad             |
| bid           | numeric   |                                                            |

## Sponsored Brand Keyword Report

Table name: *ad\_sponsoredbrand\_keyword\_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                                                                                                                                                                                                                                       |
| keywordid                       | Integer   | The identifier of the advertised keyword text                                                                                                                                                                                                     |
| adgroupid                       | Integer   | The identifier of the adgroup                                                                                                                                                                                                                     |
| 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 a                                                                                                                                                                     |
| attributedunitsordered14d       | Integer   | Number of attributed units ordered within 14 days of click on ad                                                                                                                                                                                  |
| viewableimpressions             | Integer   | Views is the number of impressions that met the MRC viewability standard (50% viewable with 2 seconds playback completed)                                                                                                                         |
| videofirstquartileviews         | Integer   | The number of impressions where the video was viewed to 25%                                                                                                                                                                                       |
| videomidpointviews              | Integer   | The number of impressions where the video was viewed to 50%                                                                                                                                                                                       |
| videothirdquartileviews         | Integer   | The number of impressions where the video was viewed to 75%                                                                                                                                                                                       |
| videocompleteviews              | Integer   | The number of impressions where the video was viewed to 100%                                                                                                                                                                                      |
| video5secondviews               | Integer   | The number of impressions where the shopper watched the complete video or 5 seconds (whichever is shorter)                                                                                                                                        |
| video5secondviewrate            | Numeric   | The percentage of impressions where the shopper watched the complete video or 5 seconds (whichever is shorter)                                                                                                                                    |
| videounmutes                    | Integer   | The number of impressions where a shopper unmuted the video                                                                                                                                                                                       |
| vtr                             | Numeric   | View-through-rate (views/impressions)                                                                                                                                                                                                             |
| vctr                            | Numeric   | Clicks-through-rate for views (clicks/views)                                                                                                                                                                                                      |
| unitssold14d                    | Integer   | Number of attributed units sold occurring within 14 days of click on an ad. Not available for search term report. Vendor only field                                                                                                               |
| dpv14d                          | Integer   | Number of attributed detail page views occurring within 14 days of click on an ad. Not available for search term report. Vendor only field                                                                                                        |
| topofsearchimpressionshare      | Numeric   | The percentage of top-of-search impressions earned out of all the top-of-search impressions that were eligible for a given date range. Various factors determine the eligibility for an impression including campaign status and targeting status |

## Sponsored **Brand** Negative Keyword

Table name: *ad\_sponsoredbrand\_negativekeyword*

*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                                    |
| keywordid       | integer        | Keyword id                                                 |
| campaignid      | integer        | Campaign id                                                |
| adgroupid       | integer        | Adgroup id                                                 |
| state           | string         | Negative keyword status                                    |
| keywordtext     | string         | The text of the expression to match against a search query |
| matchtype       | string         | The type of match. ex: negativeExact, negativePhrase       |
| creationdate    | timestamptz(0) | Negative keyword created date                              |
| lastupdateddate | timestamptz(0) | Negative keyword last updated date                         |
| servingstatus   | string         |                                                            |

## Product Target

Table name: *ad\_sponsoredbrand\_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         | Product target state                                                    |
| bid                         | numeric        |                                                                         |
| creationdate                | timestamptz(0) | Product target created date                                             |
| lastupdateddate             | timestamptz(0) | Product 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 price that is between the prices expressed                     |
| asinsameas                  | string         | Target an ASIN that is the same as the ASIN expressed                   |

## Sponsored Brand Target Report

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

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

<table><thead><tr><th>Column Name</th><th width="257.3211253386057">Data type</th><th>Description</th></tr></thead><tbody><tr><td>profile_id</td><td>integer</td><td>Amazon advertising account id</td></tr><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>reportdate</td><td>date</td><td>Report date</td></tr><tr><td>report_date</td><td>date</td><td></td></tr><tr><td>targetid</td><td>integer</td><td>Target id</td></tr><tr><td>impressions</td><td>integer</td><td>Total ad impressions</td></tr><tr><td>clicks</td><td>integer</td><td>Total ad clicks</td></tr><tr><td>cost</td><td>numeric</td><td>Total cost of all clicks. Can be divided by clicks to obtain average CPC</td></tr><tr><td>attributedsales14dsamesku</td><td>numeric</td><td>Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised</td></tr><tr><td>attributedsales14d</td><td>numeric</td><td>Number of attributed sales occurring within 14 days of click on ad</td></tr><tr><td>attributedconversions14dsamesku</td><td>integer</td><td>Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised</td></tr><tr><td>attributedconversions14d</td><td>integer</td><td>Number of attributed conversion events occurring within 14 days of click on ad</td></tr><tr><td>attributedunitsordered14d</td><td>integer</td><td>Number of attributed units ordered within 14 days of click on ad</td></tr><tr><td>is_video</td><td>boolean</td><td></td></tr><tr><td>viewableimpressions</td><td>integer</td><td>Views is the number of impressions that met the MRC viewability standard (50% viewable with 2 seconds playback completed)</td></tr><tr><td>videofirstquartileviews</td><td>integer</td><td>The number of impressions where the video was viewed to 25%</td></tr><tr><td>videomidpointviews</td><td>integer</td><td>The number of impressions where the video was viewed to 50%</td></tr><tr><td>videothirdquartileviews</td><td>integer</td><td>The number of impressions where the video was viewed to 75%</td></tr><tr><td>videocompleteviews</td><td>integer</td><td>The number of impressions where the video was viewed to 100%</td></tr><tr><td>video5secondviews</td><td>integer</td><td>The number of impressions where the shopper watched the complete video or 5 seconds (whichever is shorter)</td></tr><tr><td>video5secondviewrate</td><td>numeric</td><td>The percentage of impressions where the shopper watched the complete video or 5 seconds (whichever is shorter)</td></tr><tr><td>videounmutes</td><td>integer</td><td>The number of impressions where a shopper unmuted the video</td></tr><tr><td>vtr</td><td>numeric</td><td>View-through-rate (views/impressions)</td></tr><tr><td>vctr</td><td>numeric</td><td>Clicks-through-rate for views (clicks/views)</td></tr><tr><td>unitssold14d</td><td>integer</td><td>Number of attributed units sold occurring within 14 days of click on an ad. Not available for search term report. Vendor only field</td></tr><tr><td>dpv14d</td><td>integer</td><td>Number of attributed detail page views occurring within 14 days of click on an ad. Not available for search term report. Vendor only field</td></tr></tbody></table>

## Sponsored Brand Keyword Search Term Report

Table Name: ad\_sponsoredbrand\_keywordsearchterm\_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                   | varchar(1020)  | Intentwise account name                                                                                                                   |
| keywordid                       | int8           | The identifier of the advertised keyword text                                                                                             |
| keywordtext                     | varchar(256)   | The text of the expression to match against a search query                                                                                |
| matchtype                       | varchar(256)   | The type of match. ex: exact, phrase and broad                                                                                            |
| campaignid                      | int8           | The identifier of the campaign                                                                                                            |
| adgroupid                       | int8           | The identifier of the adgroup                                                                                                             |
| reportdate                      | date           | Report date                                                                                                                               |
| query                           | varchar(500)   | Query                                                                                                                                     |
| impressions                     | int8           | Total ad impressions                                                                                                                      |
| clicks                          | int4           | Total ad clicks                                                                                                                           |
| cost                            | numeric(12, 2) | Total cost of all clicks. Can be divided by clicks to obtain average CPC                                                                  |
| attributedsales14dsamesku       | numeric(12, 2) | 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(12, 2) | Number of attributed sales occurring within 14 days of click on ad                                                                        |
| attributedconversions14dsamesku | int4           | 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        | int4           | Number of attributed conversion events occurring within 14 days of click on ad                                                            |
| attributedunitsordered14d       | int4           | Number of attributed units ordered within 14 days of click on ad                                                                          |
| searchtermimpressionrank        | int4           | The numeric rank of your account-wide impression                                                                                          |
| searchtermimpressionshare       | numeric(12, 2) | Account-wide share (in %) of the total impressions across all advertisers                                                                 |
| impressionswithshare            | int8           | Improssion with share                                                                                                                     |
| totalimpressions                | int8           | Total Impression                                                                                                                          |

## Sponsored Brand Product Target Search Term Report

Table Name: ad\_sponsoredbrand\_producttargetsearchterm\_report

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

| Column Name                     | Data type      | Description                                                                                                                               |
| ------------------------------- | -------------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| profile\_id                     | int8           | Amazon advertising account id                                                                                                             |
| account\_id                     | int8           | Intentwise account id                                                                                                                     |
| account\_name                   | varchar(1020)  | Intentwise account name                                                                                                                   |
| targetid                        | int8           | Target id                                                                                                                                 |
| campaignid                      | int8           | The identifier of the campaign                                                                                                            |
| adgroupid                       | int8           | The identifier of the adgroup                                                                                                             |
| reportdate                      | date           | Report date                                                                                                                               |
| query                           | varchar(500)   | Query                                                                                                                                     |
| impressions                     | int8           | Total ad impressions                                                                                                                      |
| clicks                          | int4           | Total ad clicks                                                                                                                           |
| cost                            | numeric(12, 2) | Total cost of all clicks. Can be divided by clicks to obtain average CPC                                                                  |
| attributedsales14dsamesku       | numeric(12, 2) | 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(12, 2) | Number of attributed sales occurring within 14 days of click on ad                                                                        |
| attributedconversions14dsamesku | int4           | 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        | int4           | Number of attributed conversion events occurring within 14 days of click on ad                                                            |
| attributedunitsordered14d       | int4           | Number of attributed units ordered within 14 days of click on ad                                                                          |
| searchtermimpressionrank        | int4           | The numeric rank of your account-wide impression                                                                                          |
| searchtermimpressionshare       | numeric(12, 2) | Account-wide share (in %) of the total impressions across all advertisers                                                                 |
| impressionswithshare            | int8           | Improssion with share                                                                                                                     |
| totalimpressions                | int8           | Total Impression                                                                                                                          |

## Sponsored Brand Ads

Table Name: ad\_sponsoredbrand\_ad

Each adId can have multiple asins. This table should be joined with ad\_sponsoredbrand\_ad\_asin based on profileId and adId.

*This metadata is* synced multiple times a day, resulting in accurate data as of the 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   | Advertised product identifier                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| adgroupid             | Integer   | The identifier of the adgroup                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| campaignid            | Integer   | The identifier of the campaign                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| state                 | String    | The current resource state.                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| creationdate          | Timestamp | Creation date in epoch time.                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| lastupdateddate       | Timestamp | ASIN last updated date                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| servingstatus         | String    | The ad serving status determined by system.                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| brandname             | String    | The Brand to which product belongs                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| headline              | String    | The headline text                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| type                  | String    | <p>The creative type of SB ad. Possible Values:<br>PRODUCT\_COLLECTION, STORE\_SPOTLIGHT, VIDEO, BRAND\_VIDEO</p>                                                                                                                                                                                                                                                                                                                                                                               |
| landingpagepagetype   | String    | The type of landing page, such as store page, product list (simple landing page), custom url.                                                                                                                                                                                                                                                                                                                                                                                                   |
| landingpageurl        | String    | URL of an existing simple landing page or Store page. Vendors may also specify the URL of a custom landing page. If a custom URL is specified, the landing page must include the ASINs of at least three products that are advertised as part of the campaign. Do not include this property in the request if the asins property is also included, these properties are mutually exclusive. Note that brandVideo ads only support Store page as landing page and does not allow asins property. |
| name                  | String    | The name of the ad. Note: Ads created using version 3/non-multi ad group campaigns do not have an associated name                                                                                                                                                                                                                                                                                                                                                                               |
| systemlastupdateddate | Timestamp | System last updated date                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |

## Sponsored Brand Ad Asin

Table Name: ad\_sponsoredbrand\_ad\_asin

*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   | Advertised product identifier      |
| asin          | String    | The ASIN that is being advertised. |
| creationdate  | Timestamp | Creation date in epoch time.       |

## Sponsored Brand Ad Report

Table Name: ad\_sponsoredbrand\_ad\_report

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

<table><thead><tr><th width="87">Column Name</th><th width="87">Data type</th><th width="87">Description</th></tr></thead><tbody><tr><td>profile_id</td><td>Integer</td><td>The identifier of the amazon advertising account</td></tr><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>reportdate</td><td>Date</td><td>Report date</td></tr><tr><td>adid</td><td>Integer</td><td>The identifier of the advertised product</td></tr><tr><td>adgroupid</td><td>Integer</td><td>The identifier of the adgroup</td></tr><tr><td>campaignid</td><td>Integer</td><td>Campaign id </td></tr><tr><td>impressions</td><td>Integer</td><td>Total ad impressions</td></tr><tr><td>clicks</td><td>Integer</td><td>Total ad clicks</td></tr><tr><td>cost</td><td>Numeric</td><td>Total cost of all clicks. Can be divided by clicks to obtain average CPC</td></tr><tr><td>attributedsales14dsamesku</td><td>Numeric</td><td>Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised</td></tr><tr><td>attributedsales14d</td><td>Numeric</td><td>Number of attributed sales occurring within 14 days of click on ad</td></tr><tr><td>attributedconversions14dsamesku</td><td>Integer</td><td>Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised</td></tr><tr><td>attributedconversions14d</td><td>Integer</td><td>Number of attributed conversion events occurring within 14 days of click on ad</td></tr><tr><td>attributeddetailpageviewsclicks14d</td><td>Integer</td><td>The number of attributed detail page view conversions occurring within 14 days of ad click.</td></tr><tr><td>attributedordersnewtobrand14d</td><td>Integer</td><td>The number of first-time orders for brand products over a one-year lookback window. Not available for book vendors.</td></tr><tr><td>attributedordersnewtobrandpercentage14d</td><td>Numeric</td><td>The percentage of total orders that are new-to-brand orders. Not available for book vendors.</td></tr><tr><td>attributedorderratenewtobrand14d</td><td>Numeric</td><td>The number of new-to-brand orders relative to the number of clicks. New-to-brand order rate = new-to-brand orders / clicks. Not available for book vendors.</td></tr><tr><td>attributedsalesnewtobrand14d</td><td>Numeric</td><td>Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors.</td></tr><tr><td>attributedsalesnewtobrandpercentage14d</td><td>Numeric</td><td>Percentage of total sales made up of new-to-brand purchases. Not available for book vendors.</td></tr><tr><td>attributedunitsorderednewtobrand14d</td><td>Integer</td><td>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.</td></tr><tr><td>attributedunitsorderednewtobrandpercentage14d</td><td>Numeric</td><td>Percentage of total attributed units ordered within 14 days of an ad click that are part of a new-to-brand purchase. Not available for book vendors.</td></tr><tr><td>viewableimpressions</td><td>Integer</td><td>Number of impressions that met the Media Ratings Council (MRC) viewability standard (50 percent of the ad viewable with two seconds playback completed). Sponsored Brands video-only metric.</td></tr><tr><td>videofirstquartileviews</td><td>Integer</td><td>The number of impressions where the video was viewed to 25%.</td></tr><tr><td>videomidpointviews</td><td>Integer</td><td>The number of impressions where the video was viewed to 50%.</td></tr><tr><td>videothirdquartileviews</td><td>Integer</td><td>The number of impressions where the video was viewed to 75%.</td></tr><tr><td>videocompleteviews</td><td>Integer</td><td>The number of impressions where the video was viewed to 100%</td></tr><tr><td>video5secondviews</td><td>Integer</td><td>The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric.</td></tr><tr><td>video5secondviewrate</td><td>Numeric</td><td>The percentage of impressions where the customer watched the complete video or 5 seconds of the video (whichever is shorter). Sponsored Brands video-only metric.</td></tr><tr><td>videounmutes</td><td>Integer</td><td>The number of impressions where a customer unmuted the video.</td></tr><tr><td>vtr</td><td>Numeric</td><td>View-through rate (vtr). Views divided by impressions.</td></tr><tr><td>vctr</td><td>Numeric</td><td>Click-through rate for views (clicks divided by views).</td></tr><tr><td>unitssold14d</td><td>Integer</td><td>Number of attributed units sold within 14 days of click on an ad.</td></tr><tr><td>dpv14d</td><td>Integer</td><td>Number of attributed detail page views occurring within 14 days of click on an ad. Vendor-only field.</td></tr><tr><td>attributedbrandedsearches14d</td><td>Integer</td><td>The number of searches that included the name of your brand occurring within 14 days of an ad click.</td></tr></tbody></table>

## Ad Store

Brand Store analytic metrics provide brands with analytics about the Brand Store performance and customer behavior. These metrics offer a deeper understanding of how shoppers interact with the Brand Store, helping brands optimize their strategies to drive engagement and sales.

Table name: amazon\_source\_data.ad\_store

*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 Identifier                                               |
| account\_name     | Varchar   | Intentwise Account Name                                                     |
| region            | Varchar   | Region of the account                                                       |
| brandentityid     | Varchar   | ID used in campaign creation and asset registration                         |
| storename         | Varchar   | The name of the store                                                       |
| storepageid       | Varchar   | The ID of the store                                                         |
| storepageurl      | Varchar   | The store url page. Can be used for SB campaigns as a possible landing page |
| store\_page\_name | Varchar   | The page name. Defaults to Home for the main store page                     |

## Ad Store Insights Report

Table name: amazon\_source\_data.ad\_store\_insights\_report

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

<table><thead><tr><th width="299">Column Name</th><th>Data Type</th><th>Description</th></tr></thead><tbody><tr><td>profile_id</td><td>Integer</td><td>Amazon advertising account id</td></tr><tr><td>account_id</td><td>Integer</td><td>Intentwise Account Identifier</td></tr><tr><td>account_name</td><td>Varchar</td><td>Intentwise Account Name</td></tr><tr><td>region</td><td>String</td><td>Region of the account</td></tr><tr><td>reportdate</td><td>Date</td><td>Date of the report</td></tr><tr><td>brandentityid</td><td>Varchar</td><td>ID used in campaign creation and asset registration</td></tr><tr><td>dimensiontype</td><td>Varchar</td><td>Dimensional grain at which the report is generated<br><br>Types - PAGE / SOURCE / TAG / STORE / DATE</td></tr><tr><td>dimensionvalue</td><td>Varchar</td><td>Dimensional value. If dimension_type is PAGE, dimension_value will be page_id</td></tr><tr><td>views</td><td>Integer</td><td>Number of page views.</td></tr><tr><td>orders</td><td>Integer</td><td>Estimated total orders placed by Store visitors within 14 days of their visit. Orders contain one or more units sold.</td></tr><tr><td>units</td><td>Integer</td><td>Estimated units purchased by Store visitors within 14 days of their last visit</td></tr><tr><td>sales</td><td>Numeric</td><td>Estimated total sales generated by Store visitors within 14 days of their last visit</td></tr><tr><td>visits</td><td>Integer</td><td>Total visits to a page within a single day. Each visitor can visit more than one page, and they can visit your Store from more than one traffic source</td></tr><tr><td>visitors</td><td>Integer</td><td>Total visitors to your Store within the selected date range, calculated based on daily unique users or devices</td></tr><tr><td>scorelevel</td><td>Varchar</td><td>Store Quality rating calculated on various factors defining the quality of a store. It can be HIGH, MEDIUM, or LOW</td></tr><tr><td>dwell</td><td>Numeric</td><td>Average time a customer spends on the store, specifically for store quality measurement</td></tr><tr><td>peerdwell</td><td>Numeric</td><td>Average time a customer spends on other similar (peer) stores on average</td></tr><tr><td>dwelltime</td><td>Numeric</td><td>Average time a customer spends on the store, providing insights into user engagement by calculating the average duration of visits</td></tr><tr><td>bouncerate</td><td>Numeric</td><td>Ratio of total bounce visits (customer who landed on the store and left quickly without engaging) to total landing visits, providing insights into visitor engagement</td></tr><tr><td>newtostore</td><td>Integer</td><td>Total count of unique visitors who are new to the store, providing valuable insights into the number of first-time shoppers</td></tr><tr><td>systemlastupdateddate</td><td>Timestamp</td><td>Time on which the results were captured</td></tr></tbody></table>

## Sponsored Brand AdGroup

Table name: ad\_sponsoredbrand\_adgroup

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)\ <br>

| 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                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| campaignid      | integer        | Campaign id                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| name            | string         | Campaign Name                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| 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 Brand AdGroup Report

Table name: *ad\_sponsoredbrand\_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                                                                                                                                |
| 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                                                                          |
| viewableimpressions                           | integer   | Total number of ad viewable impressions                                                                                                   |
| videofirstquartileviews                       | integer   |                                                                                                                                           |
| videomidpointviews                            | integer   |                                                                                                                                           |
| videothirdquartileviews                       | integer   |                                                                                                                                           |
| videocompleteviews                            | integer   |                                                                                                                                           |
| video5secondviews                             | integer   |                                                                                                                                           |
| video5secondviewrate                          | Numeric   |                                                                                                                                           |
| videounmutes                                  | integer   |                                                                                                                                           |
| vtr                                           | Numeric   |                                                                                                                                           |
| vctr                                          | Numeric   |                                                                                                                                           |
| unitssold14d                                  | integer   |                                                                                                                                           |
| dpv14d                                        | integer   |                                                                                                                                           |
| attributedbrandedsearches14d                  | integer   |                                                                                                                                           |
| download\_date                                | Date      | Download Date                                                                                                                             |
| attributedorderratenewtobrand14d              | Numeric   |                                                                                                                                           |
| attributedordersnewtobrand14d                 | Integer   |                                                                                                                                           |
| attributedsalesnewtobrand14d                  | Numeric   |                                                                                                                                           |
| attributedunitsorderednewtobrandpercentage14d | Numeric   |                                                                                                                                           |
| attributedunitsorderednewtobrand14d           | Integer   |                                                                                                                                           |
| attributedordersnewtobrandpercentage14d       | Numeric   |                                                                                                                                           |
| attributedsalesnewtobrandpercentage14d        | Numeric   |                                                                                                                                           |

## Ad Store Asin Engagement Report

Table name: amazon\_source\_data.ad\_store\_asin\_engagement\_report\
Amazon Documentation Link: [Click Here](https://advertising.amazon.com/API/docs/en-us/guides/brand-store/insight-metrics#available-asin-metrics)

| Column Name         | Data type | Description                                                                                        |
| ------------------- | --------- | -------------------------------------------------------------------------------------------------- |
| profile\_id         | Integer   | Amazon advertising account id                                                                      |
| account\_id         | Integer   | Intentwise account id                                                                              |
| account\_name       | String    | Intentwise account name                                                                            |
| region              | String    | Region of the account                                                                              |
| reportdate          | Date      | Report date                                                                                        |
| brandentityid       | varchar   | ID used in campaign creation and asset registration                                                |
| asin                | varchar   | Advertised product                                                                                 |
| renders             | Integer   | Number of times the ASIN rendered on a store page.                                                 |
| averagesaleprice    | Numeric   | Average price in local currency for which the ASIN sold for during the order.                      |
| averageinstockprice | Numeric   | Average price in local currency the ASIN was viewed at by customers while it was in stock.         |
| instockrate         | Numeric   | Rate at which customers viewed an ASIN while it was in stock.                                      |
| clickrate           | Numeric   | Rate at which the ASIN was clicked per view.                                                       |
| clicks              | Integer   | Count of how many times a customer clicked an ASIN related widget on the store page.               |
| orders              | Integer   | Estimated total orders placed by Store visitors on the day of the ASIN view.                       |
| units               | Integer   | Estimated units purchased by Store visitors during attributed orders for the ASIN.                 |
| conversionrate      | Numeric   | Rate at which customers ordered a unit of the item over how many times customers clicked the item. |
| views               | Integer   | Number of times a customer viewed an ASIN.                                                         |
| addtocarts          | Integer   | Total number of times an ASIN was added to cart by a customer on a store page.                     |
| instockviews        | Integer   | Total views of an ASIN on a store page while the ASIN was in stock.                                |

## Sponsored Brand Audience Report

Table name: amazon\_source\_data.ad\_sponsoredbrand\_audience\_report<br>

| Column Name               | Data type | Description                    |
| ------------------------- | --------- | ------------------------------ |
| account\_id               | Integer   | Intentwise account id          |
| account\_name             | String    | Intentwise account name        |
| profile\_id               | Integer   | Amazon advertising account id  |
| report\_date              | Date      | Report date                    |
| campaign\_type            | String    | Campaign Type                  |
| campaignid                | Integer   | The identifier of the campaign |
| clickthroughrate          | Numeric   |                                |
| clicks                    | Integer   |                                |
| cost                      | Numeric   |                                |
| costperclick              | Numeric   |                                |
| impressions               | Integer   |                                |
| purchases14d              | Integer   |                                |
| sales14d                  | Numeric   |                                |
| spend                     | Numeric   |                                |
| attributedsalessamesku14d | Numeric   |                                |
| attributedsalessamesku1d  | Numeric   |                                |
| attributedsalessamesku30d | Numeric   |                                |
| attributedsalessamesku7d  | Numeric   |                                |
| campaignbiddingstrategy   | String    |                                |
| purchases1d               | Integer   |                                |
| purchases30d              | Integer   |                                |
| purchases7d               | Integer   |                                |
| purchasessamesku14d       | Integer   |                                |
| purchasessamesku1d        | Integer   |                                |
| purchasessamesku30d       | Integer   |                                |
| purchasessamesku7d        | Integer   |                                |
| sales1d                   | Numeric   |                                |
| sales30d                  | Numeric   |                                |
| sales7d                   | Numeric   |                                |
| salesclicks               | Numeric   |                                |
| unitssold14d              | Integer   |                                |
| unitssoldclicks           | Integer   |                                |
| unitssoldclicks14d        | Integer   |                                |
| unitssoldclicks1d         | Integer   |                                |
| unitssoldclicks30d        | Integer   |                                |
| unitssoldclicks7d         | Integer   |                                |
| unitssoldsamesku14d       | Integer   |                                |
| unitssoldsamesku1d        | Integer   |                                |
| unitssoldsamesku30d       | Integer   |                                |
| unitssoldsamesku7d        | Integer   |                                |
| download\_date            | Date      |                                |
| segmentname               | String    |                                |
| segmentclasscode          | String    |                                |