ReportQuery error in ReportService API when using Dimension AD_UNIT_NAME with Column AD_EXCHANGE_ESTIMATED_REVENUE

[Thomas Tatincloux]

 

Hi !

I'm getting error when using Dimension AD_UNIT_NAME with Column AD_EXCHANGE_ESTIMATED_REVENUE in the ReportQuery

Here is the error : 

DFP_SOAP.WARNING: networkCode=xxxxx service=ReportService method=runReportJob responseTime=254 requestId=yyyyyyyyyyy server=ads.google.com isFault=1 faultMessage=[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'AD_EXCHANGE_ESTIMATED_REVENUE']

DFP_SOAP.NOTICE: POST /apis/ads/publisher/v201902/ReportService?wsdl HTTP/1.1

Host: ads.google.com

Connection: close

{

    "class": "Google\\AdsApi\\AdManager\\v201902\\ApiException",

    "message": "[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'AD_EXCHANGE_ESTIMATED_REVENUE']",

    "code": 0,

    "file": "common\/lib\/googleads\/googleads-php-lib\/src\/Google\/AdsApi\/Common\/Util\/Reflection.php:43",

    "trace": [

        "common\/lib\/googleads\/googleads-php-lib\/src\/Google\/AdsApi\/Common\/Util\/Reflection.php:43",

        "common\/lib\/googleads\/googleads-php-lib\/src\/Google\/AdsApi\/Common\/AdsSoapClient.php:202",

        "common\/lib\/googleads\/googleads-php-lib\/src\/Google\/AdsApi\/Common\/AdsSoapClient.php:164",

        "common\/lib\/googleads\/googleads-php-lib\/src\/Google\/AdsApi\/AdManager\/v201902\/ReportService.php:175",

    ]

}

This error only happens when I request AD_UNIT_NAME with AD_EXCHANGE_ESTIMATED_REVENUE together, I've no error using them alone or with other parameters

We didn't change anything in the code and this request used to run without any problem everyday, every hour since months

// Init report service with current session params
$reportService = $serviceFactory->createReportService($session);

// Create report query.
$reportQuery = new ReportQuery();
$reportQuery->setDimensions([
Dimension::DATE,
Dimension::AD_UNIT_NAME,
]);

$reportQuery->setColumns([
Column::AD_SERVER_CPM_AND_CPC_REVENUE,
Column::AD_SERVER_ALL_REVENUE,
Column::AD_EXCHANGE_ESTIMATED_REVENUE,
]);

// Set the ad unit view to hierarchical.
$reportQuery->setAdUnitView(ReportQueryAdUnitView::HIERARCHICAL);
// Set the start and end dates or choose a dynamic date range type.
$reportQuery->setDateRangeType(DateRangeType::CUSTOM_DATE);

$date_time_zone = new DateTimeZone('Europe/Paris');
$reportQuery->setStartDate(AdManagerDateTimes::fromDateTime(new DateTime($date.' 00:00:00', $date_time_zone))->getDate());

$reportQuery->setEndDate(AdManagerDateTimes::fromDateTime(new DateTime($date.' 23:59:59', $date_time_zone))->getDate());

// Create report job and start it.
$reportJob = new ReportJob();
$reportJob->setReportQuery($reportQuery);
$reportJob = $reportService->runReportJob($reportJob);

// Create report downloader to poll report's status and download when ready.

$reportDownloader = new ReportDownloader($reportService, $reportJob->getId());

Thanks,

[LEFDER Marketing Digital]

Similar situation here. Suddenly the same error appeared in a script that runs since months.

[Ad Manager API Forum Advisor Prod]

Hello,

 

Please note that ReportService no longer supports reports that mix Ad Exchange historical fields with Historical reporting fields. Since you used Ad Exchange metrics, you have received errors via the API as this is no longer supported. Please refer to the blog post to know more about 'Why are we making this change? How can I tell if I am impacted? What changes do I need to make?'.

 

Thanks,

Sravani Yelamarthi, Ad Manager API Team

ref:_00D1U1174p._5001UEIFyJ:ref

[Thomas Tatincloux]

Tanks for your answer !

So what Dimensions and Columns can I use to get my AD_EXCHANGE_ESTIMATED_REVENUE for each AD_UNIT_NAME for a specific day via API ?

Like it’s stil working in the DFP web report tool interface ?

[federico dradi]

Hi, 

I get almost the same error for a similar query (please see below for details). According to the doc for v201905 (https://developers.google.com/ad-manager/api/reference/v201905/ReportService.ReportQuery), it should be compatible with "ad exchange historical" report type. Am I wrong? 

Here is my error: [ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'AD_EXCHANGE_ESTIMATED_REVENUE, AD_EXCHANGE_IMPRESSIONS']"

Ideas how to fix it? 

Thanks in advance, 

F

# report job query1
report_job1 = {
      'reportQuery': {
          'dimensions': ['MONTH_AND_YEAR',
          'AD_EXCHANGE_TAG_NAME',
          'PARTNER_MANAGEMENT_PARTNER_LABEL_NAME',
                         'AD_EXCHANGE_DFP_AD_UNIT',
                         'AD_EXCHANGE_TRANSACTION_TYPE',
'AD_EXCHANGE_ADVERTISER_NAME',
                         'AD_EXCHANGE_DEAL_NAME',
                         'AD_EXCHANGE_CREATIVE_SIZES'],
          'columns': ['AD_EXCHANGE_IMPRESSIONS',
                      'AD_EXCHANGE_ESTIMATED_REVENUE'],
          'dateRangeType': 'LAST_MONTH'
      }
  }


# report job query2
report_job2 = {
      'reportQuery': {
          'dimensions': ['MONTH_AND_YEAR',
          'AD_EXCHANGE_TAG_NAME',
          'PARTNER_MANAGEMENT_PARTNER_LABEL_NAME',
          'AD_EXCHANGE_DFP_AD_UNIT',
          'AD_EXCHANGE_URL',
                         'AD_EXCHANGE_TRANSACTION_TYPE',
'AD_EXCHANGE_ADVERTISER_NAME',
                         'AD_EXCHANGE_DEAL_NAME',
                         'AD_EXCHANGE_CREATIVE_SIZES'],
          'columns': ['AD_EXCHANGE_IMPRESSIONS',
                      'AD_EXCHANGE_ESTIMATED_REVENUE'],
          'dateRangeType': 'LAST_MONTH'
      }

  } 

--
You received this message because you are subscribed to the Google Groups "Google Ad Manager API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-doubleclick-for-p...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-doubleclick-for-publishers-api/ae564337-296d-4889-8da2-ce3d9ecaa675%40googlegroups.com.

[Pierre Malafosse]

Hello,

I also get a similar problem today for something that has been running fine for almost 6 months.

My query is 

        reportQuery = {

            'dimensions': ['DATE', 'AD_EXCHANGE_COUNTRY_NAME', 'PLACEMENT_NAME', 'AD_EXCHANGE_BUYER_NETWORK_NAME', 'AD_UNIT_NAME'],

            'columns': ['AD_EXCHANGE_AD_REQUESTS', 'AD_EXCHANGE_MATCHED_REQUESTS', 'AD_EXCHANGE_IMPRESSIONS', 'AD_EXCHANGE_CLICKS',

                        'AD_EXCHANGE_ESTIMATED_REVENUE'],

            'adUnitView': 'FLAT',

            'dateRangeType': 'CUSTOM_DATE',

            'timeZoneType': 'PUBLISHER',

            'adxReportCurrency': 'USD'

        }

and I get [ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'AD_EXCHANGE_AD_REQUESTS, AD_EXCHANGE_CLICKS, AD_EXCHANGE_ESTIMATED_REVENUE, AD_EXCHANGE_IMPRESSIONS, AD_EXCHANGE_MATCHED_REQUESTS']

Thanks

Pierre

To unsubscribe from this group and stop receiving emails from it, send an email to google-doubleclick-for-publishers-api+unsubscribe@googlegroups.com.

[federico dradi]

Hi. 

do we have to open another ticket on the forum to get some help? or is it not necessary? 

Thanks in advance

F

To unsubscribe from this group and stop receiving emails from it, send an email to google-doubleclick-for-p...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-doubleclick-for-publishers-api/ae564337-296d-4889-8da2-ce3d9ecaa675%40googlegroups.com.

--

You received this message because you are subscribed to the Google Groups "Google Ad Manager API Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-doubleclick-for-p...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-doubleclick-for-publishers-api/f4c6749c-bc4e-4b8b-b007-93077f141883%40googlegroups.com.

[Piotr Drzymała]

I have similar problem with those params:

    $reportQuery->setDimensions([

      Dimension::DATE,

    ]);

    $reportQuery->setColumns([

      Column::AD_EXCHANGE_ESTIMATED_REVENUE,

      Column::AD_EXCHANGE_IMPRESSIONS,

    ]); 

 Is there any way to solve this problem? 

[Thomas Tatincloux]

Thanks for your answers, we fixed it !

The thing is that with new DFP upgrade, Historical reports and Ad exchange historical reports are separated 

If you use at least 1 parameter prefixed with "AD_EXCHANGE_" you're automatically in an Ad exchange historical report and in this type of report you can only query params prefixed by AD_EXCHANGE_xxx (except for DATE)

So :

If you need to query Columns or Dimensions starting with AD_EXCHANGE_xxx, all your Colmuns and Dimensions have to use parameters prefixed by AD_EXCHANGE_xxx

In our case 2 different solutions fixed the problem : 

- Replace Column::AD_EXCHANGE_ESTIMATED_REVENUE by Column::TOTAL_LINE_ITEM_LEVEL_ALL_REVENUE

- Keep Column::AD_EXCHANGE_ESTIMATED_REVENUE but replace Dimension::AD_UNIT_NAME by Dimension::AD_EXCHANGE_DFP_AD_UNIT and query other columns in another report

Regards,

[Piotr Drzymała]

Hi Thomas, 

thanks for your research but for me none of your solutions works :( 

For dimension   Dimension::AD_EXCHANGE_DFP_AD_UNIT and column Column::AD_EXCHANGE_ESTIMATED_REVENUE still have error:

 [Google\AdsApi\AdManager\v201905\ApiException]                               

  [ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trig  

  ger:'AD_EXCHANGE_ESTIMATED_REVENUE'] 

I'll wait for DFP team to solve this, imo it's some kind of bug in API...

Best regards,

pd

[Ad Manager API Forum Advisor Prod]

Hi, everyone.

As explained by my colleague Sravani, we've recently added new validations to prevent mixing Historical and Ad Exchange historical columns/dimension. While these numbers were possible to pull previously from the API (but not the UI), we can't guarantee their accuracy, which is why we've decided to disallow such requests. You can find more information in this blog post.

In order to figure out which columns and dimensions are incompatible, you can use our Dimension and Column reference documentation to see which entities are compatible with Historical reports and which are compatible with Ad Exchange historical reports. Make sure that all of your report's dimensions and columns are compatible with the same report type.

If you have made the changes above and are still receiving errors, please respond back to this thread with your full SOAP logs and I'll take a look at it personally. For the user who says they're receiving the error for Dimension::AD_EXCHANGE_DFP_AD_UNIT and Column::AD_EXCHANGE_ESTIMATED_REVENUE, these two should be compatible with each other. I just ran a report on a test network with this dimension and column, and it was successful. So please provide the full SOAP log, and I'll investigate.

Thanks,
Donovan McMurray, Ad Manager API Team

ref:_00D1U1174p._5001UEIFyJ:ref

[Brandon Beard]

This query is still throwing an error:

report_job = {
 'reportQuery': {
     'dimensions': ['AD_EXCHANGE_DATE', 'AD_EXCHANGE_DFP_AD_UNIT', 'AD_EXCHANGE_DFP_AD_UNIT_ID', 'AD_EXCHANGE_ADVERTISER_NAME', 'AD_EXCHANGE_CREATIVE_SIZES', 'AD_EXCHANGE_DEVICE_CATEGORY'],
     'statement': statement.ToStatement(),
     'columns': ['AD_EXCHANGE_IMPRESSIONS', 'AD_EXCHANGE_ESTIMATED_REVENUE', 'AD_EXCHANGE_LINE_ITEM_LEVEL_AVERAGE_ECPM', 'AD_EXCHANGE_ACTIVE_VIEW_VIEWABLE'],
     'adUnitView': 'HIERARCHICAL',
     'dateRangeType': 'CUSTOM_DATE',
     'startDate': start_date,
     'endDate': end_date
  }
}

GoogleAdsServerFault: [ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'AD_EXCHANGE_ACTIVE_VIEW_VIEWABLE, AD_EXCHANGE_ESTIMATED_REVENUE, AD_EXCHANGE_IMPRESSIONS, AD_EXCHANGE_LINE_ITEM_LEVEL_AVERAGE_ECPM']

[Yeung Leung]

Got the same error too

{'reportQuery': {'adUnitView': 'TOP',

                 'columns': ['AD_EXCHANGE_IMPRESSIONS',

                             'AD_EXCHANGE_CLICKS',

                             'AD_EXCHANGE_ESTIMATED_REVENUE',

                             'AD_EXCHANGE_AD_ECPM',

                             'AD_EXCHANGE_VIDEO_COMPLETE',

                             'AD_EXCHANGE_VIDEO_COMPLETION_RATE'],

                 'dateRangeType': 'CUSTOM_DATE',

                 'dimensionAttributes': ['AD_EXCHANGE_DFP_AD_UNIT_CODE'],

                 'dimensions': ['AD_EXCHANGE_DFP_AD_UNIT_ID',

                                'AD_EXCHANGE_DFP_AD_UNIT',

                                'AD_EXCHANGE_TRANSACTION_TYPE',

                                'DATE'],

                 'endDate': datetime.date(2019, 8, 13),

                 'startDate': datetime.date(2019, 8, 6),

                 'statement': {'query': 'WHERE AD_UNIT_ID IN '

                                        '(105070738,105070858,105070978,105071098,105071218,105071338,105071818,105071938,105072058,105072178,105188338,105188458,105188818,105188938,105787978,105788098,106697938,106698058,106698178,106698298,106698418,106698538,106698658,106698778,109275778,109275898,109276018,109276138,109276258,109276378,109276498,109276618,110845258,21804584139,105071578,105112258,105071698,105112378,105071458,105112138,105188578,105188698,106699138,106699618,106699258,106699738,21804583827,106698898,106699018,106699498,106699378,105072418,105112978,110845378,105788218,105072298,105788338,105112858,105189058,105189178,109276978,109277458,109277098,109277578,109276738,109276858,109277338,109277218)',

                               'values': None}}}

Shared the log privately.

Thanks

Yeung

[Ad Manager API Forum Advisor Prod]

Hi, everyone.

To Piotr and Yeung, you are filtering on dimensions that are not compatible with "Ad Exchange historical" reports.

To Brandon, I can't see your filter statement on your reportQuery, but I would assume that you're having the same issue as well.

Let me know if your issue persists after fixing this.

[Yeung Leung]

Hi Advisor,

Did you mean the AD_UNIT_ID? But I got the following error 

googleads.errors.GoogleAdsServerFault: [PublisherQueryLanguageContextError.UNEXECUTABLE @ 'AD_EXCHANGE_DFP_AD_UNIT_ID' is not filterable.]

if I change the filter to AD_EXCHANGE_DFP_AD_UNIT_ID.

Does not mean i can no longer filter by AD_UNIT_ID?

Thanks,

Yeung

[Ad Manager API Forum Advisor Prod]

Hi, Yeung.

Thanks for pointing that out! I raised the issue of AD_EXCHANGE_DFP_AD_UNIT_ID not being filterable in the API, and our reporting team is going to fix that as soon as possible. I will report back to this thread once the change has been validated and rolled out to production.

In the meantime, it looks like you can currently filter by Ad Unit name (AD_EXCHANGE_DFP_AD_UNIT). I understand that that may not be ideal, but it will only be a temporary measure if you absolutely need Ad Unit filtering before the fix I mentioned is available.

[Piotr Drzymała]

Hi Donovan,

thanks for your patience, in my case problem was generating report for specific advertisier_id - this causes problems. Sravani looks into logs and solves my problem, thanks!

Best regards,

Piotr

[Brandon Beard]

I do not have any filter applied. I have also changed AD_EXCHANGE_DATE to just DATE. Still getting error.

report_job = {
 'reportQuery': {
     'dimensions': ['DATE', 'AD_EXCHANGE_DFP_AD_UNIT', 'AD_EXCHANGE_DFP_AD_UNIT_ID', 'AD_EXCHANGE_ADVERTISER_NAME', 'AD_EXCHANGE_CREATIVE_SIZES', 'AD_EXCHANGE_DEVICE_CATEGORY'],

     'statement': statement.ToStatement(),
     'columns': ['AD_EXCHANGE_IMPRESSIONS', 'AD_EXCHANGE_ESTIMATED_REVENUE'],

     'adUnitView': 'HIERARCHICAL',
     'dateRangeType': 'CUSTOM_DATE',
     'startDate': start_date,
     'endDate': end_date
  }
}

[Ad Manager API Forum Advisor Prod]

Hi, everyone.

The change to allow filtering by AD_EXCHANGE_DFP_AD_UNIT_ID has been rolled out, so you can now use that dimension for filtering reports.

Brandon, you do have a "statement" on your reportQuery, which is how you filter reports. Can you include the part of your code that defines the statement? Or could you click the "Reply privately to author" option and send me your full SOAP logs so that I can look into the underlying issue you're having?

[Khoa Do Dinh]

Hi everyone,

I use:

 $_dimension = array('AD_EXCHANGE_DATE','AD_EXCHANGE_DFP_AD_UNIT','AD_EXCHANGE_MOBILE_APP_NAME','AD_EXCHANGE_COUNTRY_NAME');

$statementBuilder = (new StatementBuilder())->where('AD_EXCHANGE_DFP_AD_UNIT = :tags_name'); //(tag_name is the name of app)

// Create report query.

        $reportQuery = new ReportQuery();

        $reportQuery->setDimensions($_dimension);

        $reportQuery->setColumns(

            [

                Column::AD_EXCHANGE_CLICKS,

                Column::AD_EXCHANGE_IMPRESSIONS,

                Column::AD_EXCHANGE_COVERAGE,

                Column::AD_EXCHANGE_CPC,

                Column::AD_EXCHANGE_ESTIMATED_REVENUE,

                Column::AD_EXCHANGE_AD_CTR,

                Column::AD_EXCHANGE_AD_ECPM,

                Column::AD_EXCHANGE_AD_REQUESTS,

                Column::AD_EXCHANGE_MATCHED_REQUESTS,

            ]

        );

$reportQuery->setAdUnitView(ReportQueryAdUnitView::HIERARCHICAL);

$reportQuery->setDateRangeType(DateRangeType::YESTERDAY);

$reportQuery->setTimeZoneType(TimeZoneType::AD_EXCHANGE);

But it has error: ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'AD_EXCHANGE_AD_CTR, AD_EXCHANGE_AD_ECPM, AD_EXCHANGE_AD_REQUESTS, AD_EXCHANGE_CLICKS, AD_EXCHANGE_COVERAGE, AD_EXCHANGE_CPC, AD_EXCHANGE_ESTIMATED_REVENUE, AD_EXCHANGE_IMPRESSIONS, AD_EXCHANGE_MATCHED_REQUESTS'

Please take a look and help me.

Thanks!

Vào 03:55:00 UTC+7 Thứ Tư, ngày 21 tháng 8 năm 2019, admanagerapiforumadvisor đã viết:

[Pedro Esteras Bustos]

Hi,

I have a similar error. I have sent the same report for years, but I now receive an error.

This is the information I send:

<<

POST /apis/ads/publisher/v201908/ReportService HTTP/1.1

Host: ads.google.com

User-Agent: gSOAP/2.8

Content-Type: text/xml; charset=utf-8

Content-Length: 3433

Connection: close

Authorization: X

SOAPAction: "runReportJob"

<?xml version="1.0" encoding="UTF-8"?>

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xop="http://www.w3.org/2003/12/xop/include" xmlns:ns12="https://www.google.com/apis/ads/publisher/v201908"><SOAP-ENV:Header><ns12:RequestHeader><ns12:networkCode>X</ns12:networkCode><ns12:applicationName>X</ns12:applicationName></ns12:RequestHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns12:runReportJob><ns12:reportJob><ns12:reportQuery><ns12:dimensions>ORDER_ID</ns12:dimensions><ns12:dimensions>DATE</ns12:dimensions><ns12:dimensions>LINE_ITEM_ID</ns12:dimensions><ns12:dimensions>LINE_ITEM_TYPE</ns12:dimensions><ns12:dimensions>CREATIVE_ID</ns12:dimensions><ns12:dimensions>AD_UNIT_ID</ns12:dimensions><ns12:adUnitView>FLAT</ns12:adUnitView><ns12:columns>AD_SERVER_IMPRESSIONS</ns12:columns><ns12:columns>AD_SERVER_CLICKS</ns12:columns><ns12:columns>AD_SERVER_CTR</ns12:columns><ns12:startDate><ns12:year>2019</ns12:year><ns12:month>9</ns12:month><ns12:day>10</ns12:day></ns12:startDate><ns12:endDate><ns12:year>2019</ns12:year><ns12:month>9</ns12:month><ns12:day>11</ns12:day></ns12:endDate><ns12:dateRangeType>CUSTOM_DATE</ns12:dateRangeType><ns12:statement><ns12:query>WHERE ORDER_ID=2590671775 AND LINE_ITEM_ID IN (5153520683,5152786449)</ns12:query></ns12:statement><ns12:timeZoneType>PUBLISHER</ns12:timeZoneType></ns12:reportQuery></ns12:reportJob></ns12:runReportJob></SOAP-ENV:Body></SOAP-ENV:Envelope>

>>

And this is the answer I receive:

<<

HTTP/1.1 500 Internal Server Error

Content-Type: text/xml; charset=UTF-8

Date: Tue, 10 Sep 2019 13:15:07 GMT

Expires: Tue, 10 Sep 2019 13:15:07 GMT

Cache-Control: private, max-age=0

X-Content-Type-Options: nosniff

X-Frame-Options: SAMEORIGIN

X-XSS-Protection: 1; mode=block

Server: GSE

Alt-Svc: quic=":443"; ma=2592000; v="46,43,39"

Accept-Ranges: none

Vary: Accept-Encoding

Connection: close

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><ResponseHeader xmlns="https://www.google.com/apis/ads/publisher/v201908"><requestId>3ca7872d5057c6eb437de9b47cea2a23</requestId><responseTime>106</responseTime></ResponseHeader></soap:Header><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'AD_SERVER_CLICKS, AD_SERVER_CTR, AD_SERVER_IMPRESSIONS']</faultstring><detail><ApiExceptionFault xmlns="https://www.google.com/apis/ads/publisher/v201908"><message>[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'AD_SERVER_CLICKS, AD_SERVER_CTR, AD_SERVER_IMPRESSIONS']</message><errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ReportError"><fieldPath>columns</fieldPath><fieldPathElements><field>columns</field></fieldPathElements>

>>

I have reviewed the columns and dimensions I use and I don't find any incompatibility.

What am I doing wrong?

Thanks in advance

Pedro

[Ad Manager API Forum Advisor Prod]

Hi, Pedro.

In your case, you need to make sure the startDate and endDate are not in the future. Give that a try and let me know if it works!

[Pedro Esteras Bustos]

Hi,

I have sent the same example than yesterday, I've only changed start date to 11 and end date to 12 ant it now works. However if I use as an end date another one in the future I receive the same error (it is not too clear). I think this situation didn't happen few days ago.

Thanks

Pedro

[Ad Manager API Forum Advisor Prod]

Hi, Pedro.

The behavior you're describing is correct. For Historical reports, the endDate must not be more than 1 date in the future. Technically, it only makes sense to have an endDate that's in the past or today, but because of timezone issues, we allow the endDate to be up to 1 day in the future.