Hi Google Ads API support team!
I have the next issue:
Host: "googleads.googleapis.com", Method:
"/google.ads.googleads.v11.services.GoogleAdsService/SearchStream",
CustomerId: hidden, RequestId: "VGS08iw7j0LjMzEYE6owQQ", IsFault: 1,
FaultMessage: "["The following fields may not be used in SELECT clause:
'ad_group_ad.ad.responsive_display_ad.marketing_images.asset',
'ad_group_ad.ad.responsive_display_ad.youtube_videos.asset'."]"
[2022-08-11T13:04:07.322330+00:00] google-ads.NOTICE: Request
-------
Method Name:
/google.ads.googleads.v11.services.GoogleAdsService/SearchStream
Host: googleads.googleapis.com
Headers: {
"x-goog-api-client": "gl-php\/8.0.12 gccl\/16.0.0 gapic\/16.0.0
gax\/1.14.0 grpc\/1.42.0 rest\/1.14.0 pb\/3.19.1+c",
"x-goog-request-params": "customer_id=hidden",
"developer-token": "REDACTED",
"login-customer-id": "hidden"
}
"query":"SELECT campaign.id, ad_group.id, segments.ad_network_type,
ad_group_ad.ad.id, ad_group_ad.ad.type, ad_group_ad.status,
ad_group_ad.ad.final_app_urls, ad_group_ad.ad.final_mobile_urls,
ad_group_ad.ad.final_urls, ad_group_ad.ad.display_url, ad_group_ad.labels,
ad_group_ad.ad.expanded_text_ad.headline_part1,
ad_group_ad.ad.expanded_text_ad.headline_part2,
ad_group_ad.ad.expanded_text_ad.headline_part3,
ad_group_ad.ad.expanded_text_ad.path1,
ad_group_ad.ad.expanded_text_ad.path2,
ad_group_ad.ad.expanded_text_ad.description,
ad_group_ad.ad.expanded_text_ad.description2, ad_group_ad.ad.name,
ad_group_ad.ad.image_ad.name, ad_group_ad.ad.image_ad.pixel_height,
ad_group_ad.ad.image_ad.pixel_width, ad_group_ad.ad.image_ad.image_url,
ad_group_ad.ad.image_ad.preview_image_url,
ad_group_ad.ad.image_ad.preview_pixel_height,
ad_group_ad.ad.image_ad.preview_pixel_width,
ad_group_ad.ad.call_ad.phone_number, ad_group_ad.ad.call_ad.description1,
ad_group_ad.ad.call_ad.description2, ad_group_ad.ad.call_ad.business_name,
ad_group_ad.ad.call_ad.headline1, ad_group_ad.ad.call_ad.headline2,
ad_group_ad.ad.call_ad.call_tracked,
ad_group_ad.ad.call_ad.disable_call_conversion,
ad_group_ad.ad.call_ad.phone_number_verification_url,
ad_group_ad.ad.call_ad.conversion_action,
ad_group_ad.ad.call_ad.conversion_reporting_state,
ad_group_ad.ad.call_ad.path1, ad_group_ad.ad.call_ad.path2,
ad_group_ad.ad.text_ad.headline, ad_group_ad.ad.text_ad.description1,
ad_group_ad.ad.text_ad.description2,
ad_group_ad.ad.responsive_display_ad.headlines,
ad_group_ad.ad.responsive_display_ad.long_headline,
ad_group_ad.ad.responsive_display_ad.descriptions,
ad_group_ad.ad.responsive_display_ad.business_name,
ad_group_ad.ad.responsive_display_ad.logo_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.responsive_display_ad.marketing_images,
ad_group_ad.ad.responsive_display_ad.marketing_images.asset,
ad_group_ad.ad.responsive_display_ad.youtube_videos,
ad_group_ad.ad.responsive_display_ad.youtube_videos.asset,
ad_group_ad.ad.responsive_display_ad.format_setting,
ad_group_ad.ad.responsive_display_ad.main_color,
ad_group_ad.ad.responsive_display_ad.accent_color,
ad_group_ad.ad.responsive_display_ad.allow_flexible_color,
ad_group_ad.ad.responsive_display_ad.call_to_action_text,
ad_group_ad.ad.responsive_display_ad.price_prefix,
ad_group_ad.ad.responsive_display_ad.promo_text,
ad_group_ad.ad.responsive_search_ad.headlines,
ad_group_ad.ad.responsive_search_ad.descriptions,
ad_group_ad.ad.responsive_search_ad.path1,
ad_group_ad.ad.responsive_search_ad.path2,
ad_group_ad.ad.expanded_dynamic_search_ad.description,
ad_group_ad.ad.expanded_dynamic_search_ad.description2, segments.date,
metrics.impressions, metrics.clicks, metrics.cost_micros,
metrics.conversions, metrics.conversions_value,
metrics.view_through_conversions, metrics.all_conversions,
metrics.all_conversions_value, metrics.cross_device_conversions,
metrics.engagements, metrics.interactions,
metrics.video_quartile_p100_rate, metrics.video_quartile_p25_rate,
metrics.video_quartile_p50_rate, metrics.video_quartile_p75_rate,
metrics.video_views, metrics.gmail_forwards, metrics.gmail_saves,
metrics.gmail_secondary_clicks, metrics.active_view_impressions,
metrics.active_view_measurable_impressions,
metrics.active_view_measurable_cost_micros, metrics.average_page_views,
metrics.average_time_on_site, metrics.percent_new_visitors,
metrics.bounce_rate FROM ad_group_ad WHERE segments.date>='2022-07-01' AND
segments.date<='2022-08-10' ORDER BY segments.date DESC "
Response
-------
Headers: {
"request-id": "VGS08iw7j0LjMzEYE6owQQ",
"date": "Thu, 11 Aug 2022 13:04:07 GMT",
"alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\";
ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\";
ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000;
v=\"46,43\""
}
Fault
-------
Status code: 3
Details: Request contains an invalid argument.
Failure:
{"errors":[{"errorCode":{"queryError":"PROHIBITED_FIELD_IN_SELECT_CLAUSE"},"message":"The
following fields may not be used in SELECT clause:
'ad_group_ad.ad.responsive_display_ad.marketing_images.asset',
'ad_group_ad.ad.responsive_display_ad.youtube_videos.asset'."}],"requestId":"VGS08iw7j0LjMzEYE6owQQ"}
(I can provide complete log privately )
https://developers.google.com/google-ads/api/fields/v11/ad_group_ad_query_builder
hangs for my query for some reason...
Wanted to have understanding why
'ad_group_ad.ad.responsive_display_ad.marketing_images.asset',
'ad_group_ad.ad.responsive_display_ad.youtube_videos.asset'
fields which should be available according to documentation can't be used
in my query?
Also could you please clarify:
I get 'ad_group_ad.ad.responsive_display_ad.marketing_images' as
[{"asset":"customers\/9001031727\/assets\/20963565486"},{"asset":"customers\/9001031727\/assets\/34328264347"},{"asset":"customers\/9001031727\/assets\/34334752325"}]
as example.
https://developers.google.com/google-ads/api/fields/v11/ad_group_ad#ad_group_ad.ad.responsive_display_ad.marketing_images
says 'Marketing images to be used in the ad. Valid image types are GIF,
JPEG, and PNG. The minimum size is 600x314 and the aspect ratio must be
1.91:1 (+-1%). At least one marketing_image is required. Combined with
square_marketing_images, the maximum is 15.' but values that I get look
like asset resource name. Is this expected behaviour?
Thanks in advance for looking at my question!
Oksana
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/c4216ac4-3a6a-4c50-8fda-e696d4317eacn%40googlegroups.com.
