- This topic is empty.
-
Posts
-
Hey guys,
I’m starting to create a spread sheet off all my expenses and revenue, well mostly expenses. I forgot how much of a pain in the ass it is to make a functional and nice looking spreadsheet. I want to keep track of all my websites and there transactions.
And like the sticky thread in this forum says, this is the place for newbies to ask the pro affiliates out there for help! I searched the forums but couldnt find anything of help.
So.. does anyone have some good idea’s or is there spread sheets available to download…tools…donation of spreadsheets…something!
Thanks,
Although I cannot give you my spreadsheet, which is extremely proprietary and customized, I will suggest that you keep track of the following, on a month-to-month basis, per vendor:
– Total clicks
– Total revenue
– Calculated revenue/clickThis latter derivative will help crystallize who you should focus on advertising more.
Additionally, total revenue and itemized costs need to be kept. Obviously, total profit is total rev – total cost.
I will be happy to share my spreedsheet with you as I have a blank template. Just PM me with your email address and I’ll send it. I’ve created a file in Excel with two different spreadsheets. One for affiliate stats and the other for advertising stats.
On the affiliate stats I have the following:
1. Affiliate Name
2. Total Clicks
3. Total Downloads
4. Total Signups
5. Total Earnings
6. Amount Owed (amounts below the minimum payment carried over)On the advertising stats I have the following:
1. PPC Search Engine
a. Clicks
b. Advertising Cost
2. Total Paid Clicks
3. Site Statistics
4. Free SE Traffic
5. Total Signups
6. Total Earnings
7. Total Advertising Cost
8. Cost Per Acquisition
9. Hosting/Domain Other Expenses
10. Net ProfitI am the world’s worst bookkeeper and if it wasn’t for the taxman needing proper accounting (and a good accounting firm) I would not know a lot of things.
But there is one thing you bet I always know, one needs this in order to make proper choices among programs and promotions. This is the number of new depositing players and the total number of depositors for every period.
I look at these and change exposure accordingly.
The monthly bottom line for a program can fluctuate with winners and whales and what have you, but in the long term you can see a ratio of depositing players versus income per program.
As you build your business you will be able to make all kinds of decisions based on these stats.
Good point Dominique, and who says the taxman needs proper accounting:devil:
