When you just want to have a look around to see what is changing in your web site traffic, this dashboard provides a simple interface that lets you explore from the comfort of your spreadsheet application. Choose from a long list of dimensions, a wide range of metrics, and time periods from days to weeks to months. See which of the top items are on the increase, which are dropping off, and whether everything spiked or dipped at the same time.

Interactive Segmentation with Trending

This user-driven report lets you pick what you want to see from a wide range of options, including:

• 21 different dimensions like country, browser, source, ad group or page title
• 9 different metrics, including goal completions and calculated metrics like pages per visit
• view the top or bottom 15 items because sometimes less is better
• pick from the past 14 days, 14 weeks or 14 month views
• select any of 12 standard visitor segments
• customize with your own goals, segments or custom variables

In one screen, we packed in a lot of valuable information, including:

• your top (or bottom) 15 list as well as 'the rest'
• mini sparkline charts for each of the listed items
• a large stacked chart to reveal spikes and drops in overall traffic
• multiple, easily understood drop-down selection boxes that define what you are seeing

Download TrendForTop15.xls, 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.

Next Analytics for Excel required to refresh data.