Fast Mobile Data Analysis via Excel Pivot Tables

February 18, 2012 4 Comments by Tom Fang

The name “Pivot Table” somehow makes it sound like it’s some advanced gizmo only reserved for the Excel wizards.  It’s actually quite the opposite.  It’s an easy, fast, yet powerful, way for marketers who are not familiar with Excel to quickly be able to analyze large amounts of data.  So, if Excel gives you a general headache overall, I promise, this will be a lot more pain free.

Mobile marketing gets bigger, more popular, and more interesting by the day.  As we get into it, we discover that there are a lot more parameters and variables to be tracked and analyzed than traditional traffic sources.  Pivot Tables should provide you with a versatile way to handle these extra columns that you have to deal with in your reports.

Mobile Data with Pivot Tables

The sample report in the tutorial is a real report sent to me from one of our subscribers today.  He wanted to take a look at the report and help him drill down and optimize conversion rates for his campaign using Pivot Tables.  The report used is from his Neverblue account.

While you may track your data a lot differently, I hope you still learn from this video and apply the methods to all your data tables.  This tutorial only teaches the basics of analyzing data from one table.  Look out for more tutorials in the future for data analysis across multiple tables!  Enjoy.