Results 1 to 16 of 16
  1. #1
    ABW Ambassador AddHandler's Avatar
    Join Date
    January 19th, 2005
    Posts
    1,270
    Thumbs up Affiliate Stats Calculator

    I put together a small EXCEL spreadsheet to analyze some site data..
    Just wanted to see if anyone else would be interested in using it..

    ---------
    The Calculator will tell you YOUR::
    1. Average Conversion Ratio
    2. Average Sale Amount
    3. Average Earned Per Unique Visitor (YOURs and MERCHANTs)
    4. Average Pageloads per Visitor, Hour, Week, Month
    5. Average Earned Per Day, Week, Month
    ---------

    All averages are based on the total amount of information entered. It will Analyze 12 months of DATA -- BUT -- if only two months of data are entered the averages will be correctly calculated...

    ++++++++++++
    One of the tools (Cool Stats Page) will allow you to add sales per day or traffic and it will calculate what that would mean to your sales based on your current conversion ratio and average sale amount... if you enter an increase of 10% to traffic it will tell you how many uniques and sales that adds up to be per day... ect.. ect..
    ++++++++++++

    All You Have To Enter For Each Month Is:::
    Pageloads
    Uniques
    Sales
    Commissions
    Retail Value of Sales

    It will even tell you how much your affiliate job is worth based on a 40 hour work week.. (no holidays, time off, sick days or vacation time considered)

    If you enter all the PERSONAL info it will also tell you how many days/hours it takes for you to pay::
    Your Hosting Fee
    Your Rent
    Your Car Payment

    It will even calculate your average taxes (if your tax percentage is correct)

    I hope some of you find this interesting...
    It was just a quick tool I put together for myself so don't expect it to be super NICE.. LOL... but it DOES WORK CORRECTLY........

    It is worth it to have the ability to ADD traffic or sales per day to see what that would do to your income.. the results may surprise you.. (should you try and add more traffic or make more sales with the traffic you have?)

    IF - Anyone uses it and have some ideas of what else should go in it let me know..

    -------------
    PS - The BRAINS of the spreadsheet are on the first page at the bottom hidden in black background. DO NOT mess with these cells or the calculations will not be correct...
    Attached Files Attached Files

  2. #2
    Internet Cowboy
    Join Date
    January 18th, 2005
    Posts
    4,662
    Awesome AH, thanks.
    Affiliates say, nice, cool tool.
    Parasites say, I see a bundling opportunity.
    Thanks for not loading a BHO when I opened it ...LOL


  3. #3
    ABW Ambassador AddHandler's Avatar
    Join Date
    January 19th, 2005
    Posts
    1,270
    I was going to put a DISCLAIMER saying that no Parasites/Adware/Spyware would be installed on your PC.. LOL

    YES - Check it out and let me know what you think about it..

    My Average Conversion Ratio = 3/100
    My Average Pageloads Per Unique = 5.80

    But I would be interested to see what good you think it is...
    Add some data to it and then open the COOL STATS page and increase traffic or sales.. let me know..

  4. #4
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    Palm Springs, CA
    Posts
    866
    This is really neat! Thanks for making it available.

  5. #5
    ABW Ambassador AddHandler's Avatar
    Join Date
    January 19th, 2005
    Posts
    1,270
    OOOOOPS.....
    I just Corrected a MISTAKE I found...
    The MONTHLY Stats was giving a TOTAL instead of an AVERAGE....

    I looked it over and that should be it....
    SORRY ABOUT THAT...
    This is the corrected version...
    Attached Files Attached Files

  6. #6
    Crazy like a fox suzigeek's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,096
    AWESOME!!

    I've been meaning to do this but well you know....jus never did,

    I won't get a chance to dig into it until monday er so.

    THANK YOU!!
    Suz~~GearGirl~~

  7. #7
    ABW Ambassador AddHandler's Avatar
    Join Date
    January 19th, 2005
    Posts
    1,270
    THANKS - people... very much appreciated!

    YES PLEASE ::
    Anyone that uses it please let me know what you think and if you want anything else added.. like more graphs or anything.. I am using it myself to analyze some of my individual sites.. so it is a work in progress..

    My Personal Favorite is the "What If You Did This" section...

  8. #8
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    Quote Originally Posted by AddHandler
    THANKS - people... very much appreciated!

    YES PLEASE ::
    Anyone that uses it please let me know what you think and if you want anything else added.. like more graphs or anything.. I am using it myself to analyze some of my individual sites.. so it is a work in progress..

    My Personal Favorite is the "What If You Did This" section...
    Great tool!

    Would you mind if I posted it at my site for visitors? I'll host the file so you don't have bandwidth problems...

    Thanks,

    Fred

  9. #9
    ABW Ambassador AddHandler's Avatar
    Join Date
    January 19th, 2005
    Posts
    1,270
    buy_online - Sure go ahead... but I am working on Version 1.02 right now LOL...
    That was just a quick tool I put together to see what it would tell me.. and get some ideas of what else I could add..

    Version 1.02 will be much sleaker.. and some important fields will be locked so someone cannot accidently change an important field and mess the calculations up..
    You may want to wait for that one to post as a FREE TOOL..??
    Last edited by AddHandler; October 20th, 2005 at 06:07 PM.

  10. #10
    ABW Founder Haiko de Poel, Jr.'s Avatar
    Join Date
    January 18th, 2005
    Location
    New York
    Posts
    21,609
    AddHandler,

    Great stuff man! PM me your snail mail addy along with your Tshirt Size I'll send you a little ABW goodie package for offering this. If you want a forum for support and feedback, just say so.
    Continued Success,

    Haiko
    The secret of success is constancy of purpose ~ Disraeli

  11. #11
    Affiliate Network Rep
    Join Date
    January 18th, 2005
    Posts
    497
    Nice work AddHandler!

    I really enjoyed reading this whole thread actually. Its great to see somebody being so selfless and giving up their time to create something useful for the whole community.

    Mal
    Malcolm Cowley
    Advertising.com's buy.at affiliate network
    malcolm.cowley@buy.at
    buyat.com

    Ticketmaster has Beta launched their affiliate program with buy.at - be one of the first to join now!

  12. #12
    Affiliate Manager nish's Avatar
    Join Date
    July 6th, 2005
    Posts
    762
    Quote Originally Posted by perfiliate
    Nice work AddHandler!

    I really enjoyed reading this whole thread actually. Its great to see somebody being so selfless and giving up their time to create something useful for the whole community.

    Mal
    Ditto same thoughts. This and your contribution to the datafeed thread.. Excellent work AddHandler.

    cheers!
    -nishith

  13. #13
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    Thumbs up
    Quote Originally Posted by AddHandler
    buy_online - Sure go ahead...
    You may want to wait for that one to post as a FREE TOOL..??
    Will Do... Thanks for putting your time in (for free) to benefit the community

    Fred

  14. #14
    ABW Ambassador AddHandler's Avatar
    Join Date
    January 19th, 2005
    Posts
    1,270
    Its great to see somebody being so selfless and giving up their time to create something useful for the whole community.

    Single Tear.. Thank You.. it is appreciated..

    Well I was just doing this for myself - then I realized that there are other affiliates out there that could probably use something like this as well...

    SO I decided WTF.. why not..

    ----------------------
    Any one that looks at that stats calculator and sees some things that could be done better or easier.. let me know... I am not an Excel Expert at all.. I just like to make cells calculate different scenerios..
    ----------------------

    Putting the finishing touches on Version 1.02 now.. will post ASAP...

  15. #15
    ABW Ambassador AddHandler's Avatar
    Join Date
    January 19th, 2005
    Posts
    1,270
    Affiliate Stats Calculator Version 1.02
    OK - this is the MUCH Better Version 1.02.. LMAO...
    It does everything the other version did only not so ugly..

    and it has a READ ME Tab...

    --------------
    If anyone sees anything else that it "could" do.. let me know...
    ----------------
    Attached Files Attached Files

  16. #16
    ABW Ambassador AddHandler's Avatar
    Join Date
    January 19th, 2005
    Posts
    1,270
    Haiko - Thanks..
    I sent you a PM...

  17. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Life Expectancy Calculator
    By Phil Kaufman aka AffiliateHound in forum Dieting, Fitness & Health
    Replies: 33
    Last Post: May 22nd, 2010, 09:09 AM
  2. Google AdSense Calculator
    By danbradster in forum Search Engine Optimization
    Replies: 5
    Last Post: January 17th, 2007, 03:31 AM
  3. Paypal Fee Calculator!
    By Haiko de Poel, Jr. in forum Marketing Resources & Power Tools
    Replies: 4
    Last Post: January 8th, 2007, 06:38 PM
  4. Google Calculator - Where have I been
    By swampy_webber in forum Virtual Family and Off-Topic
    Replies: 6
    Last Post: December 18th, 2004, 08:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •