Excellent Analytics v.1.0.0.45 Released

October 25th, 2009 by Lars Johansson

A new version of Excellent Analytics has been released. It allows you to analyze data from Google Analytics in Microsoft Excel 2007.

New in version 1.0.0.45:

Retrieving 10,000 rows in a single query
Select events in metrics and dimensions
Run a query only containing a metric
Decide from what row data should be retrieved (start index)
Control the number of rows to be imported (max results)

Use start index to fetch more than 10,000 rows (though not in a single query). Set start index to begin from the row # after the last row # in your previous query. Note that you can’t fetch more than 10,000 rows in a single query.

The last 7 days are pre-selected in the date selector. If you do not select dates you’ll get data for the last 7 days.

Share the love:

Tweet This Post

Share on LinkedIn

Posted in Google Analytics, Web Analytics | 1 Comment »

The Mark Red Wine and Cognac Event

October 13th, 2009 by Lars Johansson

As many as 25–30 of the participants from eMetrics invaded the Mark Red office last night. Eric T. Peterson, Jim Sterne, Aurélie Pols, Steve Jackson, Oliver Schiffers, Petri Mertanen, Marc Saarde, and many more were present.

Some of the slides from the landing page optimization workshop I held at the conference:

I also held a competition where participants guessed the outcome of fifteen A/B tests. They were then able to compare their scores to those of a web analyst, an art director, a usability expert, a HiPPO, a monkey, and my mom! The winner got a surprise.

Want to take the test as well? Contact me and I’ll let you know when I’ll present again!

Share the love:

Tweet This Post

Share on LinkedIn

Posted in Web Analytics | 3 Comments »

Excellent Analytics v.1.0.0.45 Released

The Mark Red Wine and Cognac Event

Do more

Other good stuff