How to get Click and Impressions (the data from Search Console)

[Emma Schiller]

Hello, I have my Analytics and Search Console accounts connected and I can see the SC data in Analytics: Acquisition>Search Engine Optimisation>Queries. I am trying to get the clicks and Impressions in Google Analytics Spreadsheet, but I can't figure this out, I don't know what metric to set (can't reach clicks and impressions). Can you please help me with this task, thank you :)

[jbl...@clubessential.com]

The last I read on this forum it was not possible to query these metrics from the Analytics api because Google Analytics collects the data differently than the other metrics (you also cannot create a custom report of this tab within GA for the same reason I think).

I would be interested to hear if there is a work around or what other people typically report on (keywords maybe?) in place of these metrics with GA Spreadsheet Add On.

Thanks!