Query click_view for gclid returns no results

[Sanket Dofe]

I am trying to fetch data related to an Ad click using a given gclid. For this I am using the following GAQL query

SELECT click_view.ad_group_ad, click_view.gclid, click_view.keyword, click_view.keyword_info.match_type, click_view.keyword_info.text, click_view.resource_name, ad_group.name, ad_group.id, campaign.id, campaign.name, metrics.clicks FROM click_view WHERE segments.date = '2023-01-11'

​(The above query has segments.date as click_view resource requires a date param in the query and we can only query for any one day in a query)

​But this query doesn't return any data. This gives empty results.

How can I pull data for click_view?

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API team.

With regards to your concern, kindly note that Google Ads API mirrors the Google Ads UI. You can pull/fetch the data that you're seeing in the Google Ads UI. Having said that, you mentioned that upon using the query that you provided, you are getting empty results. Can you please provide the complete request and response logs with request ID and request header generated on your end so our team can better check and investigate this on our end?

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

Regards,

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2iN6E6:ref