Product DesignFull-Stack DevelopmentAI IntegrationSecurity Hardening

PropPulse

Agent performance and commission analytics for Dubai real estate brokerages, turning a single monthly revenue figure into a ranked view of who is closing, where leads leak, and what commission is owed.

PropPulse
Overview

What we set out to build

PropPulse was built to answer the questions a Dubai brokerage owner cannot get from a listings CRM or a spreadsheet: which of their agents is actually earning the revenue, which lead source is worth paying for, and how much commission is sitting uncollected. It is a self-initiated portfolio build, demoed through a hypothetical persona, Desert View Properties LLC, an 8 agent, RERA-licensed Dubai brokerage handling sales, rentals, and off-plan, running on realistic seeded data (2,400 leads, 320 completed deals, 85 in-pipeline deals across 12 months) rather than a live client's transactions. Deliberately not a CRM or listing manager, PropPulse is a focused performance-analytics layer that sits on top of an agency's existing deal flow and answers five questions every owner asks: who is closing, where are leads leaking, what is the pipeline worth, how much commission is owed, and which communities are actually paying off.

Client

Self-Initiated Demo Project

Role

Full Stack Developer

Timeline

4 Weeks, Discovery to Deployment

Services

Product Design, Full-Stack Development, AI Integration, Security Hardening

Challenges & Goals

Challenges & Project Goals

Desert View had eight people generating real revenue and no instrument to tell the owner who was carrying the business, where the leads that mattered were coming from, and where the money was stuck. Every answer meant exporting spreadsheets and cross-referencing by hand.

Challenges

Underperformance went unnoticed for months, one agent was averaging a 45-minute lead response time against an agency norm well under 15 minutes, with no dashboard surfacing the gap.

Goals

Replace the owner's hunch with a monthly leaderboard that ranks all agents by commission earned, deals closed, and conversion rate, and makes strong performance visible enough to reward.

PropPulse dashboard, agency-wide overview with revenue trend and pipeline funnel
PropPulse dashboard, agent leaderboard ranked by commission earned
PropPulse dashboard, lead source quality matrix and commission tracker
Approach

Our Approach

The build was broken into four weekly phases, moving from Dubai-market data modeling to a hardened, production-standard dashboard with AI insights on top.

Mapped the fields that actually drive a Dubai brokerage's numbers, RERA agent IDs, lead source (Bayut, Property Finder, Dubizzle, referral, walk-in), deal stage from prospect through completed, and the UAE commission structure (2% sales, 5% rentals, 5% VAT, agent, agency, and co-broker splits), into a MongoDB schema indexed for fast filtering across thousands of leads and deals.

Key Features

Key Features & Business Value

Every feature ties back to a specific question a brokerage owner keeps asking rather than being built for its own sake.

What It Does & Why It Matters

Agent Leaderboard

Ranks all 8 agents by commission earned, deals closed, and conversion rate, with gold, silver, and bronze top-three styling, turning 'who is actually performing' from a guess into a ranked, refreshed-monthly fact.

Lead Source Quality Matrix

Scatter chart plotting every portal by lead volume, conversion rate, and total commission generated, answering the single most expensive question an owner has: where should next month's portal budget go.

Deal Pipeline (Kanban + Table)

Every active deal across 8 stages, with days-in-stage flagged red past 14 days, surfacing stalled deals and the commission attached to them before they go cold.

Commission Calculator & Tracker

Live RERA-accurate calculator plus a paid, pending, and overdue breakdown by agent, replacing spreadsheet math with an instant, auditable number and making overdue collections visible instead of buried.

Community Performance Analysis

Heatmap of deal volume and commission density by Dubai community, plus price-per-sqft trends, showing which neighborhoods are worth an agency's marketing spend and agent time.

AI Performance Insights

15 ranked, plain-language findings (critical, warning, opportunity, info) plus on-demand generation of new ones, giving a solo owner the standing output of a performance analyst without hiring one.

45 min vs 15 min

One agent's average lead response time vs. the agency norm, flagged automatically

18% vs 8%

Property Finder vs. Dubizzle conversion rate, surfaced next to spend and commission

AED 180,000+

Commission overdue past 30 days, surfaced as one ranked alert

3x

Conversion lift for leads contacted within 5 minutes vs. after an hour

Built With

Next.js 14TypeScriptTailwind CSSshadcn/uiMongoDBMongooseNextAuth.jsOpenAI APIRechartsVercel