For this example, we will be pulling the top 100 internal site search terms from the Mason core website (www2.gmu.edu) for the ‘off-campus’ segment.
Account: Mason Office of Communications and Marketing
View: [PROD] Default 2.0 (2017-06-25)
Date Range: Jul 31, 2017 – Aug 6, 2017
Segment: Service Provider: Not George Mason University (“Off-Campus”)
Dimension(s): Search Term
Metric(s): Total Unique Searches
Method 1 – Using the Google Analytics Standard Interface
Method 2 – Using the Google Analytics Query Explorer
Using the Google Analytics Query Explorer, create a query as shown in the screenshot below.
Run the query, and see that the data matches that of the GA web interface.
Method 3 – Using the AnalyticsEdge Microsoft Excel Add-In
Using the Analytics Edge Microsoft Excel plugin, create a Google Analytics report to match the above criteria.
If you have not done so already, you’ll need to install the plugin, and log-in with your Google Analytics account.
Run the report and see that the numbers match what we saw using the standard GA web interface, or the Google Analytics Query Explorer.