Loading live figures from the UPC sheets

Jack Agent

The real Jack, running the same conversation as WhatsApp on your live listings sheet. Tap or type as a buyer would, and ask for any project brochure. Tests here are never saved as leads.

Live Jack · test chat, not logged
JackUPC property advisor · replies in seconds
Try:
Live narrowing · your listings
—
units match so far
Buyer profile · Deal DNA
Lead quality—
The same score sorts leads in Handoff. Hot and warm thresholds are set in Settings.
Listing sources
UPCListings sheet—
AlnairDeveloper APINot connected
Alnair joins when the API access arrives. Until then Jack searches UPC's own listings only.

Clients

Everyone who contacted Jack, what they went through, and whether they qualify. Open a client to read his full journey, his questions and the whole chat.

Performance & actions

What needs doing right now, then how Jack is performing: the funnel, where clients stop, what they want and what they ask.

Action needed

Booked calls, hot leads nobody contacted, missing brochures, unanswered questions and clients who went quiet. Press Done once handled.

Funnel

Each client counted once, at the furthest point reached.

Where clients stop

The last question clients saw before going silent (6 hours or more).

Last 14 days

New clients per day, and clients active that day.

What clients want

Most requested in the selected period.

Questions clients typed

Free questions, newest first. Tagged when Jack handed it to a consultant.

Jack the Farmer

Farming existing owners on WhatsApp to build the UPC portfolio: monthly owners' note, unit status, title deed, then a consultant. Owners who want to buy go to Jack Sales; buyers who already own come here.

Campaigns

Pick a product and see who it matches. Every client gets it only on his own UPC number: buyers who contacted us from 5005, farmed contacts from 9498.

Tower

Everything that happened in the funnel, where buyers left, and where demand outruns your listings.

Conversion funnel

Each person counted once, at the furthest step they reached with Jack.

Drop-off by question

Which step loses people. The longest bar is where to change the question.

Noise filter · why leads were held back

Leads that did not reach the call list.

Demand vs. your listings

Where buyers want to be, against the units you hold. Gaps are sourcing opportunities.

Buyer demand (people)Your listings (units)

Live · latest activity

Leads logged by Jack and actions your team took in this portal.

Handoff

Buyers who finished the conversation, each with a ready-made opening line from your template. Update the status as you work them.

Radar

Buyers who asked Jack to alert them, and what buyers are asking for against what you hold. Jack checks every subscription once a day and WhatsApps a match (at most one alert every 3 days per buyer).

Radar subscribers

Each buyer and the search Jack is watching for them.

What buyers ask for · by area

Buyers who named the area, against projects you have on file there. "Gap" = demand with nothing to offer.

Pulse

Market intelligence from Dubai Land Department open data. Drop the DLD files in the folder once a week; the figures below and Jack's answers read from the result.

DLD data pipeline

Drop transactions.csv and rents.csv in the DLD folderDownloaded from Dubai Pulse. Open the folder

Opportunity finder

Areas that clear both thresholds. Your thresholds are saved to your preferences.

AreaAED/sq ftYoYGross yieldSales / 90d

Market by area

All areas from the latest DLD calculation, busiest first.

AreaAED/sq ft12-month changeMedian rentGross yieldSales / 90dPeriod

Vault

Your listings, scored. Each project shows how many buyers in Handoff fit it, whether its sales kit is ready, and whether it needs a push.

ProjectEmirate · areaUnitsFromHandoverKit filesWaiting buyersSignalStatus

Settings

Your preferences are saved to your account and come back on any device. Templates and pipeline rules are shared by the whole team; editors change them.

Checking access…

My preferences

Saved views

Handoff filters you saved. Apply one from Handoff or here.

Message templates

Opening lines used in Handoff and on the WhatsApp button. Placeholders: {first} {name} {agent} {project} {emirate} {area} {budget} {unit}.

Pipeline rules

Shared by the team. Only editors can change them.

Data · import and export

Exports include each lead's status, owner and notes from this portal.

To import listings in bulk, open the Listings sheet and use File → Import with your Excel or CSV file. Jack and this portal read it within five minutes.
Leads
UPC Leads - Jack bot
Listings
UPC Listings - Jack bot
Market
UPC Market - by area
Sales kits
UPC Sales Kits - Jack

Team and access

Add people from this page's Share menu. Editor: everything, including templates and rules. Contributor: work leads and save their own preferences. Viewer: read only. Each person also needs view access to the four Google files above, because the portal reads them with their own Google account.

People active in the portal

Activity log

Every status change, note, assignment and settings change, newest first.

How it works

One set of data, three ways in, one team view. Everything runs on free tools UPC already owns.

WhatsApp+971 56 709 5005 through Meta's Cloud API
Websiteadvisor.upcrealty.com and the site chat
Social linksInstagram, Facebook and LinkedIn open WhatsApp
↓
JackGoogle Apps Script. Asks with tap-to-answer choices, matches live listings, sends sales kits, flags hot leads by email.
↓
Leads sheetEvery conversation, one row per event
Listings sheetWhat Jack can recommend
Market sheetDLD figures by area
↓
This portalReads the sheets live. Adds statuses, owners, notes, templates, preferences and the activity log in its own store.

The daily routine

  1. Open Handoff each morning. Call hot leads first using the ready opening line, then set the status.
  2. Keep the Listings sheet current. Mark sold units "No" in the Active column; Jack stops offering them within five minutes.
  3. Drop new brochures in the sales kit folder. Vault shows which projects still have none.
  4. Once a week, download the two DLD files and drop them in the DLD folder. Pulse updates after the calculation.
  5. Check Tower on Mondays: the drop-off chart shows which question to improve.

Coming next

  • Arabic and Russian for Jack
  • Alnair developer inventory, once API access arrives
  • Radar: paid alerts for buyers when a match appears