Case study: Articlad's founder dashboard on top of their CRM, built in two weeks
In short
- Articlad, a Mumbai building materials company, runs its sales on a well-known ready-made CRM. Every lead, call and deal is in it.
- The founder still kept their own Excel sheets, because the CRM could not show the business the way they read it.
- SAAR built a dashboard that reads the CRM and the team's calling and attendance apps, and shows the founder's numbers, under the founder's own report names, on one screen.
- It took two weeks. The sales team did not change how they work.
"Very UX friendly way for me to get access to key metrics quickly without juggling through spreadsheets & figuring out my CRM app."
The founder of Articlad, on the dashboard
Before the dashboard, the numbers lived in the founder's own Excel sheets. Each week meant exporting from the CRM, pasting into those sheets and rebuilding the same views by hand. The CRM held all the data. It just could not show it the way the founder thinks about the business.
Why could the CRM not show these numbers?
Articlad's CRM is a capable product, with its own dashboards and custom fields, and the team uses it every day to move deals forward. The gap was not in what the CRM records. It was in what a founder needs to see. Four things stood out once we sat with the founder's sheets.
Too many stages to read at a glance. Articlad's pipeline in the CRM has well over a dozen stages, one for every step from the first enquiry to delivery. The team needs every one of them to do its work. The founder reads six broad steps, from new lead to won. The dashboard groups the stages into those six and shows how many deals sit in each, what they are worth, and what share moved ahead.
Half the story is not in the CRM. Calls are logged in a separate call tracking app. Attendance and the distance field staff travel come from an attendance app. A CRM can only report on what it holds, so "who is calling, who is visiting clients, and does it turn into orders" needed all three apps in one place.
The founder's numbers are ratios, not counts. Out of every 100 enquiries, how many get an estimate, and how many become an order? How many clients order again? Which estimates from last month are still open, and can we close them with a discount? Each of these joins several stages, people and months. A ready-made widget counts records. It does not calculate the founder's own ratios.
Each person needs a different view. The founder sees the whole company. A regional manager sees their region. A salesperson sees only their own clients. Setting that up across ready-made reports is slow and easy to get wrong.
What did SAAR build?
A dashboard that sits beside the CRM, not instead of it.
One screen for this month and for right now. The top half answers "what happened in these dates": sales closed against target, new leads, estimates sent and client meetings. The bottom half answers "what is open today": the pipeline, payments to collect, hot deals, and a "needs attention" list of overdue follow-ups, overdue payments and hot deals with no activity for a week.
Every report from the founder's sheets, under the names the founder gave them. The Excel sheets became a library of 32 reports, such as leads by source, calls by employee, deals expected to close week by week, conversion ratios and why deals are lost. Each answers one question. Any report can be pinned, exported to Excel or sent to the founder's WhatsApp every Monday.
The founder's filters. Two choices at the top apply to every page: "Showing" (the whole company, one region or one person) and "For" (this month, last month, the last 30 or 90 days, or custom dates). More filters cover lead source, product, client type and deal size.
Always current. The dashboard reads the CRM and the other apps on its own every two hours, and a refresh button pulls the latest data whenever the founder wants it.
Honest about missing data. Some fields are often left blank in the CRM, client type for example. Reports that depend on them are marked "partly ready" instead of showing a wrong number, and they fill in as the team starts entering the field.
Why not just ask ChatGPT or Claude?
This was the real alternative, and it deserves a fair answer. Many CRMs can now be connected to an AI assistant through MCP, an open standard for linking an assistant to your software. You type "how many new leads came in last week?" into Claude or ChatGPT and get an answer from your own CRM.
For a one-off question, that works well. For the numbers a business runs on every day, a dashboard does a different job.
| Asking an AI assistant | A dashboard built for you | |
|---|---|---|
| Best for | A question you have once | A number you check every day |
| How you get the answer | Type a question, wait, read | Open a link, it is already there |
| Same answer every time? | Depends on how the question is worded | Yes, each number is defined once |
| The whole team sees the same number? | Only if everyone asks the same way | Yes, each in their own view |
| Spots a problem before you ask? | No, you have to think of the question | Yes, the "needs attention" list does |
| Data from other apps | Only what the CRM holds | CRM, calls and attendance together |
The two are not rivals. An owner can have both: the dashboard for the numbers they watch every day, and an assistant for the odd question nobody planned for. What Articlad's founder wanted was not to remember to ask. They wanted to open one screen and know where the business stood.
Still rebuilding the same Excel every week?
Tell us which numbers you want to see. The free audit looks at your CRM and the sheets you keep today, and says plainly whether a dashboard is worth building.
Book a free audit →Pick a 30-minute slot that suits you.
What changed for the founder?
- The Excel sheets are no longer rebuilt by hand. Every report they held is in the dashboard, never more than two hours old.
- The founder checks the business from a laptop or phone, without opening the CRM.
- Regional managers and salespeople see the same numbers, defined the same way, each for their own part of the business.
- The sales team kept working in the CRM exactly as before. Nothing was migrated and nothing was replaced.
When is a custom dashboard worth it, and when is it not?
A custom dashboard makes sense when:
- Your team already uses a CRM it likes, and switching would cost more than it saves.
- Someone rebuilds the same report in Excel every week or month, often the owner.
- The numbers you decide on are specific to how your business sells, not the standard ones every CRM shows.
- The data sits in more than one app: the CRM, a calling app, attendance, accounts.
It is not worth it when the CRM's own reports already show what you need, or when the team is not entering data in the CRM at all. A dashboard only shows what is recorded. If calls are not logged, no screen will fix that, and we will tell you so in the audit. If you are weighing a bigger build, see what custom software actually costs in India.
Does this only work with one CRM?
No. This build reads the CRM Articlad already uses. Most CRMs and business apps in use today, including Zoho, LeadSquared, HubSpot and Salesforce, offer an API, a door that lets other software read the data with the account owner's permission. A dashboard can read from any of them, and from more than one at once. Read limits are generous: even on its free and starter plans, HubSpot allows an app 100 requests every 10 seconds, far more than a dashboard refreshing every two hours needs.
Frequently asked questions
Do we have to leave our CRM to get a custom dashboard?+
How long does it take to build a custom CRM dashboard?+
Is the data in the dashboard live?+
Is it safe to connect another tool to our CRM?+
Can my sales team see the dashboard too?+
How much does a custom CRM dashboard cost?+
Which numbers do you wish your CRM showed you?
Every build starts with an audit of how your business actually runs. We look at your CRM and the sheets you keep, and come back with one recommendation and a fixed quote.
Book a free audit →Pick a 30-minute slot that suits you.