Leadership Dashboard
Click any card to jump into that section.
Also worth your attention
Confrasilvas concentration→ confirm signature-return status directly with procurement
€87.6M · 35%
Six Senses hidden inside "Pinheirinho" — no Salesforce field→ ask Elaine to add a dedicated development field so this stops needing manual lookup
€46.0M
Lead-routing bug caught live — same lead, two reps→ flag to Elaine alongside the pending duplicate-cleanup decision
today, 08:18
Leads received in Salesforce — what's actually happening to them
Total Leads, All-Time
23,518
across every source, every project
SRC: SALESFORCE · LEAD, GROUPED BY LEADSOURCE/STATUSMarked Unqualified
96.9%
22,797 of 23,518 leads
Ever Reached "Qualified"
0.6%
147 leads, all-time
Currently Being Worked
491
2.1% — "Working" status right now
SRC: SALESFORCE · LEAD, GROUPED BY LEADSOURCE · 11SEP26
Almost every lead that ever enters Salesforce gets marked Unqualified — 96.9% of 23,518, all-time. Only 147 have ever reached "Qualified" in the system's history. That's either a genuinely brutal market filter, or a sign the qualification bar (or the process feeding it) needs a hard look — a funnel this narrow at the very first stage is worth understanding before assuming it's just low-quality traffic.
Golf is the starkest case: 241 leads, 100% Unqualified, zero ever worked or qualified — consistent with the "no new golf leads since 13 April" finding already on this dashboard, but now with the full picture: it's not just that leads stopped coming, none of the leads that did come were ever pursued.
Golf is the starkest case: 241 leads, 100% Unqualified, zero ever worked or qualified — consistent with the "no new golf leads since 13 April" finding already on this dashboard, but now with the full picture: it's not just that leads stopped coming, none of the leads that did come were ever pursued.
Sales pipeline — all three projects, past close date
SRC: SALESFORCE · OPPORTUNITY, ISCLOSED=FALSE AND CLOSEDATE < TODAY · 11SEP26
Latest monthly reports
1 VIC Properties
The holding-company layer — management, group financial entities, procurement and people. Everything here sits above the three projects, mirroring the Dropbox /1-Vic-Properties root.
Reading this tabOne supplier (Confrasilvas) holds 35% of every contract euro group-wide, and two invoice files that look reconcilable (HPII, C1HPII) turned out not to be — see Procurement and Financial & Entities for both.
Total Open Pipeline
€311.4M
265 opportunities, all projects
SRC: SALESFORCE · OPPORTUNITY, ISCLOSED=FALSE · 11SEP26Six Senses (within Pinheirinho VIC)
€46.0M
63% of Pinheirinho (VIC)'s pipeline
SRC: SALESFORCE · NAME LIKE '%SIX SENSES%'Overdue (Past Close Date)
€112.5M
64 opps, 36% of total pipeline
SRC: SALESFORCE · CLOSEDATE < TODAYNote
No direct link
Salesforce org domain not on file — ask for it to enable click-through
Pipeline by project — Six Senses broken out
SRC: SALESFORCE · OPPORTUNITY, GROUPED BY REAL_STATE_PROJECT__C, SIX SENSES ISOLATED BY NAME MATCH
| Segment | Value | Opps | Share |
|---|---|---|---|
| Prata (VIC) | €172.4M | 200 | 55.5% |
| Pinheirinho (VIC) — Six Senses | €46.0M | 10 | 14.8% |
| Pinheirinho (3rd Party) | €66.1M | 40 | 21.2% |
| Pinheirinho (VIC) — other plots | €27.0M | 15 | 9.0% |
| Total | €311.4M | 265 | 100% |
Six Senses isn't a line item inside Pinheirinho — it's 13.5% of the entire group's open pipeline on its own, bigger than the whole of Pinheirinho's non-branded plot sales combined (€27.0M). Salesforce doesn't tag it as a separate development (no dedicated field — this required matching on "Six Senses" in the opportunity name), so every report that just says "Pinheirinho (VIC)" is quietly burying the fact that most of that number is actually a hotel-branded-residences deal, not villa plots.
Pipeline health — overdue vs. on-track, by project
SRC: SALESFORCE · OPPORTUNITY, ISCLOSED=FALSE, SPLIT BY CLOSEDATE VS. TODAY
Pinheirinho is the real problem, not Prata. By value, 51.8% of Pinheirinho (VIC)'s pipeline and 51.7% of Pinheirinho (3rd Party)'s pipeline is already past close date — roughly half of both. Prata, despite being the largest and most mature pipeline, sits at just 26.2% overdue by value. Whatever is slowing deals down at Pinheirinho is a bigger problem proportionally than anything happening at Prata.
Pipeline by sales rep
SRC: SALESFORCE · OPPORTUNITY, GROUPED BY OWNER.NAME · 09SEP26
Mariana Antunes carries more pipeline (€47.0M, 18 opps) than Marcos Drummond, the Sales Manager (€43.4M, 13 opps). Her Outlook mailbox is tiny by comparison (90 messages vs. Drummond's 45,669) — worth checking whether that's because she's newer and simply hasn't accumulated inbox history yet, or whether some of her communication is happening somewhere this dashboard doesn't see.
José Crespo now owns €46.6M across 55 opportunities — he picked up 2 more deals since yesterday and has overtaken Drummond's book — and still hasn't been triaged in any email sweep.
José Crespo now owns €46.6M across 55 opportunities — he picked up 2 more deals since yesterday and has overtaken Drummond's book — and still hasn't been triaged in any email sweep.
Buyer concentration — who's actually behind the pipeline
SRC: SALESFORCE · OPPORTUNITY, NAME LIKE '%BUYER%', GROUPED BY BUYER · 11SEP26
Largest single buyer, group-wide
€40.5M
24 units · 13% of entire group pipeline — click for detail
SRC: SALESFORCE · NAME LIKE '%RKK HABITAT%' · VERIFIED VIA SOQL
One buyer — RKK HABITAT Unipessoal lda — holds 24 separate opportunities across both Prata and Pinheirinho, worth €40.5M. That's roughly 13% of the entire group's €311.4M open pipeline sitting with a single counterparty, spread across Lote 9 Sunrise, Lote 5 South, Lote 3 Factory (Prata) and multiple plots (Pinheirinho VIC). Nobody had quantified this before this pass — each unit reads as an ordinary deal in isolation, but rolled up, this is the single biggest concentration risk on the entire dashboard, bigger even than Confrasilvas. If RKK HABITAT slows down, pulls back, or renegotiates, it doesn't touch one lote — it touches four.
All 24 of RKK HABITAT's units sit with the same rep — Jorge Figueira, meaning this single buyer relationship is roughly half of his entire €83M book. If that relationship sours, it's not just a company risk, it's a personal-book risk for one person.
Other buyers worth watching, though only measured within Prata's SPA/Pre-Deed stages so far: Complexideas Unipessoal Lda (6 units, €4.9M), Yevgen Pinchuk (6 units, €4.5M, an individual not a company), Dinya Lisbon Hotel SA (6 units, €3.8M).
All 24 of RKK HABITAT's units sit with the same rep — Jorge Figueira, meaning this single buyer relationship is roughly half of his entire €83M book. If that relationship sours, it's not just a company risk, it's a personal-book risk for one person.
Other buyers worth watching, though only measured within Prata's SPA/Pre-Deed stages so far: Complexideas Unipessoal Lda (6 units, €4.9M), Yevgen Pinchuk (6 units, €4.5M, an individual not a company), Dinya Lisbon Hotel SA (6 units, €3.8M).
Win / loss, last 30 days
Won — Deed
€9.31M
9 deals
Won — Lease
€22,985
4 deals
Closed Lost
€13.22M
10 deals
Net (Won − Lost)
−€3.89M
more value lost than closed
More money walked away than closed in the last 30 days. €13.22M lost across 10 deals vs. €9.33M won across 13 (9 deeds + 4 leases) — a net negative €3.89M. By count, the win rate looks fine (13 won vs. 10 lost, 56.5%); by value, it isn't. A handful of large lost deals are outweighing a larger number of smaller wins.
SRC: SALESFORCE · OPPORTUNITY, ISCLOSED=TRUE, CLOSEDATE = LAST_N_DAYS:30
SRC: SALESFORCE · OPPORTUNITY, ISCLOSED=TRUE, CLOSEDATE = LAST_N_DAYS:30
Sales team — responsiveness signal (preliminary)
A prospect had to escalate to a phone call because their email to VIC went unanswered. Found in Drummond's inbox: an internal forward reads "the gentleman called to say he'd sent an email to VIC but got no response" — regarding a real award-nomination opportunity (free publicity), not just a routine enquiry. This is a smaller sample than Post-Venda's (25 of 461 messages), so it's a signal worth investigating, not yet a statistic — the one matched thread in this sample replied in 1h 5min, which is fine, but the volume here (461 messages in 14 days, 3x Post-Venda's) means a proper pass would need real time to do right.
Sales-team inbox — live triage (Marcos Drummond, Sales Manager)
Mailbox Size
45,669
total messages, all-time
SRC: OUTLOOK · M.DRUMMOND@VIC-PROPERTIES.COMNew Website Lead
Today, 08:18
Pinheirinho (VIC) — Margaret Parrino
Weekly Sales Meeting
Canceled
today, 08:36 — no reschedule sent yet
Six Senses New Registrations
2 today
same buyer, both Pinheirinho + Six Senses
3 New lead / SIR registration
4 Active deal admin
2 Six Senses due-diligence
2 Internal ops / scheduling
4 Marketing / IT noise
Same buyer registered for both Pinheirinho and Six Senses within the same minute (10:27–10:28 today), through a broker (SIR), not directly — worth checking whether this is being tracked as one qualified lead or risks being logged as two separate, disconnected records.
Separately: the Six Senses PSPA area-matching issue (buyer's lawyer flagging a mismatch between Annex 2 and the Constitutive Title) has been sitting unresolved and is exactly the kind of legal friction that stalls deals at the KYC/SPA stage — worth cross-referencing against the 51.8% Pinheirinho overdue-value finding above.
Separately: the Six Senses PSPA area-matching issue (buyer's lawyer flagging a mismatch between Annex 2 and the Constitutive Title) has been sitting unresolved and is exactly the kind of legal friction that stalls deals at the KYC/SPA stage — worth cross-referencing against the 51.8% Pinheirinho overdue-value finding above.
Sales-team inbox triage — all 5 reps, live access confirmed
| Rep | Mailbox size | Flagged this pass |
|---|---|---|
| Marcos Drummond (Sales Manager) | 45,669 | Lead routed to 2 people at once; Six Senses PSPA legal snag |
| Jorge Figueira (Prata) | 38,129 | RKK/Lote 9 Sunrise — buyer pressing for PSPA date by 24 Sep |
| Henrique Marques (Prata) | 27,215 | Received the misrouted Pinheirinho lead (Margaret Parrino) |
| Claudia Faria (Prata) | 9,781 | Deed scheduled 11 Sep 11:30 — buyer's IMT/passport docs still missing |
| Mariana Antunes (Pinheirinho) | 90 | Lead reassigned to her manually by email, not via Salesforce |
| José Crespo — not yet checked | — | €46.6M / 55 opps, now bigger than Drummond's book — no mailbox sweep done |
Caught the lead-routing bug in the act. A website lead tagged "Pinheirinho (VIC)" (Margaret Parrino) was assigned to a Pinheirinho contact and to Henrique Marques — a Prata rep — within the same hour this morning. That's not a hypothetical from the Alerts tab anymore; it's a live example, with the sender (info@vic-management.com) and both timestamps on record.
Lead handling has a manual patch built on top of it. Drummond reassigned a re-engaged prospect to Mariana Antunes by forwarding an email ("como era teu ainda há pouco tempo, entra lá em contacto"), not through Salesforce — meaning ownership history for that lead now lives in an inbox, not the CRM.
Lead handling has a manual patch built on top of it. Drummond reassigned a re-engaged prospect to Mariana Antunes by forwarding an email ("como era teu ainda há pouco tempo, entra lá em contacto"), not through Salesforce — meaning ownership history for that lead now lives in an inbox, not the CRM.
Today
09 Sep
09 Sep
Faria — deed
11 Sep · docs missing
11 Sep · docs missing
Kilborn — travels
20 Sep · needs status update
20 Sep · needs status update
Figueira — RKK PSPA
24 Sep · buyer booking flights
24 Sep · buyer booking flights
Three unrelated deals, three different mailboxes, all with hard dates in the next two weeks — none visible together anywhere except here.
Corporate Decks / Business Plan
On file
Business Plan Update v7.2, VIC Corporate Presentation
SRC: DROPBOX /1-VIC-PROPERTIES/01-MANAGEMENTVDR Phases (Pinheirinho)
I & II
SRC: 14 PINHEIRINHO - VDR PHASE I, 16 - PHASE IIKYC / Refinancing Packages
On file
SRC: DROPBOX /1-VIC-PROPERTIES/01-MANAGEMENTConfrasilvas Exposure
€87.6M
97 lines — 35.2% of tracked value
SRC: MAPA CONTROLO PO_CONTRATOS.XLSX · 09SEP26, ENTITY-ANCHORED RE-PARSEContracts Pending Signature-Return
21
€1.56M — 20 of 21 with VIC Construções
SRC: MAPA CONTROLO PO_CONTRATOS.XLSX · COL "DATA RECEBIDO SUB/FORN #2" BLANKOverdue_Value__c bug
Open
phantom values since 05Aug26 formula change
SRC: SALESFORCETotal Tracked Contract Value
€248.6M
1,046 valued lines across all entities
SRC: MAPA CONTROLO PO_CONTRATOS.XLSX · 14SEP26, RE-VERIFIEDContract value by contracting entity
Confrasilvas is a single-supplier concentration, not a signature-backlog issue. Signature-return status not re-verified in this pass — the risk is that one supplier holds over a third of all tracked contract value, mostly on LISFUNDO (Prata) work. The old "€2.11M awaiting signature" figure didn't reconcile against this tracker and has been replaced with the verified number.
VIC Construções — pending invoices, live
Total Pending
€219,639
38 documents, untreated
SRC: VICC_FATURAS PENDENTES_20260907.XLSX · 09SEP26, 09:37Largest Single Item
€78,567
Irrimac — Groundsmaster 3500-D mower + kit
Top 2 Suppliers
73%
Toscca + Irrimac = €161.6K of €219.6K
Awaiting "Auto" Sign-off
~22 of 38
notes column flags "Aguardar auto" repeatedly
SRC: VICC_FATURAS PENDENTES_20260907.XLSX · SUMMED FROM 38 LINE-ITEM ROWS, VERIFIED AGAINST FILE'S OWN TOTAL ROW (€219,639.01)
Toscca alone (€81.7K) is a walkway/boardwalk contractor — two invoices for common-area passadiços and guard-rails, both still awaiting approval ("auto"). Combined with Irrimac's €79.9K mower purchase, these two items are 73% of everything VIC Construções owes right now.
Lisfundo & HPII invoice controls — closing the coverage gap
Lisfundo — Validated 2026 Invoices
€26.3M
~2,727 line items, cross-checked 3 ways (±0.25%)
SRC: LISFUNDO 2026 - ATUALIZADO.XLSX · 3-METHOD CROSS-CHECK, ±0.25% (link restricted — may need Dropbox login)HPII — Controlo de Faturas
Not summable
3 overlapping sheets, same invoices repeated
SRC: HPII_CONTROLO DE FATURAS.XLSXC1HPII — Controlo de Faturas
Not summable
Same structural issue — 3 duplicate sheets
SRC: C1HPII_CONTROLO DE FATURAS.XLSXData Quality Finding
2 files flagged
recommend manual reconciliation
Triple-check result: two of the three "named but never parsed" invoice files can't be reliably summed at all. HPII_Controlo de faturas.xlsx and C1HPII_Controlo de faturas.xlsx both contain the same transactions repeated across 3–4 sheets (Sheet1, Sheet2, Sheet3, plus a main tab) rather than one clean ledger — I found the same PLMJ Advogados invoice (€48,485) appearing three times in one pass. Any total I could produce would be inflated by an unknown, unverifiable multiple. Lisfundo's file, by contrast, is a single clean sheet — I ran three independent extraction methods on it and they converged within 0.25%, so that €26.3M figure is trustworthy. Recommend someone with direct Excel access clean up or consolidate the HPII/C1HPII sheets before those numbers can safely go on a leadership dashboard.
Tracked Contract Value
€248.6M
1,046 valued lines of 1,321 entity-matched rows
SRC: MAPA CONTROLO PO_CONTRATOS.XLSX · 14SEP26, RE-VERIFIEDConfrasilvas Concentration
35.2%
€87.6M across 97 lines
2nd Largest Supplier — SEVEME
€36.9M
33 lines — 14.9%
Note
Duplicate
01-Management has its own "Procurement" subfolder, separate from top-level 12-Procurement
Contract value by contracting entity
| Entity | Value | Lines | Share |
|---|---|---|---|
| LISFUNDO (Prata) | €219.95M | 752 | 88.5% |
| VIC Construções | €11.14M | 206 | 4.5% |
| HPII (Six Senses) | €7.95M | 14 | 3.2% |
| HPR (Pinheirinho) | €5.88M | 46 | 2.4% |
| Potential Sketch (Matinha) | €3.36M | 10 | 1.4% |
| HPII | €0.32M | 12 | 0.1% |
| VIC Management | €0.03M | 1 | 0.0% |
Top suppliers by contract value
| Supplier | Value | Lines | Share |
|---|---|---|---|
| Confrasilvas | €87.60M | 97 | 35.2% |
| Seveme | €36.93M | 33 | 14.9% |
| Geos | €12.67M | 10 | 5.1% |
| JJTeixeira | €8.65M | 24 | 3.5% |
| Luzimeca | €7.72M | 15 | 3.1% |
| Schmitt Elevadores | €6.95M | 11 | 2.8% |
| Pemel | €6.54M | 16 | 2.6% |
| Decorpita | €5.90M | 63 | 2.4% |
| Cruzfer | €5.67M | 12 | 2.3% |
| Ernesto Meda | €3.97M | 6 | 1.6% |
| All other suppliers | €66.0M | 754 | 26.6% |
Methodology note: Excel-to-text export drops blank cells entirely rather than keeping them as empty placeholders, so fixed-column parsing silently misreads rows. This pass anchors each row on the "Empresa Contratante" field matched against the file's own fixed dropdown list, then reads Nome/Descrição/Valor relative to that anchor — 1,073 of 1,490 candidate lines matched a known entity (the rest are blank/subtotal/header rows, correctly excluded). Confrasilvas is confirmed the largest single concentration at 35.2% of tracked value, now €87.6M — up from the €78.3M last verified, consistent with new contract lines added since.
Live tracker feed — files touched daily
| Tracker | Cadence | Last touched | Location |
|---|---|---|---|
| Mapa Controlo PO_contratos.xlsx | Daily | 09 Sep, 06:54 | 12-Procurement/01. CONTRATOS |
| VICC_Faturas pendentes | Daily | 09 Sep, 09:37 | 04-Financial/10_VIC_Construções |
| HPII_Controlo de faturas | Daily | 09 Sep, 08:03 | 04-Financial/06_HPII |
| C1HPII_Controlo de faturas | Daily | 08 Sep, 18:02 | 04-Financial/19_Compartimento AH2 |
| Cash & balances (VIC PT) | Daily / intraday | 09 Sep, 06:31 | 04-Financial/49_VIC PT/01.Cash needs |
| Lisfundo 2026 - Atualizado | Weekly | 08 Sep, 11:53 | 04-Financial/50_LISFUNDO/06.Invoices |
Cash needs and invoice-pending files are being edited multiple times per day this week — several same-day versions exist ("0109_apos pgto obras", "SMC", "version 1"), suggesting more than one person passing the same file back and forth rather than one owner updating it once. Worth checking whether these should be one shared live file instead of parallel copies.
Henrique Monteiro Pipeline
Resolved
reassignment confirmed as of Sep report
Finance ↔ Leadership
Note
Susana & Mafalda operate at leadership level on major financing decisions
AI Champion Check-in
Queued
Afonso Ramos
2 Prata Riverside Village
Mature sales-through-delivery development. Mirrors the well-structured /2-Prata Riverside Village Dropbox folder (01–15).
Reading this tabPrata is the largest pipeline (€172.4M) and, by value, the healthiest — only 26% overdue vs. ~52% at Pinheirinho. But July's sales velocity is the weakest on record, and the Post-Venda inbox has an unanswered client with a travel deadline.
Open Pipeline
€172.4M
200 opportunities — click for detail
SRC: SALESFORCE · 11SEP26At SPA Stage
€120.5M
143 opportunities — the bulk of pipeline
SRC: SALESFORCE · GROUP BY STAGENAMEPre-Deed
€24.3M
33 opportunities
SRC: SALESFORCEWebsite Lead Routing Bug
Open
leads still hitting "VIC Properties Tech"
SRC: SALESFORCE / ASANA · ELAINE JESUSPipeline by stage
SRC: SALESFORCE · OPPORTUNITY, REAL_STATE_PROJECT__C='PRATA (VIC)' · 11SEP26
↑ click SPA or Pre-Deed bars for opportunity detail
Sales velocity — July, year over year
July 2026 net reservations (2 units) are the lowest of any July since 2020, down from 12 units in July 2024 and 6 in July 2025. CPCV signings tell the same story: 5 in July 2026 vs. 9 in July 2025. This is a real trend from the file's own year-over-year comparison block, not an extrapolation — worth checking whether it's seasonal or a genuine slowdown before next month's report.
Monthly Progress Reports
Blocked
every file >5MB fetch limit
SRC: DROPBOX /2-PRATA/01-MONTHLY PROGRESS REPORTVistorias — Lote 5
38% open
improved from prior check
Open Infiltration Tickets
58
87 (06Jul) → 65 (10Aug) → 58 (04Sep)
SRC: PLANEAMENTO INFILTRAÇÕES.XLSXShared Inbox Volume
106
emails / 7 days
SRC: OUTLOOK · POSVENDA@VIC-PROPERTIES.COMOpen infiltration tickets by lote
SRC: PLANEAMENTO INFILTRAÇÕES.XLSX — "04,09,26" SNAPSHOT
| Lote | Open | Reparado | Concluído |
|---|---|---|---|
| Lote 1 | 9 | 36 | 6 |
| Lote 2 | 16 | 27 | 9 |
| Lote 2A | 2 | 0 | 2 |
| Lote 5 | 0 | 0 | 14 |
| Lote 6 | 7 | 8 | 2 |
| Lote 7 | 17 | 16 | 1 |
| Lote 8 | 7 | 0 | 2 |
Infiltration backlog trend
SRC: SNAPSHOTS 08JUN, 06JUL, 10AUG, 04SEP26
Other Post-Venda sources
Asana "VIC PRV Pós Venda" — 19 of 20 tasks open. Latest update: "Coverage crisis resolved, 11 new items tracked." Two URGENT: Lote 5 recurring power outages, garage door access.
SRC: ASANA · GID 1217711921161543
SRC: ASANA · GID 1217711921161543
posvenda@ inbox — live email triage
Mailbox Size
8,067
total messages, all-time
SRC: OUTLOOK · POSVENDA@VIC-PROPERTIES.COMUnread, Last 25
25 of 25
but median reply time is 49min — see below
SRC: SAME MAILBOX · 09SEP26 SNAPSHOTTime-Sensitive
1 flagged
client traveling from 20 Sep
Marked High Importance
1
no hot water, D3A
| Category | Count (last 25) | Example |
|---|---|---|
| Warranty repair requests | 6 | Window (Samuel Hung), wall repair, hot water D3A |
| Site-visit scheduling | 4 | Camila (L6 C2A), Óscar (varanda), Luís (L7 B2D) |
| Door Entry app troubleshooting | 4 | Recurring across 3 separate unit owners |
| Legal / ownership paperwork | 2 | L2A B3I transfer, Fieldfisher correspondence |
| Out-of-warranty referrals | 2 | Blackout 1E5E → referred to CRUZFER directly |
| Upsell / modification requests | 1 | Nikoyan — kitchen/laundry reconfiguration |
| Needs status update before client travels | 1 | PRV L6 B2A — Kilborn, away 20 Sep–15 Oct |
Kilborn (PRV L6 B2A) needs a reply before 20 September. They explicitly asked for a status update on outstanding items and mentioned they'll be unreachable from 20 Sep to 15 Oct, offering to leave their key with management if useful for access. This is the one email in the batch with a real deadline attached — everything else is open-ended.
Separately: Door Entry app issues are the single most repeated complaint (4 of 25 emails) across three unrelated units — same root cause (Hometouch app / Wi-Fi) each time, each handled as a one-off reply rather than flagged as a pattern.
Separately: Door Entry app issues are the single most repeated complaint (4 of 25 emails) across three unrelated units — same root cause (Hometouch app / Wi-Fi) each time, each handled as a one-off reply rather than flagged as a pattern.
Response-time reality check — Aug 28 to Sep 2 (14-day window in progress)
49min
Median response time
8/15
Threads answered under 1 hour
16
Threads with no reply yet in sample
"Unread" doesn't mean unanswered here — several threads got a fast reply while staying marked unread in the mailbox. Read-status is not a reliable signal for this team; response timing is.
SRC: OUTLOOK · POSVENDA@VIC-PROPERTIES.COM · 75 OF 166 MSGS SAMPLED (28AUG–04SEP), THREAD-MATCHED · 11SEP26
Still open in this sample
Terrace bay window & ceiling cracks (D5D)
Electric shade enquiry (living room)
Ginásio mirror installation (PRV1)
West E1D warranty works (multi-round)
Water seepage, Lote 1 5º Dto
AC filter access, A1B Lote 6
Water leak, Prata Café frontage
Termoacumulador shut-off, Lote 6 A1C
+4 more not shown — full picture needs the remaining 116 of 166 messages in this window
This is a larger sample now, still not the full 14 days. 75 of 166 messages, covering 28 Aug–4 Sep (half the requested window) — the median (49 min) held steady when the sample grew, and only 1 of 15 matched threads was genuinely slow (47h). Extending through 11 Sep would need roughly 2 more passes at this depth.
Open Pipeline Value
€172.4M
click for detail
SRC: SALESFORCE · 11SEP26Overdue Value Bug
Open
affects Closed Lost / Deed-stage records
Contract Backlog (VIC Construções)
~44
of ~83 group-wide, gap not re-pulled
4 Matinha
Pre-development land assembly and licensing. No sales pipeline yet — the folder itself has no numbering convention, and licensing content is spread across three separate top-level folders rather than one branch.
Reading this tabGenuinely quiet — 0 open Salesforce opportunities confirms this is still pre-development. The one live thread here is the CML dashboard, touched daily; everything else is static reference material.
Plano de Pormenor (Base Plan)
Approved 2019
unchanged since — foundational document is settled
SRC: DROPBOX · PLANO DE PORMENOR.PDF, MODIFIED 16SEP2019Latest CML/DMGP Correspondence
17 Jul 2026
re-evaluation of public-domain parcels (INF.16469.CML.2026)
SRC: DROPBOX /3-MATINHA/COMUNICAÇÕES/DMGPPrior Milestone
03 Dec 2025
"mais-valias" (capital gains) ruling on 5 parcels
SRC: INF.48.DOP.DMGP.CML.25Urbanization Supporting Plans
Updated 2024
general works layout, internal/external
SRC: /3-MATINHA/PLANO DE PORMENOR, MAR2024CML/DMGP correspondence timeline
02 Jan '25
Autonomous indemnities
Autonomous indemnities
24 Feb '25
Parcel valuation
Parcel valuation
03 Dec '25
Capital gains ruling
Capital gains ruling
17 Jul '26
Re-evaluation (latest)
Re-evaluation (latest)
These four items are genuine correspondence with Lisbon's municipal property department (DMGP), not folder placeholders — but they still live split across Processo de Licenciamento, Contrato de Urbanização, and Plano de Pormenor as separate siblings rather than one thread.
Live tracker feed — Matinha's one genuinely active file
| Tracker | Cadence | Last touched |
|---|---|---|
| UE Matinha Dashboard - Ações.xlsx | Daily | 09 Sep, 08:02 |
| UE Matinha Dashboard.xlsx | Daily | 08 Sep, 15:59 |
Unlike the rest of Matinha, this CML action-tracker pair is edited essentially every working day — it's likely the single best place to check for what's actually moving on Matinha licensing week to week.
Comissão Acompanhamento Ambiental
Active
SRC: DROPBOX /3-MATINHADescontaminação — Lot A
Active
last touched 28 Nov 2025
SRC: DROPBOX /3-MATINHA/DESCONTAMINAÇÃO/LOT ADescontaminação — Lot B
Active
last touched 23 Jan 2026 — more recent than Lot A
SRC: DROPBOX /3-MATINHA/DESCONTAMINAÇÃO/LOT BLoteamento A
On file
Loteamento B
On file
Levantamento Topográfico
On file
Sales Pipeline
€0
no opportunities — pre-development
SRC: SALESFORCE · 11SEP26Financing Folder
On file
SRC: DROPBOX /3-MATINHA/FINANCING3 Herdade do Pinheirinho
Multi-component estate — golf, Six Senses Comporta, plots/villas, club house, and production, mirroring the /4-Herdade do Pinheirinho split by business line.
Reading this tabPinheirinho carries the group's real risk: ~52% of its Salesforce pipeline is overdue by value, Six Senses is €46.0M hidden inside "Pinheirinho (VIC)" with no dedicated field, and 15 of 88 sold plots trace to one owner-architect pair (Creinvest Pines / Hueb Ferreira).
Furo 5 — 2026 annual water license
0
26,400 m³ cap
45,404 m³ drawn
72% over cap — the single largest compliance exposure on this estate.
Golf Leads (Salesforce)
241 total
none new since 13 Apr
SRC: SALESFORCE · LEADSOURCE='GOLF'Electricity Billing
Stalled
EDP bills stop at May
SRC: ELECTRICIDADE_PINHEIRINHO.XLSXOverdue Tasks
4
all on one person
SRC: ASANA · VIC GOLFBorehole extraction vs. permitted caps
Fuel consumption (2026, litres/month)
Overdue golf-ops tasks
| Task | Due | Owner |
|---|---|---|
| Locate/confirm Furo 7 permit | 04 Sep | António Castelo |
| Clarify Furo 4 routing | 28 Aug | António Castelo |
| Resolve EDP billing gap | 28 Aug | António Castelo |
| Resolve missing fuel prices | 04 Sep | António Castelo |
Single point of load. All four overdue tasks sit with António Castelo, spanning water compliance, billing and data quality at once.
Live tracker feed — golf ops, updated daily
| Tracker | Cadence | Last touched |
|---|---|---|
| Gasolina_Pinheirinho_2026.xlsx | Daily | 09 Sep, 05:54 |
| leituras diarias rega 2026 Pinheirinho.xlsx | Daily | 08 Sep, 15:26 |
| programa diario_Setembro 26.xlsx | Daily | 08 Sep, 15:25 |
| Presenças Golfe 2026.xlsx | Daily | 08 Sep, 06:23 |
| Gasoleo_Pinheirinho_2026.xlsx | Daily | 07 Sep, 10:45 |
| Rega Pinherinho - resumos mensais.xlsx | Weekly rollup | 07 Sep, 08:30 |
| Caixa Golf Services / Vic Construções 2026.xlsx | Weekly | 26 Aug, 03:59 |
Pinheirinho (VIC) — Total
€72.9M
25 open opportunities
SRC: SALESFORCE · 11SEP26↳ Six Senses (branded residences)
€46.0M
10 opps — 63% of the VIC total above
SRC: SALESFORCE · NAME LIKE '%SIX SENSES%'↳ Other Pinheirinho (VIC) plots
€27.0M
15 opps — the remaining 40%
SRC: SALESFORCE · SAME QUERY, EXCLUDEDPinheirinho (3rd Party)
€66.1M
40 open opportunities
SRC: SALESFORCE · 11SEP26Six Senses vs. the rest of Pinheirinho's own pipeline
SRC: SALESFORCE · OPPORTUNITY, REAL_STATE_PROJECT__C='PINHEIRINHO (VIC)', SPLIT BY NAME MATCH
SRC: SAME QUERY, GROUPED BY STAGENAME
Six Senses is carrying the Pinheirinho (VIC) pipeline, not just contributing to it. 6 of its 9 opportunities are already at SPA stage (€30.5M), the most advanced stage before Pre-Deed — meaning the branded-residences product is converting faster and further than the standalone villa plots, which are more spread across earlier stages (Qualification through KYC).
Other Pinheirinho sales notes
Google Ads Data Handoff
Weekly friction
lives in Dropbox, no ad-platform connector
Six Senses — Total Keys
128
58 branded residences + 70 hotel guestrooms/villas
SRC: SSC_GUESTROOM AND RESI MIX.XLSX · UPDATED 16APR26Club House — Utilization License
In progress
folder touched 04 Sep 2026 — 4 days ago
SRC: /6 CLUB HOUSE/3 LICENÇA DE UTILIZAÇÃOClub House Construction
Near-complete
site photos current as of Mar 2026
SRC: /6 CLUB HOUSE/FOTOSPrivate Plots Tracked
47 folders
some bundle multiple lot numbers per architect
SRC: DROPBOX /5 LOTES PRIVADOSLive construction cams
Lote 194 (AR194) — Hyperlapse
Live time-lapse construction feed
↗
AR75 — likely has a cam too
Invoices confirm a 24-month audiovisual contract, but no URL on file yet
AR75 almost certainly has the same live camera setup as Lote 194. VIC Construções invoices show a parallel 24-month "Acompanhamento Audiovisual de Obra" contract for AR75, from the same vendor, running the same billing cycle — but I don't have that camera's actual hyperlapse.pt link, so I haven't guessed at one. If you have it (or any other villa's), send it over and I'll add it here the same way.
SRC: SSC_GUESTROOM AND RESI MIX.XLSX · UPDATED 16APR26
Beach Club is still draft-stage. ~1,081 m² indoor + ~775 m² outdoor planned (seafood restaurant & bar, pool cabanas, changing rooms) but marked "DRAFT" in the resort program — not yet locked.
Club House — recent activity
| Date | Item |
|---|---|
| 04 Sep 2026 | Licença de utilização folder updated — most recent activity |
| 12 Mar 2026 | Construction site photos current |
| 04 Sep 2025 | Works-deadline extension (Prorrogação prazo obra) |
Plot-by-plot licensing & construction status
Total Plots Tracked
204
116 still unsold/held by HPII
SRC: PINHEIRINHO-CONTROLO DE PROCESSOS E PROJECTOS.XLSX · 09SEP26Past Submission Deadline
11
from 39 to 704 days overdue
SRC: SAME FILE · "DELAY (DAYS)" COLUMNPrior Communications — 2026 Queue
45
vs. 42 already submitted
SRC: SAME FILE · "CP SUBMETIDAS" SHEETIn Construction
18
of 88 owned/sold plots
SRC: SAME FILE · STATUS COLUMN
SRC: PINHEIRINHO-CONTROLO DE PROCESSOS E PROJECTOS.XLSX · 112 PLOTS WITH A DETERMINED STATUS
SRC: SAME FILE · SORTED BY DELAY DESCENDING, COLOR = SEVERITY
Four Lusiaves-linked plots (A R20–23) are stuck together at exactly 142 days overdue — same owner group, same delay, suggesting one blocked decision rather than four separate issues. Worth a single conversation rather than four.
Who's actually holding the pipeline: owners & architects
SRC: PINHEIRINHO-CONTROLO DE PROCESSOS E PROJECTOS.XLSX · TOP OWNERS BY PLOT COUNT, EXCL. HPII-HELD
SRC: SAME FILE · PLOTS PER ARCHITECT/DESIGN FIRM
Creinvest Pines alone owns 15 of the 88 sold plots — the single largest concentration by far, all designed by Hueb Ferreira, and mostly already in Construction. Hueb Ferreira (15 plots) and Jacobsen (12) together design over half of everything currently owned — a scheduling conflict or capacity issue with either firm would ripple across dozens of plots at once, not just one.
Licensing submissions: done vs. queued
SRC: PINHEIRINHO-CONTROLO DE PROCESSOS E PROJECTOS.XLSX · "CP SUBMETIDAS" SHEET
Monthly Progress Tracker
Live & fetchable
SRC: MONTHLY PROGRESS REPORT_UPDATED.XLSXProduction Folder
On file
SRC: DROPBOX /4-HERDADE.../PRODUCTIONAlerts & Data Health
Cross-cutting issues that don't belong to one folder.
63 open opportunities are past close date, worth €110.8M (all projects) — new this pull. Prata alone: 37 opps / €45.3M. Pinheirinho (VIC): 15 / €34.8M. Pinheirinho (3rd Party): 11 / €30.5M. Not previously surfaced — only visible when filtering CloseDate < today rather than summing total open pipeline.
Salesforce duplicate-lead cleanup — decision pending (email, 08 Sep). Elaine Jesus flagged that a case-by-case review is needed before deleting: at least one "duplicate" lead is a real 2024 walk-in that re-engaged in August 2026 (downloaded floor plans). Awaiting sign-off from Alfredo before any cleanup runs.
Furo 5 over annual water license (4 · Pinheirinho). 45,404 m³ drawn against a 26,400 m³ cap for 2026.
Golf electricity billing gap (4 · Pinheirinho). EDP bills stopped since May; four related Asana tasks overdue.
Confrasilvas concentration risk (1 · VIC Properties) — revised up again. €87.6M across 97 contract lines, 35.2% of the group's €248.6M tracked contract value (re-parsed 09Sep26, anchored on the entity dropdown list rather than fixed columns). Signature-return backlog not re-verified in this pass — treat the earlier 21/€1.56M figure as stale.
Vistorias outlier — Lote 4 (2 · Prata). 95% of inspection items still open, unchanged since first flagged.
Overdue_Value__c formula bug (1 · VIC Properties / Salesforce). Phantom values on Closed Lost / Deed-stage records since 05 Aug.
Website lead routing (2 · Prata). Leads still routing to system user instead of reps.
Source ledger — every figure, by business unit
1 VIC Properties: Mapa controlo PO_contratos.xlsx — re-fetched and re-verified 14Sep26 using entity-anchored parsing (1,046 valued lines, €248.6M total — stable to within €1,063 of the 09Sep26 parse; note: entity dropdown values changed format between checks, now suffixed e.g. "LISFUNDO (Prata)", parser updated accordingly; Confrasilvas €87.6M/97 lines/35.2%; signature-return backlog not re-verified this pass) · VICC_Faturas pendentes_20260907.xlsx (€219,639.01 / 38 docs, VIC Construções, verified against file's own total row) · Lisfundo 2026 - Atualizado.xlsx (€26.3M / ~2,727 lines, cross-checked via 3 independent parsing methods, converged within 0.25%) · HPII_Controlo de faturas.xlsx and C1HPII_Controlo de faturas.xlsx (flagged unreliable — duplicate transactions across 3+ overlapping sheets, no trustworthy total possible via text extraction) · Salesforce Overdue_Value__c · Salesforce Opportunity (all projects, IsClosed=false AND CloseDate<TODAY, 09Sep26) · Outlook inbox (Salesforce duplicate-cleanup thread, 08Sep26) · Dropbox /1-Vic-Properties (01-Management, 04-Financial, 12-Procurement)
2 Prata: Salesforce Opportunity (Real_State_Project__c='Prata (VIC)', full stage breakdown + overdue filter, 09Sep26) · PRV - Sales Report Mensal.xlsx (July 2026, "Net Unidades"/"CPCV's NET Mensais" YoY blocks) · PRV-Master PV.xlsx (Resumo, Vistorias) · PRV PV - Planeamento Infiltrações.xlsx · Mapa Relatório HB.xlsx · Asana VIC PRV Pós Venda 1217711921161543 · Outlook posvenda@vic-properties.com
3 Pinheirinho: Pinheirinho-Controlo de processos e projectos.xlsx — full 204-row re-parse 09Sep26 (112 plots with determined status; 88 sold/reserved; owner and architect concentration; 11 plots past deadline) · Salesforce Opportunity (Real_State_Project__c='Pinheirinho (VIC)' and 'Pinheirinho (3rd Party)', full stage + overdue breakdown, 09Sep26) · Salesforce Lead LeadSource='Golf' · Dropbox /4-Herdade do Pinheirinho/Manutenção Golf (Rega, Combustíveis, 07–09Sep26) · Six Senses SSC_Guestroom and Resi Mix.xlsx (128 keys, updated 16Apr26) · 6 Club House folder (Licença de utilização touched 04Sep26) · Asana VIC Golf 1217579927400162
4 Matinha: Salesforce (0 open opportunities, confirms pre-development stage) · Plano de Pormenor.pdf (approved 2019) · /Comunicações/DMGP correspondence (4 filings, Jan25–Jul26, dates from filenames — PDFs are scanned/no extractable text) · /Descontaminação/Lot A (Nov25), Lot B (Jan26) · UE Matinha Dashboard files (touched daily)
2 Prata: Salesforce Opportunity (Real_State_Project__c='Prata (VIC)', full stage breakdown + overdue filter, 09Sep26) · PRV - Sales Report Mensal.xlsx (July 2026, "Net Unidades"/"CPCV's NET Mensais" YoY blocks) · PRV-Master PV.xlsx (Resumo, Vistorias) · PRV PV - Planeamento Infiltrações.xlsx · Mapa Relatório HB.xlsx · Asana VIC PRV Pós Venda 1217711921161543 · Outlook posvenda@vic-properties.com
3 Pinheirinho: Pinheirinho-Controlo de processos e projectos.xlsx — full 204-row re-parse 09Sep26 (112 plots with determined status; 88 sold/reserved; owner and architect concentration; 11 plots past deadline) · Salesforce Opportunity (Real_State_Project__c='Pinheirinho (VIC)' and 'Pinheirinho (3rd Party)', full stage + overdue breakdown, 09Sep26) · Salesforce Lead LeadSource='Golf' · Dropbox /4-Herdade do Pinheirinho/Manutenção Golf (Rega, Combustíveis, 07–09Sep26) · Six Senses SSC_Guestroom and Resi Mix.xlsx (128 keys, updated 16Apr26) · 6 Club House folder (Licença de utilização touched 04Sep26) · Asana VIC Golf 1217579927400162
4 Matinha: Salesforce (0 open opportunities, confirms pre-development stage) · Plano de Pormenor.pdf (approved 2019) · /Comunicações/DMGP correspondence (4 filings, Jan25–Jul26, dates from filenames — PDFs are scanned/no extractable text) · /Descontaminação/Lot A (Nov25), Lot B (Jan26) · UE Matinha Dashboard files (touched daily)
Access & Sources
Every system this dashboard actually reaches into, and how far that access goes.
Systems Connected
4
Dropbox, Salesforce, Outlook, Asana
Mailboxes Checked
6
posvenda@ + 5 sales reps
Excel Files, Last 30 Days
~242 touched / 15 covered
~6% — curated for materiality, not exhaustive
Salesforce Click-Through
Not yet live
org domain not on file
Access status, by system
Full access, verified
Partial — some limits
Known gap
Dropbox — read/search
live
Dropbox — new shared links
org policy blocks new; pre-existing links still found
Salesforce — SOQL queries
live
Salesforce — click-through links
needs org domain
Outlook — posvenda@
8,067 msgs
Outlook — Drummond
45,669 msgs
Outlook — Figueira
38,129 msgs
Outlook — Marques
27,215 msgs
Outlook — Faria
9,781 msgs
Outlook — Antunes
90 msgs
Outlook — other sales reps
not yet checked
Asana — VIC Golf
live
Asana — VIC PRV Pós Venda
live
Dropbox file coverage, last 30 days
| Folder | Excel files touched |
|---|---|
| 1 · VIC Properties | 129 |
| 2 · Prata | 14 |
| 3 · Pinheirinho | 92 |
| 4 · Matinha | ~7 |
| Total touched | ~242 |
| Actually cited on this dashboard | ~15 |
This dashboard is a curated view, not a comprehensive feed — the ~15 files cited were picked because they drove the biggest, most decision-relevant numbers, not because they're the only ones that moved. Most of the other ~227 are operational logs (bank statements, daily fuel/irrigation readings, monthly reports) that don't need a dashboard citation to be useful — but if there's a specific cluster you check often, tell me and I'll fold it in.
Known limitations, stated plainly
Salesforce isn't clickable yet. Every Salesforce citation on this dashboard names the object and filter used, but doesn't link to the actual record or list view — I don't have your org's domain (e.g. yourcompany.lightning.force.com).
HPII and C1HPII invoice files can't be trusted for totals. Both contain the same transactions duplicated across 3+ overlapping sheets — any sum would be inflated by an unknown multiple. Flagged rather than guessed.
Only 6 of an unknown total number of mailboxes checked. Sales-team triage covers posvenda@ and 5 reps; the full sales team (Pinheirinho side especially) hasn't been swept.
Dropbox new-link creation is blocked by an account-level policy. I can only surface links that already existed before I touched the file — confirmed via list_shared_links, not something I can force per-file.