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.

Error! You must specify an anchor parameter if you are not using the auto_thumb option.

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.

4 Comments

  1. manu

    Great tutorial Tom and already learned some nice things about pivot tables I didn’t know before. THANKS!

  2. Mike

    great video! I’m currently watching all of the tutorials you guys have put up. I like how most of the tutorials are short and simple; this makes it easy for me to follow along without being overwhelming from information overload. Thanks!

  3. eitan

    awesome video!!
    you are great man!

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>