This report focuses on What's Changed (from the previous reporting period).  You see trends as they emerge. 

• Changes in traffic by Campaign.
• Changes that occur by referring sites.
• Which pages are being landed on more or less frequently than before
• New phrases being searched, 
• Old phrases no longer being searched
• Changes in geographical location of visitors

Download WhatsChanged-AdwordCampaign.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.

These reports run on a rolling two week basis. They compare the results for the past two weeks against the results for the two week period prior. 

The report focuses what's changed from period to period; this helps you to discover important trends and patterns as they are happening and adjust your marketing plans accordingly.

This report helps you to monitor some key trends and performance indicators in a quick and easy to read dashboard. It shows five key indicators of web site health.

Download The-One-Report-That-Gives-You-An-Overview.XLSX orThe-One-Report-That-Gives-You-An-Overview.XLS, open in Microsoft Excel and click Refresh on the Next Analytics menu.

You can segment this report to see how behavior changes among different target profiles.

This report lets you monitor how well specific pages are doing. Typically applied to landing pages, you can see the effectiveness of the underlying marketing campaign which could be a PPC or web external campaign such as a Press Release.

Download Who-visited-your-most-important-pages.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.

Segment this report to see how behavior changes among different target profiles.

This report shows the various sources that direct traffic to your web site. For example:

• Adwords
• Direct
• Referred
• Search

This dashboard lets you see which ones generate the most effective results, and which ones generate the most short-stay bounces.

Download What-They-See-And-Who-They-Are.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.

Segment this report to see how behavior changes among different target profiles.

Your Web Designer Needs to Know!

Many people in web design have newer computers with large screens, but it is critical for them to design your site for your audience. Target screen size is one of the most fundamental metrics required.

• Is it possible to take advantage of larger displays
• Are a large percentage of your customers using smaller ones?
• How far down the page can content be placed before it disappears 'below the fold', requiring people to scroll down to see it?

These are decisions that can dramatically affect your web site's performance.

Most reports on screen resolution give you only a few of the most popular display sizes, but that isn't what your designer needs to know. 

This report gives them a complete profile of the display resolutions being used by your customers.

Based on a recent 3 month sample, it uses a simple grid display with color highlighting to provide a clear, concise report of the percentage of your website visitors with a specific screen size or larger.

Now you can give them the information they need.

Download ScreenResolution.XLSX or ScreenResolution.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.

A great tool for customer intelligence! See what prospects and customers have been to your web site recently.

Identify key pages like the Contact Us page, your new Product page, or a specific Campaign Landing Page, and quickly see who is looking at them.

This report digs through the recent web traffic and shows you who your top visitors are, where they are from, and what key web pages they have looked at.

Easily update which pages you are interested in by entering them directly into the legend. This lets you keep tabs on:

• the latest Campaign page,
• a specific Product page,
• a critical News release; and
• the Pricing page, or
• the Contact page.

Also see how many other pages they looked at and how many times they visited.

Download KeyPageVisitors.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.

Use this dashboard to know which Traffic Sources are the most effective at driving visits to your site. What do you know about each Traffic Source that brings people to your site? Which of the landing pages are proving to be more effective?

The Landing Page spreadsheet segments the data by each traffic source: Direct, Search, Referral, and Paid. All of your top landing pages are shown, starting with the most effective ones. You can see its number of visits, average time on site, and bounce rate for each of these segments.

For each of the four traffic segments, you can see:

• Which page they land on
• How many visits the traffic source generated
• How long the average visit lasted (not just the page); and
• What percent of visits resulted in a bounce.

You can answer important questions like:

• Do paid ads generate more bounces?
• Are your search engine optimization activities resulting in more frequent and long enough visits?

Download LandingPageAnalysis.XLSX or LandingPageAnalysis.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.

With this report, you can compare the behavior of your visitors as segmented by the traffic source. This will help you to measure and adjust SEO activities, web site structure, and content.

What are your Customers looking for?

When a customer finally finds something on your site and buys it, you should be looking at what they were searching for. Not just the last phrase that triggered the purchase, but the ones they tried to get them to that point as well!

This report, unique to Next Analytics and not available in Google Analytics, delivers your top revenue generating search terms as well as all the other search terms those purchasers also tried.

Are you overlooking some key phrases in your product pages? Improve your SEO results and site effectiveness by including the words they are using in their initial searches.

The report includes:

• search term that led to a purchase
• other search terms used by the same visitors
• number of visits
• number of transactions
• total revenue earned

Download SearchTermsThatSell.XLSX or SearchTermsThatSell.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.

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

Stay in tune with your eCommerce site performance with this easily refreshed monthly report. Using a scorecard approach, key metrics, trends and comparisons are provided on a single page, suitable for printing. The scorecard report includes:

• Key metrics of visits, revenue, transaction count, average order size and conversion rate
• Current month contrasted with previous month and the same month last year
• Thirteen month trend lines with peak and median metrics
• Conversion rates by medium (search, referral, etc)
• A listing of the top 20 sources with key metrics for each

The entire report can be viewed for specific segments of your traffic -- by new or returning visitors, referral or search traffic, or only visits with conversion or transactions.

Download eCommerceScorecard.xlsx, 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.

This Excel dashboard includes a world map that shows the countries with the most traffic highlighted in deeper shades of green.

The map is supported by a listing of the top countries as well as all of the visitor engagement metrics and a technical profile:

• Loyalty profile
• Recency profile
• Depth of visit profile
• Duration of visit profile
• Top browsers
• Connection speeds
• Top languages
• Screen resolutions

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.

Next Analytics for Excel required to refresh data.

As with many Next Analytics reports, easily zoom in on a segment of your traffic -- by new or returning visitors, referral or search traffic, or visits with conversion or transactions.

Excel Web Analytics arranges visits to resemble a weekly calendar making it easy to spot day-of-week and week-to-week patterns and trends. This report, arranged like a weekly calendar, makes it easy to spot trends both by day-of-the-week and from week-to-week over a 6 month period. 

Displaying the number of website visits for each day, the weeks are arranged vertically with one column for each day of the week. By using Excel's conditional formatting, you can see:

• does traffic peak consistently on the same weekday,
• what was the impact of a long weekend or holiday,
• whether visits climbed before or after your special event,
• is your site affected by the summer vacation lull?

Download CalendarView.XLSX or CalendarView.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.

Which web pages are more effective?  There are lots of ways to evaluate and compare web pages, and this report takes a new spin on some old metrics.

Starting with the top 25 web pages, as measured by the number of visits, this report analyzes each page:

• page views per visit
• first page viewed ("entrances") percentage
• entrances from new visitors to your site
• last page viewed ("exits") percentage
• single page visits ("bounces")
• average time spent on the page

Using Microsoft Excel's custom formatting, it makes it easy to see which pages

• visitors come back to often,
• which ones are primarily landing pages, and
• which appeal to new visitors to your site.

Also see which pages are frequently the last to be seen, and which failed to hold visitors on the site. For those that do stay, see which pages hold them longer.

Download WebPageAnalysis.XLSX, 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.

This goal tracking report monitors when people accomplish something on your site - whether it is

• completing a registration form,
• downloading a whitepaper,
• reading the bio's of your executives
• or simply visiting your Contact page.

How many goal conversions did your site achieve this week? Which visitors hit your website goals, where were they are from, and what brought them to your site.

With this report, Next Analytics provides key information about visitors that triggered your goals:

• country and city
• network domain
• search engine and keyword used
• referral web site and page
• monitor up to 10 goals

Shows the last seven days of data, including today's traffic, keeps you on top of what is happening on your site. (seven days of history is easily customized to show more or less).

Download Goals-this-week.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.

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.

From the day a new marketing campaign starts or your newsletter is released, this dashboard track it's effectiveness compared to previous campaigns. This Excel report pulls your campaign history directly from Google Analytics and compares how many visits each campaign brought in over the following 60 days. Features include:

• start threshold allows a few test previews before the release date
• display your top campaigns or specify the ones you want to compare
• specify your start and end dates for the collection period
• pick one of 8 predefined visitor segments to see all visits or only those resulting in conversion or transactions

Download CampaignComparison.XLS or CampaignComparison.XLSX, open in Microsoft Excel, and then click Refresh on the Next Analytics menu.

Next Analytics for Excel required to refresh data.

This dashboard workbook combines both long-term trends and multiple segmentation in an easy-to-read report. The top sources, from all mediums, are tracked over a thirteen month period. A summary of traffic by medium is included with percentage change over the previous month. 

The top sources are arrayed across eight different visitor segments to show you which segments are bringing you traffic through which sources. Segments shown:

Download TrafficSourcesTrends.XLS or TrafficSourcesTrends.XLSX, open in Microsoft Excel, and then click Refresh on the Next Analytics menu.

Next Analytics for Excel required to refresh data

If you track more than one website in Google Analytics, you'll love this scorecard!

Covering 6 website profiles on a single page, the workbook displays 7 common metrics for each site, providing both numeric and visual updates on each site's activity.

Metrics include:

For each metric, the report displays:

• 13 month trend curve
• Last calendar month's value
• Percentage change from the previous month

Download MultisiteScorecard.xls, open in Microsoft Excel, enter your GA account information as well as the website profile IDs and names on the Multisite_actions sheet, and then click Refresh on the Next Analytics menu.

Next Analytics for Excel required to refresh data.

This dashboard is also available for Next Analytics v4 as a widget in both weekly and monthly variants.

Many organizations are mining their Google Analytics reports on a daily basis, feeding information to their sales staff about interest from potential customers. This report automates much of the work, freeing your staff from the mundane tasks of downloading and copying data.

This report shows the keywords they were searching for, the company or service provider name, their city, region and country as well as a possible web site address for the salesperson to check out. Metrics include the number of visits, the average pages viewed per visit and the average time on your site.

It is a bad idea to send junk information to your sales people, so the workbook includes an 'exclude' worksheet that lets you keep a running list of service provider names, regions or countries to automatically remove from the report. This lets you filter out competitors, general domains and regions or countries outside your salespeople's sales region. You could even tailor a worksheet for each of your sales region.

Download DailyLeadsReport.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

This Excel dashboard includes a map of the lower 48 states.

States with the most web site traffic highlighted in deeper shades of green.

The map is supported by a listing of the top cities.

It also shows visitor engagement metrics and a technical profile:

• Loyalty profile
• Recency profile
• Depth of visit profile
• Duration of visit profile
• Top browsers
• Connection speeds
• Top languages
• Screen resolutions

As with many Next Analytics reports, easily zoom in on a segment of your traffic -- by new or returning visitors, referral or search traffic, or visits with conversion or transactions.

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.

Next Analytics for Excel required to refresh data.

This report is a quick overview of some key metrics relating to how often they visit, how long it is between visits, volume of visits, duration, and number of pages. You can also see which pages are growing in popularity the fastest.

There's actually two dashboards here. The first is for the past 14 days, and the second shows the current month to date.

Report on Past 14 days: download XLSX or XLS. Report on last calendar month: download XLSX. Open in Microsoft Excel and click Refresh on the Next Analytics menu. You will be prompted for your Google Analytics account, password and website profile.

Next Analytics for Excel required to refresh data.

The data comes from Google Analytics which lets you segment this report to see how behavior changes. As well as custom segments and filtering, you can choose from pre-defined segments.

This dashboard shows when people visit your site by using business intelligence techniques of pivoting the data plus exception highlighting.

The data comes from Google Analytics, which is tracks the visits of your web site. You can use information like this to tune your advertising to suit your audience. Stop wasting money on off-peak hours and focus your ad budget for when you know you get the most visits.

• see time of day trends by day of the week
• are weekends better or worse?
• see how it changes over time, from week to week
• are holiday periods better or worse?

Also, maybe you just want to know when your site is busiest so you can plan new content to be most effective. Or when the best time to schedule downtime for an upgrade.

Download for Excel 2007/2010 or for Excel 2003, open in Microsoft Excel and then click Refreshon the Next Analytics menu.

Next Analytics for Excel is required to refresh data.

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

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.

This report lets you visualize the words that bring people to your web site! 

Download for Excel 2007/2010 or for Excel 2003, and then Refresh with Next Analytics. You will be prompted for your Google Analytics account, password and the website profile of interest.

The report downloads and analyzes the past month's search keywords from Google Analytics, and presents the most frequently used words, with the size proportional to the popularity.

This report provides a simple summary of visits and conversions for up to 20 different web properties (Google Analytics profiles), ideal for keeping an eye on the big picture. 

The workbook is easily configured, allowing each of the 20 charts to:

• display 20 different profiles, whether they are different websites or different views of the same site
• display visits count with one alternate metric per chart such as goal conversions
• display meaningful titles and names for each chart and metric
• drop-down lets you pick advanced segments like organic search, paid search, referrals, or new visits
• refresh all 20 charts at once with no manual effort!

Download this Excel workbook MultiSiteSummary.xlsx, identify your profiles and metrics and refresh with Next Analytics. 

Don't have 20 profiles? Simply remove the extras. Want to track more than 20? Easy to add more with simple copy/paste!

This report gives you a quick introduction top the capabilities of Next Analytics for reporting your Google Analytics data inside Microsoft Excel. Simply load and click the Next Analytics Refresh menu.

It includes a trend chart showing new and returning visitors as well as listings of the top sources, top keywords, top locations and top pages. Download the workbook for Excel 2003 or Excel 2007/2010.

This report provides a quick validation check of your website by looking at the bounce rates segmented by your visitor's technical environment.

If your site experiences high bounce rates for particular browsers, connection speeds, languages, versions of Flash or operating system, it may indicate a problem with the site structure or coding. This report gives you a quick snapshot of all these dimensions all on one focused report. Check back a week after any major site change, just in case.

Download here Bounce-Rate-Check.xls.

This report shows you which sources and their respective landing pages are your top performers. It displays both absolute metrics of entrances, pageviews, bounces and goal completions as well as per-visit averages for time on site, pages per visit, bounce rate and conversion rate.

The information is downloaded and presented in Excel with a simple Refresh, ready for inspection or further analysis.

Download this report for Excel2007/2010 or Excel 2003.

This report shows a ranked list of referring sites per period similar to top music charts. Available in weekly and monthly versions, the workbooks allow you to select from 3 to 12 consecutive periods or to set a specific date range. Each column lists the domains of the top 10 referring sites, in descending order by the number of visits they brought to your site.

Download this report with weekly or monthly time periods for Excel 2003 and above.

This report shows the last 12 months of traffic to your website and what sources contributed the most.  It is a simple month-by-month accounting of metrics, including total visits, visitors, direct traffic, organic traffic, referral traffic and traffic from paid campaigns.

It also shows month-to-month percentage change in all of those key metrics as well as the top 5 search engines and referral sites. The report finishes with general site averages for time on site, pageviews per visit, visit bounce rate and the percentage of visits from new visitors.

The workbook can be downloaded here TrafficSourcesByMonth.xls. Use Next Analytics to Refresh the data for your website.

This workbook combines monthly versions of our Overview report, our Visitors with world map, Traffic sources overview, Content overview, eCommerce scorecard and What's changed reports into a single workbook that you can refresh all at once. Each of the overview charts also include dashed lines comparing the previous month's traffic.

The report allows for the selection of the past month, past 30 days or last calendar month as usually requested, but it also allows for the past 28 days or last calendar 4 weeks for better previous-period comparisons on sites with strong weekday-weekend cycles.

Download this report for Excel 2007/2010 or Excel 2003, and refresh with Next Analytics.

This report provides a simply summary of your website funnel performance, with visitor counts and conversion percentages for each step. Any website URL's can be used to define the funnel and the report does not require funnels to be pre-defined in Google Analytics.

The workbook lets you enter regular expressions for up to 5 funnel steps, providing the flexibility needed for ecommerce and dynamic websites. The report includes both a page-to-page flow analysis, where people may enter the funnel at any step, as well as a segmented analysis which shows only visits with all steps included.

The workbook is available for Excel 2003 or Excel 2007/2010 and is refreshed with Next Analytics.