Core Add-in, Google Search Connector
See a week-by-week summary of the top queries and pages for your website, direct from Google Search Console. Quickly identify trends and changes in ranking of popular terms. It also shows the number of impressions and clicks for the most-recent week!
Just enter your website URL and click Refresh All; Analytics Edge takes care of the rest, downloading the data for each week, combining the results, pivoting and sorting by the to show your search engine rankings over a 7-week period.
Download the workbook: SearchAnalytics-weekly-position-3-01.xlsx [updated 2015-10-16]
Requires the Analytics Edge Core Add-in and the Analytics Edge Connector for Google Search.
UPDATE: similar functionality is now available from the Basic Add-in with the Google Search connector v4.0: