RE: Can't get assets report

[Google Ads API Forum Advisor Prod]

Hi Shelly,

Thanks for raising your concern. Also, I would like to inform you that I am going to remove the first comment of this post, and re-post below without the screenshots, as the original post contained your account ID information :

"Hi,
We are using google ads api to pull assets report for UAC campaigns. Here is the sql:
SELECT
      customer.id,
      campaign.id,
      ad_group.id,
      video.id,
      segments.date,
      segments.ad_network_type,
      segments.conversion_action_name,
      metrics.conversions,
      metrics.conversions_value,
      metrics.all_conversions,
      metrics.all_conversions_value
    FROM video
    where segments.date ='2020-10-09'

Since Sep 30th , we could not get any data. Here are the screenshots when we run the report."

Moving forward, could you confirm if this is the customer ID 547-XXX-XXXX that you are trying to generate the report for? If yes, the empty video report is expected as this account has no video campaigns and the video report is intended for retrieving video campaign statistics.

Lastly, I am afraid that it is not possible to get the asset metrics/statistics using video report. For the asset related performance report, you can use asset report and ad_group_ad_asset_view report.

Hope this will help. Let me know if you have further questions.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q274w98:ref