Google Search: SEO Summary Report (Core)

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.

Requires: Analytics Edge Core Add-in with Google Search connector
Download the workbook: GoogleSearch-SEOSummaryReport-3-0.xlsx

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.