Access to the video id column from ad_group_ad

[Anass Aimane]

Hello,

I am trying to build a query to mimic our UI report. I have got almost all the columns, I am only missing one that is the YouTube video id. I cannot find anything related to that. Do you happen to know what I can do ?

Here is my query so far and you can see that I added ad_group_ad.ad.video_ad.video.asset but without any success:

SELECT

segments.date

, campaign.name

, campaign.id

, ad_group_ad.ad.name

, ad_group_ad.ad.id

, ad_group.name

, ad_group.id

, ad_group.type

, ad_group_ad.ad.type

, campaign.listing_type

, segments.device

, segments.ad_network_type

, metrics.impressions

, metrics.interactions

, metrics.engagements

, metrics.video_views

, metrics.video_view_rate

, metrics.video_quartile_p25_rate

, metrics.video_quartile_p50_rate

, metrics.video_quartile_p75_rate

, metrics.video_quartile_p100_rate

, metrics.active_view_measurable_impressions

, metrics.active_view_measurability

, metrics.active_view_impressions

, metrics.active_view_viewability

, ad_group_ad.ad.video_ad.video.asset

FROM

ad_group_ad

[Google Ads API Forum Advisor]

Hi Rakshit,

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

In order to analyze the issue further, we require uncropped UI screenshot (from Google Ads account) highlighting the specific fields of the report that you are trying to mimic via the Google Ads API and complete API logs (request and response with request-id and request header) generated at your end.

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. For REST interface requests, you can enable logging via the curl command by using the -i flag.

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

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

Thanks,
 

Google Ads API Team

[Anass Aimane]

Hello, 

Thanks for your message. So actually the video column is not in the UI. It is automatically added when we download the report that contains the add column. Can we still get it somehow ?

[Anass Aimane]

Hello, any updates ?

[Google Ads API Forum Advisor]

Hi,

I would like to inform you that retrieving the video ID field is not possible via the Google Ads API. Currently there is no workaround to retrieve the field.

[Anass Aimane]

So actually I found a turn around by joining asset.youtube_video_asset.youtube_video_id with video.id and asset.resource_name with ad_group_ad.ad.video_ad.video.asset.

However, for the ad_type "responsive_ad", these values are NULL. Any idea why ?