Get Adgroup Ads Issue Google Ads API

[Saurabh Suman]

Hi Team,

  After sending the request to Google Ads API  using below we are not getting the rows in result .Please check.

query: "SELECT ad_group_ad.ad.legacy_responsive_display_ad.accent_color, ad_group_ad.ad.responsive_display_ad.accent_color, ad_group_ad.ad.id, ad_group_ad.ad_strength, ad_group_ad.ad.type, ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color, ad_group_ad.ad.responsive_display_ad.allow_flexible_color, ad_group_ad.ad.responsive_display_ad.control_spec.enable_autogen_video, ad_group.base_ad_group, ad_group_ad.ad.call_ad.business_name, ad_group_ad.ad.gmail_ad.teaser.business_name, ad_group_ad.ad.legacy_responsive_display_ad.business_name, ad_group_ad.ad.responsive_display_ad.business_name, ad_group_ad.ad.call_ad.call_tracked, ad_group_ad.ad.call_ad.conversion_reporting_state, ad_group_ad.ad.call_ad.conversion_action, ad_group_ad.ad.call_ad.country_code, ad_group_ad.ad.call_ad.description1, ad_group_ad.ad.call_ad.description2, ad_group_ad.ad.call_ad.disable_call_conversion, ad_group_ad.ad.call_ad.phone_number, ad_group_ad.ad.call_ad.phone_number_verification_url, ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text, ad_group_ad.ad.responsive_display_ad.call_to_action_text, ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text, ad_group_ad.ad.final_app_urls, ad_group_ad.ad.final_mobile_urls, ad_group_ad.ad.final_url_suffix, ad_group_ad.ad.final_urls, ad_group_ad.ad.tracking_url_template, ad_group_ad.ad.url_custom_parameters, ad_group_ad.ad.expanded_dynamic_search_ad.description, ad_group_ad.ad.expanded_dynamic_search_ad.description2, ad_group_ad.ad.expanded_text_ad.description, ad_group_ad.ad.expanded_text_ad.description2, ad_group_ad.ad.legacy_responsive_display_ad.description, ad_group_ad.ad.text_ad.description1, ad_group_ad.ad.text_ad.description2,  ad_group_ad.ad.video_ad.out_stream.description, ad_group_ad.ad.device_preference, ad_group.display_custom_bid_dimension, ad_group_ad.ad.gmail_ad.teaser.description, ad_group_ad.ad.gmail_ad.teaser.headline, ad_group_ad.ad.gmail_ad.teaser.logo_image, ad_group_ad.ad.display_url, ad_group_ad.ad.expanded_text_ad.headline_part3, ad_group_ad.ad.legacy_responsive_display_ad.format_setting, ad_group_ad.ad.responsive_display_ad.format_setting, ad_group_ad.ad.gmail_ad.header_image, ad_group_ad.ad.gmail_ad.marketing_image, ad_group_ad.ad.text_ad.headline,  ad_group_ad.ad.video_ad.out_stream.headline, ad_group_ad.ad.expanded_text_ad.headline_part1, ad_group_ad.ad.expanded_text_ad.headline_part2, ad_group_ad.ad.image_ad.pixel_height, ad_group_ad.ad.image_ad.preview_pixel_height, ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.url_collection_id, ad_group_ad.ad.image_ad.name, segments.conversion_lag_bucket, ad_group_ad.labels, ad_group_ad.ad.local_ad.logo_images, ad_group_ad.ad.responsive_display_ad.long_headline, ad_group_ad.ad.legacy_responsive_display_ad.long_headline, ad_group_ad.ad.legacy_responsive_display_ad.main_color, ad_group_ad.ad.responsive_display_ad.main_color, ad_group_ad.ad.responsive_display_ad.square_logo_images, ad_group_ad.ad.responsive_display_ad.marketing_images, ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image, ad_group_ad.ad.legacy_responsive_display_ad.marketing_image, ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image, ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text_color, ad_group_ad.ad.gmail_ad.marketing_image_description, ad_group_ad.ad.gmail_ad.marketing_image_headline, ad_group_ad.ad.app_ad.html5_media_bundles, ad_group_ad.ad.display_upload_ad.media_bundle, ad_group_ad.ad.image_ad.mime_type, ad_group_ad.ad.responsive_display_ad.price_prefix, ad_group_ad.ad.legacy_responsive_display_ad.promo_text, ad_group_ad.ad.responsive_display_ad.promo_text, ad_group_ad.ad.video_responsive_ad.headlines, ad_group_ad.ad.responsive_search_ad.headlines, ad_group_ad.ad.responsive_display_ad.headlines, ad_group_ad.ad.responsive_display_ad.logo_images, ad_group_ad.ad.legacy_responsive_display_ad.logo_image, ad_group_ad.ad.local_ad.marketing_images, ad_group_ad.ad.responsive_display_ad.square_marketing_images, ad_group_ad.ad.responsive_display_ad.youtube_videos, ad_group_ad.ad.call_ad.path1, ad_group_ad.ad.local_ad.path1, ad_group_ad.ad.expanded_text_ad.path1, ad_group_ad.ad.responsive_search_ad.path1, ad_group_ad.ad.expanded_text_ad.path2, ad_group_ad.ad.local_ad.path2, ad_group_ad.ad.responsive_search_ad.path2, ad_group_ad.ad.call_ad.path2, ad_group_ad.policy_summary.review_status, ad_group_ad.policy_summary.policy_topic_entries, ad_group_ad.policy_summary.approval_status, ad_group_ad.ad.legacy_responsive_display_ad.price_prefix, ad_group_ad.ad.gmail_ad.product_images, ad_group_ad.ad.gmail_ad.product_videos, ad_group_ad.ad.responsive_search_ad.descriptions, ad_group_ad.ad.name, ad_group_ad.ad.legacy_responsive_display_ad.short_headline, ad_group_ad.ad.system_managed_resource_source, ad_group_ad.status, ad_group_ad.ad.app_ad.descriptions, ad_group_ad.ad.app_ad.headlines, ad_group_ad.ad.app_ad.images, ad_group_ad.ad.app_ad.mandatory_ad_text, ad_group_ad.ad.app_ad.youtube_videos, ad_group_ad.ad.url_collections, ad_group_ad.ad.image_ad.image_url, ad_group_ad.ad.image_ad.preview_image_url, ad_group_ad.ad.display_upload_ad.display_upload_product_type, ad_group_ad.ad.image_ad.pixel_width, ad_group_ad.ad.image_ad.preview_pixel_width, ad_group_ad.ad.app_pre_registration_ad.youtube_videos, ad_group_ad.ad_group FROM ad_group_ad WHERE ad_group.id IN (7492855098) and ad_group_ad.status IN ('ENABLED', 'PAUSED', 'REMOVED')"

Logs

2022-03-14 17:10:01,670  INFO [grpc-default-executor-0] A: C: summary:157 - SUCCESS REQUEST SUMMARY. Method: google.ads.googleads.v9.services.GoogleAdsService/Search, Endpoint: googleads.googleapis.com:443, CustomerID: 9752159705, RequestID: YO-byOm-7tx93QNqhySUnQ, ResponseCode: OK, Fault: null.
2022-03-14 17:10:01,675  INFO [main] A: C: API:2357 - Execution of getAllAds took 4298ms
junit.framework.AssertionFailedError: Ad group 114792383 should have 73 ads, but 0 ads have been retrieved.
Expected :73
Actual   :0

[Google Ads API Forum Advisor]

Hi Saurabh,

Thank you for reaching out to the Google Ads API support team.

Allow me to raise the issue of internal error to my team. Rest assured that we will provide updates when available.

Thanks,

Nirmita Google Ads API Team

ref:_00D1U1174p._5004Q2Yl2N5:ref

[Saurabh Suman]

Any update on this? 

[Google Ads API Forum Advisor]

Hi Saurabh,

Thank you for checking updates. We appreciate your patience with this thread.

My team have done investigating this issue, let me share their responses below:

That ad group is not in that account. It's in 239-050-8764. So, that's the first issue. The second issue is that 239-050-8764 is a disabled account, so even if you ran the request, it would fail because the Google Ads account is not enabled. 

Best regards,

Jinky Google Ads API Team

ref:_00D1U1174p._5004Q2Yl2N5:ref

[Ngon Nguyen]

Chào mừng bạn đến với bảng nhớ tạm của Gboard, bất kỳ văn bản nào bạn sao chép sẽ được lưu tại đây.Sử dụng biểu tượng chỉnh sửa để ghim, thêm hoặc xóa đoạn.Nhấn vào một đoạn để dán vào hộp văn bản.Chạm và giữ một đoạn để ghim đoạn đó. Các đoạn đã bỏ ghim sẽ bị xóa sau 1 giờ.

Vào 18:42, Th 2, 14 thg 3, 2022 Saurabh Suman <saurabhs...@gmail.com> đã viết:

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/f77ae15e-e91c-4e33-8dde-77548178d51dn%40googlegroups.com.