Cannot find Image Asset Resource in ad_group_ad

88 views
Skip to first unread message

Estanislao Garcia Goya

unread,
Oct 11, 2023, 6:11:47 PM10/11/23
to Google Ads API and AdWords API Forum
Hi,
I am pulling Ads information, but struggling to get the asset id for TextAssets attached to those ads, cannot find a way to get this id, to later on query the assets table.
When querying the ad_group_ad table, i am able to retrieve the headline, description1, description2 and tumbnail text values, but not the asset resources.
Is this even possible?

Query result:

ad { type_: IN_FEED_VIDEO_AD video_ad { video { asset: "customers/4661699415/assets/98626787995" } in_feed { headline: "Headline Testing" description1: "Desc Testing #1" description2: "Desc Testing #2" thumbnail: DEFAULT_THUMBNAIL } } resource_name: "customers/4661699415/ads/676940941835" id: 676940941835 name: "Ad #1" }

Query Select:

SELECT
ad_group.status,
ad_group_ad.ad_strength,
ad_group_ad.labels,
ad_group_ad.action_items,
ad_group_ad.status,
ad_group_ad.ad.type,
ad_group_ad.ad.app_ad.headlines,
ad_group_ad.ad.app_engagement_ad.headlines,
ad_group_ad.ad.app_pre_registration_ad.headlines,
ad_group_ad.ad.call_ad.headline1,
ad_group_ad.ad.call_ad.headline2,
ad_group_ad.ad.discovery_carousel_ad.headline,
ad_group_ad.ad.discovery_multi_asset_ad.headlines,
ad_group_ad.ad.discovery_video_responsive_ad.headlines,
ad_group_ad.ad.discovery_video_responsive_ad.long_headlines,
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.legacy_responsive_display_ad.long_headline,
ad_group_ad.ad.legacy_responsive_display_ad.short_headline,
ad_group_ad.ad.local_ad.headlines,
ad_group_ad.ad.responsive_display_ad.headlines,
ad_group_ad.ad.responsive_display_ad.long_headline,
ad_group_ad.ad.responsive_search_ad.headlines,
ad_group_ad.ad.shopping_comparison_listing_ad.headline,
ad_group_ad.ad.smart_campaign_ad.headlines,
ad_group_ad.ad.text_ad.headline,
ad_group_ad.ad.video_ad.bumper.action_headline,
ad_group_ad.ad.video_ad.in_feed.headline,
ad_group_ad.ad.video_ad.in_stream.action_headline,
ad_group_ad.ad.video_ad.non_skippable.action_headline,
ad_group_ad.ad.video_ad.out_stream.headline,
ad_group_ad.ad.video_responsive_ad.headlines,
ad_group_ad.ad.video_responsive_ad.long_headlines,
ad_group_ad.ad.app_ad.mandatory_ad_text,
ad_group_ad.ad.discovery_carousel_ad.call_to_action_text,
ad_group_ad.ad.discovery_multi_asset_ad.call_to_action_text,
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.legacy_responsive_display_ad.call_to_action_text,
ad_group_ad.ad.legacy_responsive_display_ad.promo_text,
ad_group_ad.ad.responsive_display_ad.call_to_action_text,
ad_group_ad.ad.responsive_display_ad.promo_text,
ad_group_ad.ad.text_ad.description1,
ad_group_ad.ad.text_ad.description2,
ad_group_ad.ad.app_ad.descriptions,
ad_group_ad.ad.app_engagement_ad.descriptions,
ad_group_ad.ad.app_pre_registration_ad.descriptions,
ad_group_ad.ad.call_ad.description1,
ad_group_ad.ad.call_ad.description2,
ad_group_ad.ad.discovery_carousel_ad.description,
ad_group_ad.ad.discovery_multi_asset_ad.descriptions,
ad_group_ad.ad.discovery_video_responsive_ad.descriptions,
ad_group_ad.ad.expanded_dynamic_search_ad.description,
ad_group_ad.ad.expanded_dynamic_search_ad.description2,
ad_group_ad.ad.legacy_responsive_display_ad.description,
ad_group_ad.ad.local_ad.descriptions,
ad_group_ad.ad.responsive_display_ad.descriptions,
ad_group_ad.ad.responsive_search_ad.descriptions,
ad_group_ad.ad.smart_campaign_ad.descriptions,
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.thumbnail,
ad_group_ad.ad.video_ad.out_stream.description,
ad_group_ad.ad.video_responsive_ad.descriptions,
ad_group_ad.ad.video_responsive_ad.videos,
ad_group_ad.ad.video_ad.bumper.companion_banner.asset,
ad_group_ad.ad.video_ad.in_stream.companion_banner.asset,
ad_group_ad.ad.video_ad.non_skippable.companion_banner.asset,
ad_group_ad.ad.video_ad.video.asset
FROM ad_group_ad

Google Ads API Forum Advisor

unread,
Oct 13, 2023, 3:15:34 AM10/13/23
to estan...@manso.dev, adwor...@googlegroups.com
Hi,

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

After reviewing your concern, I understand that you are encountering an issue while pulling the details of asset resources for TextAssets.

In order to assist you further, 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 that you are trying to duplicate via the Google Ads API. 

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.NetPHPPythonRuby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.

 
This message is in relation to case "ref:_00D1U1174p._5004Q2pQuMQ:ref"

Thanks,
 
Google Logo Google Ads API Team


Reply all
Reply to author
Forward
0 new messages