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,