Hello,
I trying to migrate my google ads from v8 to v9.
I was using the same query on v8
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
But now it throwing an error saying that the date format is wrong.
This is the error message I got from google itself
{"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":"QFppm0p9hnbz5z4exmHgBA"}]}}}
I already follow the format of YYYY-MM-DD even the query validator say my
query is wrong when 2021-12-01 is already the first day of the month
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/fae2b8cb-cd52-4ffe-b262-14b14198d9c0n%40googlegroups.com.
