How do I see how my sales team is doing?
The CRM Reports screen answers three different questions, and that is why it has three tabs. Dashboard is the quick look: how things are going right now. Reports is the in-depth library: tables you can sort, open up and export. Printable reports are papers to print or save as PDF.
It opens at /crm/informes.
If your company has only the CRM, this screen doesn't have the Dashboard tab: the Dashboard is then your home screen, and it is explained in the home screen when you only have the CRM. The other two are the same.
What do I need before I start?
Contacts and deals loaded in the CRM. With a brand-new CRM the panels show zero, and that isn't an error: there is nothing to summarise yet.
Some data comes from the ERP, not from the CRM: actual invoicing and who is a customer. If the contact isn't linked to an ERP customer, it doesn't appear in those numbers.
What does the Dashboard tell me at a glance?
At the top there are six figures, and they all follow the period and the scope you choose.
- Value of deals — the money from everything still open, neither won nor lost. It is what sales people call the pipeline.
- Won — the money from what you closed successfully within the period.
- Conversion rate — of everything closed in the period, what percentage you ended up winning.
- Customers — contacts who have already bought from you.
- Contacts at risk — customers who haven't bought from you for a while. Click the card to see who they are.
- Deals stalled — open and stuck for more than 30 days in the same stage. You can also click it to see which ones.
When two figures don't match each other there is usually a reason: Won counts what the CRM treats as closed, and Customers what the ERP has actually invoiced.
What do the four panels below show?
Conversion pipeline — how many contacts there are right now in each stage, and what percentage reached each one from the previous one. It also counts those who have already passed it, so the pipeline doesn't "empty" as people move forward.
Won vs. invoiced — compares month by month what the CRM treated as won with what the ERP invoiced. It is normal for them not to match: the ERP picks up invoicing for the whole company, not just what came from the CRM. This panel only appears if your company has the ERP; without it there is no invoicing to compare with, and no gap is left in its place: you see three panels instead of four.
Top salespeople — your team sorted by money won in the period.
Why we lose — the reasons for lost deals, from the most frequent to the least. It is fed by the reason chosen when marking a deal as lost, so it is only useful if the team fills it in.
What reports can I get and export?
The Reports tab has seven, each with its own table:
- Performance by sales agent
- Conversion pipeline
- Deals open and stalled
- Loss reasons
- Disqualification reasons
- Lead sources
- Won vs. invoiced (ERP)
The last one is only there if your company has the ERP: it is the one that reads invoicing. Without the ERP the list has six.
Performance by sales agent is grouped by department, if your company has them: each department with its totals on a highlighted row and its people below, and at the end a No department row with anyone who isn't in one. That row always shows when there is somebody like that, because hiding it would make the totals not add up without saying why. Anyone in two departments counts in one only, so that the total still adds up. With no departments set up, the report is the list of people as always.
It goes by department and not by work group on purpose: you can be in several groups at once, and then the same person would count two or three times.
In several of them you can click a row to open its detail and see what is behind that number, instead of settling for the total. A department row opens nothing: detail is looked at per person.
The Export to Excel button downloads what you are viewing, with the period and scope applied. It doesn't export the whole CRM: it exports that report exactly as you have it on screen.
How do I change the period or who I am looking at?
The two filters are at the top and apply to everything below them, both tabs included.
The period is chosen from This month, This year and Last 12 months.
The scope decides whose data it is: the whole company, your departments or only yours. It is the same filter as in Contacts and in the calendar, so if you see less than you expected, check it before assuming data is missing.
What is the AI summary?
Below the figures there is an executive summary that is generated on request and tells in words what those same numbers say. It doesn't add data or take anything from anywhere else: it puts the dashboard you are viewing into words.
It is optional. If you don't ask for it, it isn't generated.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| Everything at zero | There is no data in the chosen period, or the scope is hiding it | Try «Last 12 months» and Company scope |
| «Won» and «invoiced» don't match | The ERP invoices things that don't come from the CRM | That is normal; it is for comparing trends, not for matching to the cent |
| «Why we lose» is empty | The reason isn't being filled in when a deal is lost | See move a deal through the pipeline |
| Contacts at risk shows zero | No customer meets the criterion, or there is no purchase history yet | Normal in a newly set-up CRM |
And Printable reports?
They are three papers designed to print or carry with you, not to look at on screen. They come out as PDF and follow the scope you have set at the top; the period doesn't affect them.
Contact records
Your contacts with their company and their address, sorted by name, in six columns: CUSTOMER, COMPANY, ADDRESS, POSTCODE, TOWN / CITY and CONTACT. The customer appears with its code in front, with six digits. Disqualified contacts don't appear: this is the list of whom to call.
The address printed is the main one; if the contact has none, those three columns are empty and the record still prints.
Reminders for a day
The activities on the date you choose, by time. You choose the date in the report itself, and it starts at today. Nine columns: Code, Name, Warning, Description, Date, Last, Next, Period and Comment.
- Warning is the activity type (call, visit, whatever you have set up).
- Last and Next are the previous and the following activity for that same contact, so you can see at a glance whether you are up to date with them.
- Period is blank: in the CRM an activity has a date, not a frequency. The column is kept so the paper is the same as always.
If there is nothing on that day, the report still prints, empty. That is an answer: there are no reminders.
Active reminders
What is still not done, whenever it is due, sorted by date. Three columns: Code, Name and Description. It isn't limited by dates on purpose: what is overdue and not closed is exactly what you need to see here.
More about CRM
- How do I ask the assistant to show me a screen?
- How do I make the board work on its own?
- How do I convert a contact into a customer?
- How do I create a board to run the pipeline?
- How do I add a contact?
- How do I add a deal?
- Why is my home screen the CRM dashboard?
- Why did the CRM ask me what I work on?
- How do I see only my own work or my department's?
- How do I store a contact's documents?
- How do I make a quote from the CRM?
- Follow up your customers with the CRM