Help - Need to get organized

matyko · 2008-07-17, 04:44 AM

Very nice thread!

Since I am analyzing my stats/sales/etc my biz is growing very fast. I highly recommend to everyone to track sales, traffic and ROI as accurate as possible.

I have a spreadsheet for all my submitted galleries, with date/URL/long description, and have a separate sheet for important submissions like The Hun, WorldSex, etc. For these I also track if they are approved (with date) and results (sale amount/type/$$$).

For tracking the sales I have another spreadsheet and I log: date/sale type/$$$/source (AskJolene for example)/site (assholefever for example)/gallery URL/sponsor program/notes (rebilled or not for trials). At the beginning of each new month I summarize the latest months sales:
Rebill $$$/sales $$$/extra (bonuses, etc), number of sales/rebills, and 10 most important sale sources. This way its very easy to count at least an approx ROI for paid passes.

Payment tracking:

Another spreadsheet with 3 pages:
1) payment forecast: when can i expect a payment/from which sponsor/exact amount.
2) payment history: when receiving a payment, i move the cells from the forecast part to here, under the actual month. There's a huge autosum cell where i can see clearly how much money i got that month.
3) expense calendar: to avoid expired passes, etc.

2008-07-17, 04:44 AM	#20
matyko Well you know boys, a nuclear reactor is a lot like women. You just have to read the manual and press the right button Join Date: Jan 2008 Location: Hungary Posts: 158	Very nice thread! Since I am analyzing my stats/sales/etc my biz is growing very fast. I highly recommend to everyone to track sales, traffic and ROI as accurate as possible. I have a spreadsheet for all my submitted galleries, with date/URL/long description, and have a separate sheet for important submissions like The Hun, WorldSex, etc. For these I also track if they are approved (with date) and results (sale amount/type/$$$). For tracking the sales I have another spreadsheet and I log: date/sale type/$$$/source (AskJolene for example)/site (assholefever for example)/gallery URL/sponsor program/notes (rebilled or not for trials). At the beginning of each new month I summarize the latest months sales: Rebill $$$/sales $$$/extra (bonuses, etc), number of sales/rebills, and 10 most important sale sources. This way its very easy to count at least an approx ROI for paid passes. Payment tracking: Another spreadsheet with 3 pages: 1) payment forecast: when can i expect a payment/from which sponsor/exact amount. 2) payment history: when receiving a payment, i move the cells from the forecast part to here, under the actual month. There's a huge autosum cell where i can see clearly how much money i got that month. 3) expense calendar: to avoid expired passes, etc. __________________ Matyko (Listen to PsyRadio FM)