Skip to content

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.

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:

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 seeWhat has happenedWhat to do
Everything at zeroThere is no data in the chosen period, or the scope is hiding itTry «Last 12 months» and Company scope
«Won» and «invoiced» don't matchThe ERP invoices things that don't come from the CRMThat is normal; it is for comparing trends, not for matching to the cent
«Why we lose» is emptyThe reason isn't being filled in when a deal is lostSee move a deal through the pipeline
Contacts at risk shows zeroNo customer meets the criterion, or there is no purchase history yetNormal 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.

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