How to use Flag-filters, Spread-sheets, etc.

Hello everyone,

I don't see too many golden member with
2000 rented referral posting their stats.

I was in profit with 2000 refs and see
the earning potential and have since upgraded to rent more than 2000.
Message posts before 128 still applies to golden with 2000 rented referrals.

Hope you can learn from my stats...

Membership
Since: 2009/07/10
[x]Golden 2009/09/18
[x]Diamond 2010/10/30
[x]Ultimate 2010/11/23

Current Strategies

AutoPay

• Always Off

Renewing

• 240 days

Recycling

• All refs clicking less than 6 clicks
  every 10 days gets red flag and monitored.
  Then recycled if clicking less than 4 clicks every 10 days.

Other

• 16 clicks within 5 days gets locked
• I also keep track of daily clicks using the export list,
  it makes recycling decision lot easier.

Flag Filter Golden with less than 2000 refs, activity filter is 14/6

• White: 0 clicks and new refs,
  all new clickers are moved to red
  
• Red: 12 ~ 16 clicks every 10 days
  Moved to yellow
  
• Orange: refs that clicks below BEP
  and over 21 days old
  recycled on their first click
  
• Yellow: 16 clicks or more every 10 days
  Moved to green
  6 ~ 8 clicks every 10 days are moved to red
  4 clicks or less every 10 days are moved to orange
  
• Green: 12 clicks or less are move back
  to yellow
  
• Blue: profitable weekly clickers,
  clicking below BEP are moved to orange

Flag Filter Golden with Ultimate pack, activity filter is 17/7

• White: 0 clicks and new refs
  Move all refs that have clicked to red flag
  
• Red: 16~20 clicks are locked and moved
  to green flag
  
• Orange: refs pick out from spread sheet
  that has less than 4 average clicks over 4
  weeks in a row recycled as soon they made a click.
  
• Yellow: study and test group
  
• Green: average less than 1.2 are
  moved to yellow
  
• Blue: profitable weekly clickers,
  clicks at least 9 or 10 ad regularly,
  refs are monitored regularly

Strategies are developed to adapt to current refs/overall account situation.
Current ultimate pack strategies:
110204
http://www.neobux.com/forum/?/4/147947/schen2000-Golden-with-Ultimate-Pack/0/1947180/#m1947180
110419
http://www.neobux.com/forum/?frmid=4&tpcid=147947&msgid=2160439#m2160439
110506
http://www.neobux.com/forum/?/4/147947/schen2000-Golden-with-Ultimate-Pack/0/2195428/#m2195428

Current Goals:

• [x] To reach 5,000 Personal clicks 101115
• [x] To reach 6,000 Personal clicks 110105
• [x] To reach 8,000 Personal clicks 110320
• [x] To reach 10,000 Personal clicks 110513
• [ ] To reach 15,000 Personal clicks
• [ ] To reach 20,000 Personal clicks
• [ ] To reach 30,000 Personal clicks
• [ ] To reach 50,000 Personal clicks
  
• [x] To reach 250,000 Referral clicks 100923
• [x] To reach 300,000 Referral clicks 101026
• [x] To reach 400,000 Referral clicks 101221
• [x] To reach 500,000 Referral clicks 110127
• [x] To reach 600,000 Referral clicks 110226
• [x] To reach 700,000 Referral clicks 110325
• [x] To reach 800,000 Referral clicks 110419
• [x] To reach 900,000 Referral clicks 110512
• [ ] To reach 1,000,000 Referral clicks
• [ ] To reach 2,000,000 Referral clicks
• [ ] To reach 3,000,000 Referral clicks
  
• [x] To reach 1500 clicks a day 100925
• [x] To reach 1600 clicks a day 101026
• [x] To reach 1800 clicks a day 101122
• [x] To reach 1900 clicks a day 101124
• [x] To reach 2000 clicks a day 101128
• [x] To reach 2100 clicks a day 101130
• [x] To reach 2200 clicks a day 101216
• [x] To reach 2400 clicks a day 101225
• [x] To reach 2500 clicks a day 101228
• [x] To reach 2600 clicks a day 101229
• [x] To reach 2700 clicks a day 110101
• [x] To reach 2800 clicks a day 110111
• [x] To reach 2900 clicks a day 110113
• [x] To reach 3000 clicks a day 110120
• [x] To reach 3200 clicks a day 110120
• [x] To reach 3400 clicks a day 110213
• [x] To reach 3600 clicks a day 110223
• [x] To reach 3800 clicks a day 110304
• [x] To reach 4000 clicks a day 110320
• [x] To reach 4200 clicks a day 110403
• [x] To reach 4400 clicks a day 110417
• [x] To reach 4600 clicks a day 110519
• [ ] To reach 4800 clicks a day
• [ ] To reach 5000 clicks a day
• [ ] To reach 6000 clicks a day
• [ ] To reach 7000 clicks a day
• [ ] To reach 8000 clicks a day
  
• [x] To reach ROI 25% 110113
• [ ] To reach ROI 50%
• [ ] To reach ROI 75%
• [ ] To reach ROI 100%
• [ ] To reach ROI 125%
• [ ] To reach ROI 150%
• [ ] To reach ROI 175%
• [ ] To reach ROI 200%

Ref avg = Total ref clicks / # of Refs

Day:
100919
Total ref clicks:
1241
Recycle:
5.88$

Thank you for any suggestions ^^

SPREAD SHEETS:
(use at your own risk & check for errors)

1. Break even spread sheet for Standard, Golden (& 2nd year),
   Emerald, Sapphire, Platinum, Diamond , and Ultimate (& 2nd year) members
   last updated 2011/01/19
   last updated 2011/03/25
   
2. Basic generic export list to track export list
   last updated 2010/10/29
   
3. Advance ExportList_Mar_01_2011.ziplast updated:
   2011/03/01 (bits of makeover and improved)
   2011/03/25 (update the tables, to reflect the changes)
   
   About export list & instructions here
   
4. Daily Profit Calculator
   last updated:
   2011/01/13 (Renewing cost 1 ref per day fixed)
   2011/05/01 (sorry, monthly tab removed/not supported)

Read here for a How To Guide and FAQ