Need Help retrieving the exact time of a click with GCLID Please

[Cassio Mariani]

Hi all, I really need help here if someone could be so nice, I'm struggling to retrieve the exact time of a click made on my ad thru gclid, I am using this query:

function main() {
const spreadsheet = SpreadsheetApp.create('GCLID Report');
const report = AdsApp.report(`SELECT click_view.gclid,  click_view.keyword_info.text, click_view.location_of_presence.city, click_view.location_of_presence.country, metrics.clicks, customer.id, ad_group.id, campaign.id FROM click_view WHERE segments.date = '2023-11-22'`);
report.exportToSheet(spreadsheet.getActiveSheet());
}

Everything works fine, but all the parameters that I looked for inside the query builder help like: segments.hour  or clickTime, they don't work, could anyone please help me to get this ?

Thanks so much in advance.

[Google Ads API Forum Advisor]

Hi,

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

After reviewing your concern, I understand that you are trying to fetch the exact time of a click through GCLID.

Could you please clarify the campaign type you are referencing in the click_view resource?

You can send the details via Reply privately to the author option, or direct private reply to this email.

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02qUfpp:ref"

Thanks,
 

Google Ads API Team