Demo project · Dubai free zone company setup · Simulated data

Built by: Shaheen Sha · Tools: Tally · Google Sheets · Google Ads (GCLID, offline conversions) · WhatsApp/email nurture design Note: All 100 leads are simulated to test every scenario. No real ad spend.


The problem

My hands-on experience was in e-commerce, where the sale happens on the website. In B2B lead generation, the website only captures an enquiry, and the sale happens weeks later through a sales team. I built this system to learn and demonstrate the full lead-gen workflow, end to end.

How the system works

  1. Qualifying form: 5 dropdown questions filter serious founders from casual visitors
  2. Click tracking: a hidden field captures the Google Click ID (GCLID), so every lead is tagged as Google Ads or organic
  3. Mini CRM: each submission lands in Google Sheets automatically
  4. Automatic lead scoring: 0–50 points, labelled Hot / Warm / Nurture in real time
  5. Sales outcome: sales records SQL / Won / Not Qualified / No answer / Not Contacted after each call
  6. Next action: each lead shows its next step automatically (call within 1 hour, WhatsApp nurture, monthly email)
  7. Reporting: funnel, source quality and cost metrics
  8. Closing the loop: an offline conversion file that sends SQL and Won data back to Google Ads

image.png

image.png

Lead scoring model

Field Points
Business activity Trading / E-Commerce 10 · Consulting / IT 8 · Others 4
Visas needed 6+ 10 · 3-5 8 · 1-2 5 · 0 2
Setup timeline Immediate 10 · Within 1 month 8 · 1-3 months 5 · Just exploring 0
Location In UAE 10 · In GCC 7 · Outside GCC 4
Budget AED 30K+ 10 · 15-30K 7 · Under 15K 3