What do you use (or recommend) to keep track of your sales, expenses, traffic?
 

I'm a stats junkie. I like to be able to see as much information as possible. I'm wondering what you guys use to track all your important business data. We keep track of most of it now but I'm sure there is a better solution out there that we really make my life easier.

Ideally I'd like to be able to have one software or place where all our information is.
Some of the information I'm looking to keep track of
Company Expenses
Sales data from processors
Sales data from sponsors
Traffic numbers
Bandwidth Usage
Affiliate Payouts

I'm basically looking for a software where I'll take all my data from the processors, from my affiliate program, from my stats remote, from google analytics and store it all in one place and be able to view trends and analyze the data.

Do you guys have any recommendations? Thanks :thumbsup

get ShylaJennings.com up already!

Sounds like you need some type of BI software.

I've not seen anything solid for this type of data warehouse setup - we're going to build out our own.

That sounds like something really custom. Especially bandwidth and traffic numbers, I would have recommended an accounting software but if you want bw and traffic included that's something really custom.
WG

Which accounting software do you think would be best (if i remove bw and traffic) ;)

I just use Statsremote for everything, including an account for my program that shows the profit from affiliate sales... I also use it's limited expense feature and put in stuff like my hosting and ad buys.

I use QuickBooks which monitors media buying, revenues, etc. It does have the ability to add 2-3 custom fields which you could probably use for bw and traffic fields, but its a lot of work to enter all that data every day/week.
WG

I'm going to give quickbooks a shot (lol i actually had mistyped quickbucks lol).

I had a feeling I may need something custom. I don't mind having someone enter all the data in. I feel if i could somehow bring all the information together it would really help us to improve our ability to maximize our earnings in every aspect of our business.

BI ...............

If you have someone on staff who can do all the bitch work (ie: data entry), why not go custom. Hell its easy enough that you could use Excel and plot charts and graphs with the data you have. If you like stats, you'll love graphing ;)
WG

im so old, i still use Lotus123

You're not old. If you had said VisiCalc, then you?re old.

I use spreadsheets and PHP. In the inverse order.

i think i had that on my old atari

I recommend that you contact back people you have been talking too.

Might take a peek at this. I use it but I don't want to chart as much as you do.

http://www.expensable.com

And you'll be wanting to track sales, or actual money received? You might want a section for payouts to make sure you've gotten paid.

Microsoft Office Excel

That is my current system lol

Yeah, I also use Excel over here...

We did everythign custom to fit our needs.

Statsremote is not always accurate, most of the time it is right. But it can get off thousands and if you run a ccbill paysite its off your ccbill %.

Are you using Access?