?
Solved

Choosing Sales Tracking Software

Posted on 2014-02-24
3
Medium Priority
?
337 Views
Last Modified: 2014-02-25
I have been looking online for a good sales tracking program but have not found one that suits our needs.

I am looking for:
 - The ability to enter sales that happened up to 8 years ago
 - Track the customers who purchased product from us (and break it down by the product, date, and $ spent)
 - See visual data analytics for each year (starting in 2006).

A little more detail:

We sell Buses (School, Commercial, Parts, Etc.) - I am looking for a way to enter all of our bus sales (starting in 06) based on customer and for a program to break down the data to show how much a customer (school district) buys from us (and how often, because most schools replace a small % of their fleet every year). I am willing to enter each sale we have had since 2006 (including price, type of bus, and customer) if I can get a good program to give me valuable feedback from that data. (i.e. which customers have purchased every year, which customers have not purchased from us in many years, etc.)


I have looked into Zoho, Salesforce, etc. and it seems like they are catering to ACTIVE salesman to be a daily "to do" list based on their opportunities to make sales.

I am looking for a program to look at a year(s) worth of data and give me specific breakdowns based on that data.

Any suggestions?
0
Comment
Question by:Nicholas_BlueStar
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Joe Winograd, EE MVE 2015&2016 earned 2000 total points
ID: 39883634
Hi Nicholas,

Two comments for you:

(1) Although you're right that Zoho CRM focuses on active sales, Zoho Reports can almost surely do what you're looking for:
https://www.zoho.com/reports/

Zoho Reports has some very nice visual data analytics, with a good selection of chart types and customization features:
https://reports.wiki.zoho.com/Charts.html

(2) Your needs sound relatively simple and I'm thinking that you may even be able to do what you want in Excel, including charts/visuals.

Regards, Joe
0
 

Author Comment

by:Nicholas_BlueStar
ID: 39884250
Thanks Joe!

unfortunately their sign-up is not currently working (go figure) - I will check it out as soon as their site comes back on.

As for excel - I was thinking the same thing. However, I am not very knowledgeable about excel and am worried I would not be able to "design" it correctly to really utilize the data...any pointers if I decide to go that route? Examples? Templates? Websites?
0
 
LVL 57

Expert Comment

by:Joe Winograd, EE MVE 2015&2016
ID: 39886241
Hi Nicholas,
I hope Zoho sign-up is working and that you've had a chance to take a look. I am by no means an Excel expert, but based on my somewhat limited knowledge, I'm pretty sure it's doable. There are some real experts on Excel here at EE. One of them is teylyn, who is an EE MVE and also an MS MVP in Excel for 2012, 2013, and 2014. I'm sure a question in the Excel topic here at EE will reach her, but she also has her own website.

I think Zoho Reports (with Charts) will do what you want, but I also think Excel will work for you...with some help from the experts. :)  Regards, Joe
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While Plesk offers many potential benefits to website administrators, including compatibility with Windows Server and other leading technologies, the company has also been working to differentiate it from other control panels for content management…
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question