Skip to content
Veracy Toolbox
← All prompts

Price Per Square Foot Analysis & Trends

Operations Data Analyst Real Estate

The prompt

Analyze price per sq ft trends to identify market movement.

{{historical_sales_data_by_property_type_t}}

Steps: 1) Calculate price per sq ft for all comps 2) Group by property type and neighborhood 3) Calculate median price per sq ft by period 4) Trend month-over-month and year-over-year 5) Identify anomalies and address 6) Project forward with trend analysis 7) Compare to national/state averages

Output: Price per sq ft trend chart, historical table, market movement summary, forward projection.

Why this works

Price per sq ft trends reveal market movement quickly. Simple metric for rapid analysis.

Risks & review

Price per sq ft alone ignores quality differences. Must adjust for condition and amenities.