Free Keyword Rank Tracking Spreadsheet Using Google Search Console

[@studentu05]

Thanks for putting this together. Can you please help me understand how do I extend the date on to the Pivot table as it won't show in the charge all 16 months from Search console. It shows less then a year of data on to the graphic.

[@seo-frank]

Sorry for taking so long to reply. Are you able to extend the dates on the pivot table so that it includes all the dates in the GSC tab? Let me take a look and I will get back to you. I saw you sent me an email so I can respond to thay as well!

[@ianelkin4153]

Do we have to export each keyword individually or is there a way to export all keywords with date and position data?

[@warrenbest]

This is great

[@saadmudassar5148]

How to improve the CTR if impressions is very high like 14K-20K & CTR is 0.3% how we can improve it to 15%-20%? Can you guide please or create a video?

[@seo-frank]

If you have high impressions, check your average ranking position for the keyword in the GSC performance report. If your average ranking is higher than 10, almost all of those impressions are likely bot traffic. This is because users don't scroll/click past page 1 very often at all. If you want to increase your clicks, get on page 1 (less than Position 10). If your position is less than 10, try on page optimizations to improve your position and try better title tags to improve CTR.

[@warrenbest]

does the data update automatically

[@warrenbest]

I can't get the pivot table to come up

[@resultspestcontrol]

I would love your spreadsheet if it worked, but it did not.

[@seo-frank]

What didn't work on the sheet? Let me know and I can have a look