Tutorial: Calculate Your Site’s CTR Using Google Sheet and Search Console API

Learn the calculate the real value of ranking in position ‘x’ for your keywords, which is great if you need to forecast SEO performance. This Google Sheet will analyse the last sixteen months of Google Search Console data for keywords of your choice, calculate the average CTR for every position you appear in, and output the results in a pivot table. You can also set it to automatically refresh the data every seven days, so your benchmarked CTRs are always updating.

Thanks for the heads-up Suganthan.