The Google Search Console metric for “position” is an average, and it doesn’t tell the whole story. This report looks at the individual queries used for each of your pages over the past 12 weeks, groups them by position, and shows you the distribution of impressions and clicks by position.
Using the power of the Analytics Edge Core Add-in, the workbook macros will download your website data and do all the analysis work for you.
Requires: Analytics Edge Add-in with Google Search connector
Download the workbook: GoogleSearch-PositionDistributions-2-0.xlsx