Home > General > Affiliate Marketing Forum

[Request] Using Pivot Tables To Manage Stats (11)

11-28-2011 02:29 PM #1 ppvnewbie (Member)
[Request] Using Pivot Tables To Manage Stats

Hey folks,

is anybody using Pivo Tables in Excel to manage and sort data of their campaigns? I have played with Pivot Tables but still don't get it right.

I would appreciate a short tut about using them for separating data like clicks, ads, conversion...

Any thoughts?

11-28-2011 02:35 PM #2 inversion (Member)

LOL . . . that was on my list to do for the forum today. Give me a couple of hours and I'll post it. :-)

11-28-2011 11:39 PM #3 shanktank (Member)

I first learned about it from Jonathan van Clute.
Here's his video.

11-29-2011 01:41 AM #4 inversion (Member)

That works too! :-)

11-29-2011 04:13 AM #5 rileypool (Member)

The new version of Excel does all the work for you. Highlight the Data. Click Insert PivotTable. Then you can manipulate the data however you want to using the menu on the right hand side.

11-29-2011 04:50 AM #6 shoent (Member)

i made a little something for mobile, hit me up if you want it, can be modified

11-29-2011 04:54 AM #7 pancakes (Member)

Originally Posted by shoent

i made a little something for mobile, hit me up if you want it, can be modified

Share the wealth

11-29-2011 05:05 AM #8 shoent (Member)

ok here it is,its a work in progress and sorry if im im brief im in bed on my ipad right now. you runyour reports on the netwotk side and paste on the first page , make. sure u have the right fields selected and on results page you ledt click and selsect refresh data, here is a dropbox link.please modify amd lets work on makimg it better
http://db.tt/QamhapLQ

11-29-2011 07:40 AM #9 ppvnewbie (Member)

Hey shanktank this vid is golden, thanks for posting!

11-29-2011 08:27 AM #10 harrypotter (Member)

shhhant also did a post pretty recently

http://stmforum.com/forum/showthread...e-long-Subid-s

check it out. certainly helped me.

11-29-2011 09:33 AM #11 topgun (Member)

last time I heard, he started his own coaching program and became an "educator"...

not sure if he still launches ppv campaigns these days...

Originally Posted by shanktank

I first learned about it from Jonathan van Clute.
Here's his video.

Home > General > Affiliate Marketing Forum