CRM & Sales Automation Platform Case Study — 200-Person Sales Team
CRMSales AutomationEnterprise

CRM & Sales Automation Platform for 200-Person Sales Team

Replaced a complex spreadsheet and email-based sales process with a unified CRM that automated lead routing, follow-up reminders, performance tracking and management reporting.

Follow-up Rate
200
Sales Team Size
5 mo
Build Time
Project Overview
Client TypeB2B Sales Organisation
IndustryFinancial Services
Users200 sales + 40 managers
Timeline5 months
StatusLive in Production
The Problem

A 200-Person Sales Team on Spreadsheets and WhatsApp

The client was a financial services company with a large field sales team selling insurance and investment products across multiple cities. Each sales executive managed their leads in their own spreadsheet, follow-ups happened through WhatsApp messages and calls were logged nowhere.

Management had no real visibility into pipeline health, conversion rates or individual performance without manually compiling numbers from each team lead's Excel file — a process that took 2 days every week.

Multiple third-party CRM products had been trialled and abandoned because they were not designed for the specific workflow of this business — the lead sources, the multi-step approval process for certain products, the branch hierarchy and the incentive calculation logic all required customisation that SaaS CRM vendors could not accommodate.

Key Challenges

200 individual Excel files across 8 branches — no consolidated view
Follow-ups missed due to no reminder system — estimated 60% drop-off
Management reporting requiring 2 days of manual compilation weekly
No visibility into which lead sources were generating the most value
Incentive calculations done manually by HR — error-prone and delayed
The Solution

CRM Modules Built

🎯
Lead Management
Centralised lead database with auto-assignment rules, source tracking, duplicate detection and priority scoring based on engagement signals.
🔔
Follow-Up Automation
Configurable follow-up schedules with automatic WhatsApp and SMS reminders for sales executives — with snooze, reschedule and completion tracking.
📊
Pipeline Dashboards
Real-time pipeline views by branch, team, product type and executive — with conversion funnel analytics and stage-velocity tracking.
📋
Approval Workflow Engine
Multi-level approval flows for high-value products — routing leads to team leads and branch managers with SLA tracking and escalation.
💰
Incentive Calculator
Automated incentive calculation engine based on closed deals, product mix and achievement tiers — reducing HR calculation time from 2 days to 20 minutes.
📱
Field Sales Mobile App
Lightweight Android app for field executives to log calls, update lead status, view their pipeline and get reminders — works on low-end devices without WiFi.
Technology

Stack & Technical Approach

The CRM was built as a single-page web application with a RESTful Node.js backend. Real-time updates used Socket.IO so managers could see lead activity without refreshing. The mobile app was a React Native PWA to ensure it worked on the low-cost Android handsets the field team used.

The WhatsApp automation integrated with the WhatsApp Business API via a middleware layer, allowing follow-up messages to be sent from individual sales executive numbers (using API-assigned virtual numbers) so recipients saw a familiar contact.

Vue.jsNode.jsPostgreSQLRedisSocket.IOWhatsApp APIReact NativeAWS RDS
Results

What Changed After Launch

Improvement in follow-up completion rate — from 30% to over 90% within the first quarter
-2 days
Weekly reporting time — management now has real-time dashboards instead of compiled Excel reports
28%
Increase in qualified lead conversion rate within 6 months of CRM adoption
20 min
Incentive calculation time — reduced from 2 working days to automated generation in 20 minutes

Running a Large Sales Team on Spreadsheets?

A custom CRM built for your exact process delivers results that generic SaaS tools simply cannot match. Let's discuss.