Google Analytics Widgets


Adwords Performance Summary

Summarize your Adwords performance with this simple Excel report. Compare key metric values to the previous period for 4 different website profiles. It displays the total cost, number of impressions, clicks, cost per goal conversion, completions and visit count. Select from a number of preset time periods such as the past month or last calendar month, and automatically compare performance to the previous period.

AdwordsSummary

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

 
Google Analytics Visit Duration

How engaging is your content? Is your site organized and keep people interested? How long do visitors stay at your site?

Name: google analytics visit duration.xlsx.xlsx 
Subject: widget 
Keywords: Google Analytics Visit Duration

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Visit Frequency

Measure the interest level and freshness of your content by how often people return to your site.

Name: google analytics visit frequency (number of times they returned).xlsx.xlsx 
Subject: widget 
Keywords: Google Analytics Distribution of How Many Times Your Visitors Have Returned

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Visit Recency

Optimize your content by knowing how many are coming back and how long in between visits? Combine this with segments to get a picture by behavior types.

Name: google analytics visit recency (how long since they last visited).xlsx.xlsx 
Subject: widget 
Keywords: Google Analytics Proportion of Visitors By How Recently They Visited

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Trend By Day of Week and Week of Year

Want to see when the peak periods are? This tells you when the best time to launch new messaging. Day of week, time of day, day of month.

Name: google analytics winners and losers for ANY metric by day and day of week and day of month.xlsx.xlsx 
Subject: widget 
Keywords: See the best and worst values for ANY metric grouped by time of day, day of week, day of month

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics New Versus Returning Visitors with Prior Period

Is your marketing working? Are the proportion of new visitors changing ? By day? What's the overall trend?

Name: google analytics trend of new versus returning visitors with previous period.xlsx.xlsx 
Subject: widget 
Keywords: Google Analytics Trend of New Versus Returning Visitors

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics New Versus Returning Visits

Know the effectiveness of your promotions by measuring the proportion of new versus returning visitors for each day, as well as watching the trend.

Name: google analytics trend of new versus returning visitors.xlsx.xlsx 
Subject: widget 
Keywords: Google Analytics: New vs returning web site visitors

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Visit Depth

Is your content interesting and well organized? Are your visitors finding what they're looking for?

Name: google analytics visit depth (number of page views).xlsx.xlsx 
Subject: widget 
Keywords: Google Analytics number of page views (depth)

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Top Keywords for Visitors to Your Site

Optimize your content and messaging by knowing what people were searching for when they landed at your site.

Name: google analytics top keywords used by people when they landed on your site.xlsx.xlsx 
Subject: widget 
Keywords: Keywords people were using when they landed at your site

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Top Cities for New and Returning Visitors

Is your geographic-segmented marketing working? Where should you invest your budget and energy? Is there a long tail? How big is the tail compared to the top ten?

Name: google analytics top ten cities for new and returning visitors to your site.xlsx.xlsx 
Subject: widget 
Keywords: Top Ten cities by new and returning visitors (incudes sum of the rest)

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Top Mediums and Sources

Is your traffic generation working? Are your visits coming from where you think they should be? What mediums should you emphasize?

Name: google analytics top traffic medium and source for new and returning visitors.xlsx.xlsx 
Subject: widget 
Keywords: Top Traffic medium and source combinations that drive traffic to your site

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Trend of Any Metric

Looking to monitor how a metric is trending?

Name: google analytics trend of ANY metric.xlsx.xlsx 
Subject: widget 
Keywords: Use this Widget to Get a Trend of ANY Metric over ANY Date Range

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Top Traffic Sources and Mediums

Is your traffic generation working? Are your visits coming from where you think they should be? What sources should you emphasize?

Name: google analytics top 100 traffic source and medium for visitors.xlsx.xlsx 
Subject: widget 
Keywords: Top 100 Traffic source and medium combinations that drive traffic to your site

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Top Web Pages for New and Returning Visitors

What are your top pages? What pages are in your long tail? How much do they contribute to the overall flow? Do the impact new or returning customers or both?

Name: google analytics top 100 web pages for new and returning visitors.xlsx.xlsx 
Subject: widget 
Keywords: Top 100 web pages - new and returning visitors

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Top Web Pages

What are your page ranks? I mean, what are the page ranks ON YOUR OWN Site? Use this to find out what content is getting found, and what people are landing on. Do you have a long tail?

Name: google analytics top 100 web pages for web page views.xlsx.xlsx 
Subject: widget 
Keywords: Top 100 webpages with percentage of pageviews

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Top Keywords of New and Returning Visitors

What are new visitors searching for when they land on your site? What are returning visitors searching for? What's popular with both new and returning? Use this to optimize your content and messaging.

Name: google analytics top keywords used by new and returning visitors to your site.xlsx.xlsx 
Subject: widget 
Keywords: Top keywords of new and returning visitors

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Popular Operating Systems

Is your messaging the right one? Is the presentation what they're comfortable with? Are your web site visualizations the most appropriate? Be sure to check out the screen-size widget too!

Name: google analytics popular operating systems used by visitors to your site.xlsx.xlsx 
Subject: widget 
Keywords: Most Popular Operating Systems Used by Visitors To Your Web Site

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Popular Screen Sizes

Is your messaging the right one? Is the presentation what they're comfortable with? Are your web site visualizations the most appropriate? Be sure to check out the operating system widget too!

Name: google analytics popular screen sizes used by visitors to your site.xlsx.xlsx 
Subject: widget 
Keywords: Most Popular Screen Sizes Used by Visitors To Your Web Site (includes sum of the rest)

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Web Site Scorecard

How do your overall site metrics compare with last month or last year? What is the trend?

Name: google analytics scorecard showing current vs previous period vs last year for key metrics.xlsx.xlsx 
Subject: widget 
Keywords: Popular Web Site Metrics and Trends for Current, Previous, Last Year

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Any Metric Over Any Time Period

Display any metric over any time period. Compares the current period to the previous period and same period last year. Use any of three common sample presentations included: as a mini-chart, as a scorecard row, or as a major page element. 

Name: google any metric any time period.xlsx 
Subject: widget 

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Any Dimension Any Metric Any Time Period

Display any dimension and any metric for a specific time period. Shows the top values and displays with the percentage of total. Use any of three common sample presentations included: as a top-10 table, as a stacked column chart, or as a pie chart. 

Name: google any dimension any metric any time period.xlsx 
Subject: widget 

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Ecommerce Scorecard

How's the overall health of your eCommerce? Is Revenue rising? Are transactions increasing? Are the conversions better than last period or last year? What was the average order value?

Name: google analytics scorecard showing eCommerce metrics.xlsx.xlsx 
Subject: widget 
Keywords: Ready to Use eCommerce Scorecard Five Key Metrics Showing Current, Previous, Last Year Comparisons and Sparkline

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Compare Any Metric Any Dimension to Prior Periods

How is your favorite dimension doing against your favorite metric compared to previous period? How about year ago?

Name: google analytics get ANY metric by ANY dimension and see values for current previous year-ago.xlsx.xlsx 
Subject: widget 
Keywords: Choose ANY metric and ANY dimension and see how it compares to previous period, and same period a year ago

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Dashboard Metrics

Want to know the value of any five metrics for your chosen segment and time range?

Name: google analytics micro-widgets showing any five metrics.xlsx.xlsx 
Subject: widget 
Keywords: Pick ANY FIVE METRICS to add to your dashboard

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Dashboard Parts Trends and Comparisons

Are you building a scorecard for overall web site health? Chances are you need these metrics. Nice to be able to compare to last month in one condensed visual.

Name: google analytics micro-widgets showing key metrics with sparklines net change and growth as well as month by month trend.xlsx.xlsx 
Subject: widget 
Keywords: Re-usable parts to build a scorecard with: Sparkline and trends, last month's values, growth of Five Key Metrics

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Top Browsers

Is your messaging the right one? Is the presentation what they're comfortable with? Are your web site visualizations the most appropriate? Be sure to check out the screen-size widget too!

Name: google analytics popular browsers used by visitors to your site.xlsx.xlsx 
Subject: widget 
Keywords: Most Popular Browsers Used by Visitors To Your Web Site Plus Sum of the Others (includes sum of the rest)

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Dashboard Metrics Compared to Site Average

How does one segment compare to "all visits segment"? Use it to measure the proportion of a segment to the overall traffic.

Name: google analytics five key metrics comparing segment to overall site average.xlsx.xlsx 
Subject: widget 
Keywords: Google Analytics Compare a Segment to All Visits Segment, see the proportion of Visits, Pageviews, Bounce Rate, Pages/Visit, Time on Site

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Dashboard Metrics Compared to Prior Period

As an overall sign of web site health, how are these popular five metrics doing compared to prior period?

Name: google analytics five key metrics current vs prior period.xlsx.xlsx 
Subject: widget 
Keywords: Google Analytics Visits, PageViews, Bounce, Pages/Visit, Time on Site: Current Period Versus Prior Period

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Any Dimension and Five Key Metrics

Choose any Google Analytics dimension and see what the values are for five popular metrics. Useful for a broad range of business needs.

Name: google analytics five key metrics for ANY dimension.xlsx.xlsx 
Subject: widget 
Keywords: See Five Key Metrics by ANY dimension

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Event Actions by Labels

Name: google analytics events action by label.xlsx.xlsx 
Subject: 
Keywords:

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Event Categories by Actions

Name: google analytics events category by action.xlsx.xlsx 
Subject: 
Keywords:

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Event Categories by Labels

Have you added events and categories to your web site? Then use this widget to see how they are distributed.

Name: google analytics events category by label.xlsx.xlsx 
Subject: widget 
Keywords: Web Site Events -- See the Distribution of eventCategories by eventLabels

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Dashboard Metrics Compared to Prior Period

Get a sense of overall web site health by looking at how these five key metrics change from period to period

Name: google analytics five key metrics comparing period to previous period.xlsx.xlsx 
Subject: widget 
Keywords: Google Analytics Comparison of Five Key Metrics Current Period Compared to Previous Period

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Catch Trends As They Are Happening

Catch trends as they are happening. This analytic goes beyond straight comparison, it also accounts for period-wide volume. Often referred to as a what's changed report.

Name: google analytics compare ANY dimension period to period to see whats hot whats not.xlsx.xlsx 
Subject: widget 
Keywords: Compare period to period and immediately know what's rising and falling. Works for ANY dimension.

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Any Dimension Distribution

Everyone needs something different. What do you need to know? And over what time period do you want it summarized?

Name: google analytics distribution of members for ANY dimension.xlsx.xlsx 
Subject: widget 
Keywords: Pick a dimension and time period. Add it to your dashboard.

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Compare Affiliate Sales/Conversions By Month from Google Analytics

See how your affiliates are performing. Compare their sales month to month.

Name: google analytics affiliation sales by month.xlsx 
Keywords: Google Analytics, affiliations

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Compare Ad Groups by Revenue/Conversions from Google Analytics

See which ad groups are delivering higher conversion values or product sales. Compare this to the number of visits all on one chart.

Name: google analytics revenue by ad group.xlsx 
Keywords: Google Analytics, conversions, ad groups, revenue

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Landing Page Load Times and Bounce Rates

See which of your top landing pages are are slow to load or experiencing higher bounce rates. Stay ahead of trends by comparing to the previous period.

Name: google analytics landing page load time and bounce rate.xlsx 
Keywords: Google Analytics, landing pages, bounce rate, page load time

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

 
Google Analytics Number of Visits Until Ecommerce Transaction

Measuring marketing efforts is all about measuring money.

Unfortunately, customers don't always cooperate. They'll see a mention of your brand, they'll visit your web site, as well as Facebook and Twitter to check you out, they might see a print ad. Each time, they'll visit your web site to confirm what they heard.

So, one valid question is, How many visits do your website visitors make before they become customers?

HERE'S A HANDY WIDGET YOU CAN ADD TO ANY SPREADSHEET that tells you how many visits they made before they purchased something. It gives you an idea of their engagement, their adherence to your brand, and a sense of whether or not you need to invest in other forms of marketing.

Using our widgets is easy. Watch the videos on our demo page to see it in action.

 

Name: google analytics visits to transaction.xlsx 
Keywords: Google Analytics, Ecommerce

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

Thanks to Ani Lopez of dynamical.biz for the inspiration behind this widget.

 
Excel Widget #Measure Days from First Visit to eCommerce Transaction

This is another great excel widget that tells you how long it takes to convert a customer to their first eCommerce transaction. It was contributed by Ani Lopez of Cardinal Path.

As a marketer, this is vital information. You are effectively measuring your messaging as well as how efficient your funnel is, according to what actually happens through real customer behavior.

By knowing this information can help make business decisions. For example, you can consider various incentives to either accelerate their purchase, or use the time to encourage them to upsize their order. You can conduct independent lead nurturing campaigns for those who have entered the funnel without actually purchasing yet. Knowing how many days help with all these marketing and sales activities.

So, bottom line, it would be very useful to know how quickly you are converting your website visitors into customers. 

So why is this widget useful? Google Analytics, with a bit of time spent setting up the eCommerce, is free. If you already own Next Analytics, you can get this valuable data for free, otherwise the cost is only $199/year. Join the many hundreds of customers who think that Next Analytics offers great value.

Since it is one of our new version 4 widgets, you can incorporate it quite easily into an existing spreadsheet or as the basis of a new one. And it wil work on both the Windows and MAC platforms.

Name: google analytics days to transaction.xlsx 
Keywords: Google Analytics, Ecommerce

This widget is available for Excel 2007 and above and is refreshed with Next Analytics.

Thanks to Ani Lopez of dynamical.biz for the inspiration behind this widget.