how to access Google ads video metric data using Java API?

[mingxing shao]

I want to access google ads video on YouTube video's metric, but response is empty.

How can I access google ads video metric?

My SQL is

SELECT metrics.video_quartile_p100_rate, metrics.video_quartile_p25_rate, metrics.video_quartile_p50_rate, metrics.video_quartile_p75_rate, video.channel_id, video.id, video.title, ad_group.id FROM video WHERE ad_group.id = 148689528701

but GoogleAdsRow list in Response is empty.

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to Google Ads API Forum.

In order for us to investigate further why you are getting empty results in the API, can you provide us with the complete API logs (request and response with request-id and request header) generated on your end? 

Additionally, can you also please share to us the whole Google Ads UI screenshot (without cropping with the CID shown) of the data in the UI you are trying to retrieve via API? This is so we can check on our end as well and provide more appropriate guidance accordingly.

For the Java client library, logging can be enabled by referring to this guide (https://developers.google.com/google-ads/api/docs/client-libs/java/logging). You can provide it via the Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Reference links included in this email:

• request: https://developers.google.com/google-ads/api/docs/concepts/field-service?hl=en#request
• response: https://developers.google.com/google-ads/api/docs/concepts/field-service?hl=en#response
• request-id: https://developers.google.com/google-ads/api/docs/concepts/call-structure?hl=en#request-id
• request header - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers

 

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

Thanks,
 

Google Ads API Team

[mingxing shao]

Hi,

Thanks you for help me.

my Java code

Its result of execution is 0

request log detail is

SUCCESS REQUEST SUMMARY. Method: google.ads.googleads.v12.services.GoogleAdsService/Search, Endpoint: googleads.googleapis.com:443, CustomerID: **********, RequestID: uFaERo1jnTmsZzE56RkmOw, ResponseCode: OK, Fault: null.

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us.

I noticed that you have redacted some parts of your UI screenshot. Please note that, for us to investigate further I would like to request that you provide us with an unredacted and uncropped screenshot of this Google Ads UI view.

You can provide it via Reply privately to the author option. If this option is not available, then send it instead on this email address googleadsa...@google.com

With that being said, can you please try on your end if this sample query is of any help towards your concern?

Sample:

SELECT
asset.id,
asset.type,
asset.youtube_video_asset.youtube_video_title,
asset.youtube_video_asset.youtube_video_id,
metrics.clicks,
metrics.impressions,
metrics.ctr
FROM ad_group_ad_asset_view
WHERE 
  asset.id = <INSERT ASSET ID HERE>