← Work

Lapiz Blue General Trading LLC

Turning WhatsApp leads into a AED 2.27M pipeline view

A lead ledger and dashboard that value every WhatsApp and email enquiry at trader price, route it to a salesman by emirate, and stage it into Zoho CRM. It is the number behind the 9.2× ad return.

Role
Head of Technology: lead ledger, dashboard, CRM staging
Period
Nov 2025 to Jul 2026
Stack
Next.js · Recharts · Python · Zoho Books API
Half-yearly report web app showing lead and revenue charts
  • AED 2.27Mquantified pipeline · Feb to Jul 2026, trader rates
  • 316verified leads · Nov 2025 to Jul 2026, 264 companies
  • 39 → AED 406,343June leads valued
  • AED 128cost per lead
  • AED 8,524net profit after ad spend · cash-positive since Apr 2026

01Context

Leads arrived in three WhatsApp numbers, two inboxes and a website form, and went to whichever salesman answered first. Nobody could say what the channel was worth.

02Constraint

Salesmen in Dubai, Sharjah and Abu Dhabi had to be treated fairly, existing customers had to be filtered out before anything counted as a lead, and the valuation had to be defensible to management: trader price, not list price.

03What I did

I designed the lead ledger: every enquiry is checked against Zoho Books for an existing account, priced at trader rates, assigned in turn across emirates and tracked to outcome, with missed enquiries logged so none are lost again. A dashboard values leads per salesman, emirate and status with period selection and downloadable data; a WhatsApp-chat-to-Excel script and a 17-tab salesman workbook feed it. A separate lead staging app collects leads from four sources into review drafts and pushes them to Zoho CRM with the salesman already assigned.

04Result

316 verified leads from 264 companies between November 2025 and July 2026, priced into a AED 2.27M Category-1 pipeline; June alone valued 39 leads at AED 406,343. The channel was cash-positive from April 2026 with AED 8,524 net profit after ad spend over the review period, and the ledger is what made the 9.2× Google Ads return provable.

05What I'd change

The ledger started as a spreadsheet and the dashboard was a static export fed by weekly snapshots. It proved the value fast, but the staging app should have been the first thing, not the last. The manual period is where leads leak.

06Stack

  • Next.js
  • Recharts
  • Python
  • Zoho Books API
  • Zoho CRM
  • Excel