Google Analytics/Microsoft Excel: Internal Site Search Term Comparison Reporting Tool

The Microsoft Excel Internal Site Search Terms Comparison Reporting Tool uses the Analytics Edge Microsoft Excel plugin to automate the process of pulling-in data from GA and running a comparison analysis.

This tool pulls the top internal site search terms for two date ranges, and then runs a comparison of how the search terms have changed between those two ranges.

It will:

  • calculate the change in searches for each search term,
  • produce summary ‘top 10’ lists for search terms with the largest increases, largest decreases, and largest overall changes (increases or decreases),
  • produce a slopegraph-type chart showing the search terms with the largest changes.

If your internal website search usage is being tracked in Google Analytics, you can use this tool.

You specify the Google Analytics view ID for the website you want to analyze, and the start- and end-dates of the two date ranges you want to compare. When you hit the ‘Analyze’ button, Excel will automatically calculate the changes and produce the reports.

Since this Excel workbook uses automation, note that you will need to allow Excel to run macros.

Example Reports