ERROR_GETTING_RESPONSE_FROM_BACKEND when including CampaignId in PLACEHOLDER_FEED_ITEM_REPORT

[Jeremy Aube]

I'm trying to get a PLACEHOLDER_FEED_ITEM_REPORT that includes CampaignId, but so far I keep getting this error:

AdwordsApi::Errors::ReportXmlError - HTTP code: 500, error type: 'ReportDownloadError.ERROR_GETTING_RESPONSE_FROM_BACKEND', trigger: 'Unable to read report data', field path: '':

The report works just fine if I remove the CampaignId field. Other fields like CampaignName, AdGroupId, and AdGroupName result in the same error. 

Other attribute fields are working fine. For example, I can include AttributeValues, FeedId, or FeedItemId without any problems. 

I saw another post where the issue seemed to have something to do with not including any metrics, but I am requesting metrics. There was also another post regarding an implied campaign_id, but I don't think that applies here.

[Josh Radcliff (AdWords API Team)]

Hi Jeremy,

Could you provide the complete report request after removing any sensitive information? I just successfully ran the PLACEHOLDER_FEED_ITEM_REPORT with the fields mentioned below. I'd like to see which fields and predicates you are using -- it may be that you found certain combinations that aren't working.

Thanks,

Josh, AdWords API Team

[Anash P. Oommen (AdWords API Team)]

Hi Jeremy,

ERROR_GETTING_RESPONSE_FROM_BACKEND usually happens when the amount of data being requested is very large, and there is a timeout between the API server and stats server. Try reducing the size of the report by removing some columns, or restricting the report to a shorter date range / fewer campaigns. Let me know if that doesn't work, and I'll investigate this further.

Cheers,

Anash P. Oommen,
AdWords API Advisor.

On Wednesday, May 14, 2014 4:52:10 PM UTC-4, Jeremy Aube wrote:

[Jeremy Aube]

I tried reducing the size of the request, but I'm still getting the same error. Here's the report definition I just tried:

<reportDefinition>

  <selector>

    <fields>CampaignId</fields>

    <fields>Clicks</fields>

    <predicates>

      <field>ClickType</field>

      <operator>IN</operator>

      <values>SITELINKS</values>

    </predicates>

    <predicates>

      <field>IsSelfAction</field>

      <operator>IN</operator>

      <values>true</values>

    </predicates>

    <predicates>

      <field>Status</field>

      <operator>IN</operator>

      <values>ACTIVE</values>

    </predicates>

    <predicates>

      <field>CampaignId</field>

      <operator>IN</operator>

      <values>39258782</values>

    </predicates>

  </selector>

  <reportName>Placeholder+Feed+Item+Report</reportName>

  <reportType>PLACEHOLDER_FEED_ITEM_REPORT</reportType>

  <dateRangeType>YESTERDAY</dateRangeType>

  <downloadFormat>CSV</downloadFormat>

  <includeZeroImpressions>true</includeZeroImpressions>

</reportDefinition>

[Pearl Jam]

Hi,

we have the same problem.
We are using java-api and if we download a report for a certain account with only FeedId, FeedItemId and Impressions, we get less than 100 feedItems, thats good.
But if we include CampaignId or CampaignName or AdGroupId or AdGroupName, we get

com.google.api.ads.adwords.lib.utils.v201402.DetailedReportDownloadResponseException: 500
    at com.google.api.ads.adwords.lib.utils.v201402.ReportDownloader.handleResponse(ReportDownloader.java:119) ~[ads-lib-1.26.0.jar:na]
    at com.google.api.ads.adwords.lib.utils.v201402.ReportDownloader.downloadReport(ReportDownloader.java:93) ~[ads-lib-1.26.0.jar:na]
with trigger=Unable to read report data

Jam

[Pearl Jam]

aahhh, i think i solved it...
you have to set includeZeroImpressions to false, otherwise there are too much combination possibilities....

Jam =)

[Pearl Jam]

One last thought : in the documentation of Placeholder Feed Item Report  for CampaignId/CampaignName/AdGroupId/AdGroupName/AdId Behavior should be marked as Segment, not as Attribute

Jam

[Joel]

I've been playing with this recently too and I'm getting the ERROR_GETTING_RESPONSE_FROM_BACKEND error. I don't believe it's a case of too much data since I'm experimenting with an Account that only has 1 campaign. What I'm trying to accomplish is to generate a Report that lists all the SiteLinks mapped to each Campaign along with their approval status and feed item details. Stats like impressions/clicks would be nice but are optional since I can pull those separately. Is there a way to get this via Reports?

Joel

[Pearl Jam]

Unfortunately, I think there is no mappingInfo provided in the report. It only shows FeedItems and in which Campaign or Adgroup it has Impressions or otherwise stats. because an feedItem could be mapped to every campaign or adgroup in your account, the
combination possibilities are too much if you ask with zeroImpressions. also you can not limit the results by asking only for Active Adgroups or Campaigns


therefore my next Question: where can FeedItem-Adgroup-Matchings be obtained?

Jam

[Jeremy Aube]

It looks like this report pretty much needs zeroImpressions to be set to false, otherwise most combinations won't work. We were able to get most of what we needed this way, though it probably should be made more clear from the documentation that this report won't work with zeroImpressions set to true for all but the most basic requests.

[Chirag]

Hello,

We are also facing same issue for some of reports. And We have already make include Zero Impressions data to false.

Thanks,

[Tirtha Ghosh Dastidar]

Hi Team,

What if we need to download zero impressions too? I am getting this error when I am downloading keyword performance with zero impressions= True to build my structure data.

[Anash P. Oommen (AdWords API Team)]

Hi Tirtha,

Could you kindly open a new thread if the issue persists? ERROR_GETTING_RESPONSE_FROM_BACKEND is a somewhat generic error, so your issue might be unrelated to this old thread.

Cheers

Anash P. Oommen

AdWords API Advisor.