Thought I should share some of the lastest analytics news/tools I found…
Microsoft Excel-Google Analytics integration
Through one of my LinkedIn groups I found this new tool - it’s a free, open source, plug-in for Microsoft Excel that let’s you import, store, and manipulate data from Google Analytics.
The add-on is available for free download and use at: excellentanalytics.com - go check it out.

Tracking mobile applications
With all the mobile app stores that have sprung up in the past year, developers and brands have a wide range of new ways to reach mobile users. As is so often true, however, opportunity brings new challenges, and in this case it’s monitoring sales and performance across all those platforms.
Distimo, a Dutch startup has the solution, tracking prices and download activity on all the major app stores. It covers Apple, Android, Blackberry, Nokia and Palm app stores, among others and functions as a sort of Google Analytics for mobile applications, monitoring and reporting on the details of each application’s performance across platforms.
The free Distimo Monitor program (in beta) offers a central place to monitor one’s apps in all app stores. Updated daily, the Monitor program provides an analytics page that also includes information on the competition, such as which channels they’re doing best in and how price changes are affecting their download numbers.
In addition to a free monthly report focusing on Apple’s App Store, the company also offers custom reports for the Apple and Android markets that provide data specific to a client’s applications, including those of the competition.
As the world embraces all things mobile, there are opportunities aplenty not just for developers, but also for those who can help support them.
ROI
When you have all the measurement codes etc. in place, next step is to really have a closer look at your digital marketing investment ROI - some of the key metrics you should be looking at/discussing are:
- Total campaign cost
- Total cost per sold item
- Redemption cost
- Total revenue
- Total profit
- Prospect acquisition
- Customer acquisition
- Click rate
- Response rate
- Conversion rate
- Risk assesment
- Breakeven point
- Prospect asset value
- Life time customer value
- Customer satisfaction
- Long term programme value