We guess that the most users analyze search analytics data directly in Google Webmaster Tools. This approach has own pros. Console interface has great filters to find any information. But it hasn’t opportunity to edit collected result. So, we recommend you try Search Analytics for Sheetes Add On
. It helps to work with all data from Console in Google Sheets.
You can see on the screenshot how simple and easy to use is sidebar of Add On.
Working with search analytics in Google Sheets gives an opportunity to make own calculations and combine data in pivot tables. Pay attention to two indexes which we add to collected data.
1. Potential rank.
It is an index calculated as Number of Impressions divided on the Average Position. The highest index is, the more traffic keyword can bring in the near future.
2. Ideal Final Result (IFR).
It is an index calculated as Potential Rank divided on the Number of Impressions. Our purpose is to get 100% on this index.