Higher Profits: Using Pivot Tables To Analyze & Optimize Advertising Campaigns

This video shows you how to use pivot tables to analyze a mobile campaign, but pivot tables can be used to gain insights into ANY type of online campaign if you are able to collect the right data.

Best viewed in full-screen!

Video Footnotes:

  • Here’s the link to CPV Lab
  • Here’s the link to Jumptap
  • You can reduce the amount of data to be crunched by eliminating any unnecessary parameters.  If some of Jumptap’s parameters are not useful to you, set up your tracking software so it doesn’t receive those parameters.
  • In the sample campaign I used Jumptap and CPV Lab.  Other ad networks and tracking software may have different capabilities in terms of the types and quantities of parameters that they can send and receive through tracking URLS.
  • If you use Tracking202/Prosper202, you’ll need to use Jumptap’s “Option 2″ appending method explained here, and I THINK you’re going to be limited to 4 additional parameters as explained here.
  • The “NY5…” site ID mentioned in the video was modified to protect its identity (you won’t find that site ID on Jumptap)
  • Although “CPV Lab” has the word “CPV” it it’s name, it can just as easily be used for any type of online advertising (in my experience).  I started using CPV Lab a year ago and now I use it for ALL of my advertising campaigns.

{ 10 comments… read them below or add one }

nickycakes January 12, 2012 at 4:38 pm

That’s a really sick video. In the past, I’ve had to do reporting like this with php/mysql and a 3rd party table plugin. This is going to save me a ridiculous amount of time.


Justin (admin) January 12, 2012 at 5:11 pm

Thanks for the feedback, glad you liked it!


Patrick January 12, 2012 at 4:46 pm

Can you actually block specific websites on Jumptap? I didn’t think you could.


Justin (admin) January 12, 2012 at 5:13 pm

Yes you can, but you can’t do it yourself through the interface; you have to email your rep and they’ll do it for you. They can both blacklist (block certain sites from a campaign) and whitelist (set up campaigns targeting ONLY whitelisted sites) any site ids that you choose.


David Kyle January 12, 2012 at 5:21 pm

definitely the best “how to use Pivot tables for analysis” video I’ve seen. Great work, and thanks for sharing!

Shocked a legend like NickyCakes has not been using them. :)


nickycakes January 19, 2012 at 11:57 pm

haha. a legend.. i’m flattered


Buddy January 17, 2012 at 12:43 am

You talk about this excel file & pivot tables.
Why not provide an live & downloadable example, fully filled out of this working Excel File featuring the pivot tables?

It’s all great to see it on video. But if there is something you can provide freely that is an actual working & functional file would be more beneficial.


CTRtard January 17, 2012 at 6:03 pm

Great video. Showing how you analyze actual campaign data makes it way better than any other pivot table video I’ve seen. Nice job!


laurence February 14, 2012 at 1:11 am

well presented im going to watch this video 50 times until i drill this in my skull..you are now INVOLUNTARY…drafed into my mastermind..ill be watching you..lol great job jedi


Chris Lawell April 15, 2012 at 6:14 pm

Great training video. This will be useful for anyone wanting to add another element of analysis to their campaigns. Nicely done.


Leave a Comment