# Sponsored Ads | Metric | Value | | ------------------------------------------- | ------------ | | **Frequency Of Download** | Daily | | **Date Range Of Download** | Last 30 Days | | **Historical Date Range For A New Account** | Last 30 Days | ## **Data Source** To enable the Criteo Sponsored Ads Reports, the datasource: **Criteo Ads** has to be enabled on the Intentwise Platform ### Balance Table name - ad\_balance | Column Name | Data type | Description | | -------------- | --------- | --------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | currency\_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics | | country\_code | String | Countries associated with the account | | balance\_id | String | Balance ID | | created\_at | Timestamp | Timestamp in UTC of balance creation | | deposited | Numeric | Amount of funds deposited, uncapped | | end\_date | Date | Balance end date in the account timeZone; available indefinitely if null | | memo | String | Memo | | balance\_name | String | Balance Name | | po\_number | String | Purchase order number | | remaining | Numeric | Amount of funds remaining until cap is hit, null if not set | | spent | Numeric | Amount of funds already spent | | start\_date | Date | Balance start date in the account | | status | String | Balance status | | updated\_at | Timestamp | Timestamp in UTC of last balance update | ### Brand Table - ad\_brand | Column Name | Data type | Description | | -------------- | --------- | --------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | currency\_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics | | country\_code | String | Countries associated with the account | | brand\_id | String | Brand ID | | name | String | Brand name | ### Campaign Table : ad\_campaign | Column Name | Data type | Description | | -------------------------- | --------- | ------------------------------------------------------------------------------------------------------------ | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | currency\_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics | | country\_code | String | Countries associated with the account | | campaign\_id | String | Campaign ID | | budget | Numeric | Campaign lifetime spend cap; uncapped if omitted or set to null | | budget\_remaining | Numeric | Amount the campaign has remaining until cap is hit; null if budget is uncapped | | budget\_spent | Numeric | Amount the campaign has already spent | | click\_attribution\_window | String | Post-click attribution window | | click\_attribution\_scope | String | Post-click attribution scope | | created\_at | Timestamp | Timestamp in UTC of campaign creation | | drawable\_balance\_ids | String | List of balances the campaign is able to draw from; at least one balance is required for a campaign to begin | | name | String | Campaign name; must be unique within an account | | promoted\_brand\_ids | String | Set of brands represented in line items of the campaign; note this set is append only | | status | String | Campaign status, derived from the status of line items it holds; active if at least one line item is active | | type | String | Campaign type | | updated\_at | Timestamp | Timestamp in UTC of last campaign update | | view\_attribution\_window | String | Post-view attribution window | | view\_attribution\_scope | String | Post-view attribution scope | | version | Integer | Version | ### Campaign Line Item Keyword Table : ad\_campaign\_line\_item\_keyword\_report | Column Name | Data type | Description | | ---------------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | report\_date | Date | Report Generated Date | | keyword | String | Keyword or phrase used to land on the search page where an ad creative rendered | | line\_item\_id | String | Line item ID of the requested report | | attributed\_orders | Integer | Orders (or transactions) attributed to a click or impression | | attributed\_sales | Numeric | Sales revenue attributed to a click or impression; exclusive of assistedSales | | attributed\_units | Integer | Units sold attributed to a click or impression; exclusive of assistedUnits | | clicks | Integer | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | cpc | Numeric | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees | | cpo | Numeric | Cost-per-order (CPO), calculated by dividing spend by attributedOrders; inclusive of platform fees | | roas | Numeric | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees | | spend | Numeric | For open auctions campaigns, the total cost of clicks for the advertiser; inclusive of platform fees | | assisted\_sales | Numeric | Sales revenue attributed to a click or impression on the path to purchase leading to the sale; exclusive of attributedSales | | assisted\_units | Integer | Units sold attributed to a click or impression on the path to purchase leading to the sale; attributedUnits | | campaign\_id | String | Campaign ID | | line\_item\_ctr | Numeric | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types; for all other report types, the appropriate placementImpressions is used instead | | line\_item\_placement\_impressions | Integer | Measured when an ad creative renders on a page; an ad creative may display products from one or more line items; each unique line item is counted once; used in all report types except for Product and Product Category reports | | retailer\_id | Integer | Retailer ID of the retailer the line item served on | | retailer\_name | String | Retailer name of the retailer the line item served on | ### Campaign Line Item Page Type Table - ad\_campaign\_line\_item\_page\_type\_report | Column Name | Data type | Description | | ---------------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | report\_date | Date | Report Generated Date | | line\_item\_id | String | Line item ID of the requested report | | page\_type\_name | String | Type of retailer web page an ad creative rendered on, such as home page, browse pages, search pages, product detail pages, checkout pages etc. | | attributed\_orders | Integer | Orders (or transactions) attributed to a click or impression | | attributed\_sales | Numeric | Sales revenue attributed to a click or impression; exclusive of assistedSales | | attributed\_units | Integer | Units sold attributed to a click or impression; exclusive of assistedUnits | | clicks | Integer | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | cpc | Numeric | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees | | cpo | Numeric | Cost-per-order (CPO), calculated by dividing spend by attributedOrders; inclusive of platform fees | | roas | Numeric | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees | | spend | Numeric | For open auctions campaigns, the total cost of clicks for the advertiser; inclusive of platform fees | | assisted\_sales | Numeric | Sales revenue attributed to a click or impression on the path to purchase leading to the sale; exclusive of attributedSales | | assisted\_units | Integer | Units sold attributed to a click or impression on the path to purchase leading to the sale; attributedUnits | | campaign\_id | String | Campaign ID | | line\_item\_ctr | Numeric | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types; for all other report types, the appropriate placementImpressions is used instead | | line\_item\_placement\_impressions | Integer | Measured when an ad creative renders on a page; an ad creative may display products from one or more line items; each unique line item is counted once; used in all report types except for Product and Product Category reports | | retailer\_id | Integer | Retailer ID of the retailer the line item served on | | retailer\_name | String | Retailer name of the retailer the line item served on | ### Campaign Line Item Product Category Table - ad\_campaign\_line\_item\_product\_category\_report | Column Name | Data type | Description | | ---------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | report\_date | date | Report Generated Date | | line\_item\_id | String | Line item ID of the requested report | | adv\_product\_category | String | Category of product advertised; categories are standardized across brands and retailers, which may differ from retailer-specific categories | | attributed\_orders | Integer | Orders (or transactions) attributed to a click or impression | | attributed\_sales | Numeric | Sales revenue attributed to a click or impression; exclusive of assistedSales | | attributed\_units | Integer | Units sold attributed to a click or impression; exclusive of assistedUnits | | click\_spend | Numeric | Spend by clicks | | product\_clicks | Integer | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | product\_cpc | Numeric | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees | | product\_cpo | Numeric | Cost-per-order (CPO), calculated by dividing spend by attributedOrders; inclusive of platform fees | | product\_ctr | Numeric | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types; for all other report types, the appropriate placementImpressions is used instead | | product\_impressions | Integer | Measured when a promoted product is rendered on the page, whether as a single ad creative or as one of many products in an ad creative; each product is counted once separately | | product\_roas | Numeric | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees | | assisted\_sales | Numeric | Sales revenue attributed to a click or impression on the path to purchase leading to the sale; exclusive of attributedSales | | assisted\_units | Integer | Units sold attributed to a click or impression on the path to purchase leading to the sale; attributedUnits | | campaign\_id | String | Campaign ID | | retailer\_id | Integer | Retailer ID of the retailer the line item served on | | retailer\_name | String | Retailer name of the retailer the line item served on | ### Campaign Line Item Product Category Table - ad\_campaign\_line\_item\_product\_report | Column Name | Data type | Description | | ---------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | adv\_product\_id | String | Advertised product ID; this references the same ID used in Catalogs | | report\_date | Date | Report Generated Date | | line\_item\_id | String | Line item ID of the requested report | | adv\_product\_category | String | Category of product advertised; categories are standardized across brands and retailers, which may differ from retailer-specific categories | | attributed\_orders | Integer | Orders (or transactions) attributed to a click or impression | | attributed\_sales | Numeric | Sales revenue attributed to a click or impression; exclusive of assistedSales | | attributed\_units | Integer | Units sold attributed to a click or impression; exclusive of assistedUnits | | click\_spend | Numeric | Spend by clicks | | product\_clicks | Integer | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | product\_cpc | Numeric | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees | | product\_cpo | Numeric | Cost-per-order (CPO), calculated by dividing spend by attributedOrders; inclusive of platform fees | | product\_ctr | Numeric | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types; for all other report types, the appropriate placementImpressions is used instead | | product\_impressions | Integer | Measured when a promoted product is rendered on the page, whether as a single ad creative or as one of many products in an ad creative; each product is counted once separately | | product\_roas | Numeric | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees | | adv\_product\_name | String | Advertised product name | | assisted\_sales | Numeric | Sales revenue attributed to a click or impression on the path to purchase leading to the sale; exclusive of attributedSales | | assisted\_units | Integer | Units sold attributed to a click or impression on the path to purchase leading to the sale; attributedUnits | | brand\_id | String | Advertised product brand ID | | brand\_name | String | Advertised product brand name; names are standardized across retailers | | campaign\_id | String | Campaign ID | | retailer\_id | Integer | Retailer ID of the retailer the line item served on | | retailer\_name | String | Retailer name of the retailer the line item served on | ### Campaign Line Item Summary Table - ad\_campaign\_line\_item\_summary\_report | Column Name | Data type | Description | | ---------------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | report\_date | Date | Report Generated Date | | line\_item\_id | String | Line item ID of the requested report | | attributed\_orders | Integer | Orders (or transactions) attributed to a click or impression | | attributed\_sales | Numeric | Sales revenue attributed to a click or impression; exclusive of assistedSales | | attributed\_units | Integer | Units sold attributed to a click or impression; exclusive of assistedUnits | | clicks | Integer | Spend by clicks | | cpc | Numeric | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees | | cpo | Numeric | Cost-per-order (CPO), calculated by dividing spend by attributedOrders; inclusive of platform fees | | roas | Numeric | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types; for all other report types, the appropriate placementImpressions is used instead | | spend | Numeric | For open auctions campaigns, the total cost of clicks for the advertiser; inclusive of platform fees | | assisted\_sales | Numeric | Sales revenue attributed to a click or impression on the path to purchase leading to the sale; exclusive of attributedSales | | assisted\_units | Integer | Units sold attributed to a click or impression on the path to purchase leading to the sale; attributedUnits | | campaign\_id | String | Campaign ID | | frequency | Numeric | An average representing how often an impression has painted for the same user | | line\_item\_ctr | Numeric | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types; for all other report types, the appropriate placementImpressions is used instead | | line\_item\_placement\_impressions | Integer | Measured when an ad creative renders on a page; an ad creative may display products from one or more line items; each unique line item is counted once; used in all report types except for Product and Product Category reports | | retailer\_id | Integer | Retailer ID of the retailer the line item served on | | retailer\_name | String | Retailer name of the retailer the line item served on | | unique\_visitors | Integer | Number of unique visitors an impression painted for | ### Campaign Page Type Table - ad\_campaign\_page\_type\_report | Column Name | Data type | Description | | -------------------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | campaign\_id | String | Campaign ID | | report\_date | Date | Report Generated Date | | page\_type\_name | String | Type of retailer web page an ad creative rendered on, such as home page, browse pages, search pages, product detail pages, checkout pages etc. | | attributed\_orders | Integer | Orders (or transactions) attributed to a click or impression | | attributed\_sales | Numeric | Sales revenue attributed to a click or impression; exclusive of assistedSales | | attributed\_units | Integer | Units sold attributed to a click or impression; exclusive of assistedUnits | | clicks | Integer | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | cpc | Numeric | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees | | cpo | Numeric | Cost-per-order (CPO), calculated by dividing spend by attributedOrders; inclusive of platform fees | | roas | Numeric | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees | | spend | Numeric | For open auctions campaigns, the total cost of clicks for the advertiser; inclusive of platform fees | | campaign\_ctr | Numeric | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types; for all other report types, the appropriate placementImpressions is used instead | | campaign\_placement\_impressions | Integer | Measured when an ad creative renders on a page; an ad creative may display products from one or more campaigns; each unique campaign is counted once; used in all report types except for Product and Product Category reports | | campaign\_type\_name | String | Type of campaign configured | ### Campaign Product Category Table - ad\_campaign\_product\_category\_report | Column Name | Data type | Description | | ---------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | campaign\_id | String | Campaign ID | | report\_date | Date | Report Generated Date | | adv\_product\_category | String | Category of product advertised; categories are standardized across brands and retailers, which may differ from retailer-specific categories | | attributed\_orders | Integer | Orders (or transactions) attributed to a click or impression | | attributed\_sales | Numeric | Sales revenue attributed to a click or impression; exclusive of assistedSales | | attributed\_units | Integer | Units sold attributed to a click or impression; exclusive of assistedUnits | | click\_spend | Numeric | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | product\_clicks | Integer | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | product\_cpc | Numeric | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees | | product\_cpo | Numeric | Cost-per-order (CPO), calculated by dividing spend by attributedOrders; inclusive of platform fees | | product\_ctr | Numeric | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types; for all other report types, the appropriate placementImpressions is used instead | | product\_impressions | Integer | Measured when a promoted product is rendered on the page, whether as a single ad creative or as one of many products in an ad creative; each product is counted once separately | | product\_roas | Numeric | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees | | campaign\_type\_name | String | Type of campaign configured | ### Campaign Product Table - ad\_campaign\_product\_report | Column Name | Data type | Description | | ---------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | adv\_product\_id | String | Advertised product ID; this references the same ID used in Catalogs | | campaign\_id | String | Campaign ID | | report\_date | Date | Report Generated Date | | adv\_product\_category | String | Category of product advertised; categories are standardized across brands and retailers, which may differ from retailer-specific categories | | attributed\_orders | Integer | Orders (or transactions) attributed to a click or impression | | attributed\_sales | Numeric | Sales revenue attributed to a click or impression; exclusive of assistedSales | | attributed\_units | Integer | Units sold attributed to a click or impression; exclusive of assistedUnits | | click\_spend | Numeric | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | product\_clicks | Integer | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | product\_cpc | Numeric | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees | | product\_cpo | Numeric | Cost-per-order (CPO), calculated by dividing spend by attributedOrders; inclusive of platform fees | | product\_ctr | Numeric | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types; for all other report types, the appropriate placementImpressions is used instead | | product\_impressions | Integer | Measured when a promoted product is rendered on the page, whether as a single ad creative or as one of many products in an ad creative; each product is counted once separately | | product\_roas | Numeric | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees | | adv\_product\_name | String | Advertised product name | | brand\_id | String | Advertised product brand ID | | brand\_name | String | Advertised product brand name; names are standardized across retailers | | campaign\_type\_name | String | Type of campaign configured | ### Campaign Summary Table - ad\_campaign\_summary\_report | Column Name | Data type | Description | | -------------------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | campaign\_id | String | Campaign ID | | report\_date | Date | Report Generated Date | | attributed\_orders | Integer | Orders (or transactions) attributed to a click or impression | | attributed\_sales | Numeric | Sales revenue attributed to a click or impression; exclusive of assistedSales | | attributed\_units | Integer | Units sold attributed to a click or impression; exclusive of assistedUnits | | clicks | Integer | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | cpc | Numeric | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | cpo | Numeric | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees | | roas | Numeric | Cost-per-order (CPO), calculated by dividing spend by attributedOrders; inclusive of platform fees | | spend | Numeric | For open auctions campaigns, the total cost of clicks for the advertiser; inclusive of platform fees | | campaign\_ctr | Numeric | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types; for all other report types, the appropriate placementImpressions is used instead | | campaign\_placement\_impressions | Integer | Measured when an ad creative renders on a page; an ad creative may display products from one or more campaigns; each unique campaign is counted once; used in all report types except for Product and Product Category reports | | campaign\_type\_name | String | Type of campaign configured | | frequency | Numeric | An average representing how often an impression has painted for the same user | | unique\_visitors | Integer | Number of unique visitors an impression painted for | ### CampaignKeyword Table - ad\_campaignkeyword\_report | Column Name | Data type | Description | | -------------------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | currency\_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics | | country\_code | String | Countries associated with the account | | campaign\_id | String | Campaign ID | | report\_date | Date | Report Generated Date | | keyword | String | Keyword or phrase used to land on the search page where an ad creative rendered | | attributed\_orders | Integer | Orders (or transactions) attributed to a click or impression | | attributed\_sales | Numeric | Sales revenue attributed to a click or impression; exclusive of assistedSales | | attributed\_units | Integer | Units sold attributed to a click or impression; exclusive of assistedUnits | | clicks | Integer | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | cpc | Numeric | Measured when an ad creative is clicked on, which incurs a cost to the advertiser for open auction campaigns | | cpo | Numeric | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees | | roas | Numeric | Cost-per-order (CPO), calculated by dividing spend by attributedOrders; inclusive of platform fees | | spend | Numeric | For open auctions campaigns, the total cost of clicks for the advertiser; inclusive of platform fees | | campaign\_ctr | Numeric | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types; for all other report types, the appropriate placementImpressions is used instead | | campaign\_placement\_impressions | Integer | Measured when an ad creative renders on a page; an ad creative may display products from one or more campaigns; each unique campaign is counted once; used in all report types except for Product and Product Category reports | | campaign\_type\_name | String | Type of campaign configured | ### Line Item Table - ad\_line\_item | Column Name | Data type | Description | | -------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | currency\_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics | | country\_code | String | Countries associated with the account | | line\_item\_id | String | Line item ID of the requested report | | budget | Numeric | Campaign lifetime spend cap; uncapped if omitted or set to null | | budget\_remaining | Numeric | Amount the campaign has remaining until cap is hit; null if budget is uncapped | | budget\_spent | Numeric | Amount the campaign has already spent | | campaign\_id | String | Campaign ID | | created\_at | Timestamp | Timestamp in UTC of balance creation | | end\_date | Date | Balance end date in the account timeZone; available indefinitely if null | | name | String | Brand name | | start\_date | date | Balance start date in the account | | status | String | Balance status | | target\_retailer\_id | String |

Retailer ID of the retailer the line item served on
retailerName

| | type | String | Campaign type | | updated\_at | Timestamp | Timestamp in UTC of last balance update | | max\_bid | Numeric | The maximum amount allowed to bid for each bid; respected regardless of targetBid; | | monthly\_pacing | Numeric | [Amount the line item can spend per calendar month in the ](https://developers.criteo.com/retail-media/v2021.07/docs/accounts)[account](https://developers.criteo.com/retail-media/v2021.07/docs/accounts) timeZone; | | daily\_pacing | Numeric | [Amount the line item can spend per day in the ](https://developers.criteo.com/retail-media/v2021.07/docs/accounts)[account](https://developers.criteo.com/retail-media/v2021.07/docs/accounts) timeZone; | | bid\_strategy | String | Bid algorithm optimizing for sales conversions, sales revenue, or clicks | | target\_bid | Numeric | A target average amount to bid because each bid is modulated up or down by our optimization algorithm; | | auto\_daily\_pacing | Boolean | To activate, either line item endDate and budget, or monthlyPace, must be specified; overwrites dailyPacing with a calculation if not set prior | | version | Integer | Version | ### Line Item Keyword Table - ad\_line\_item\_product | Column Name | Data type | Description | | -------------- | --------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | currency\_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics | | country\_code | String | Countries associated with the account | | line\_item\_id | String | Line item ID of the requested report | | product\_id | String | Advertised product ID; this references the same ID used in Catalogs | | bid\_override | Numeric | Amount used to bid for the specific product; overrides targetBid specified on the line item and behaves similarly; must meet minBid, which is retrieved through the catalogs; input excludes platform fees | | type | String | Campaign type | | version | Integer | Version | ### Product Catelog Table - ad\_product\_catalog | Column Name | Data type | Description | | -------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | currency\_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics | | country\_code | String | Countries associated with the account | | product\_id | String | Advertised product ID; this references the same ID used in Catalogs | | product\_name | String | Advertised product name | | category | String | Retailer product category | | brand\_id | String | Brand ID | | brand\_name | String | Brand name | | retailer\_id | String | Retailer ID of the retailer the line item served on | | retailer\_name | String | Retailer name of the retailer the line item served on | | price | Numeric | Retailer product price in USD | | is\_in\_stock | Boolean | Whether or not the product is in stock | | min\_bid | Numeric | [Minimum Cost-Per-Click (CPC) an advertiser must bid for the product, established by the retailer; any ](https://developers.criteo.com/retail-media/v2021.07/docs/line-items)[line item](https://developers.criteo.com/retail-media/v2021.07/docs/line-items) with this product must have targetBid meet this value | | gtin | String | Global Trade Item Number (GTIN), if available; also known as European Article Number (EAN) or Universal Product Code (UPC) | | mpn | String | Manufacturer Part Number (MPN), if available | | image\_url | String | Retailer URL for the product image | | updated\_at | Timestamp | Timestamp in UTC of last update | ### Retailer Table - ad\_retailer | Column Name | Data type | Description | | -------------- | --------- | --------------------------------------------------------------------------------------- | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | currency\_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics | | country\_code | String | Countries associated with the account | | retailer\_id | String | Retailer ID of the retailer the line item served on | | name | String | Retailer name of the retailer the line item served on |