# 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 | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.intentwise.com/iac-source-data/data-models/criteo-source-data/sponsored-ads.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.