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

Shap · 06-08-2008, 10:55 AM

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

Mutt · 06-08-2008, 11:00 AM

get ShylaJennings.com up already!

datatank · 06-08-2008, 11:00 AM

Sounds like you need some type of BI software.

Daruma · 06-08-2008, 11:01 AM

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

WiredGuy · 06-08-2008, 11:16 AM

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

Shap · 06-08-2008, 11:22 AM

Quote:

Originally Posted by WiredGuy

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) ;)

fuzebox · 06-08-2008, 11:22 AM

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.

WiredGuy · 06-08-2008, 11:45 AM

Quote:

Originally Posted by Shap

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

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

Shap · 06-08-2008, 08:49 PM

Quote:

Originally Posted by WiredGuy

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.

datatank · 06-08-2008, 10:35 PM

Quote:

Originally Posted by Shap

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 ...............

WiredGuy · 06-08-2008, 11:22 PM

Quote:

Originally Posted by Shap

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.

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

the Shemp · 06-08-2008, 11:40 PM

im so old, i still use Lotus123

NemesisEnforcer · 06-09-2008, 12:24 AM

Quote:

Originally Posted by the Shemp

im so old, i still use Lotus123

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

GrouchyAdmin · 06-09-2008, 12:34 AM

I use spreadsheets and PHP. In the inverse order.

the Shemp · 06-09-2008, 01:11 AM

Quote:

Originally Posted by NemesisEnforcer

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

i think i had that on my old atari

Warren · 06-09-2008, 01:22 AM

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

Bama · 06-09-2008, 01:44 AM

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

NinjaSteve · 06-09-2008, 04:05 AM

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.

Eman - PG · 06-09-2008, 08:47 AM

Microsoft Office Excel

Shap · 06-09-2008, 09:09 AM

Quote:

Originally Posted by Eman - PG

Microsoft Office Excel

That is my current system lol

tranza · 06-09-2008, 09:15 AM

Yeah, I also use Excel over here...

Niktamer · 06-09-2008, 09:15 AM

We did everythign custom to fit our needs.

KillerK · 06-09-2008, 11:28 AM

Quote:

Originally Posted by fuzebox

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.

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 %.

Shap · 06-10-2008, 08:40 AM

Quote:

Originally Posted by Niktamer

We did everythign custom to fit our needs.

Are you using Access?

06-08-2008, 10:55 AM	#1
Shap Confirmed User Industry Role: Join Date: May 2001 Posts: 8,313	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

06-08-2008, 11:00 AM	#2
Mutt Too lazy to set a custom title Industry Role: Join Date: Sep 2002 Posts: 34,431	get ShylaJennings.com up already! __________________ I moved my sites to Vacares Hosting. I've saved money, my hair is thicker, lost some weight too! Thanks Sly!

06-08-2008, 11:01 AM	#4
Daruma Confirmed User Join Date: Nov 2002 Location: PandaLand™ Posts: 3,494	I've not seen anything solid for this type of data warehouse setup - we're going to build out our own. __________________ RIP TD

06-08-2008, 11:16 AM	#5
WiredGuy Pounding Googlebot Industry Role: Join Date: Aug 2002 Location: Canada Posts: 34,482	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 __________________ I play with Google.

06-08-2008, 11:40 PM	#12
the Shemp congrats to the winners Industry Role: Join Date: Nov 2001 Location: Echo Beach Posts: 10,891	im so old, i still use Lotus123 __________________ i use Vacares...so should you Submit your picture galleries to my site...Outlaw TGP

06-08-2008, 11:00 AM	#3
datatank Confirmed User Join Date: Aug 2004 Location: My dog is blacker than Tupac Posts: 5,471	Sounds like you need some type of BI software.

06-08-2008, 11:22 AM	#7
fuzebox making it rain Industry Role: Join Date: Oct 2003 Location: seattle Posts: 22,113	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.

06-09-2008, 12:34 AM	#14
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	I use spreadsheets and PHP. In the inverse order. __________________ AIM: GrouchyGfy

06-09-2008, 01:22 AM	#16
Warren Confirmed User Join Date: Jul 2003 Location: Porn Valley Posts: 2,284	I recommend that you contact back people you have been talking too. __________________ ICQ:208-603-797 www.altdollars.com

06-09-2008, 01:44 AM	#17
Bama Confirmed User Join Date: Nov 2001 Location: Redmond, WA Posts: 2,727	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

06-09-2008, 04:05 AM	#18
NinjaSteve Too lazy to set a custom title Industry Role: Join Date: Dec 2003 Posts: 11,089	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. __________________ ...

06-09-2008, 08:47 AM	#19
Eman - PG PG Co-Boss Industry Role: Join Date: Nov 2003 Location: GFY Posts: 524	Microsoft Office Excel

06-09-2008, 09:15 AM	#21
tranza ICQ: 197-556-237 Join Date: Jun 2003 Location: BRASIL !!! Posts: 57,559	Yeah, I also use Excel over here... __________________ I'm just a newbie.

06-09-2008, 09:15 AM	#22
Niktamer Lord of the Leads Industry Role: Join Date: May 2005 Location: Canada Posts: 3,021	We did everythign custom to fit our needs. __________________