Filtering your wp7 App Hub Data in Excel

With the new update to the App Hub comes the option to download your data for offline analysis.

One of the most effective ways to do this is also one of the quickest. Utilise two of Excels’ built in analysis features – “autosum” and “autofilter” by following the following two videos which show this can be achieved within a matter of seconds. (With apologies if I am teaching Granny to suck eggs).

This will then allow you to ask questions of your data such as:

How many paid version of a particular app have been downloaded?

Which Country is the primary user of my apps?

Which apps are the most popular?

What is the ratio of free to trial to paid apps ?

(and many more …)

Creating an autosum field

AutoSum Exported Data

AutoFilter Exported Data

NB To filter by date simply bring down only the data required and go through the two steps above again.

No doubt we will see a multitude of Excel templates that make detailed analysis of this data a breeze, but for a quick and dirty analysis you can’t beat the basics of this method!