This is my favourite tool of all three of I will look at today. Google Search Console, if you don’t have it, get it and start setting this up. Google Search Console will give you insight of how Google sees your website, your errors, performance of your site (with Core Web Vitals) and terms your users are searching to reach your site.
The fun part is you can see the keywords that you’re ranking for and which pages are ranking, as well as the impressions and clicks for these terms. One drawback is that you have to manually look at it through Google Search Console. If you wanted to go into the report, you’d have to look at a specific page or query, and then if you export the data and it still shows in separate tabs.
With Search Analytics for Sheets add-on, you can see all of it in one place. It will output a table like you see in the image below of all your pages and queries. Not just one query and not just one page, but also all the clicks and impressions.
When you run the add-on, choose to group by page, query.