Excellent Analytics – How an Excel plug-in Improves Marketing Optimization and your business

Winds of changes do not always come with a roar. In fact many come with a hush.  One terrific hush that came in 2012 (and still going in 2013 – hey, tech never stands still!) was the refinement of analytic dashboards.   These applications were meant to pull data from web analytic solutions, allowing analysts to quickly refine the data into charts or combine with other data queries to support business decisions. One of the earliest for Google Analytics has been Excellent Analytics, an open source plug in for Microsoft Excel for Windows.

Lars Johansson of Outfox, Blogger of web analytics info
Lars Johansson, Co-founder of Outfox and Amploify, Blogger at web analytics info

A while back, I had the pleasure of exchanging an email Q and A with one of the EA original developers, Lars Johansson (@webanalyticsinfo).  Based in Stockholm, Lars developed the plug-in as a necessity to pull and manage data.  He explained some of the details behind the plug-in development that lead to the current team behind Excellent Analytics.

1. How did the team behind Excellent Analytics came to be?  What attracted you to this open source development?

I came up with the idea while running an analytics consultancy, Mark Red. I had used Excel plugins for other web analytics tools previously and seen the benefits, but there was none for Google Analytics. My colleague Christoffer agreed that it was a great idea, so we brought in a student to work on EA as his project. The idea was to get the community involved in the development to ensure that Google Analytics would have the best Excel plugin of all web analytics tools. That’s why we made it open source.

2. You have spoken with a number of well-known analytics professionals, such as Stephane Hamel and Paras Chopas about analytics.  Have you or the EA team encountered a professional audience broader than the analytics community since the launch of EA?

I would say so, yes. We count the users in tens of thousands. It’s not just used by web analyst. In fact, our main criteria when making Excellent Analytics was to make it easier to use than all other web analytics plugins for Excel. It should be so easy that anyone can understand how to use it after watching a short introductory video. As far as I can tell, we’ve succeeded with that. For Excellent Analytics Pro we are facing the challenge of adding more features without making it more complicated and scaring non-analysts off.

3. Can you share some success stories and examples of how businesses have improved their analytical modeling with Excellent Analytics?

The most common story we hear is how Excellent Analytics is saving them a lot of time on the tedious part of analysis: extracting and combining data for analysis. Just by saving your queries and reusing them again you save a lot of time. In Excel you can also use plugins for other types of tools and combine data from multiple sources in a single view. Basically Excellent Analytics is a tool that generates more time for actual analysis.

4. Many other open source developments, like the databases (MongoDB, Couch) have a community, which supports their development.  With EA being an open team back an open source free product, do you find it difficult to find and add developers to assist with refinement and development? 

We have had a number of developers sign up to help us out. To our surprise, however, they have not contributed anything to the project. Maybe it’s because they’re not that familiar with the technology used.

I and Christoffer left Mark Red (which in effect was just the two of us) in June 2010 to start inUse Insights, a web analytics consultancy. We also started the web analytics product company Ampliofy. We can’t put endless of hours into the open source project unless we have a different source of revenue. That’s why we also created Excellent Analytics Pro, which has been coded from scratch to allow for more automation and advanced features. We are making sure both versions of Excellent Analytics will live on through Ampliofy’s developers.

5. What inspirations or new developments in analytics have caught your interest?  Where do you see the budding community of analytics plug-ins headed?

I’m impressed by Paras Chopra’s and Wingify’s fast,  customer-centric, development of Visual Website Optimizer. I also enjoy following Dennis Mortensen’s latest venture, Visual Revenue. Different solutions aiming at making website tagging for web analytics, and other tools, simpler, faster, and less IT-demanding, have also caught my interest for some time.



Dan Bricklin – Spreadsheet Godfather, Technology Royalty (2009 post updated)


Original Post Date; September 9, 2008 (Now we know who is responsible for Excel!)

Every day there’s a new invitation to a network here in NYC. Some groups are “out of the wrapper, still have styrofoam peanuts in the nooks and crannies” new, others have been laboring online for years. Few have hit the sweet spot combination like The New York Tech Meet Up. Started only a few years ago, the numbers of registrants increases every year. In June 2009, the Meet Up had over 10,000 members. Held in the Fashion Institute of Technology (FIT — gotta love it!) Auditorium, attendees listen to speakers from every aspect of application development.

I was pleased to see the presentation by Dan Bricklin, founder of the first spreadsheet, VisiCalc. Now a spreadsheet does not sound sexy, but think about how much can not be achieved without a cell to hold important information (Update: Here is an All Analytics post “Don’t Toss Out Excel Yet” that notes how far Excel plug-in development has come). Zimana’s business, along with many other analytics tools, business firms, consultancies and organizations, rely on the ol’ spreadsheet as a starting point for data analysis.  This movement owes much to VisiCalc.

But Dan did not bore the audience with just column-and-row talk. His autobiographical book Bricklin On Technology covers the early days of his start up and serves as a window into the early days of the computer industry. Bricklin spoke to the New York Tech audience about entrepreneurship, how many people are looking for the pot of gold, but should just try to run a solid business. Says Bricklin, “You’ll end up in an nice home, just focus on what you love to do.” I personally like that statement!

You can  find Dan Bricklin site, including his book Bricklin on Technology here.

I also reviewed Bricklin on Technology at Small Business Trends – click here to read the review.


AI comes to GA: Google Analytics Features Announced with Analytics Intelligence (2009)

Google has made significant refinements to the popular Google Analytics user interface. The biggest news among the enhancements is AI: Analytics Intelligence. According to Google, AI is an algorithmic driven Intelligence engine that “will provide automatic alerts of significant changes in the data patterns of your site metrics and dimensions over daily, weekly and monthly periods.”

This means alerts can help marketers and strategists know when a target metric has changed significantly, like a sudden increase in bounce rate or drop in unique visitors.

In Zimana speak, AI means sweet! 🙂

Other new features include:

    New goal types allow you to set thresholds for Time on Site and Pages per Visit. The allows more grannularlity — say percentage of

Advanced Table Filtering allows user to filter the rows in a table based on different metric conditions such as filtering thousands of keywords to identify just the keywords with a bounce rate less than 30% and that referred at least 25 visits.

Unique Visitors can be selected in Custom Reports as a metric against any dimensions in Google Analytics. This allows marketers to see how many actual visitors (unique cookies) make up any user-defined segment.

UPDATE: You can read about the Analytics Intelligence and other Google Analytics features here at the Google Analytics blog. Share your hopes for the new AI feature here!


Microsoft offers free software development incubator for entreprenuers (2009)

One thing I have learned since being in NYC is that despite an image of high  costs, free is everywhere if one looks carefully.  Microsoft has made free an easier search, at least for software developers.  Microsoft announced the BizSpark program, a business incubator where entrepreneurs can develop software or software-as-a-service (SaaS) using Microsoft servers and resources like Azure and Visual Studio.  The 3 year program is a free to start ups, with a minor exit fee upon completion. During program membership, start ups will have access to Microsoft developers and associated partners, adding visibility to the start up and excellent advisory aid.  Microsoft started the BizSpark program as a means for start ups to create software while reducing the initial development costs.

At a Microsoft Gallery, a short term loft display as part of NYC’s Internet Week, Brian Johnson, Start Up Evangelist at Microsoft, explained the conditions of program. Microsoft is offering the program for small businesses that has less than $1 millions in revenue, that has been in operation for 3 years or less as a privately held company, and that offers software as its core product offering.

As a small business I really appreciate the  effort from Microsoft. They have made some really interesting efforts into small business support that is not heralded in the media often.  Zimana, has used Office Live for hosting the company website  (UPDATE: Officelive has been discontinued in 2012, replaced by Office 365, which has no free hosting.)

For more information check out this BizSpark site.  Also, learn more about Microsoft’s other start up services at the Start Up Zone.


Bookmark and Share