This free Analytics Edge report lets you see long-term trends in the individual words used in search queries that showed you site. Refresh weekly and the report maintains previous results, letting you see not just the current hot topics but also those that have fallen out of the rankings.
You don’t have to dig through hundreds of similar but unique query phrases, Analytics Edge splits each term apart and performs a Soundex grouping of word variants to give you a concise summary of the current topics of interest. A companion blog article describes how the report was created.
Requires: Analytics Edge Add-in with Google Search connector
Download the workbook: GoogleSearch-WordFrequency-3-0.xlsm