Request for information: API error

24 views
Skip to first unread message

api.doub...@gmail.com

unread,
May 20, 2024, 4:46:01 AMMay 20
to Google Ad Manager API Forum
 hope you're doing fine. 

I am trying to retrieve data for a report based on these dimensions and columns (alias metrics) using the latest version of the API. However, I am encountring an API error, which looks like I don't have permission. 

This is the post data send in the request. 

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:v20="https://www.google.com/apis/ads/publisher/v202402" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Header>
    <v20:RequestHeader>
      <v20:networkCode>*removed*</v20:networkCode>
      <v20:applicationName>application-name (removed)</v20:applicationName>
    </v20:RequestHeader>
  </soap:Header>
  <soap:Body>
    <v20:runReportJob>
      <v20:reportJob>
        <v20:reportQuery>
          <v20:dimensions>AD_UNIT_ID</v20:dimensions>
          <v20:dimensions>AD_UNIT_NAME</v20:dimensions>
          <v20:columns>AD_SERVER_CPM_AND_CPC_REVENUE_GROSS</v20:columns>
          <v20:columns>AD_SERVER_ALL_REVENUE_GROSS</v20:columns>
          <v20:startDate>
            <v20:year>2021</v20:year>
            <v20:month>5</v20:month>
            <v20:day>30</v20:day>
          </v20:startDate>
          <v20:endDate>
            <v20:year>2024</v20:year>
            <v20:month>5</v20:month>
            <v20:day>13</v20:day>
          </v20:endDate>
          <v20:dateRangeType>CUSTOM_DATE</v20:dateRangeType>
        </v20:reportQuery>
      </v20:reportJob>
    </v20:runReportJob>
  </soap:Body>
</soap:Envelope>


And this is the response I am getting.
HTTP/1.1 500 Internal Server Error
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><ResponseHeader xmlns="https://www.google.com/apis/ads/publisher/v202402"><requestId>fb0e84f2d078eb3f0e0336272f6c2aab</requestId><responseTime>219</responseTime></ResponseHeader></soap:Header><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>[ReportError.COLUMN_VIEW_NOT_ALLOWED @ columns; trigger:'AD_SERVER_ALL_REVENUE_GROSS, AD_SERVER_CPM_AND_CPC_REVENUE_GROSS']</faultstring><detail><ApiExceptionFault xmlns="https://www.google.com/apis/ads/publisher/v202402"><message>[ReportError.COLUMN_VIEW_NOT_ALLOWED @ columns; trigger:'AD_SERVER_ALL_REVENUE_GROSS, AD_SERVER_CPM_AND_CPC_REVENUE_GROSS']</message><errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ReportError"><fieldPath>columns</fieldPath><fieldPathElements><field>columns</field></fieldPathElements><trigger>AD_SERVER_ALL_REVENUE_GROSS, AD_SERVER_CPM_AND_CPC_REVENUE_GROSS</trigger><errorString>ReportError.COLUMN_VIEW_NOT_ALLOWED</errorString><reason>COLUMN_VIEW_NOT_ALLOWED</reason></errors></ApiExceptionFault></detail></soap:Fault></soap:Body></soap:Envelope>

Additionally, it is stated that the equivalent of the AD_SERVER_CPM_AND_CPC_REVENUE_GROSS metric is  "Ad server CPD revenue (gross)" in the Ad Manager UI, however, I cannot find it. See the attached image for reference. 

Therefore, could you let me know how can I overcome this error, when using the v202402 version of the API?

Waiting for your reply,

Best regards, 
Reply all
Reply to author
Forward
0 new messages