This is a math-geek post (which is ironic as I’ve always hated math; however, it’s quite useful).  It’s totally optional and has the potential to only complicate your life if you let it.  Don’t sweat it; it’s a good thing to not be as OCD as I am.

This sprang out of my desire to best plan my offers – which site gave the greatest value to an offer?

For example: Netflix is worth .33 credits on a $40 site.  It’s worth .25 credits on a $60 site.  Which is the better value?

I decided to assign a dollar value to the offer depending on which site it was on.  That is, how many dollars do you ‘make’ for doing the offer?

The math is simple, really.  It’s:

(referral value) x (credit value) = (offer value)

With our Netflix example, it’s:

40 x .33 = 13.20

An offer worth .33 credits on a $40 site has a value of $13.20.

What about the $60 site?

60 x .25 = 15

So, even though the weight is lower on the $60 site, the value is higher – you’re getting more bang for your buck.

So what?  You ask.  I’m working a $40 site, I need .3 credits to go green, so I’m gonna do Netflix.  Hey, that’s fine!  Nothing wrong with it.  Netflix is a cool company and I’d recommend you try them even if their crediting stunk.

But if you’re like me and want to work as many sites as possible and use your offers to the best possible advantage, this can be useful in your planning.  Once I determined the next several sites I was going to work on, I looked over the offers at all of them.  I created a spreadsheet with columns for each site and offers I was interested in in each row.  The cells I filled in with the offer value on each site, bolded the number where the offer had the highest value, and used the sort tool to organize my info and help me decide which offers were best used where.

Here’s a screenshot of my spreadsheet at work:

Here’s a copy of my spreadsheet for you to download.  Keep in mind, the example page is just that – an EXAMPLE.  Weights of offers can and do change, so I make no guarantees as to the validity of the numbers on that sheet.  Use it exactly as I have, or tweak it to suit your needs, it’s a tool for you to use.