Missing ads in ad_group_ad report

[Romain Deshaies]

We are trying to query the ad_group_ad report with google ads v15 (or v16 to test).
We can't get all the ads we expect.
On account 6985262280, these ads are missing: 696813605487, 696865206934, 696820922805, 696854299438, 696871205437, 696843022005, 696943388597, 31229365, 696931640120, 696922107809
We retrieve these ad ids from the tracking template and the {creative} variable
We don't have them in the Google Ads interface either.
The request we make:

SELECT campaign.id,campaign.status,campaign.base_campaign,campaign.name,ad_group.id,ad_group.status,ad_group.base_ad_group,ad_group.name,ad_group_ad.ad.name,ad_group_ad.status,ad_group_ad.ad.id,ad_group_ad.ad.type,ad_group_ad.ad.final_mobile_urls,ad_group_ad.ad.final_app_urls,ad_group_ad.ad.final_urls,ad_group_ad.ad.tracking_url_template,ad_group_ad.ad.display_url,ad_group_ad.ad.app_ad.descriptions,ad_group_ad.ad.app_ad.headlines,ad_group_ad.ad.app_ad.html5_media_bundles,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.app_engagement_ad.descriptions,ad_group_ad.ad.app_engagement_ad.headlines,ad_group_ad.ad.app_engagement_ad.images,ad_group_ad.ad.app_engagement_ad.videos,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.call_ad.description1,ad_group_ad.ad.call_ad.description2,ad_group_ad.ad.discovery_carousel_ad.business_name,ad_group_ad.ad.discovery_carousel_ad.description,ad_group_ad.ad.discovery_carousel_ad.headline,ad_group_ad.ad.discovery_carousel_ad.logo_image,ad_group_ad.ad.discovery_multi_asset_ad.business_name,ad_group_ad.ad.discovery_multi_asset_ad.descriptions,ad_group_ad.ad.discovery_multi_asset_ad.headlines,ad_group_ad.ad.discovery_multi_asset_ad.marketing_images,ad_group_ad.ad.display_upload_ad.media_bundle,ad_group_ad.ad.expanded_dynamic_search_ad.description,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.description,ad_group_ad.ad.expanded_text_ad.description2,ad_group_ad.ad.expanded_text_ad.path1,ad_group_ad.ad.expanded_text_ad.path2,ad_group_ad.ad.image_ad.image_url,ad_group_ad.ad.image_ad.name,ad_group_ad.ad.legacy_responsive_display_ad.description,ad_group_ad.ad.legacy_responsive_display_ad.business_name,ad_group_ad.ad.legacy_responsive_display_ad.short_headline,ad_group_ad.ad.legacy_responsive_display_ad.long_headline,ad_group_ad.ad.legacy_responsive_display_ad.marketing_image,ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image,ad_group_ad.ad.legacy_responsive_display_ad.logo_image,ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image,ad_group_ad.ad.local_ad.descriptions,ad_group_ad.ad.local_ad.headlines,ad_group_ad.ad.local_ad.path1,ad_group_ad.ad.local_ad.path2,ad_group_ad.ad.responsive_display_ad.descriptions,ad_group_ad.ad.responsive_display_ad.headlines,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.business_name,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,ad_group_ad.ad.shopping_product_ad,ad_group_ad.ad.shopping_smart_ad,ad_group_ad.ad.smart_campaign_ad.descriptions,ad_group_ad.ad.smart_campaign_ad.headlines,ad_group_ad.ad.video_ad.bumper.companion_banner.asset,ad_group_ad.ad.video_ad.in_feed.description1,ad_group_ad.ad.video_ad.in_feed.description2,ad_group_ad.ad.video_ad.in_feed.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.asset,ad_group_ad.ad.video_ad.video.asset,ad_group_ad.ad.video_ad.non_skippable.companion_banner.asset,ad_group_ad.ad.video_ad.out_stream.description,ad_group_ad.ad.video_ad.out_stream.headline,ad_group_ad.ad.video_responsive_ad.descriptions,ad_group_ad.ad.video_responsive_ad.headlines,ad_group_ad.ad.video_responsive_ad.long_headlines,ad_group_ad.ad.discovery_video_responsive_ad.descriptions,ad_group_ad.ad.discovery_video_responsive_ad.headlines,ad_group_ad.ad.discovery_video_responsive_ad.long_headlines,ad_group_ad.ad.discovery_video_responsive_ad.business_name FROM ad_group_ad

[Google Ads API and AdWords API Forum]

Hi,

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

We would like to specify first the following when comparing the value of the Google Ads UI and Google Ads API.

• The segments and fields of the API and UI should be the same
  
• The date range should also be the same
  
• Comparing the API and UI at the same level as much as possible
  

With that, please provide us with the complete API logs (request and response with request-id and request header) generated at your end and the entire UI screenshot of the report you are trying to duplicate to better assist you.

If you are using a client library and haven't enabled the logging yet, I would request you to enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. You can enable logging via the curl command by using the -i flag for REST interface requests.

You can send the details via Reply privately to the author option, or direct private reply to this email.

Thanks & Regards,

Google Ads API support team.

[Romain Deshaies]

HI,

I only have this information in the log :

Request made: Host: "googleads.googleapis.com", Method: "/google.ads.googleads.v15.services.GoogleAdsService/SearchStream", CustomerId: 6985262280, RequestId: "eiIZcGiDrlF4iEEe6-9Gvw", IsFault: 0, FaultMessage: "None"

[Jakub Banik]

How did you resolve the issue?

[Google Ads API Forum Advisor]

Hi,

After verifying the account, it is observed that these ad IDs (696813605487, 696865206934, 696820922805, 696854299438, 696871205437, 696843022005, 696943388597, 31229365, 696931640120, and 696922107809) are not available. That is the reason you're not able to retrieve these ad IDs via the API. 

Kindly note that if ad Ids is present in the Google Ads account (UI), then only you will be able to retrieve it via the Google Ads API. 

Additionally, could you please tell us using which account ID you've retrieved those ad IDs from the tracking template and the {creative} variable? 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vDRaK:ref" (ADR-00246514)

Thanks,
 

Google Ads API Team

Register for the upcoming workshop: Performance Max and the Google Ads API!