More robust "reporting"!
The ability to "export" certain lists seems to be a substitute for reporting, and isn't quite there. Sometime I don't want to simply regurgitate entire contact/organization records. I'd like to be able to filter these lists-as is currently available-then customize what is exported INCLUDING history/notes.
It would be good to be able to filter lists by whether or not an opportunity exists for each contact - this would enable you to identify people who need action
Is useful to have the following option.
People & Organisations-------Filter list by-------Has opportunity------Tag opportunity
People & Organisations-------Filter list by-------Has cases------Tag cases
Why can't I create a custom list based upon website information? it would be great to search by companies with linkedin pages?
Would like the capability to view and filter notes much the same way as other objects and (eg show list of notes and create a custom list of all notes created by a user within the last seven days).
I still find creating reports a bit awkward (in comparison to zoho which we are testing at teh moment). Is is possible to simplify reporting a bit more? I am missing < and > signs, 'starts with' doesnt seem to work very well or is it me?
Thanks for all the feedback so far in this request. The current heading for the request is a bit loose so makes it hard to define exactly what’s required here. Here’s a summary of what I’ve got so far:
There’s a couple of requests in here for boolean operators which is already getting votes over here:
David has mentioned a few specific reports:
1. Number of new leads generated in a period by source
2. Number of leads contacted in a period
3. Number of leads that generated an opportunity
4. Number of opportunties closed, by lead type/source/period
Jeff has requested control over what’s included in the export
I have also had the following requests through our support channel:
- Number of customers handled in a day by user (based on notes). I think this can be handled in the same was item 2 on David’s list.
- Customer report based on tag, date range and user
Is there anything key missing for anyone else following this request?
Mark E Felling commented
Take a look at Nutshell CRM activity reporting. It is PHENOMENAL. It is the one reason I've been seriously considering using Nutshell instead of Capsule. But I like your Integrations with Zendesk and Zero. For each employee there's a small little report that shows their activity in phone calls, emails,and customizable activities such as webinars,quotes, proposals, face-to-face meetings, etc. Manager can set basic expected "standards" and then they can see that they've made 5 of their 10 expected sales calls for the week, etc. Also shows their Sales one versus Projected Sales.
The whole point is these are used as METRICS. You have to have a goal to achieve otherwise it isn't very meaningful. By looking at a little graph and seeing you are halfway or three quarters of the way or 100% there is a quick motivator and measure of success. I heard a metaphor for business, if you want to a baseball game and they told you the scoreboard was broken so they would still play the game but not bother keeping score wouldn't it make it a lot less fun, players would be less motivated to try hard? Business is the same way, you have to have metrics.
Nutshell also adds a report for Sales Cycle (average days to win), Activity Effort [activities per sale]. Under the detailed activity reporting I absolutely love the Benchmark report that shows simple little graphs of how each employee is doing relative to their benchmarks. Each employee is listed vertically with each of their activities under that employee section.
Take a great idea and run with it, mimicry is the greatest flattery. Otherwise I have to encourage Nutshell to take hints/ideas from your integrations with Zendesk and Xero!
ACTIVITY BENCHMARKS PER EMPLOYEE
Really need to be able to export a person/contact along with their full email history, without having to export the whole database!
When will this feature be available. The sooner the better :-)
I am looking at alternatives to Capsule as other newer CRM products appear to offer far superior reporting and presentation of the sales pipeline and related opportunity information.
From a Capsule perspective, the dashboard in particular needs updating and improvement to provide users with a quicker graphical view of current metrics which reflects information in the system such as inbound inquiry levels, a reflection of what is happening with the sales pipeline and progress of opportunities and associated values.
This has been flagged for a very long time, years infact, but still no apparent progress.
Any updates on when this aspect will be dramatically improved. Look to your new competitors if you need further inspiration.
Owen Morgan commented
Hi there, is reporting being worked on? Notice it was first posted in Jan 2010...
Troy Harris commented
Regarding a separate Idea for enabling sort by clicking column title, on 6/8/11 contributor Andy wrote in that thread: "why don't you put this in with more robust reporting?"
I agree, and so have retrieved my vote from that Idea to make the case here that while you're Under Review for this Idea you also consider building a clickable column sort into the eventual reporting solution.
Henry Hwong commented
Need to be able to filter pipeline list based on fields on organization and/or people
Matt S commented
Are any of these being worked on?
Nick Purvis commented
Activity report grouped by opportunity - so you can run a report for, say, a fortnightly meeting that shows all the history related to that opp (notes, conversations, actions, tasks etc) that took place for each opportunity within a chosen time period (e.g. since the last fortnightly meeting).
user activity reports - the ability to see emails, calls and other notes a particular user has added to the system over a chosen period of time - incredibly useful for sales teams to see how active they are and keep them on their toes.
Simply more control over fields that get exported. More robust internal capsule reporting would be icing on the cake.
Kyle Smith commented
I'm glad I'm not the only one with this request. The problem with most CRM's is that they're so complex that sales people end up not using them. You have really great data mining ability, but end up with no data. Capsule is exactly the opposite! The interface is so easy to use, that EVERYTHING gets logged, but we have NO tools to use any of that great data!
Making a big difference in user experience wouldn't require that meany features.
- Opportunities - Exisits in part today.
Filter & Sort by - Sales Person, Organization, Contact, Milestones, a Date Range (instead of a single day), Revenue Potential.
- Activities - Does not exist today.
Filter & Sort by - Sales Person, Organization, Contact, Type of Contact (Note/E-Mail), Date Range.
* It might also be helpful to be able to add a PHONE CALL in addition to a NOTE.
it would be great if you could also utilise the notes field as part of the reporting. Currently this is only available as part of the export function
Ryan O'Connell commented
Can you also please incorporate the ability to filter for opportunities by details about the linked person or organisation.
For example, this would allow you to identify how many opportunities are at x milestone in the region or post code of y, along with multiple other benefits.
Andrena Miles commented
When I have sorted a list, I'd like to be able to print / export it with just certain information not every single field.
George M commented
Is there any news on Capsule's plans for reporting ?
I believe having the ability to build and print sales forecasts, contact reports etc will be critical to the long term take up of CapsuleCRM, and is a logical development to add. It's always difficult to meet every user's reporting needs - so perhaps a system that allows selection of data elements for inclusion in the report template would be the best way to go.
Greg Potts commented
The weak reporting functionality will prohibit us from implementing Capsule company wide. I run a sales and service organization and I love the interface and integration with Google Apps. The inability to get a report on anything non-opportunity related makes Capsule drop on our list of potential CRM systems.
If you are adding in the ability to create specific reports, is it possible to add in the ability to arrange the organisations/people in a list by alphabetical order (ascending/descending)? At the moment it appears in a unknown order (possibly by date added). In addition can you either give the option to expand the number of organisations/people displayed per page or expand the number beyond 50?
Andrew Bishop commented
Our sales reps are required to publish a report every friday with the notes from all the customer visits and phone calls to the Sales Manager. This is currently a manual process by copying all the notes into a word doc. Surely we could simply run a report by user for "notes only" for a certain period; day, week, month etc.
@Lauren Harding You can export any filtered list to Excel. Once you have filtered for a list of contacts or opportunities or cases, on the right hand side there's an option to 'Export to CSV'. The CSV file can then be opened in Excel.
Lauren Harding commented
The capacity to export to Excel from any filtered list is essential. Intervals (Time Task) does this realy well and is ideal for reporting as it allows users to essentially create their own reports rather than having to come up with a standard reporting display to suit everyone (you're never going to please everyone!).