Report Type: productLeadAndCrossSell

Performance metrics, configuration attributes, and inventory attributes for products defined in an inventory feed and sold as a result of paid search advertising.

This report can only be returned by an asynchronous request (that is, via the Reports.request() method).

Because events occur on specific dates, a request for this report must specify a timeRange. You can specify either of the following:

Request excerpt

Send a regular Reports.request() request body, but specify "reportType": "productLeadAndCrossSell".

{
...
  "reportType": "productLeadAndCrossSell",
  "columns": [
    {
      "columnName": string,
      "headerText": string,
      "startDate": string,
      "endDate": string
    }
  ],
  "filters": [
    {
      "column": {
        "columnName": string,
      },
      ...
    },
    ...
  ],
...
}

For each column that you want returned or filtered in the report, specify the columnName listed in the table below. You can also optionally specify headerText, startDate, and endDate. Note that some columns cannot be filtered; refer to "Filterable" in the table below.

columnNameDescriptionBehaviorTypeFilterable
agency Agency name. attribute String Yes
agencyId DS agency ID. attribute ID Yes
advertiser Advertiser name. attribute String Yes
advertiserId DS advertiser ID. attribute ID Yes
productId The item ID of the product. attribute String Yes
productCountry The country registered for the product's inventory feed. attribute String Yes
productLanguage The language registered for the product's inventory feed. attribute String Yes
productMpn The MPN attribute (Manufacturer Part Number) of a product item. attribute String Yes
productColor The color attribute of a product item. attribute String Yes
productSize The size attribute of a product item. attribute String Yes
productMaterial The material attribute of a product item. attribute String Yes
productPattern The pattern attribute of a product item. attribute String Yes
productAvailability The availability attribute of a product item. attribute Product availablity Yes
productGender The gender attribute of a product item. attribute String Yes
productAgeGroup The age group attribute of a product item. attribute String Yes
productLandingPageUrl The landing page attribute of a product item. attribute String Yes
productCategory The google product category attribute of a product item. attribute String Yes
productCategoryLevel1 The google product category level 1 attribute of a product item. attribute String Yes
productCategoryLevel2 The google product category level 2 attribute of a product item. attribute String Yes
productCategoryLevel3 The google product category level 3 attribute of a product item. attribute String Yes
productCategoryLevel4 The google product category level 4 attribute of a product item. attribute String Yes
productCategoryLevel5 The google product category level 5 attribute of a product item. attribute String Yes
productBrand The brand attribute of a product item. attribute String Yes
productGtin The GTIN attribute (Global Trading Item Number) of a product item. attribute String Yes
productPrice The price attribute of a product item. attribute Money Yes
productSalePrice The price attribute of a product item. attribute Money Yes
productTypeLevel1 The product type leve 1 attribute of a product item. attribute String Yes
productTypeLevel2 The product type leve 2 attribute of a product item. attribute String Yes
productTypeLevel3 The product type leve 3 attribute of a product item. attribute String Yes
productTypeLevel4 The product type leve 4 attribute of a product item. attribute String Yes
productTypeLevel5 The product type leve 5 attribute of a product item. attribute String Yes
productCondition The condition attribute of a product item. attribute String Yes
productCustomLabel0 The custom label 0 attribute of a product item. attribute String Yes
productCustomLabel1 The custom label 1 attribute of a product item. attribute String Yes
productCustomLabel2 The custom label 2 attribute of a product item. attribute String Yes
productCustomLabel3 The custom label 3 attribute of a product item. attribute String Yes
productCustomLabel4 The custom label 4 attribute of a product item. attribute String Yes
productCostOfGoodsSold The total cost of selling a product as specified in the inventory feed. attribute Money Yes
productStoreId The store for which a product was advertised in a Local Inventory Ad. This should match the store IDs used in your local products feed. attribute String Yes
productChannel The sales channel attribute of a product item: Online or Local. attribute Product channel Yes
productChannelExclusivity The channel exclusivity attribute of a product item. attribute Product channel exclusivity Yes
productItemGroupId The item group id attribute of a product item. attribute String Yes
productTitle The title attribute of a product item. attribute String Yes
dfaActions The total number of DFA actions. metric Integer Yes
dfaRevenue Aggregate revenue generated by DFA transactions. metric Money Yes
dfaTransactions The total number of DFA transactions. metric Integer Yes
dfaWeightedActions Weighted sum of DFA actions. metric Number Yes
crossSellAverageUnitPrice Average price reported for sales of a product when it sold as a result of advertising a different product metric Money Yes
crossSellCostOfGoodsSold The total cost of selling a product when it sold as a result of advertising a different product. metric Money Yes
crossSellGrossFromUnitsSold The total revenue generated from sales of a product as a result of advertising a different product. metric Money Yes
crossSellGrossProfitMargin The gross profit margin for a specific product when sold as a result of advertising a different product. metric Number Yes
crossSellRevenueFromUnitsSold The total revenue generated from cross sales (revenue generated as a result of advertising a different product). metric Money Yes
crossSellUnitsSold The number of units sold as the result of cross-selling. (The number of units sold as a result of advertising a different product.) metric Number Yes
leadAverageUnitPrice The average price reported for sales of a product when it sold as a result of advertising the product. metric Money Yes
leadCostOfGoodsSold The total cost of selling a product when sold as a result of advertising the product. metric Money Yes
leadGrossProfitFromUnitsSold The total revenue generated from sales of a product as a result of advertising the product. metric Money Yes
leadGrossProfitMargin The gross profit margin for a specific product as a direct result of advertising the product. metric Number Yes
leadRevenueFromUnitsSold The total revenue generated from a product as a result of advertising the product. metric Money Yes
leadUnitsSold The number of units sold as a result of advertising the product. metric Number Yes
productUnitsSold The total number of units sold for a particular product. metric Number Yes
productRevenueFromUnitsSold The total revenue generated from a product (using the price reported on each product). metric Money Yes
productAverageUnitPrice The average price reported for sales of a product (using the price reported on each product). metric Money Yes
date Segments the report by days; each row and its aggregate metrics are split into multiple rows, one for each day. This column returns the date of each row. segment Date Yes
monthStart Segments the report by months; each row and its aggregate metrics are split into multiple rows, one for each month. This column returns the first day of the month of each row. segment Date Yes
monthEnd Segments the report by months; each row and its aggregate metrics are split into multiple rows, one for each month. This column returns the last day of the month of each row. segment Date Yes
quarterStart Segments the report by quarters; each row and its aggregate metrics are split into multiple rows, one for each quarter. This column returns the first day of the quarter of each row. segment Date Yes
quarterEnd Segments the report by quarters; each row and its aggregate metrics are split into multiple rows, one for each quarter. This column returns the last day of the quarter of each row. segment Date Yes
weekStart Segments the report by weeks (Sunday to Saturday); each row and its aggregate metrics are split into multiple rows, one for each week. This column returns the first day (Sunday) of each row. segment Date Yes
weekEnd Segments the report by weeks (Sunday to Saturday); each row and its aggregate metrics are split into multiple rows, one for each week. This column returns the last day (Saturday) of each row. segment Date Yes
yearStart Segments the report by years; each row and its aggregate metrics are split into multiple rows, one for each year. This column returns the first day of the year of each row. segment Date Yes
yearEnd Segments the report by years; each row and its aggregate metrics are split into multiple rows, one for each year. This column returns the last day of the year of each row. segment Date Yes
deviceSegment Segments the report by device; each row and its aggregate metrics are split into multiple rows, up to one for each device segment. This column returns the device segment of each row. segment Device segment Yes
accountId DS engine account ID. segment ID Yes
campaignId Segments the report by campaign. This row returns the DS campaign ID associated with the row. segment ID Yes
adGroupId Segments the report by ad group. This row returns the ad group id associated with the row. segment ID Yes

Send feedback about...

DoubleClick Search API