This is the request { url: 'https://googleads.googleapis.com/v9/customers/5171512735/googleAds:search', json: true, body: { query: "SELECT customer.id, campaign.id, campaign.name, ad_group.id, ad_group.name, ad_group_ad.ad.id, ad_group_ad.ad.name, ad_group_ad.ad.legacy_responsive_display_ad.marketing_image, ad_group_ad.ad.legacy_responsive_display_ad.long_headline, ad_group_ad.ad.legacy_responsive_display_ad.description, ad_group_ad.ad.responsive_display_ad.descriptions, ad_group_ad.ad.responsive_display_ad.headlines, ad_group_ad.ad.responsive_display_ad.logo_images, ad_group_ad.ad.responsive_display_ad.long_headline, ad_group_ad.ad.responsive_display_ad.marketing_images, ad_group_ad.ad.responsive_display_ad.square_logo_images, ad_group_ad.ad.responsive_display_ad.square_marketing_images, ad_group_ad.ad.image_ad.image_url, ad_group_ad.ad.image_ad.name, segments.month, campaign.advertising_channel_type, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.conversions_value, metrics.cost_per_conversion, metrics.interactions, metrics.view_through_conversions FROM ad_group_ad WHERE segments.month BETWEEN '2021-12-01' AND '2021-12-31' AND campaign.advertising_channel_type IN ('DISPLAY') ORDER BY ad_group_ad.ad.id ASC", page_size: 1000 } }
This is the response { "error":{ "code":400, "message":"Request contains an invalid argument.", "status":"INVALID_ARGUMENT", "details":[{ "@type":"type.googleapis.com/google.ads.googleads.v9.errors.GoogleAdsFailure", "errors":[{ "errorCode":{ "queryError":"MISALIGNED_DATE_FOR_FILTER"}, "message":"Dates in conditions should be the start of week/month/quarter if the filtered field is segments.week/segments.month/segments.quarter.", "trigger":{ "stringValue":"segments.month"} } ], "requestId":"IdF3phOGu8m0kgegNK0m2Q" } ]} } On Thursday, 27 January 2022 at 16:24:32 UTC+9 adsapi wrote: > Hello Azfar, > > Thank you for reaching out to our team. > > To investigate the issue '*MISALIGNED_DATE_FOR_FILTER*' error that you've > mentioned and to address it, please provide us with the > complete *request* > <https://developers.google.com/google-ads/api/docs/concepts/field-service#request> > and *response* > <https://developers.google.com/google-ads/api/docs/concepts/field-service#response> > logs > with *request ID* > <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id> > and *request header* > <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers> > generated > on your end. > > You may send the requested information via the *Reply privately to the > author option*. If this option is not available, you may send the details > directly to our googleadsa...@google.com > <https://mail.google.com/mail/u/0/?fs=1&tf=cm&source=mailto&to=googleadsapi-supp...@google.com> > alias > instead. > > Best regards, > [image: Google Logo] > Jinky Mandaya > Google Ads API Team > > > ref:_00D1U1174p._5004Q2VPvfo: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 "Google Ads API and AdWords 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/e80298f5-ff4d-4096-842f-eb23750f5641n%40googlegroups.com.