Maximum number of resources

[Dihan Cheng]

Hi, I made an api call to ad_group_ad with where clause resource_name in ( ... ), and got an internal_error. but I notice if the number of resources in the where clause is small like hundreds of resources, the api call will return successful, however if it's thousands it will fail. I just upgrade from v3 to v5, I don't have this problem in v3, so I'm wondering if v5 has put more strict limitation on the number of resources can put in the where clause?

the gaql is as following

SELECT ad_group.id,ad_group.name,campaign.id,campaign.name,campaign.advertising_channel_type,customer.id,ad_group_ad.ad.id,ad_group_ad.ad.name,ad_group_ad.status,ad_group_ad.policy_summary.approval_status,ad_group_ad.policy_summary.policy_topic_entries,ad_group_ad.policy_summary.review_status,ad_group_ad.ad.tracking_url_template,ad_group_ad.ad.final_url_suffix,ad_group_ad.ad.url_custom_parameters,ad_group_ad.ad.display_url,ad_group_ad.ad.final_urls,ad_group_ad.ad.final_app_urls,ad_group_ad.ad.final_mobile_urls,ad_group_ad.ad.display_url,ad_group_ad.ad.type,ad_group_ad.ad.device_preference,ad_group_ad.ad.url_collections,ad_group_ad.ad_strength,ad_group_ad.ad.text_ad.description1,ad_group_ad.ad.text_ad.description2,ad_group_ad.ad.text_ad.headline,ad_group_ad.ad.image_ad.image_url,ad_group_ad.ad.image_ad.mime_type,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.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.expanded_text_ad.description,ad_group_ad.ad.expanded_text_ad.description2,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_dynamic_search_ad.description,ad_group_ad.ad.expanded_dynamic_search_ad.description2,ad_group_ad.ad.gmail_ad.header_image,ad_group_ad.ad.gmail_ad.marketing_image,ad_group_ad.ad.gmail_ad.marketing_image_description,ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text,ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text_color,ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.url_collection_id,ad_group_ad.ad.gmail_ad.marketing_image_headline,ad_group_ad.ad.gmail_ad.product_images,ad_group_ad.ad.gmail_ad.product_videos,ad_group_ad.ad.gmail_ad.teaser.business_name,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.video_ad.bumper.companion_banner,ad_group_ad.ad.video_ad.discovery.description1,ad_group_ad.ad.video_ad.discovery.description2,ad_group_ad.ad.video_ad.discovery.headline,ad_group_ad.ad.video_ad.in_stream.action_button_label,ad_group_ad.ad.video_ad.in_stream.action_headline,ad_group_ad.ad.video_ad.in_stream.companion_banner,ad_group_ad.ad.video_ad.media_file,ad_group_ad.ad.video_ad.non_skippable.companion_banner,ad_group_ad.ad.video_ad.out_stream.description,ad_group_ad.ad.video_ad.out_stream.headline,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.business_name,ad_group_ad.ad.responsive_display_ad.call_to_action_text,ad_group_ad.ad.responsive_display_ad.descriptions,ad_group_ad.ad.responsive_display_ad.format_setting,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.main_color,ad_group_ad.ad.responsive_display_ad.marketing_images,ad_group_ad.ad.responsive_display_ad.price_prefix,ad_group_ad.ad.responsive_display_ad.promo_text,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.youtube_videos,ad_group_ad.ad.responsive_search_ad.descriptions,ad_group_ad.ad.responsive_search_ad.headlines,ad_group_ad.ad.responsive_search_ad.path1,ad_group_ad.ad.responsive_search_ad.path2 FROM ad_group_ad WHERE ad_group_ad.resource_name in ('customers/**********/campaigns/**********', ... )

thanks,

Dihan

[Google Ads API Forum Advisor Prod]

Hi Dihan,

Thank you for your email.

Report sizes may be only up to 100,000 rows as discussed here. Also as discussed in our best concepts guide for retrieving objects, the recommendation would be to limit the number of objects returned, to avoid issues.

You may check out our paging guide and the rest of our streaming guide for the best reporting options you can implement that would fit your requirement.

Thanks,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2684Gd:ref