Hi Jatin, Allow me to provide support as Luis is currently OOO. Regarding your issue with not being able to generate the Geo Performance Report, the 788-458-2821 account ID you provided belongs to a MCC account. This MCC account ID cannot be used as your clientCustomerId to download an AdWords API report as reports can only be downloaded per client account <https://developers.google.com/adwords/api/docs/guides/reporting#reports_for_multiple_accounts>. Unless you are using the Parallel Report Download <https://developers.google.com/adwords/api/docs/samples/java/reporting#download-a-report-for-multiple-accounts> example, only then can you specify a MCC account ID as the clientCustomerId.
That being said, could you retry your request and use a client account ID instead? I also noticed that you are retrieving all the fields of the Geo Performance Report. Doing so might result to a timeout <https://developers.google.com/adwords/api/docs/guides/reporting#timeouts> due to the volume of information you are using. You may need to reduce the number of fields or break down your report using predicates to avoid the said timeouts. Should the issue persist, you may send to me privately your clientCustomerId (account ID of the client account) and your updated report definition <https://developers.google.com/adwords/api/docs/guides/reporting#create_a_report_definition> so I can further investigate. Thanks and regards, Peter AdWords API Team On Monday, September 24, 2018 at 2:15:34 AM UTC+8, Jatin Katyal wrote: > > Hi Luis, > > Like in our private conversation, i can download reports for campaign, > click and keyword performance reports using my customer client id. Only Geo > performance report is giving the issue. Another strange thing that i > noticed is that, I can't download same using the Web UI too. Page keeps on > waiting for response when i try to download geo performance report. I > suspect there is something wrong with geo performance reports. > > On Friday, September 21, 2018 at 9:03:00 AM UTC+5:30, Luis Xander Talag > (AdWords API Team) wrote: >> >> Hi Jatin, >> >> Thank you for providing additional information. However, I would need >> your clientCustomerID to check this further on my end. Could you provide >> your clientCustomerId and reply to me via *Reply privately to author*. >> >> Regards, >> Luis >> AdWords API Team >> >> >> On Thursday, September 20, 2018 at 8:12:24 PM UTC+8, Jatin Katyal wrote: >>> >>> Hi Luis, thanks for looking into issue and sorry for late reply. I tried >>> using predicate reduce size, also for simplicity, now i am looking for >>> YESTERDAY only. Here is the new report definition. >>> >>> report_definition = { >>> 'reportName': 'Custom GEO_PERFORMANCE_REPORT', >>> 'dateRangeType': 'YESTERDAY', >>> 'reportType': 'GEO_PERFORMANCE_REPORT', >>> 'downloadFormat': 'CSV', >>> 'selector': { >>> 'fields': ['AccountCurrencyCode,' >>> 'AccountDescriptiveName,' >>> 'AccountTimeZone,' >>> 'CampaignId,' >>> 'CampaignName', >>> 'CampaignStatus', >>> 'CityCriteriaId', >>> 'CountryCriteriaId', >>> 'CustomerDescriptiveName', >>> 'ExternalCustomerId', >>> 'IsTargetingLocation', >>> 'MetroCriteriaId', >>> 'MostSpecificCriteriaId', >>> 'RegionCriteriaId', >>> 'AdFormat', >>> 'AdGroupId', >>> 'AdGroupName', >>> 'AdGroupStatus', >>> 'Date', >>> 'DayOfWeek', >>> 'Device', >>> 'LocationType', >>> 'Month', >>> 'MonthOfYear,' >>> 'Quarter,' >>> 'Week,' >>> 'Year,' >>> 'AllConversionRate,' >>> 'AllConversions,' >>> 'AllConversionValue,' >>> 'AverageCost,' >>> 'AverageCpc,' >>> 'AverageCpm,' >>> 'AverageCpv,' >>> 'AveragePosition,' >>> 'Clicks,' >>> 'ConversionRate,' >>> 'Conversions,' >>> 'ConversionValue', >>> 'Cost', >>> 'CostPerAllConversion', >>> 'CostPerConversion', >>> 'CrossDeviceConversions', >>> 'Ctr', >>> 'Impressions', >>> 'InteractionRate', >>> 'Interactions', >>> 'InteractionTypes', >>> 'ValuePerAllConversion', >>> 'ValuePerConversion', >>> 'VideoViewRate', >>> 'VideoViews', >>> 'ViewThroughConversions'], >>> 'predicates': { >>> 'field': 'CityCriteriaId', >>> 'operator': 'IN', >>> 'values': ['1017310','1016479'] >>> } >>> } >>> } >>> >>> On Wednesday, September 19, 2018 at 12:33:23 PM UTC+5:30, Luis Xander >>> Talag (AdWords API Team) wrote: >>>> >>>> Hi Jatin, >>>> >>>> Thank you for providing your report definition. The error code 400 that >>>> you encountered could be due to timeouts >>>> <https://developers.google.com/adwords/api/docs/guides/reporting#timeouts>. >>>> >>>> This error usually occurs when generating large amount of data. I would >>>> suggest to check your date range and add more filters to lessen the result >>>> of your data. >>>> >>>> If you still encounter any error after doing my suggestions, could you >>>> provide your latest report definition >>>> <https://developers.google.com/adwords/api/docs/guides/reporting#create_a_report_definition> >>>> >>>> as well as your clientCustomerId and the date range that you used to >>>> generate the report so I could further investigate the issue? Please reply >>>> via *Reply privately to author.* >>>> >>>> Thanks and regards, >>>> Luis >>>> AdWords API Team >>>> >>>> On Wednesday, September 19, 2018 at 4:57:47 AM UTC+8, Jatin Katyal >>>> wrote: >>>>> >>>>> Hello >>>>> I am trying to download GEO_PERFORMANCE_REPORT, but i receive this >>>>> error "Report failed for customer ID #### with code 400 after 1 retries". >>>>> From my past experience, i know this might be related to report >>>>> definition, >>>>> but i couldn't fine any faults in it. Here is the report definition: >>>>> >>>>> report_definition = { >>>>> 'reportName': 'Custom GEO_PERFORMANCE_REPORT', >>>>> 'dateRangeType': 'CUSTOM_DATE', >>>>> 'reportType': 'GEO_PERFORMANCE_REPORT', >>>>> 'downloadFormat': 'CSV', >>>>> 'selector': { >>>>> 'fields': ['AccountCurrencyCode', >>>>> 'AccountDescriptiveName', >>>>> 'AccountTimeZone', >>>>> 'CampaignId', >>>>> 'CampaignName', >>>>> 'CampaignStatus', >>>>> 'CityCriteriaId', >>>>> 'CountryCriteriaId', >>>>> 'CustomerDescriptiveName', >>>>> 'ExternalCustomerId', >>>>> 'IsTargetingLocation', >>>>> 'MetroCriteriaId', >>>>> 'MostSpecificCriteriaId', >>>>> 'RegionCriteriaId', >>>>> 'layers Segment', >>>>> 'AdFormat', >>>>> 'AdGroupId', >>>>> 'AdGroupName', >>>>> 'AdGroupStatus', >>>>> 'AdNetworkType1', >>>>> 'AdNetworkType2', >>>>> 'Date', >>>>> 'DayOfWeek', >>>>> 'Device', >>>>> 'LocationType', >>>>> 'Month', >>>>> 'MonthOfYear', >>>>> 'Quarter', >>>>> 'Week', >>>>> 'Year', >>>>> 'show_chart Metric', >>>>> 'AllConversionRate', >>>>> 'AllConversions', >>>>> 'AllConversionValue', >>>>> 'AverageCost', >>>>> 'AverageCpc', >>>>> 'AverageCpm', >>>>> 'AverageCpv', >>>>> 'AveragePosition', >>>>> 'Clicks', >>>>> 'ConversionRate', >>>>> 'Conversions', >>>>> 'ConversionValue', >>>>> 'Cost', >>>>> 'CostPerAllConversion', >>>>> 'CostPerConversion', >>>>> 'CrossDeviceConversions', >>>>> 'Ctr', >>>>> 'Impressions', >>>>> 'InteractionRate', >>>>> 'Interactions', >>>>> 'InteractionTypes', >>>>> 'ValuePerAllConversion', >>>>> 'ValuePerConversion', >>>>> 'VideoViewRate', >>>>> 'VideoViews', >>>>> 'ViewThroughConversions'], >>>>> 'dateRange':{ >>>>> 'min': report_dt, >>>>> 'max': report_dt >>>>> } >>>>> } >>>>> } >>>>> >>>>> Please help in figuring out the issue. >>>>> >>>>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/617b6db5-51b9-46d8-a5ad-2fb6232a976c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
