How to Track Solar Leads

You got a WhatsApp ping at 8 PM, "bhai, 3 kW solar ka rate kya hai?" You replied. Three days later, you cannot remember who that was, whether you sent a quote, or whether anyone followed up. Meanwhile a competitor locked the deal.

This is not a sales problem. It is a tracking problem. And it costs Indian EPCs an average of 4–7 deals every month, according to QuickEstimate platform data from 2025. If your average deal is ₹1.5 lakh, that is ₹6–10 lakh walking out the door every single month, not because your price was wrong, but because the lead fell through a gap between WhatsApp, Excel, and your team's memory.

The good news: you do not need expensive software to start. You need a disciplined framework first, the software just automates what you have already designed. This guide walks you through building the Solar Lead Tracking Dashboard from scratch, then shows how to move it from a spreadsheet to a proper CRM when you are ready. For a complete view of the best practices behind this system, see our solar lead management best practices guide.

Why Solar Leads Are Harder to Track Than General Sales Leads

Solar selling is multi-step, multi-stakeholder, and multi-channel, all at once. A typical residential lead in India comes in through WhatsApp, gets a site visit scheduled on a phone call, receives a PDF proposal via email, and closes when the homeowner consults their spouse, bank, and sometimes their neighbour. Each of those touchpoints is happening on a different tool.

Compare that to a furniture salesperson who handles everything inside one showroom visit. The solar EPC sales cycle averages 18–28 days for a residential system, according to JMK Research's 2025 India solar market report. Commercial projects take 60–90 days. Over that span, leads touch WhatsApp messages, site survey notes, PDF proposals, DISCOM (Distribution Company) paperwork, and bank loan follow-ups.

There is also the team dimension. Rohit, who runs a 12-person EPC in Surat, told us he has three sales boys, Kiran, Darshan, and Mehul, each carrying 30–40 leads on their personal phones. When Kiran goes on leave, those leads are essentially gone. When Rohit asks "who is following up with Hiranpura housing society?" on a Monday morning, the answer is a 10-minute WhatsApp scroll session for each of them. According to the Ministry of New and Renewable Energy (MNRE), over 1.4 crore households have registered on the PM Surya Ghar portal, each one a potential solar lead for an EPC. Without a tracking system, most of those opportunities are invisible.

This is the problem the Solar Lead Tracking Dashboard solves.

The Solar Lead Tracking Dashboard, The 5-Column Framework

The Solar Lead Tracking Dashboard (SLTD) is a named framework we have developed from observing how high-performing Indian EPCs manage their pipelines. It replaces the common "WhatsApp scroll + Excel sheet + mental notes" system with one structured view that each team member can update in under 60 seconds per lead.

The dashboard has exactly five columns:

1. 1

   Source

   Where did this lead come from? Options: WhatsApp, IndiaMART, referral, Facebook Ad, walk-in, site visit (existing customer), other. This column tells you which channels are producing and which are burning money.

2. 2

   Stage

   Where is the lead right now in your pipeline? New → Contacted → Site Survey Scheduled → Proposal Sent → Negotiation → Closed Won / Closed Lost. We cover each stage in full in our 7-stage pipeline guide.

3. 3

   Last Touch

   Date + channel of the last meaningful contact. "Meaningful" means an exchange, not just a message you sent. A read receipt counts only if the customer replied. This tells you which leads are going cold.

4. 4

   Next Action

   A specific task with a specific date. Not "follow up", but "call about subsidy eligibility on Tuesday by 11 AM". Vague next actions are the same as no next action. See our follow-up cadence guide for timing benchmarks by stage.

5. 5

   Owner

   One person is responsible. Not "team", one named person. When Kiran goes on leave, Rohit can reassign all of Kiran's open leads to Darshan in two minutes. No lead is orphaned.

Setting Up the Dashboard in a Spreadsheet (Day One)

Before you move to a CRM, build the SLTD in a Google Sheet first. This gets your team into the habit of updating a central record, the hardest part of any tracking discipline is behaviour change, not software.

Open a new Google Sheet. Row 1 is your header: Lead Name, Phone, Source, Stage, Last Touch Date, Last Touch Channel, Next Action, Next Action Date, Owner, System Size (kW), Notes. Freeze row 1.

Now add conditional formatting:

• If Next Action Date < TODAY(), highlight the row red. This is your "lead in danger" signal.
• If Stage = "Closed Lost", grey out the row so it does not clutter your view.
• If Stage = "Proposal Sent" AND Last Touch Date < TODAY()-5, highlight amber. Proposal went out five or more days ago with no follow-up.

Every morning, Rohit's sales meeting is five minutes: open the sheet, look at the red rows (overdue actions), assign them. That is it. The rest of the day, each sales boy updates their own rows. No more "kya update hai?" on WhatsApp at 7 PM.

Read our guide on solar lead management best practices for more detail on how to structure your daily check-in around this dashboard.

How to Capture WhatsApp Leads Into the Dashboard

WhatsApp is where most solar leads start in India, but it is terrible for tracking. Messages get buried, context gets lost, and the same customer can contact three different people on your team without anyone knowing.

The SLTD fixes this with a lead-entry protocol. Every time a sales team member gets a new lead on WhatsApp, they fill in a simple entry form before they reply. This takes 90 seconds. The fields are: name, phone, source (WhatsApp organic / referral / WhatsApp ad), rough system size query, and owner (themselves, by default).

Here is why the entry happens before the reply: once you have replied, you will not go back and log the lead. This is human nature. Train your team to log first, then reply. After two weeks, it is automatic.

For leads coming through Facebook Ads or IndiaMART, you want auto-capture. Both platforms offer lead notification emails that can feed into a CRM automatically. Without a CRM, set up a Zapier automation: Facebook Lead Ads → new row in Google Sheet. It takes 20 minutes to configure and saves hours of manual entry each month.

Our guide on managing solar leads in India covers IndiaMART and Facebook integration in detail.

Tracking Lead Stages, The Pipeline View

The Stage column is the heartbeat of the SLTD. At any given moment, you should know exactly how many leads are in each stage. This is your pipeline health check.

Once a week, Friday afternoons work well, review these percentages. If your Proposal Sent stage has swollen to 40% of the pipeline with no movement, your follow-up cadence is broken. For detailed timing benchmarks by stage, see our solar lead follow-up cadence guide.

The Ownership Column, Preventing Lead Orphaning

The single most common lead tracking failure we see at QuickEstimate is the ownerless lead. Someone contacted the office number. Someone else replied on WhatsApp. A third person did the site survey. Now, no one is sure who is responsible for the follow-up after the proposal was sent.

The SLTD's Owner column prevents this with a simple rule: one lead, one owner, at all times. When the lead changes hands (e.g., after a site survey, the technical team member passes it back to the sales team), the Owner column is updated, not left blank, not listed as "team".

For Rohit's EPC, the ownership rules are straightforward: Kiran owns all Surat city leads, Darshan owns peripheral areas, Mehul owns commercial leads citywide. When Kiran is on a site visit, his phone is not checked, but his leads are still being managed because ownership is in the sheet, not in his head.

See our companion article on solar pipeline stages to understand how ownership shifts across each stage of the deal.

Reading the Source Column, Your Marketing ROI Decoder

The Source column does more than track where a lead came from. Over 90 days, it tells you exactly which marketing channels are worth continuing. This is the equivalent of a mini marketing attribution report, built for free, inside your existing SLTD.

After 90 days of tracking sources, run a simple pivot table: Source vs Close Rate vs Average Deal Size. If your Facebook Ad leads close at 6% but your referral leads close at 22%, and the average deal size is the same, you are spending marketing money on the harder-to-close channel. This insight alone can redirect ₹30,000/month of ad spend toward referral activation instead.

For a deeper analysis, read our WhatsApp solar proposals guide, our analysis on cost per solar lead in India, and how to manage solar leads.

Moving From Spreadsheet to CRM, The Signal to Watch

The SLTD in a spreadsheet works well up to about 80–100 active leads across your team. Beyond that, the manual update burden creates its own problem: people stop updating it because it feels like extra work on top of actual selling.

The trigger to switch is usually one of these:

• A lead was marked as "Next Action: Tuesday" but it is now Thursday and no one noticed.
• Two sales boys contacted the same prospect on the same day without knowing it.
• You discovered a Closed Won lead that was still in the "Contacted" stage because someone forgot to update the sheet.
• Your pipeline has grown past 100 open leads and you are spending 20+ minutes in the morning review instead of 5.

For a full comparison of spreadsheets vs. CRMs with ₹ ROI math, see our detailed analysis at solar CRM vs spreadsheet. And if you are ready to move now, the Excel-to-CRM migration guide walks through a practical one-weekend process. The Mercom India Q1 2026 report notes that Indian solar EPCs using CRM tools have 23% better close rates on average than those operating purely on spreadsheets and WhatsApp. And according to IRENA's India solar outlook, India's rooftop solar market is on track to exceed 40 GW by 2030, the EPCs building scalable tracking systems now will be best positioned to capture that growth.

How QuickEstimate Fits Your Lead Tracking System

QuickEstimate is built around the SLTD framework. When Rohit logs in on his Android phone, the first screen shows his team's pipeline sorted exactly by the 5 columns of the SLTD: Source, Stage, Last Touch, Next Action, Owner. He can see in 90 seconds which leads need attention today.

Here is what each feature maps to in the framework:

• Lead Capture, auto-imports leads from Facebook Ads and IndiaMART, pre-filling Source and owner from the channel. WhatsApp leads can be added in 20 seconds from a floating action button.
• Pipeline Management, visual kanban board sorted by Stage, with red indicators on any lead whose Next Action date has passed. Rohit sees every orphaned lead at a glance.
• WhatsApp Follow-up, sends the proposal directly from the app and records the read receipt as a Last Touch event automatically. No manual update required.
• Sales Reports, weekly Source vs Close Rate vs Average Deal Size pivot, built in. The same report that takes 30 minutes in Excel is available in two taps.

The free plan supports 10 proposals per month, enough to run the SLTD for a solo installer or a small team getting started. The Pro plan at ₹6,999/user/year removes all limits and adds team-level visibility, reminders, and the automated follow-up sequences. Start at quickestimate.co, no credit card needed.

What to Do This Week

1. 1

   Build the SLTD in a Google Sheet today

   Create the 11-column header row, add conditional formatting for red and amber rows, and import your current open leads from WhatsApp and wherever else they live. Assign an owner to every lead before you close the sheet.

2. 2

   Run a 5-minute morning review for 7 straight days

   Every morning at 9 AM, open the sheet with your team. Look at red rows first, then amber. Assign or confirm next actions. This single habit has more impact on close rates than any software feature.

3. 3

   Evaluate a CRM at the 30-day mark

   After 30 days of SLTD discipline, you will know exactly which pain points remain. Use that list to evaluate a CRM, start with the 25-question checklist in our Solar CRM Buyer's Guide. Most EPCs find they can migrate in a weekend once the habit is established.

Frequently Asked Questions

What is the best way to track solar leads in India?

The most effective method for Indian solar EPCs is the Solar Lead Tracking Dashboard (SLTD), a 5-column system covering Source, Stage, Last Touch, Next Action, and Owner. Start in a Google Sheet with conditional formatting to highlight overdue follow-ups. Once your pipeline exceeds 80–100 active leads, migrate to a dedicated solar CRM like QuickEstimate, which automates the tracking from WhatsApp capture through to proposal sent and follow-up reminders.

How do I track leads from WhatsApp?

Create a log-before-reply habit: every time a new lead comes in on WhatsApp, fill in the lead entry form (name, phone, source, system size) before you reply. In a spreadsheet, this takes 90 seconds. In a CRM like QuickEstimate, the customer's name and phone auto-fill when you open their WhatsApp conversation, cutting entry time to 20 seconds. The critical discipline is logging every lead, every time, not just the promising ones.

What stages should a solar sales pipeline have?

For residential solar in India, the standard seven stages are: New, Contacted, Site Survey Scheduled, Site Survey Done, Proposal Sent, Negotiation, and Closed (Won or Lost). Each stage has different entry criteria, average dwell time, and next-action protocols. We cover each stage in detail, including conversion rate benchmarks, in our 7-stage solar pipeline guide.

How many leads should a solar salesperson handle at once?

Based on QuickEstimate platform data, a field sales executive in India performs best with 30–50 active leads at any given time. Below 30, they are underutilised. Above 60, follow-up quality drops and leads start slipping. If your sales boys regularly carry 70+ leads, you need either more headcount or a CRM that automates follow-up reminders so they do not need to actively track each lead manually.

Can I track solar leads for free?

Yes. The SLTD Google Sheet is completely free. For a CRM, QuickEstimate's free plan includes up to 10 proposals per month and basic pipeline tracking. For a team with more volume, the Pro plan at ₹6,999/user/year works out to roughly ₹583/user/month, less than a single lost lead costs you in most markets.

How do I know if a lead has gone cold?

A lead has gone cold when the Last Touch date in your SLTD is more than 7 days ago and the last interaction was outbound (you messaged them, they did not reply). In your spreadsheet, this row turns red or amber depending on your conditional formatting rules. In QuickEstimate, the pipeline card shows a "no activity" warning automatically after your configured threshold.

What is the most common reason solar leads do not convert?

Across QuickEstimate's installer base, the top three reasons are: no follow-up after the proposal was sent (42% of lost leads), proposal sent too late, more than 72 hours after the inquiry (31%), and price objection not addressed with subsidy math in the proposal (27%). All three are solvable with the SLTD framework and a faster proposal workflow. See our guide on solar proposal best practices for how to structure the proposal itself.

How long does a solar lead take to close in India?

Residential solar leads in India close in 18–28 days on average, according to JMK Research. PM Surya Ghar residential leads with DISCOM paperwork can run 30–45 days due to net-metering approval timelines. Commercial rooftop projects average 60–90 days. These benchmarks are your baseline, leads sitting significantly longer than these windows at a given stage should trigger a review of your follow-up process.