SEO Summary Report

Core Add-in, Google Search Connector
Search Engine Optimization is a changing market. It’s not about keywords, it’s about topics and long-tail in aggregate. This free report summarizes your website’s appearance in search, showing the distribution of the # of keywords, impressions and clicks by position.

seo-summary-report-2

 

The included Analytics Edge macro downloads the last 12 weeks worth of Google Search Analytics data and extracts the data, excluding your branded search terms if desired.

Download the workbook: GoogleSearch-SEOSummaryReport-2-0.xlsx

v2.0 Updated to display counts for position 1 at the bottom of the charts, and added counts for position 21+ at the top.

Configuration: Enter your account and website on the Data worksheet in the highlighted cells, enter any brand terms to be excluded on the Brand Terms worksheet. Click Refresh All.