Google Analytics Excel: Weekly Visitors Scorecard

Original inspiration for this dashboard courtesy of Stéphane Hamel @ Immeria

This report shows the values side by side with the values from prior periods. This lets you immediately see if things are improving or declining.

  • Visitors - more people are visiting
  • Visits - more visits are occurring (includes repeat visits)
  • Page views - visitors are looking at more content
  • Unique Page Views - non-repeat pages in a visit
  • Unique Page Views as % of Visits
  • Visits as a % of Visitors
  • Bounce Rate - how many people landed and clicked away
  • New Visits as a percent of overall visits

visitor scorecard weekly

Download for Excel 2007/2010 or for Excel 2003, open in Microsoft Excel and click Refresh on the Next Analytics menu. You will be prompted for your Google Analytics account, password and the website profile of interest.

Knowing this information helps you plan your web site content and assess the effect of changes you may have made in your Google and other marketing activities.

As with all the Next Analytics dashboards, these are spreadsheets which you can customize. To get your own data showing, you only need to provide your Google Analytics connection information when prompted, and the rest is automatic.

If you are technical, learn more about how it was built and how it works by consulting the Visitor Scorecard blog.