Turn 12 months of sales data into an interactive neighborhood dashboard with Claude Cowork
New York agent Todd Vitolo exported 12 months of Compass sales data and used Claude Cowork to build an interactive dashboard of 491 Tribeca transactions with monthly price trends, days on market, building-level breakdowns, and a heat map, as featured in Agent Intelligence issue #29.
At a glance
- Tools used
- Claude CoworkCompassMLS export
- Category
- Marketing & content
- Audience
- agent
- Difficulty
- No-code setup
- Source
- The $0 Research Department | Agent Intelligence #29
Matt Spangler (Agent Intelligence) · Newsletter · Mar 7, 2026 - First step
- Export closed sales for the last 12 months in one neighborhood as a CSV.
Suggested prompt
Written by this directory, inspired by the source. Replace the [bracketed] parts.
Using the attached CSV of closed sales in [neighborhood] for the last 12 months: Build an interactive HTML dashboard with: monthly median price and price per square foot, median days on market by month, a table by building or street, the 10 fastest sales, the 10 largest list-to-sale discounts, and a scatter plot of price per square foot vs. days on market. Add a "Data source and date range" note at the top. Do not fill gaps with estimates; show missing data as blank.