The Bhopal Insurance Agency That Couldn't Tell Which Leads Actually Bought a Policy
Deepak Chouhan was renewing the same Facebook ad budget every month because the leads looked plentiful. He had no way to see that his referral leads, the ones costing him nothing, were the ones actually turning into policies.
The short answer
Most insurance agents and financial advisors know their total leads and their total policies sold each month, but not which source produced which sale. Once every lead is auto-tagged with its source at the point of capture, a source-wise report shows leads and sales side by side, so an ad budget or a referral program can be judged on what it actually sells, not on how many leads it appears to bring in.
A financial services agency in Bhopal, and a blind spot nobody noticed
Deepak Chouhan runs a small financial services agency in Bhopal. He sells LIC policies along with term and health plans from two private insurers, and works with two junior advisors, Ritu and Sanjay. Leads come in from three places: Facebook Lead Ads (around ₹18,000 a month in spend, roughly 40 leads), JustDial (about 15 leads a month from people searching "insurance agent Bhopal"), and referrals from existing policyholders (usually 8 to 10 a month).
Every lead landed in a shared Excel sheet with a column marked "Source." In theory, whoever added the lead was supposed to fill it in. In practice, Ritu filled it in about half the time, Sanjay almost never did, and Deepak himself only bothered when a lead came from a source he was curious about that week.
At the end of each month, Deepak knew one number for certain: how many policies his team had sold. He had no reliable way to connect that number back to where each of those buyers had come from. So every month, he renewed the Facebook budget because 40 leads "felt like" more business than 8 referrals, without ever confirming it.
Why source visibility disappears in a shared Excel sheet
The source field depends on memory, not the system
A manual column gets filled in when someone remembers. Under daily call pressure, that's the first field an advisor skips.
Lead count and sale outcome live in different places
The Excel sheet tracks leads. Policy sales get recorded separately, often on paper or in the insurer's own portal. Nobody joins the two.
The loudest source gets the most attention
An ad spend that produces a visible flow of new leads every day feels productive, even if the leads it produces rarely convert.
Quiet, high-converting sources get ignored
Referrals arrive one or two at a time, on WhatsApp, from people the advisor already knows. There's no dashboard nudging anyone to nurture that channel.
Tagging the source at the moment the lead arrives
The fix isn't a stricter instruction to fill in the Excel column. It's removing the manual step altogether. In 3Sigma, every lead carries a leadSource field that gets set automatically the moment the lead is captured, based on where it came from.
Facebook Lead Ads
A lead that fills out Deepak's Facebook form is pulled in and tagged 'Facebook Lead Ads' the instant it's submitted, no copy-paste from Ads Manager.
JustDial
JustDial enquiries sync in via webhook and are tagged automatically, so a JustDial caller and a Facebook form-filler never blur into one bucket.
Referrals
A referral added from the mobile app in a few taps, or through a shareable referral link, is tagged 'Referral' by default. Nobody has to type it in later.
The report that changed Deepak's ad budget
Once every lead was source-tagged automatically, 3Sigma's Leads by Source report gave Deepak a single view he had never had before: leads and closed sales, side by side, per source, for the month. It looked roughly like this.
| Source | Leads | Policies sold | Monthly cost |
|---|---|---|---|
| Facebook Lead Ads | 40 | 3 | ₹18,000 |
| JustDial | 15 | 2 | Free listing |
| Referrals | 9 | 5 | ₹0 |
Nine referral leads had sold more policies than forty Facebook leads. Deepak didn't cut Facebook entirely, some of those leads were still worth calling, but he moved a part of that ₹18,000 into a small thank-you gesture for policyholders who referred a friend, and asked Ritu and Sanjay to call every referral within a day instead of whenever they got to it.
Are the leads even being called? The Call Leaderboard
Knowing which source sells is half the picture. The other half is knowing whether advisors are actually working those leads. 3Sigma's team activity tracking includes a Call Leaderboard that shows calls made, talk time and outcomes per advisor, filterable by lead source.
Calls per source, per advisor
Deepak could see that Sanjay called every Facebook lead within an hour but let referral leads sit for three or four days, because they felt less urgent.
Sales targets by source mix
Sales targets can be tracked against a healthier source mix, not just a total number, so the team isn't rewarded for chasing volume alone.
WhatsApp and call on the same timeline
Every WhatsApp message and call for a lead sits on one timeline, so reviewing a source's performance means reading real conversations, not guessing.
The same blind spot in loan DSA and other financial services teams
Deepak's agency happens to sell insurance, but the pattern repeats across Indian financial services businesses. A loan DSA juggling Facebook Lead Ads, JustDial enquiries and bank referrals faces the same question at month-end: which channel actually produced a disbursed loan, not just an enquiry. A mutual fund or wealth advisor tracking leads across two or three sources has the identical gap.
The fix doesn't change by product. It's the same leadSource field on every lead and the same source-wise report in the dashboard, whichever financial product is being sold.
FAQs: Lead Source Tracking for Insurance and Financial Services
How does 3Sigma tag the lead source automatically instead of relying on a manual field?
When a lead comes in through a connected integration, Facebook Lead Ads, JustDial, a website form or a referral link, 3Sigma stamps the leadSource field on the lead record at the moment of capture. Nobody has to remember to type it in an Excel column, so the field is never blank or inconsistent.
Can I see which lead source actually converts to a sold policy, not just which one brings the most leads?
Yes. The Leads by Source report in 3Sigma's reporting suite breaks down every source by lead count and by how many of those leads reached a won status with a sale value attached. So you can compare a source that brings 40 leads against one that brings 8, and see which one is actually producing business.
Does this work for loan DSA and general financial services leads too, or only insurance?
The same leadSource field and Leads by Source report apply to any lead in 3Sigma, regardless of product. A loan DSA tracking BankBazaar, JustDial and referral leads, or a financial advisor tracking mutual fund and insurance enquiries together, sees the same source-wise breakdown.
What if a referral comes to me directly on WhatsApp, not through a form?
You can add the lead manually from the mobile app in a few seconds and set the source as 'Referral' yourself, or share a referral link with existing clients that auto-tags every lead that comes through it. Either way, the source is recorded on the lead, not lost in a chat thread.
Can I tell if my advisors are actually calling the leads from a specific source, or just the easy ones?
The Call Leaderboard report shows calls made, talk time and outcomes per advisor, and you can filter activity and lead lists by source. So if referral leads are sitting uncalled while Facebook leads get worked first, it shows up in the numbers instead of staying invisible.
Do I need to ask someone to prepare this report every month?
No. Leads by Source, Call Leaderboard and the other reports in 3Sigma's dashboard update in real time and can be filtered by date range, team member, status or source whenever you open the app. There is also a daily email report subscription if you want the summary without opening the dashboard.
Related reading
See which lead source is actually selling, not just arriving
Every lead in 3Sigma is source-tagged the moment it's captured, and the Leads by Source report shows leads and sales side by side, so your team can put effort and budget where it's actually converting.
Or read: financial services CRM · reporting and analytics