/v2/publishers/{publisherId}/reports/spa/product

POST

https://<pcm-domain>/v2/publishers/{publisherId}/reports/spa/product

Retrieve paginated SPA product performance report.

Filter fields:

GTIN - product GTIN, exact match
PRODUCT_TITLE - product title, contains, case-insensitive
BRAND - product brand, exact match
MARKET - market country code, exact match

Rules:

endDate is inclusive and should be greater than or equal to startDate.
page and limit are required

Path Parameters

publisherIdinteger<int32>required
Format
int32

Body Parameters

bodyV2PublisherSpaProductReportRequestrequired
- filtersFilterValuesSpaProductReportFilterField[]
  - fieldstring<GTIN | PRODUCT_TITLE | BRAND | MARKET>
    Allowed
    GTINPRODUCT_TITLEBRANDMARKET
  - valuesobject[]
- startDatestring<date>required
  Format
  date
- endDatestring<date>required
  Format
  date
- attributionProfilestring<IMP_1_DAY_CLK_14_DAYS | IMP_1_DAY | CLK_14_DAYS>
  Allowed
  IMP_1_DAY_CLK_14_DAYSIMP_1_DAYCLK_14_DAYS
- pageinteger<int32>required
  Format
  int32
  Minimum
  0
  Maximum
  1000
- limitinteger<int32>required
  Format
  int32
  Minimum
  1
  Maximum
  10000
- sortTypestring<ASC | DESC>
  Allowed
  ASCDESC
- dateBreakdownboolean
- orderBystring<GTIN | PRODUCT_TITLE | BRAND | MARKET | DATE | IMPRESSIONS | CLICKS | LOADS | CONVERSIONS | UNITS_SOLD | CLICK_THROUGH_RATE | CONVERSION_RATE | CONVERSION_VALUE | AD_SPEND_REVENUE | COST_PER_CLICK | RETURN_ON_AD_SPEND>
  Allowed
  GTINPRODUCT_TITLEBRANDMARKETDATEIMPRESSIONSCLICKSLOADSCONVERSIONSUNITS_SOLDCLICK_THROUGH_RATECONVERSION_RATECONVERSION_VALUEAD_SPEND_REVENUECOST_PER_CLICKRETURN_ON_AD_SPEND

Responses

200OK

V2PublisherSpaProductReport
- detailedV2PublisherSpaProductReportRow[]
  - impressionsinteger<int64>
    Format
    int64
  - clicksinteger<int64>
    Format
    int64
  - conversionsinteger<int64>
    Format
    int64
  - unitsSoldinteger<int64>
    Format
    int64
  - clickThroughRatenumber<double>
    Format
    double
  - conversionRatenumber<double>
    Format
    double
  - conversionValuenumber<double>
    Format
    double
  - costPerClicknumber<double>
    Format
    double
  - returnOnAdSpendnumber<double>
    Format
    double
  - adSpendRevenuenumber<double>
    Format
    double
  - loadsinteger<int64>
    Format
    int64
  - datestring
  - marketstring
  - gtinstring
  - productTitlestring
  - brandstring
- aggregatedAggregatedV2AggregatedSpaReportRow
  - countinteger<int64>
    Format
    int64
  - metricsV2AggregatedSpaReportRow
    - impressionsinteger<int64>
      Format
      int64
    - clicksinteger<int64>
      Format
      int64
    - conversionsinteger<int64>
      Format
      int64
    - unitsSoldinteger<int64>
      Format
      int64
    - clickThroughRatenumber<double>
      Format
      double
    - conversionRatenumber<double>
      Format
      double
    - conversionValuenumber<double>
      Format
      double
    - costPerClicknumber<double>
      Format
      double
    - returnOnAdSpendnumber<double>
      Format
      double
    - adSpendRevenuenumber<double>
      Format
      double
    - loadsinteger<int64>
      Format
      int64
    - countinteger<int64>
      Format
      int64

401Unauthorized

403Forbidden

404Not Found

ExceptionResponse
- messagesstring[]

422Unprocessable Entity

ExceptionResponse
- messagesstring[]

curl

curl --request POST \
     --url https://<pcm-domain>/v2/publishers/{publisherId}/reports/spa/product \
     --header 'accept: application/json' \
     --header 'content-type: application/json' \
     --data '{
     "startDate": "",
     "endDate": "",
     "page": 0,
     "limit": 0
     }'

javascript

var myHeaders = new Headers();
myHeaders.append("accept", "application/json");
myHeaders.append("content-type", "application/json");

var raw = JSON.stringify({
   "startDate": "",
   "endDate": "",
   "page": 0,
   "limit": 0
});

var requestOptions = {
   method: 'POST',
   headers: myHeaders,
   body: raw,
   redirect: 'follow'
};

fetch("https://<pcm-domain>/v2/publishers/{publisherId}/reports/spa/product", requestOptions)
   .then(response => response.text())
   .then(result => console.log(result))
   .catch(error => console.log('error', error));

ruby

require "uri"
require "json"
require "net/http"

url = URI("https://<pcm-domain>/v2/publishers/{publisherId}/reports/spa/product")

https = Net::HTTP.new(url.host, url.port)
https.use_ssl = true

request = Net::HTTP::Post.new(url)
request["accept"] = "application/json"
request["content-type"] = "application/json"
request.body = JSON.dump({
   "startDate": "",
   "endDate": "",
   "page": 0,
   "limit": 0
})

response = https.request(request)
puts response.read_body

python

import requests
import json

url = "https://<pcm-domain>/v2/publishers/{publisherId}/reports/spa/product"

payload = json.dumps({
   "startDate": "",
   "endDate": "",
   "page": 0,
   "limit": 0
})
headers = {
   'accept': 'application/json',
   'content-type': 'application/json'
}

response = requests.request("POST", url, headers=headers, data=payload)

print(response.text)

200

// OK
{
  "detailed": [
    {
      "impressions": "",
      "clicks": "",
      "conversions": "",
      "unitsSold": "",
      "clickThroughRate": "",
      "conversionRate": "",
      "conversionValue": "",
      "costPerClick": "",
      "returnOnAdSpend": "",
      "adSpendRevenue": "",
      "loads": "",
      "date": "",
      "market": "",
      "gtin": "",
      "productTitle": "",
      "brand": ""
    }
  ],
  "aggregated": {
    "count": "",
    "metrics": {
      "impressions": "",
      "clicks": "",
      "conversions": "",
      "unitsSold": "",
      "clickThroughRate": "",
      "conversionRate": "",
      "conversionValue": "",
      "costPerClick": "",
      "returnOnAdSpend": "",
      "adSpendRevenue": "",
      "loads": "",
      "count": ""
    }
  }
}

401

// Unauthorized

403

// Forbidden

404

// Not Found
{
  "messages": [
    ""
  ]
}

422

// Unprocessable Entity
{
  "messages": [
    ""
  ]
}