400 Bad Request when requesting SHOPPING_PERFORMANCE_REPORT
Hi, I always get 400 Bad Request when requesting SHOPPING_PERFORMANCE_REPORT with the following customer id. I have couple other customer ids, which work fine. Only this one has 400 bad request (and there is no other error message), the reportDefinition is set the same for other customer ids too, but others are working fine. Could you help take a look? customer id is 197-931-1608 ReportDefinition is https://adwords.google.com/api/adwords/cm/v201809";> < ns2:fields>MerchantId OfferId < ns2:fields>Brand CategoryL1 < ns2:fields>CategoryL2 CategoryL3 < ns2:fields>CategoryL4 CategoryL5 < ns2:fields>ProductCondition CustomAttribute0 CustomAttribute1 CustomAttribute2 CustomAttribute3 < ns2:fields>CustomAttribute4 ProductTypeL1 ProductTypeL2 ProductTypeL3 ProductTypeL4 ProductTypeL5 Impressions < ns2:dateRange> 20190818 20190825 PRODUCT_STRUCTURE SHOPPING_PERFORMANCE_REPORT CUSTOM_DATE GZIPPED_CSV Thank you, Kain -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/9fe09b80-11d3-4201-aedc-717f385ed9f3%40googlegroups.com.
Re: Downloading Ads report with includeZeroImpressions = false still downloads the creative with impression = 0
Hi Hiroyuki, Thank you so much for your answer. Best, Kain On Thursday, August 22, 2019 at 12:26:57 AM UTC-7, adsapiforumadvisor wrote: > > Hi Kain, > > Thank you for posting your concern. > > *> From the above test result. I have a feeling that in order to exclude > the object with impression = 0 in the report, besides setting > includeZeroImpressions = false, we also need to include the "Impressions" > field into the report download request. So is this expected? * > > Could you confirm if you are using any metric fields in the SELECT clause? > If yes, could you also confirm if the values for the metric fields have > zero values? If the values aren't zero, this is the expected behavior. > Please note that excluding zero impressions with *includeZeroImpressions > = false* has a side effect in that rows are excluded only if all > specified metric fields in the query have zero values. > > > *> In Case 1, actually I'm expecting the creative with impression = 0 > should NOT appear in the report. If this is expected, besides "Impressions" > field, is there any other fields having the similar behavior that affect > the report?* > > If you have any other metric fields in the SELECT clause in your query and > if they have values, they will affect the report. > > You may refer to this guide > <https://developers.google.com/adwords/api/docs/guides/zeroimpression-structure-reports#top_of_page> > for > more details about zero Impression. > > > If this doesn't help to resolve your issue, so I can further investigate, > could you provide the complete report definition > <https://developers.google.com/adwords/api/docs/guides/reporting#create_a_report_definition> > together > with your Client customer ID > <https://developers.google.com/adwords/api/docs/guides/first-api-call#client_customer_id> > ? > > Regards, > Hiroyuki > Google Ads API Team > > > ref:_00D1U1174p._5001UHEJrK:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/f1066ebc-f7cb-4316-bfa2-3100224fce07%40googlegroups.com.
Re: Downloading Ads report with includeZeroImpressions = false still downloads the creative with impression = 0
Hi HIroyuki, Not sure why my previous reply got cut in the middle. If you choose to see the original text, you should be able to see the full content. But let me paste the missing part here. Here is the report definition in Case 2, that the creative with impression = 0 does not show in report. The only difference is in Case 2 here, we have 3 more fields requested, "Impressions", "Cost" and "Clicks". https://adwords.google.com/api/adwords/cm/v201809";> < ns2:fields>Headline HeadlinePart1 < ns2:fields>HeadlinePart2 Description < ns2:fields>Description1 Description2 < ns2:fields>AdType Status DisplayUrl Path1 Path2 CreativeUrlCustomParameters CreativeTrackingUrlTemplate CreativeFinalUrls CreativeFinalMobileUrls DevicePreference ImageCreativeImageWidth ImageCreativeImageHeight ImageAdUrl Id AdGroupId CampaignId ResponsiveSearchAdPath1 ResponsiveSearchAdPath2 ShortHeadline LongHeadline MarketingImageHeadline MarketingImageDescription Impressions Cost Clicks < ns2:predicates> CampaignId IN 6455474065 < ns2:predicates> AdType NOT_IN SHOWCASE_AD < ns2:dateRange> 20190814 20190821 AD_STRUCTURE AD_PERFORMANCE_REPORT CUSTOM_DATE GZIPPED_CSV This is the content in the report (no creative, only headers): Ad,Headline 1,Headline 2,Description,Description line 1,Description line 2,Ad type,Ad state,Display URL,Path 1,Path 2,Custom parameter,Tracking template,Final URL,Mobile final URL,Device preference,Image Width,Image Height,Image Ad URL,Ad ID,Ad group ID,Campaign ID,Responsive Search Ad path 1,Responsive Search Ad path 2,Short headline,Long headline,Gmail ad marketing image headline,Gmail ad marketing image description,Impressions,Cost,Clicks By the way this is the report in case 3, where I set includeZeroImpressions = true and includes the Impressions header. You can see in the last 3 fields, all of them are 0, which is expected. Ad,Headline 1,Headline 2,Description,Description line 1,Description line 2,Ad type,Ad state,Display URL,Path 1,Path 2,Custom parameter,Tracking template,Final URL,Mobile final URL,Device preference,Image Width,Image Height,Image Ad URL,Ad ID,Ad group ID,Campaign ID,Responsive Search Ad path 1,Responsive Search Ad path 2,Short headline,Long headline,Gmail ad marketing image headline,Gmail ad marketing image description,Impressions,Cost,Clicks ,mpm-1340-head-line-1,mpm-1340-head-line-2,mpm-1340-desc-1,,,Expanded text ad,enabled,,p1,p2, --, --,"[""https://www.powpow.com""]";, --, --, --, --, --,378574373950,78915899202,6455474065, --, --, --, --, --, --,0,0,0 Thank you, Kain On Thursday, August 22, 2019 at 11:52:58 AM UTC-7, Kain wrote: > > Hi Hiroyuki, > > Thank you for your reply. > > Yes I understand the point that when setting includeZeroImpressions = > false, "Impressions" is not the only field that adwords api checks if it's > 0 or not, couple more fields also matter. > > But in my Case 2 above, I set includeZeroImpressions = false (same as Case > 1), and I included the "Impressions"(together with "Cost","Clicks") field > in my report download request (which is the only difference from Case 1). > But in case 2, in the report, this creative does not show up (meaning the > impression and all related metric fields are actually 0), but in Case 1, it > shows up in the report. > > My client cusomter id is "212-438-1568". The creative id is 378574373950. > Here is the report definition in Case 1, that the creative with impression > = 0 shows in report. > > https://adwords.google.com/api/adwords/cm/v201809";> < > ns2:fields>Headline HeadlinePart1 < > ns2:fields>HeadlinePart2 Description > Description1 Description2 > AdType Status < > ns2:fields>DisplayUrl Path1 < > ns2:fields>Path2 CreativeUrlCustomParameters ns2:fields> CreativeTrackingUrlTemplate < > ns2:fields>CreativeFinalUrls > CreativeFinalMobileUrls DevicePreference ns2:fields> ImageCreativeImageWidth > ImageCreativeImageHeight ImageAdUrl > Id AdGroupId >CampaignId ResponsiveSearchAdPath1 > ResponsiveSearchAdPath2 ShortHeadline > LongHeadline > MarketingImageHeadline MarketingImageDescription > CampaignId < > ns2:operator>IN 6455474065 ns2:predicates> AdType < > ns2:operator>NOT_IN SHOWCASE_AD ns2:predicates> 20190814 > 20190821 > AD_STRUCTURE AD_PERFORMANCE_REPORT ns2:reportType> CUSTOM_DATE < > ns2:downloadFormat>GZIPPED_CSV > > And here is content in the report (creative shows): > > Ad,Headline 1,Headline 2,Description,Description line 1,Description line > 2,Ad type,Ad state,Display URL,Path 1,Path 2,Custom parameter,Tracking > template,Final URL,Mobile final URL,Device
Re: Downloading Ads report with includeZeroImpressions = false still downloads the creative with impression = 0
Hi Hiroyuki, Thank you for your reply. Yes I understand the point that when setting includeZeroImpressions = false, "Impressions" is not the only field that adwords api checks if it's 0 or not, couple more fields also matter. But in my Case 2 above, I set includeZeroImpressions = false (same as Case 1), and I included the "Impressions"(together with "Cost","Clicks") field in my report download request (which is the only difference from Case 1). But in case 2, in the report, this creative does not show up (meaning the impression and all related metric fields are actually 0), but in Case 1, it shows up in the report. My client cusomter id is "212-438-1568". The creative id is 378574373950. Here is the report definition in Case 1, that the creative with impression = 0 shows in report. https://adwords.google.com/api/adwords/cm/v201809";> < ns2:fields>Headline HeadlinePart1 < ns2:fields>HeadlinePart2 Description < ns2:fields>Description1 Description2 < ns2:fields>AdType Status DisplayUrl Path1 Path2 CreativeUrlCustomParameters CreativeTrackingUrlTemplate CreativeFinalUrls CreativeFinalMobileUrls DevicePreference ImageCreativeImageWidth ImageCreativeImageHeight ImageAdUrl Id AdGroupId CampaignId ResponsiveSearchAdPath1 ResponsiveSearchAdPath2 ShortHeadline LongHeadline MarketingImageHeadline MarketingImageDescription CampaignId IN 6455474065 AdType NOT_IN SHOWCASE_AD 20190814 < ns2:max>20190821 AD_STRUCTURE AD_PERFORMANCE_REPORT CUSTOM_DATE < ns2:downloadFormat>GZIPPED_CSV And here is content in the report (creative shows): Ad,Headline 1,Headline 2,Description,Description line 1,Description line 2,Ad type,Ad state,Display URL,Path 1,Path 2,Custom parameter,Tracking template,Final URL,Mobile final URL,Device preference,Image Width,Image Height,Image Ad URL,Ad ID,Ad group ID,Campaign ID,Responsive Search Ad path 1,Responsive Search Ad path 2,Short headline,Long headline,Gmail ad marketing image headline,Gmail ad marketing image description ,mpm-1340-head-line-1,mpm-1340-head-line-2,mpm-1340-desc-1,,,Expanded text ad,enabled,,p1,p2, --, --,"[""https://www.powpow.com""]";, --, --, --, --, --,378574373950,78915899202,6455474065, --, --, --, --, --, -- Here is the report definition in Case 2, that the creative with impression = 0 does not show in report. The only difference is in Case 2 here, we have 3 more fields requested, "Impressions", "Cost" and "Clicks". https://adwords.google.com/api/adwords/cm/v201809";> < ns2:fields>Headline HeadlinePart1 < ns2:fields>HeadlinePart2 Description < ns2:fields>Description1 Description2 < ns2:fields>AdType Status DisplayUrl Path1 Path2 CreativeUrlCustomParameters CreativeTrackingUrlTemplate CreativeFinalUrls CreativeFinalMobileUrls DevicePreference ImageCreativeImageWidth ImageCreativeImageHeight ImageAdUrl Id AdGroupId CampaignId ResponsiveSearchAdPath1 ResponsiveSearchAdPath2 ShortHeadline LongHeadline MarketingImageHeadline MarketingImageDescription Impressions Cost Clicks < ns2:predicates> CampaignId IN 6455474065 < ns2:predicates> AdType NOT_IN SHOWCASE_AD < ns2:dateRange> 20190814 20190821 AD_STRUCTURE AD_PERFORMANCE_REPORT CUSTOM_DATE GZIPPED_CSV This is the content in the report (no creative, only headers): Ad,Headline 1,Headline 2,Description,Description line 1,Description line 2,Ad type,Ad state,Display URL,Path 1,Path 2,Custom parameter,Tracking template,Final URL,Mobile final URL,Device preference,Image Width,Image Height,Image Ad URL,Ad ID,Ad group ID,Campaign ID,Responsive Search Ad path 1,Responsive Search Ad path 2,Short headline,Long headline,Gmail ad marketing image headline,Gmail ad marketing image description,Impressions,Cost,Clicks By the way this is the report in case 3, where I set includeZeroImpressions = true and includes the Impressions header. You can see in the last 3 fields, all of them are 0, which is expected. Ad,Headline 1,Headline 2,Description,Description line 1,Description line 2,Ad type,Ad state,Display URL,Path 1,Path 2,Custom parameter,Tracking template,Final URL,Mobile final URL,Device preference,Image Width,Image Height,Image Ad URL,Ad ID,Ad group ID,Campaign ID,Responsive Search Ad path 1,Responsive Search Ad path 2,Short headline,Long headline,Gmail ad marketing image headline,Gmail ad marketing image description,Impressions,Cost,Clicks ,mpm-1340-head-line-1,mpm-1340-head-line-2,mpm-1340-desc-1,,,Expanded text ad,enabled,,p1,p2, --, --,"[""https://www.powpow.com""]";, --, --, --, --, --,378574373950,78915899202,6455474065, --, --, --, --, --, --,0,0,0 Thank you, Kain On Thursday, August 22, 2019 at 12:26:57 AM UTC-7, adsapiforumadvisor wrote: > > Hi Kain, > > Thank you for posting your concern. > >
Downloading Ads report with includeZeroImpressions = false still downloads the creative with impression = 0
Hi, I have a question with regard to the behavior of using ReportDefinition and ReportDownloader from package com.google.api.ads.adwords.lib.utils.v201809. So I want to download the ad report WITHOUT the object of impression = 0. Here is the observation when I did my test. Case 1: * set includeZeroImpressions = false * Specify couple ad fields like Headline, Id, AdGroupId, CampaignId, etc, but NO "Impressions" field. In the report, my creative of impression = 0 appears. Case 2: * set includeZeroImpressions = false * Specify couple ad fields together with "Impressions" field. In the report, my creative of impression = 0 doesn't appear. Case 3: * set includeZeroImpressions = true * Specify couple ad fields together with "Impressions" field. In the report, my creative of impression = 0 appears. >From the above test result. I have a feeling that in order to exclude the object with impression = 0 in the report, besides setting includeZeroImpressions = false, we also need to include the "Impressions" field into the report download request. So is this expected? In Case 1, actually I'm expecting the creative with impression = 0 should NOT appear in the report. If this is expected, besides "Impressions" field, is there any other fields having the similar behavior that affect the report? Thank you, Kain -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/446c0f8b-7a9b-4393-8ec3-c94703c68823%40googlegroups.com.
Removing campaign via api gives error missing operations[0].operand.settings[0].languageCode & operations[0].operand.settings[0].domainName
I want to remove campaign via api (meaning SET campaign status to REMOVED according to google api https://developers.google.com/adwords/api/docs/samples/php/basic-operations#remove-a-campaign) The issue is that it asks me for the languageCode and domainName (which are dynamic search ads fields), why removing a campaign needs these two fields? And I don't think my campaign is a dynamic search ad campaign. It succeeded if I set campaign status to PAUSED or ENABLED, only REMOVED does not work. Please help! thank you! The soap request looks like: http://schemas.xmlsoap.org/soap/envelope/"; xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> https://adwords.google.com/api/adwords/cm/v201710"; soapenv:mustUnderstand="0"> 123-345-1008 REDACTED xxx (AwApi-Java, AdWords-Axis/3.10.0, Common-Java/3.10.0, Axis/1.4, Java/1.8.0_91, maven) false false https://adwords.google.com/api/adwords/cm/v201710";> SET 1408927584 campaginBudget1 REMOVED SERVING 20180518 20371230 1464626154 123 STANDARD false ENABLED https://adwords.google.com/api/adwords/cm/v201710"; xsi:type="ns2:DynamicSearchAdsSetting"/> SEARCH true true true false https://adwords.google.com/api/adwords/cm/v201710"; xsi:type="ns3:ManualCpcBiddingScheme"> false And the response looks like: http://schemas.xmlsoap.org/soap/envelope/";> https://adwords.google.com/api/adwords/cm/v201710";> 00056cd075b736a10a62aa13bd094b12 CampaignService mutate 1 80 soap:Client [RequiredError.REQUIRED @ operations[0].operand.settings[0].domainName, RequiredError.REQUIRED @ operations[0].operand.settings[0].languageCode] https://adwords.google.com/api/adwords/cm/v201710";> [RequiredError.REQUIRED @ operations[0].operand.settings[0].domainName, RequiredError.REQUIRED @ operations[0].operand.settings[0].languageCode] ApiException http://www.w3.org/2001/XMLSchema-instance"; xsi:type="RequiredError"> operations[0].operand.settings[0].domainName operations 0 operand settings 0 domainName RequiredError.REQUIRED RequiredError REQUIRED http://www.w3.org/2001/XMLSchema-instance"; xsi:type="RequiredError"> operations[0].operand.settings[0].languageCode operations 0 operand settings 0 languageCode RequiredError.REQUIRED RequiredError REQUIRED -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options,