Mason Web Analytics

Tag: MS Excel

Google Analytics/Microsoft Excel: Top Pages Comparison Reporting Tool

The Microsoft Excel Top Pages Comparison Reporting Tool uses the Analytics Edge Microsoft Excel plugin to automate the process of pulling-in data from GA and […]

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 […]

Google Analytics: Three Ways to Pull Data

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: […]

Microsoft Excel: AnalyticsEdge Add-In

Name: Analytics Edge Add-ins for Microsoft Excel Website: http://www.analyticsedge.com/ The Analytics Edge Plug-In for Microsoft Excel allows you to easily pull data in to an […]

Excel: Custom VBA Function to Return Quarter from Date

Function fnQuarterFromWeek(varDate) ‘Declare variables Dim varMonth ‘Get month from date varMonth = Month(varDate) ‘Set quarter based on month If varMonth < 3 Then varQuarter = […]