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.
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.