Greenguy
2007-01-26, 02:42 PM
I completely forgot that I promised people that I'd type up a little tutorial on how I compile my stats, so here it is.
1st, there's an xls file attached here (http://www.greenguysboard.com/blank.xls). It's the blank sheet that I use when I start a new stats run. You can customize this anyway you like, but this is the one I've made up from the years of me publishing my stats.
So, go to a sponsor, log in & run the stats for whatever time period you choose. I find it easiest to copy & paste the table of results into a blank html file & edit the table by hand (I use Namo's WYSIWYG editor, but you can probably use any html editor or a blank xls sheet) I clean up the table/cells/rows so that there's no background colors, make the fonts all default & unlink everything. Then I delete the rows/columns that I don't need so that I'm down to 4: site, clicks, sales, money
I then copy the sites from the table to the spread sheet under the "Sites" column. Then, the clicks, sales & money totals are all copied & posted into the Clicks, Total Signups & Money columns (these 3 are right next to each other on my sheet, so you can copy & paste them all at once) The sheet then automatically calculates the Overall Ratio, Overall $ Per Click & Money Per PPS totals.
Finally, I put OVERALL in the Sites column & use the AutoSum feature to total up the columns, which also automatically calculates the numbers on the right.
Repeat this process for as many programs you want.
There's also a column on the sheet for Category, which I do at the end of everything - you can do this as you go if it makes you feel better.
One thing that I do as I go is remove bad sites from my listings. I scan thru the results & based on a couple of variables, if a site is performing poorly, I remove it from my admin.
Once you're all done & have all the columns filled in, before you start to sort & whatnot, copy the entire page, paste it into a blank text file (I use Textpad) Then copy it again & paste it back into the spread sheet. This will change all the numbers from calculations/sums to actual numbers (once you start to sort the sheet, if you do not do this, a lot of things will get fucked up, especially the overall totals you used the AutoSum option to compile)
That's it. Sort them by category, by ratio, by money per click, by money per signup, alphabetically - whatever.
OH! This is also a good time to have your accounting books open, looking to see when the last time a sponsor sent you money & if you're owed any.
If you have any questions, feel free to ask :)
1st, there's an xls file attached here (http://www.greenguysboard.com/blank.xls). It's the blank sheet that I use when I start a new stats run. You can customize this anyway you like, but this is the one I've made up from the years of me publishing my stats.
So, go to a sponsor, log in & run the stats for whatever time period you choose. I find it easiest to copy & paste the table of results into a blank html file & edit the table by hand (I use Namo's WYSIWYG editor, but you can probably use any html editor or a blank xls sheet) I clean up the table/cells/rows so that there's no background colors, make the fonts all default & unlink everything. Then I delete the rows/columns that I don't need so that I'm down to 4: site, clicks, sales, money
I then copy the sites from the table to the spread sheet under the "Sites" column. Then, the clicks, sales & money totals are all copied & posted into the Clicks, Total Signups & Money columns (these 3 are right next to each other on my sheet, so you can copy & paste them all at once) The sheet then automatically calculates the Overall Ratio, Overall $ Per Click & Money Per PPS totals.
Finally, I put OVERALL in the Sites column & use the AutoSum feature to total up the columns, which also automatically calculates the numbers on the right.
Repeat this process for as many programs you want.
There's also a column on the sheet for Category, which I do at the end of everything - you can do this as you go if it makes you feel better.
One thing that I do as I go is remove bad sites from my listings. I scan thru the results & based on a couple of variables, if a site is performing poorly, I remove it from my admin.
Once you're all done & have all the columns filled in, before you start to sort & whatnot, copy the entire page, paste it into a blank text file (I use Textpad) Then copy it again & paste it back into the spread sheet. This will change all the numbers from calculations/sums to actual numbers (once you start to sort the sheet, if you do not do this, a lot of things will get fucked up, especially the overall totals you used the AutoSum option to compile)
That's it. Sort them by category, by ratio, by money per click, by money per signup, alphabetically - whatever.
OH! This is also a good time to have your accounting books open, looking to see when the last time a sponsor sent you money & if you're owed any.
If you have any questions, feel free to ask :)