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:
- startDate and endDate.
- changedMetricsSinceTimestamp (changedAttributesSinceTimestamp is not valid for events).
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.
columnName | Description | Behavior | Type | Filterable |
---|---|---|---|---|
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 availability |
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 Campaign manager actions. | metric | Integer |
Yes |
dfaRevenue |
Aggregate revenue generated by Campaign manager transactions. | metric | Money |
Yes |
dfaTransactions |
The total number of Campaign manager transactions. | metric | Integer |
Yes |
dfaWeightedActions |
Weighted sum of Campaign manager actions. | metric | Number |
Yes |
dfaActionsCrossEnv |
The total number of cross-environment Campaign manager actions. | metric | Number |
Yes |
dfaRevenueCrossEnv |
Aggregate revenue generated by cross-environment Campaign manager transactions. | metric | Money |
Yes |
dfaTransactionsCrossEnv |
The total number of cross-environment Campaign manager transactions. | metric | Number |
Yes |
dfaWeightedActionsCrossEnv |
Weighted sum of cross-environment Campaign manager 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 |
floodlightGroup |
Segments the report by Floodlight groups; each row and its aggregate metrics are split into multiple rows, up to one for each Floodlight group. This column returns the Floodlight group name of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits. | segment | String |
Yes |
floodlightGroupId |
Segments the report by Floodlight groups; each row and its aggregate metrics are split into multiple rows, up to one for each Floodlight group. This column returns the DS Floodlight group ID of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits. | segment | ID |
Yes |
floodlightGroupTag |
Segments the report by Floodlight groups; each row and its aggregate metrics are split into multiple rows, up to one for each Floodlight group. This column returns the Floodlight group tag of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits. | segment | String |
Yes |
floodlightActivity |
Segments the report by Floodlight activities; each row and its aggregate metrics are split into multiple rows, up to one for each Floodlight activity. This column returns the Floodlight activity name of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits. | segment | String |
Yes |
floodlightActivityId |
Segments the report by Floodlight activities; each row and its aggregate metrics are split into multiple rows, up to one for each Floodlight activity. This column returns the DS Floodlight activity ID of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits. | segment | ID |
Yes |
floodlightActivityTag |
Segments the report by Floodlight activities; each row and its aggregate metrics are split into multiple rows, up to one for each Floodlight activity. This column returns the Floodlight activity tag of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits. | segment | String |
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 |