I think most SEOs are familiar with the annoying 1000 row limit of Google Search Console. Over time I've tried many ways to get around this and although many solutions work really well, they were either time-consuming to setup/maintain (i.e. Python) or they did not allow exports of period comparisons (i.e. the Search Analytics for Sheets add-on). Personally I really like the simplicity of Google Sheets, so I've created an add-on that's plug-and-play and allows for period comparisons. Being able to do so, I've also created advanced explorations of your data which you can create by simply enabling a checkbox. This allows you to answer questions like: * How much clicks or impressions did we gain this period? (period comparisons) * Did rank for new queries or lose some? (new and lost queries) * What is our CTR or total clicks for a specific position? (rank distribution) * How did we perform month by month? (month by month overview) * Which pages are competing for the same keywords? (cannibalization report) In addition you can: * Pull up to six months of data from Google's Chrome User Experience (CrUX) report to see how your website is performing on Core Web Vitals and other performance metrics. * Write all your sitemap contents to Google Sheets straight from GSC or just a URL. You can look for SEOSHEETS in the Google Workspace Marketplace, it has over 20K installs by now. In case you already use alternatives to get period comparisons beyond the 1000 row limit, what do you use?

SEOSHEETS

Making SEO analysis simple in Google Sheets

Making SEO analysis simple in Google Sheets