Real Estate Sales Price Comparison Report Prompt

You are a data analyst with deep knowledge of the real estate market. Create a comprehensive report comparing recent sales prices of the following:
– Property Type: [property type], placeholder
– Area: [area], placeholder
– Timeframe for “recent” sales (e.g., last 30/90/180 days): [TIMEFRAME], placeholder
– Data provided (paste if available): [SALES DATA], placeholder
– Currency: [CURRENCY], placeholder
If [SALES DATA], placeholder is provided, analyze it directly. If not provided, outline exactly what data is needed and present a sample report framework with assumptions clearly labeled.
Report requirements:
1) Executive summary
– 5–8 bullet highlights for buyers and sellers
2) Market snapshot (tables)
– Count of closed sales
– Average, median, and price range
– Price per square foot (avg/median)
– Days on market (avg/median)
– Sale-to-list ratio (avg/median) if list price is available
– Distribution by beds/baths, size bands, or sub-areas (if available)
3) Trend and pattern analysis
– Month-over-month or quarter-over-quarter movement (based on the timeframe)
– Identify outliers and explain plausible causes (renovation level, view, micro-location, lot size, building amenities)
– Segment performance (e.g., entry-level vs. luxury tiers)
4) Opportunity analysis
– Buyer opportunities (negotiation leverage, best-performing price bands, DOM-based strategies)
– Seller opportunities (pricing strategy, staging/renovation ROI signals, timing insights)
– Micro-market insights (hot vs. soft pockets) if sub-area data exists
5) Market drivers and context (only if supported by the data provided)
– Inventory signals, absorption indicators, and seasonality notes
– Any relevant factors in the dataset (HOA fees, parking, age of building, condition)
6) Client-ready recommendations
– For buyers: 3–6 actionable moves
– For sellers: 3–6 actionable moves
– Clear caveats and confidence level based on data completeness
Formatting rules:
– Use plain language suitable for clients
– Include clear tables and short paragraphs
– Define metrics briefly (e.g., what DOM means)
– Do not invent numbers; if data is missing, state “Not available” and explain impact
Data notes:
– If you detect missing fields, list them under “Data gaps” and suggest how to collect them
Inputs:
[property type], placeholder
[area], placeholder
[TIMEFRAME], placeholder
[SALES DATA], placeholder
[CURRENCY], placeholder