Congrats on your sales, Keith.
The way I keep track of my sell-through rate is I have all my names in an Excel spreadsheet, and I have a column for the exact date when each "goes live" or gets published.
Then I have another column which is =()TODAY-G33
where G33 would be the cell that has the "went live" date
Then way at the bottom of the spreadsheet I have a cell which is the SUM of all the individual days live.
Now I call that number my total listed-days.
You need this number to be able to calculate an exact sell-through rate. (I'll cover the calculation of a sell-through rate in a later post.)
Regarding listed-days, it works like this:
Let's say you have 3 total names published. One has been live for 45 days, one for 27 days, and one for 5 days.
Your listed-days = 45 + 27 + 5 = 77
My actual number for my BB portfolio is 47,404 listed-days. The individual domains range from my first that went live about 14 months ago (436 listed-days) to names that went live today (0 listed-days).
I have 295 names currently listed. So you can see that my average name has been listed for a little over 5 months (161 days).
To be exact, when you have a sale or remove a name, you have to change the cell from =()TODAY-G33 to:
=(date of sale or removal)-G33