← Work

Lapiz Blue General Trading LLC

Google Ads that harvested a AED 2.27M lead pipeline

Built the group's paid-search channel from zero, fixed conversion tracking, harvested a AED 2.27M lead pipeline for the sales team, and matched leads to invoices in Zoho Books: AED 242K in first purchases alone on AED 26K of spend, a 9.2× return.

Role
Head of Technology: campaigns, tracking, attribution
Period
Feb to Jul 2026 (channel live since Nov 2025)
Stack
Google Ads · Google Tag Manager · GA4 · Zoho Books
Abstract render: ascending bars of frosted glass, one with a cyan edge light
  • 9.2×return on ad spend, first purchases alone · AED 242,642 invoiced from AED 26,358 spend; repeat orders come on top
  • AED 2.27Mlead pipeline harvested · 209 qualified leads, 264 companies, trader price
  • AED 66 → 35cost per conversion · −47%
  • 448conversions · Feb to Jul 2026
  • 72.5Kimpressions · Feb to Jul 2026

01Context

A trading company with three branches and no digital lead channel. Sales came from walk-ins, WhatsApp and the salesmen's own networks. The first campaigns (Mapei and Profilpas) were an experiment with a small budget.

02Constraint

Management would only fund the channel if it paid for itself in invoiced revenue, not in clicks. Conversion tracking was broken when I inherited it, advertiser verification and ad-policy blocks had to be cleared, and attribution had to survive leads that arrived by WhatsApp and phone, not forms.

03What I did

I started with Mapei and Profilpas search campaigns, then grew to five (Mapei, Dulux, Kalinga Stone, Kerakoll, Weber) at AED 5,000 a month, writing the ad copy packs after competitor research and adding 507 negative keywords across four campaigns. I rebuilt GTM conversion tracking for calls, forms and WhatsApp with a Google expert. For attribution I designed a lead ledger: every website, WhatsApp and email lead is checked against Zoho Books, priced at trader rates, assigned to a salesman by emirate, and later matched to invoices by company.

04Result

Thirty-eight conversions in the first fifteen days; CTR up from 4.18% to 5.47%. Over the half-year review the account recorded 448 conversions and 72.5K impressions with cost per conversion down 47% to AED 35. Ledger matching attributed AED 242,642 of confirmed invoiced revenue to 25 lead companies against AED 26,358 of spend (9.2×), and the wider ledger priced 209 qualified leads into a AED 2.27M pipeline. The channel has been cash-positive since April 2026.

05What I'd change

Attribution by ledger matching is manual and conservative; it undercounts revenue from companies that first found us on Ads and later bought through a salesman. A CRM-native attribution field from day one would have made the number larger and the argument shorter.

06Stack

  • Google Ads
  • Google Tag Manager
  • GA4
  • Zoho Books
  • Zoho CRM
  • Excel
  • WhatsApp Business