HARKEY / Billboard Intelligence

Dashboard

Your pipeline at a glance.

Loading your scorecard…

Opportunities Maricopa Assessor GIS

Graded parcels on the left, the live parcel map on the right — click any row to fly the map to it (ℹ details for the full 10-gate checklist). Every result is a real parcel through a 10-gate eligibility check, graded A–F (Yes / No / Needs-Manual-Review). Tick rows → ➕ Targets.

Loading graded opportunities…

opportunity-city board    closed-city board    saved    county island    graded opp  — click any pin for details.

Comps lease & revenue

Log the billboard deals you look at — one record per face: rate, annual revenue, lease terms, panel details and traffic. The map sizes & colors each face by annual revenue, so you can eyeball high-value corridors and benchmark a deal against nearby comps. Hit ➕ Add comp to log one.

Loading comps…

Each face is a circle sized & colored by annual revenue — click a pin for its rate, lease and traffic detail.

Documents

Every file across all deals, in one place. Filter by category or search by name or deal, and click a document to download it (or its deal to open it).

Loading documents…

Peoria Spacing

The billboard locations we hold rights to, measured against the spacing rule and against every existing board nearby. The rule is editable — Peoria's figures are a proposed amendment, so change them and see what moves.

Loading…

Deal Folder Mapping Admin

Connect each pipeline deal to its top-level SharePoint Deals folder. Use the local sync while testing and Microsoft Graph in production. Suggestions are based on names only; nothing is moved, renamed, or uploaded.

Folder source
Local phase
The Fly.io site cannot read this C: drive. Switch to Microsoft Graph for the deployed connection.
Open this tab to scan mappings…

All Deals

Every deal in both pipelines — organic, completed, M&A and long-term — in one table, with one weekly review and one search across all four categories. Development and Acquisitions stay the lists you work in; this is the view that spans them. Each row names the pipeline it came from, and click any deal to open it.

Loading every deal…

Development Pipeline

Deals we're building (organic + completed). Click a deal to open its weekly change log — what moved each week and who worked it. Add this week's update on the deal. Imported from the workbook; edits live here.

Loading pipeline…

Acquisitions Pipeline

Deals we're acquiring (M&A + target operators), grouped by stage (Closed / Under LOI / Negotiating / Long-term / Dead-Paused). Click a deal for its weekly change log; add this week's update on the deal.

Loading pipeline…

Targets

Sites your team has promoted to a target for review. Each row opens a workbook — site details, a status (Prospect → In review → Approved / Passed), an assignee, and a shared comment thread. Promote a site from the Map (click a board/parcel → 🎯 Promote to target) or from a saved board's popup, then push it to the next reviewer.

prospect in review approved passed
Loading targets…

Lease Jumps

A competitor's ground lease approaching its notice deadline is a chance to approach the landlord and take the site. Upload a lease and it is read — embedded text first, then OCR, then vision — into a review queue ranked by the date we have to act. Every value shows the page it came from and how that page was read, and a derived date never poses as one the document stated. Nothing reaches the deal board until you promote it.

or drop lease PDFs here

Found — needs review

Loading lease jumps…

Tracked

Loading promoted lease jumps…

Discovery

Development Roadmap

Every development plotted on a timeline by its go-live date. Set a deal's go-live date in its detail view and it appears here. Click any deal to open it.

Loading roadmap…

Risk management

Insurance Policies

One register for coverage, premiums, renewals, insured entities, brokers, and policy documents.

Loading insurance policies...

Policy register

Coverage and renewals

Loading policy register...

Policy document links should point to the authoritative file in OneDrive or your data room. The linked source file is never modified by this register.

2026 portfolio performance

Revenue Dashboard

Budget, pace, forecast, lease expense, revenue share, and estimated net revenue in one asset-level view.

Download import template
Loading revenue performance…

Portfolio view

Filter and group

Planning scenarios

Reforecast and next-year budget

Saved separately from the locked 2026 source budget. Generate a starting point, then edit any asset.

Asset detail

Revenue performance by asset

The master workbook is read-only. Uploads replace actual revenue only; budget, lease, split, ownership, and entity assumptions remain preserved.

Lease Finder

The database behind Lease Jumps. Lease Jumps asks “which lease can we take, and when”; this is everything discovery has found whether or not it is actionable yet — the properties, the documents they were read out of, what still needs triage, and the record of what was requested from whom. Every figure carries the document and page it came from. Nothing on this tab writes to the deal board.

Loading…

Admin

Who is on the team, what they can open, what they have done, and the database backups. Changes here take effect immediately and are enforced on the server, not just hidden in the interface.

Reports

The weekly digest and the exports that come off the pipeline.

Shared Sites

Sites shared with you, and the documents that go with them. Everything here is a working folder: what the team uploads you can read, and what you upload they see. Nothing else in the pipeline is reachable from this page.

Loading…

🏦 Lender Summary

A clean, lender-facing snapshot of the Development and Acquisitions deals you choose to show. Add one from its detail view — open any deal and toggle Show in Lender Summary. Values are pulled from each deal's own figures (Purchase Price / Proforma Revenue / cost) and totaled per pipeline.

Loading…