Ask an Expert: CRM That Drives Revenue with Rayan Ramharuk

Series: Ask an Expert Expert: Rayan Ramharuk — CRM Specialist LinkedIn: Rayan Ramharuk Commentary by: Anthony Lopes, Lopes Advisory

Introduction

For the final instalment in this opening round of our Ask an Expert series, I spoke with Rayan Ramharuk, a CRM specialist whose focus is on turning CRM platforms into practical, revenue-driving tools — not the data graveyards they so often become.

Rayan's perspective is grounded in implementation reality: the messy, political, human side of CRM that no vendor demo ever shows you. And it's exactly this reality that makes CRM the single most underleveraged asset in most solar and renewable energy businesses I encounter.

When I audit a solar installer's marketing and sales infrastructure, the CRM is almost always where the biggest gaps live. Leads arrive but aren't routed. Pipeline stages exist but aren't used consistently. Reporting is technically possible but practically useless because the underlying data is stale. Rayan's answers get into the why behind these failures — and what to do about them.

Q: What's the most common CRM mistake you see in growing businesses?

Rayan Ramharuk: The biggest recurring issue across businesses of all sizes is the lack of unified data — not having a single source of truth for a customer. CRM is meant to solve this, and to an extent it does. But businesses use third-party vendors that don't natively integrate with their chosen CRM, and have legacy solutions and data that haven't been migrated. This results in different versions of the customer, and messaging becomes inconsistent. Solving this leads to more targeted campaigns, the right message to the right client at the right time, and clear lifecycle tracking.

Anthony's Commentary

This is the foundational problem I see in nearly every solar installer I work with. The leads come in through a website form, get logged in a spreadsheet, are sometimes entered into a CRM, and are simultaneously tracked in whatever system the sales team prefers — which is often WhatsApp.

In the EU solar market, where a single residential installer might use a website form, a quoting tool, a project management platform, and a financing partner's portal, the "single source of truth" problem isn't theoretical — it's existential. If you can't see, in one place, every interaction a homeowner has had with your business from first enquiry to completed installation, you cannot meaningfully optimise your marketing spend, your sales process, or your customer retention.

This is precisely why CRM integration sits at the centre of the work I do. Before we talk about campaigns or content, we need to know: where does the data live, and can we trust it?

Q: What are the non-negotiable pipeline stages for any serious sales operation?

Rayan Ramharuk: There isn't a one-size-fits-all answer. Too many stages become noise and people won't update them; too few, and deals appear stalled when they're actually moving. Stages should reflect buyer commitment — what's required for a lead to become an opportunity, what non-negotiable criteria are needed for qualification, evaluation, and commitment. Each stage should have a clear outcome, with the final stage being closed-won or closed-lost.

Pipeline stages only work if there is team alignment — everyone uses them the same way and understands the definition.

Anthony's Commentary

Rayan's point about buyer commitment is the key principle. In solar, this translates to a pipeline that mirrors the actual buyer's journey — not the internal process your sales team wishes existed.

A pipeline I frequently recommend for residential solar installers looks something like this: New Enquiry → Qualified (owns property, suitable roof, budget aligned) → Site Survey Booked → Site Survey Completed → Proposal Sent → Proposal Reviewed → Contract Signed → Installation Scheduled. That's eight stages, which might seem like a lot, but each represents a genuine shift in buyer commitment and a point where the deal can stall or fall out.

The critical word in Rayan's answer is "alignment." If your sales rep thinks "Qualified" means "they answered the phone" and your marketing team thinks it means "they meet all ICP criteria," your pipeline data is meaningless. Define every stage in writing. Make the criteria binary — either the condition is met or it isn't. This is not bureaucracy. It's the foundation of every forecast, every marketing ROI calculation, and every resource allocation decision.

Q: Which CRM data points have the biggest impact on forecast accuracy?

Rayan Ramharuk: Budget confirmation — whether it's speculative or actually approved — is the difference between a wishful deal and one with a real likelihood of closing. Open date and close date help with forecasting, particularly when the gap between them becomes unrealistic. Deal stage combined with last activity date shows whether a deal is progressing or stalling. And a calculated field based on stage and last activity — using RAG indicators — lets you see at a glance which deals are red, amber, or green.

Anthony's Commentary

Every one of these maps to solar with sharp precision.

Budget confirmation in solar means: has the homeowner received and understood the financing options? Or are they still comparing quotes without any commitment to a price range? This single data point separates a pipeline full of optimism from a pipeline that predicts revenue.

The days-since-last-update metric is particularly powerful for solar because of how the sales cycle works. A homeowner might request a quote, go quiet for three weeks while they get a second quote from a competitor, and then re-engage. If your CRM doesn't flag that three-week silence — and if your sales team doesn't have a triggered follow-up sequence for it — you're relying on memory and manual tracking. That doesn't scale.

I build a version of Rayan's RAG dashboard for every solar client I work with. Green means the deal progressed within the expected timeframe. Amber means it's gone quiet but is still within salvage range. Red means it needs immediate intervention or should be moved to closed-lost to keep the forecast honest.

Q: What's your approach to defining lead status, qualification, and disqualification?

Rayan Ramharuk: Lead status needs to be relevant to the business, easy for everyone to interpret, and its definitions should complement reporting. Vague or overcomplicated statuses result in confusion. They should reflect buyer readiness, not internal actions.

For qualification and disqualification, there should be adequate information captured to enable an informed decision between a curious customer and one with real intent. Definition of the need, the role of the buyer, timeline, and budget — combined, they make up lead scoring, which is generally a better indicator.

Anthony's Commentary

"Buyer readiness, not internal actions" — this is a distinction that most solar businesses get wrong. A lead status of "Contacted" tells you what the sales rep did. A lead status of "Interested — Awaiting Survey" tells you where the buyer is. The difference determines whether your reporting reflects activity or progress.

For solar, disqualification criteria should be explicit and enforced: renting, unsuitable roof orientation or shading, property in a restricted heritage zone, no budget or financing eligibility, timeline beyond 12 months. These aren't judgement calls — they're binary filters. If a lead meets any of them, it should be disqualified immediately, freeing the sales team's time for opportunities that can actually close.

Lead scoring, as Rayan mentions, is the more sophisticated version of this. In the solar context, a lead scoring model might weight property ownership heavily, add points for energy bill size, timeline urgency, and engagement behaviour (opened emails, visited pricing page, downloaded case study), and subtract points for indicators of low intent. When this scoring model feeds back into your ad platforms — as Natasha discussed in the previous Field Note — the entire acquisition engine starts to self-optimise.

Q: What automations create the biggest uplift in conversion and speed-to-lead?

Rayan Ramharuk: Auto-assignment of the correct lead to the correct person as soon as it's captured, with notifications. Follow-up notifications if a status isn't updated within hours or days. Pre-built email templates for confirmation emails or bookings. Lead scoring automations that update in real time. Escalation automations if follow-up prompts are ignored.

The key is having as many automations as necessary to help with conversion, without creating so many that they become noise.

Anthony's Commentary

Speed-to-lead is one of the most well-documented drivers of conversion in high-consideration purchases — and solar is no exception. Research consistently shows that responding to a lead within five minutes dramatically increases the likelihood of booking an appointment compared to responding within an hour.

For solar installers, the minimum automation stack I recommend is: instant lead assignment with SMS notification to the assigned rep, an automated confirmation email to the homeowner within 60 seconds of form submission, a follow-up task created if no activity is logged within four hours, and an escalation to a manager if 24 hours pass without contact.

This isn't complex to build in HubSpot or most modern CRM platforms. But I rarely see it implemented correctly. The most common failure mode is that the automations were set up once, never tested end-to-end, and quietly broke when someone changed a form field or added a new sales rep without updating the routing rules.

Q: How do you stop CRMs becoming data graveyards that nobody updates?

Rayan Ramharuk: You have to think about why people stop updating CRM in the first place. The system isn't user-friendly — building a CRM that can do everything is useless if most features won't be used. The data quality is bad — loading it with obsolete or garbage data turns it into an archive. And there was never a push from the right people to drive adoption — change management gets overlooked constantly.

CRM works when the system is designed to help the people who use it. When leadership relies on CRM data and reporting, there will always be a greater push to ensure the data is accurate.

Anthony's Commentary

This answer is worth reading twice. Every solar business owner who has invested in a CRM and watched it gather dust should pay attention to Rayan's framing: the problem is almost never the software. It's the implementation, the data quality, and the change management.

In solar, I see a specific pattern: the business buys HubSpot or Salesforce, loads in a list of historical leads that are two years old, builds out 15 custom properties that nobody understands, and then wonders why the sales team keeps their real pipeline in a spreadsheet.

The fix is to start light. Build only the fields and workflows the sales team will actually use in their first month. Clean the data before loading it. And — this is non-negotiable — make CRM usage part of how sales performance is measured. If a deal doesn't exist in the CRM, it doesn't count toward quota. That's the leadership signal Rayan is describing. Without it, adoption will always be optional, and optional tools don't get used.

Q: What does a useful leadership dashboard look like?

Rayan Ramharuk: Pipeline value — forecasted versus target. Conversion rate, with week-on-week comparison. Stage progression — open, closed, won, and lost. Hot leads lost — high lead score but lost deal. Stalled deals. And the number of deals not updated in the past five days — which speaks directly to the reliability of the data on the dashboard.

A useful dashboard should be absorbed in a few minutes and help leaders make decisions, not just observe numbers. It should also surface where intervention is needed.

Anthony's Commentary

The "deals not updated" metric is quietly the most important item on this list. It's a meta-metric — it tells you whether the other metrics on the dashboard can be trusted. If 40% of your pipeline hasn't been touched in a week, your forecast isn't a forecast. It's a guess.

For solar business leaders, I'd add one more view to Rayan's list: marketing-sourced pipeline versus sales-sourced pipeline, with separate conversion rates for each. This tells you whether your marketing investment is generating deals that actually close, or just filling the top of a leaky funnel. It also gives marketing and sales a shared language for performance conversations — something that's conspicuously absent in most solar businesses I work with.

Q: How should email nurture work when deals take weeks or months to close?

Rayan Ramharuk: There's a fine line between reminding a client that you exist and helping a buyer decide. Cadence and content matter — less is sometimes more. A weekly email, hyper-personalised toward the client, is far better than a generic newsletter. Education on the products they're interested in, product updates, and case studies if available. Based on their interaction — opens and clicks — the cadence and content can be adjusted.

Email nurture should support the conversion, not compete with it. Emails should be sent because they are relevant and help a buyer decide, not because they are scheduled.

Anthony's Commentary

"Not because they are scheduled" — I want that on a poster. Solar businesses, more than most, fall into the trap of sending a monthly newsletter to their entire database because someone decided that's what marketing looks like. It isn't. It's noise.

Effective email nurture for a solar buyer in the consideration phase should be triggered by behaviour, not by calendar. If a homeowner downloaded your savings calculator but didn't book a survey, they get a sequence about financing options and case studies from similar properties. If they booked a survey but haven't responded to the proposal, they get a sequence addressing common objections — ROI timeline, panel durability, warranty coverage.

This requires CRM segmentation and content assets that most solar businesses don't have yet. Building them is one of the highest-ROI activities a solar installer can invest in, because the leads are already in the database — they just need the right nudge at the right time, not a monthly blast about your company's latest team outing.

Q: What are the biggest mistakes teams make with CRM/email compliance and deliverability?

Rayan Ramharuk: Sending generic newsletters instead of relevant, personalised content. Failing to scrub lists periodically and remove inactive contacts. And over-investing in preference centres that rarely work as intended — a customer who wants to unsubscribe usually wants out completely, and a complex preference centre more often results in the "report spam" button being pressed.

Deliverability works best when clients find the content relevant and the timing appropriate. Break those rules and engagement drops while spam complaints rise.

Anthony's Commentary

The preference centre point is one of those uncomfortable truths that email marketers rarely discuss. In solar, where your database might include a mix of active prospects, past customers, and leads who enquired two years ago and never progressed, the temptation is to keep mailing everyone. Don't.

A clean solar email list should segment by lifecycle stage and engagement recency. Active prospects get nurture sequences. Recent customers get onboarding and referral content. Leads who haven't engaged in 90 days get a re-engagement campaign — and if they don't respond, they come off the active list. Your sender reputation is a finite resource. Protect it the way you'd protect your brand.

Q: If a company has 30 days to improve pipeline reliability, what do you fix first?

Rayan Ramharuk: Data quality — is the data clean? Are there old or stale deals in the system? Are close dates and values correct? Cleaning up data and adding validation rules and automations helps immediately. Then I'd look at stages — are they clearly defined, and does everyone know what they mean? Is reporting in place, and is it being used effectively? Realistically, 30 days is tight, and I'd focus on what gives the biggest visible improvement fastest.

Anthony's Commentary

This mirrors Natasha's triage approach and my own diagnostic methodology: start with the data, not the strategy. You cannot make good decisions on bad data, and most solar businesses are sitting on pipelines full of stale deals that inflate the forecast and mask the real conversion rate.

My 30-day playbook for a solar installer's CRM would be: Week 1 — audit and clean the pipeline, removing or archiving every deal that hasn't been updated in 60+ days. Week 2 — define and document pipeline stages with the sales team, getting explicit buy-in on definitions. Week 3 — build the core automations (lead assignment, follow-up reminders, stage validation). Week 4 — launch the leadership dashboard and make CRM accuracy a standing agenda item in the weekly sales meeting.

It's not glamorous. But it's the work that makes everything else — paid media, content, nurture, reporting — actually reliable.

Closing Thoughts

Rayan's answers consistently return to a theme that runs through all three Field Notes in this series: the tools aren't the problem. The data quality, the process design, and the human adoption are. CRM is the connective tissue between marketing and sales, and when it's neglected, every other investment — from ad spend to content creation to sales training — delivers less than it should.

For solar and renewable energy businesses, where the journey from enquiry to installation is long, multi-stage, and involves multiple handoffs, CRM isn't a nice-to-have. It's the operating system of the business. Getting it right doesn't just improve marketing ROI — it changes how the entire company understands and serves its customers.

This Field Note is part of the Ask an Expert series on Lopes Advisory, where we speak to practitioners across digital marketing, RevOps, and growth strategy about the questions that matter most to scaling businesses — with a particular focus on the solar and renewable energy sector.