System Health
diagnostics, audit trail, and admin
Operational view of the competitor-intelligence pipeline: database connection, schema integrity, last ETL run summary, operator coverage, and onboarding checklist. For analytics, see the Field landing page.
ETL Audit
| Run ID | 71060a53-f2b1-4cbe-a162-4ac322aaf7ed |
| Started | Jun 1, 2026, 6:46 AM |
| Finished | Jun 1, 2026, 6:49 AM |
| Operators run | 1 |
| Inserted / Updated | 136 / 0 |
| Failures | 0 |
Health
database, schema, seed data
Database Connection
| Connected | true |
| Schema applied | true |
| Operators | 185 / 9 |
| Fingerprints | 61 |
Active Listings
pulled from the latest ETL run · Jun 1, 2026, 2:46 PM PT
Operator Breakdown
Portfolio weighting across operators in the latest ETL
How well multifamily CL inventory maps to known operators
| Brick + Timber | 54 listings · $4,020 median |
| Rentals Inc. | 20 listings · $2,695 median |
| Gaetani Real Estate | 14 listings · $3,645 median |
| RentSFNow | 12 listings · $1,770 median |
| Trinity SF | 11 listings · $3,447 median |
| Mosser Living | 8 listings · $2,145 median |
| Parkmerced | 6 listings · $3,210 median |
| 2B Living | 4 listings · $5,422 median |
Recent Changes
| 2035 Castro St · 31rentals_inc | removedremoved from market |
| 3099 Washington St · 24rentals_inc | removedremoved from market |
| 980 Bush St · 207rentals_inc | removedremoved from market |
| 2037 Castro St · 21rentals_inc | removedremoved from market |
| 3900 21st Strentals_inc | removedremoved from market |
| 938 Hayes St · 6rentals_inc | removedremoved from market |
| 1085 S Van Ness Ave · 206rentals_inc | removedremoved from market |
| 1532 Howard St · 101rentals_inc | removedremoved from market |
Attribution Confidence
623 of 2,455 CL ads matched to a known website listing.
Operator Roster
eight operators plus a separate Craigslist scan
SF Multifamily Competitors
Plus a separate Craigslist SF scan (apartments-for-rent, multifamily only), attributed to operators via the fingerprint dictionary in the fingerprints table.
Onboarding Checklist
complete before first daily run
Pre-flight
- Connect Neon database via Vercel → Storage. Confirm
LEASING_DATABASE_URL_UNPOOLEDpopulated. - Apply schema:
npm run db:apply - Create Cloudflare R2 bucket and add credentials to env vars.
- Apply lifecycle rule on R2 bucket:
Delete after 90 days. - Add GitHub Actions secrets:
LEASING_DATABASE_URL_UNPOOLED,R2_*,SLACK_WEBHOOK_URL. - Verify daily ETL runs at 06:00 PT via GitHub Actions cron.