hotel_performance_view UI vs API discrepancies

[ts...@rivery.io]

Hey,

I'm trying to get from the API the same hotel_performance_view report that I can see in Google Ads UI.

This is the query that I'm running:

SELECT campaign.id, segments.hotel_booking_window_days, segments.hotel_length_of_stay, segments.device, segments.date, segments.partner_hotel_id, segments.hotel_price_bucket, campaign.advertising_channel_type, metrics.clicks, metrics.hotel_price_difference_percentage, metrics.hotel_eligible_impressions, metrics.impressions, metrics.cost_micros, metrics.conversions
FROM hotel_performance_view
where segments.date = '2021-11-15'

I can see that I'm getting much less rows comparing the UI data and that the API doesn't return rows which their clicks and impressions are zero (it returns only rows that one of these metrics is higher than 0). This makes the hotel_eligible_impressions, for example, to be much lower than I can see in the UI report.

Can you plz help me figure out how can I get the same results as in the UI?

Thanks!

[Google Ads API Forum Advisor]

Hi, 

You have reached the Google Ads API Forum. 

It appears that you are encountering discrepancy between API and Google Ads UI. To try this in our end, could you please provide the complete API request and response logs with request ID and request header that generated on your end also the screenshot of the Google Ads UI that you are expecting to be results? If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. This information will help our team to better check this.

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 googleadsapi-support@google.com.

Best regards,

Jinky Google Ads API Team

ref:_00D1U1174p._5004Q2gSSXg:ref