Cannot access to table "Video" since days before

[Pan Liu]

Dear Ads API team,

We purpose to synchronize metrics from google Ads API into our database for our employees and ad managers to view. However, a problem was found when requesting video data (https://developers.google.com/google-ads/api/fields/v8/video_query_builder). We got empty result without any error information. Although, several days ago, we just got the correct data when calling request with same GAQL query . What's the problem and how can we get the correct data?

Here is the GAQL query:

`SELECT

video.id,metrics.cost_per_all_conversions,ad_group.id, ad_group.name, ad_group_ad.ad.id, ad_group_ad.ad.name, campaign.name, metrics.clicks, metrics.conversions, metrics.impressions, metrics.video_quartile_p100_rate, metrics.video_quartile_p25_rate, metrics.video_quartile_p50_rate, metrics.video_quartile_p75_rate, campaign.app_campaign_setting.app_store, metrics.video_views, ad_group.campaign, campaign.app_campaign_setting.app_id

FROM video

WHERE segments.date = '2021-06-01'`

[Pan Liu]

No error message, only empty response, just like no records.

[Google Ads API Forum Advisor]

Hi Pan Liu,

Thanks for reaching out to us.

Could you please double check if the GAQL query you used before when you got the correct data is the same when calling the request with the GAQL query which returns only an empty response without an error message?

To help you build your query, we suggest that you use the Query Builder or use the Query Validator, so that you may confirm if the query is valid.

If you still persist with the issue, you may provide us with the complete request and response logs with request ID, in order for us to investigate further. Kindly provide the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Let us know if you have any further questions.

Regards,

Yasar Google Ads API Team

 

ref:_00D1U1174p._5004Q2Lnpo7:ref