Hello!
Just wanted to confirm that my question is still actual.
Thanks,
Oksana
On Thursday, August 11, 2022 at 4:17:49 PM UTC+3 Oksana Sulyma wrote:
> 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 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/ea242f75-d446-4587-82ce-5340946e229cn%40googlegroups.com.
