Higher Profits: Using Pivot Tables To Analyze & Optimize Advertising Campaigns
Warning: preg_match_all() [function.preg-match-all]: Compilation failed: invalid range in character class at offset 22 in /home/adchop/public_html/wp-content/plugins/wordpress-https/wordpress-https.php on line 392
Warning: preg_match_all() [function.preg-match-all]: Compilation failed: invalid range in character class at offset 22 in /home/adchop/public_html/wp-content/plugins/wordpress-https/wordpress-https.php on line 392
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 }
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.
Thanks for the feedback, glad you liked it!
Can you actually block specific websites on Jumptap? I didn’t think you could.
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.
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.
haha. a legend.. i’m flattered
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.
Great video. Showing how you analyze actual campaign data makes it way better than any other pivot table video I’ve seen. Nice job!
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
Great training video. This will be useful for anyone wanting to add another element of analysis to their campaigns. Nicely done.