ERROR_GETTING_RESPONSE_FROM_BACKEND- Unable to read report data

[Sabri Karagönen]

Hi, I'm trying to download a report using KEYWORDS_PERFORMANCE_REPORT.

Normally, I can download this report succesfully. However, when I add labels to filter this report, I get error below:

ERROR_GETTING_RESPONSE_FROM_BACKEND- Unable to read report data.

My XML output is below, so you can examine it with details.

1. in ReportUtils.php line 202
2. at ReportUtils::DownloadReportFromUrl('https://adwords.google.com/api/adwords/reportdownload/v201603', array('Authorization' => '***', 'developerToken' => '***', 'clientCustomerId' => '***', 'skipReportHeader' => 'true', 'skipColumnHeader' => 'true', 'skipReportSummary' => 'true'), array('__rdxml' => '<?xml version="1.0" encoding="UTF-8"?> <reportDefinition><selector><fields>Date</fields><fields>CampaignId</fields><fields>AdGroupId</fields><fields>Id</fields><fields>Criteria</fields><fields>CpcBid</fields><fields>Impressions</fields><fields>Clicks</fields><fields>ConvertedClicks</fields><fields>Conversions</fields><predicates><field>CampaignStatus</field><operator>IN</operator><values>ENABLED</values></predicates><predicates><field>AdGroupStatus</field><operator>IN</operator><values>ENABLED</values></predicates><predicates><field>Status</field><operator>NOT_IN</operator><values>PAUSED</values></predicates><predicates><field>AdNetworkType2</field><operator>IN</operator><values>SEARCH</values><values>SEARCH_PARTNERS</values></predicates><predicates><field>Labels</field><operator>CONTAINS_ANY</operator><values>BRND</values><values>Brand</values></predicates><dateRange><min>20160708</min><max>20160717</max></dateRange></selector><reportName>Criteria performance report #578d6b95d7483</reportName><reportType>KEYWORDS_PERFORMANCE_REPORT</reportType><dateRangeType>CUSTOM_DATE</dateRangeType><downloadFormat>XML</downloadFormat></reportDefinition>'), null)

How can I fix this error?

[Michael Cloonan (AdWords API Team)]

Hello,

I am not able to reproduce this error. I'm wondering if it was a temporary issue. Is this still happening for you if you run the query now?

If it is, can you send me the customer ID you're running the query against so I can try running it on the account where it's actually happening?

Regards,

Mike, AdWords API Team

[joel]

I'm seeing this consistently with just 1 of our accounts as well. The customer id is 3177205665. This has happened repeatedly for 2 days now, so it doesn't seem temporary. Can you investigate with this customer id?

Joel

[Michael Cloonan (AdWords API Team)]

Hello,

Thank you for the customer ID. Can you also please provide a report definition or AWQL that fails, that works when only removing the label filter? As I am still unable to reproduce, these will hopefully help narrow down the specific circumstance that is causing this issue.

Regards,

Mike, AdWords API Team

[joel]

It's the KEYWORDS_PERFORMANCE_REPORT

Include 0 impressions = true

Format = GZIPPED CSV

Date Range = 20160728-20160728

Fields: AdGroupId, AverageCpc, AveragePosition, Clicks, Cost, FinalUrls, FirstPageCpc, Id, Impressions, CpcBid, QualityScore, TopOfPageCpc, AdGroupStatus, CampaignId, CampaignStatus, SearchPredictedCtr, PostClickQualityScore, CreativeQualityScore, FirstPositionCpc, EstimatedAddClicksAtFirstPositionCpc, EstimatedAddCostAtFirstPositionCpc

Thanks!

Joel

[Michael Cloonan (AdWords API Team)]

Hello,

Those are some other type of logging. That is not the report definition or the AWQL. I did my best to try to construct a query based on the information you provided, but was still unable to reproduce the issue. Please provide the specific report definition or AWQL you are using, both the one that succeeds without the references to Labels and the one that fails including it, so that I can attempt to reproduce the issue.

Regards,

Mike, AdWords API Team

[Tyler Murphy]

I think I'm having a similar issue. The following query for customer ID 763-523-8060 and API version v201607, without a label filter, works:

SELECT Cost,Labels FROM CAMPAIGN_PERFORMANCE_REPORT DURING 20160912,20160918

And this one, with a label filter, doesn't work:

SELECT Cost,Labels FROM CAMPAIGN_PERFORMANCE_REPORT WHERE Labels CONTAINS_ALL ["PLAs"] DURING 20160912,20160918

It results in this error:

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

<reportDownloadError>

    <ApiError>

        <type>ReportDownloadError.ERROR_GETTING_RESPONSE_FROM_BACKEND</type>

        <trigger>Unable to read report data</trigger>

        <fieldPath></fieldPath>

    </ApiError>

</reportDownloadError>

Please let me know if more information would be helpful. Thanks!

[Michael Cloonan (AdWords API Team)]

Hello,

I have learned that in CONTAINS_ALL queries for labels, you have to specify the Label ID, not the string. Please try again with the ID for "PLAs" and let me know if that works.

Regards,

Mike, AdWords API Team

[Tyler Murphy]

Yep, that works. Thanks for the help.

[Tyler Murphy]

Will the behavior be changed so that it works the way it's supposed to?

[Michael Cloonan (AdWords API Team)]

Hello,

The current behavior is the intended behavior. I was under an incorrect impression when I was first trying to diagnose the issue.

Regards,

Mike, AdWords API Team

[Tyler Murphy]

That's surprising. All other fields I know of filter on the same values you'd get if you included the field in your SELECT clause. There are both "Labels" and "LabelIds" fields for the CAMPAIGN_PERFORMANCE_REPORT. Why does a filter for "Labels" filter on the "LabelIds" values?

In any case, could a more helpful error message be returned? An update to the documentation to point out the way this works might also be helpful.

[Michael Cloonan (AdWords API Team)]

Hello,

I will look into how we can improve this to be more discoverable. That is a good point that the field name represents different pieces of data depending on the context.

Thanks for the feedback.

Regards,

Mike, AdWords API Team

[defrancos]

Hi all.

Same point here: I'm surprised that it is by Label ID, not Label name.

Anyway, thank you  Michael for your reply!

regards

/e