video_view and view_view_rate do not return data for campaign_audience_view

[Julius Fechner]

Hello,

We are trying to retrieve data for a client that includes their video_views and video_view_rate data for their audience view. We've confirmed with them that this data does exist in their UI, and we successfully return video data for their campaign (from the campaign endpoint). However, when querying for this same video data from the campaign_audience_view, no data is returned. In fact, when querying for this data the response does not even contain a return field for video_view_rate (i.e it does not contain video_view_rate: 0). 

An example query is:

SELECT campaign_criterion.criterion_id, campaign_criterion.display_name, metrics.video_views, metrics.video_view_rate, metrics.impressions FROM campaign_audience_view WHERE segments.date >= '2022-09-01' AND segments.date <= '2022-10-01'

Thank you in advance for any help, and kind regards,

Julius

[Google Ads API Forum Advisor]

Hi Julius,

Thank you for reaching out to us.

For our team to further compare, investigate, and validate why you are encountering discrepancies between the UI and the API, could you please provide us with the complete API logs(request and response with request-id) generated on your end and the whole UI screenshot where you can see the expected data you want to retrieve?

Note that the logs can be requested or provided to the developer handling the Google Ads API transactions when logging of the API requests has been enabled. You may check here and click your client library for the specific guideline to enable it.

For REST interface requests, you can enable logging via the curl command by using the -i flag. This will cause the tool to include the HTTP response headers in the output.

You may then send 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.

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2f5Wgx:ref