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!


~ by Ian on July 19, 2011.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: