Raw market dataEdited, captioned report episodesAd-hoc uploadsA fixed weekly & monthly cadence
Background
Harlem Lofts Inc. is a real estate brokerage in Upper Manhattan, New York, publishing a recurring market report for townhouse and condo buyers and sellers.
The challenge
Market data on its own is not something people watch. It needed to become an edited series with a fixed identity, published on an unbroken weekly and monthly cadence — plus separate reporting on the brokerage’s own marketing.
What I built
The series
The Upper Manhattan Real Estate Report: weekly and monthly townhouse and condo market updates, plus annual reports, published to YouTube with a fixed series identity.
How the episodes are made
- Data-led edits with motion titling and captions
- Hooks, pacing, jump cuts, zooms and short-form storytelling
- Consistent branding across every episode
- Multiple aspect-ratio versions for YouTube, Shorts, Reels and ads
Reporting & lead organisation
- Separate weekly and month-to-date marketing reports for the brokerage
- Buyer and property enquiry leads compiled and organised for Upper Manhattan condo and co-op enquiries
Results
Never missed — Weekly and monthly reports published on schedule since October 2025.