AI Business AcceleratorBook a Call

Free Resource

AI Market Update Report Template

Suburb Report, Vendor Update, and Buyer Snapshot in One

Free resource from aibusinessaccelerator.au

Complete the data collection worksheet first. Then run the three prompts in order.

⚠️ Compliance reminder: AI cannot source market data. All figures must come from CoreLogic, RP Data, REI Institute, or your agency’s verified sales records. Never present AI-generated market narrative as professional financial or investment advice.

Component 1: Data Collection Worksheet

Complete before opening ChatGPT or Claude. These are the inputs that make the output accurate.

Report period: [Month and year] Suburb / area: [Suburb], [State]

Price Data

Metric This Quarter Last Quarter Same Quarter Last Year
Median house price $[X] $[X] $[X]
Median unit price $[X] $[X] $[X]
Change (QoQ) [+/-X%] — —
Change (YoY) [+/-X%] — —

Source: [CoreLogic / RP Data / REI report — specify]

Activity Data

Metric This Period Same Period Last Year
Median days on market [X] days [X] days
Clearance rate [X]% [X]%
Total new listings [X] [X]
Total sales [X] [X]

Source: [Specify]

Notable Comparable Sale

  • Address: [Street, suburb]
  • Property: [Brief description — beds, baths, key feature]
  • Result: $[X]
  • Notes: [Any relevant context — passed in, multi-offer, etc.]

Market Context

  • Interest rate environment: [RBA current cash rate and recent movement]
  • Relevant news: [Any policy, development, or economic news affecting the market]

Component 2: Suburb Market Report Prompt

You are a real estate agent writing a monthly market update report 
for clients in [suburb], [state].

Here is the market data for this month:
- Median house price: $[X] (up/down [%] from last quarter, 
  up/down [%] year-on-year)
- Median days on market: [X] days ([X] days same time last year)
- Clearance rate: [X]% ([X]% last month)
- Total properties listed: [X] | Total sold: [X]
- Notable recent sale: [address] — [brief description] sold for $[X]
- Context: [any relevant macro news — rate movement, policy change, 
  local development]

Write a market update report suitable for emailing to property 
vendors and buyers.

Tone: professional but accessible — a knowledgeable friend who 
understands the market. Not a data dump; an interpretation.

Structure:
Paragraph 1: What the data tells us about the current market (2–3 sentences)
Paragraph 2: What this means for sellers right now (2–3 sentences)
Paragraph 3: What this means for buyers right now (2–3 sentences)
Final sentence: One forward-looking note — what to watch in the next 90 days.

Under 250 words total.
Do not use the phrases "in today's market," "challenging conditions," 
or "unprecedented." Plain, specific language only.

After generating:

  • Every statistic in the output matches your worksheet exactly
  • No speculative claims about future price movements
  • No statements that could constitute financial advice
  • Readable by someone who doesn’t work in real estate

Component 3: Personalised Vendor Update Prompt

Write a personalised market update email for a vendor whose property 
at [address] has been listed for [X] weeks at $[price].

Current suburb market context: [paste 2–3 most relevant data points 
from your suburb report — e.g., "median days on market in [suburb] 
is currently 34 days, up from 22 days 12 months ago. Clearance rate 
has softened to 61%."]

The vendor's current situation or concern: [describe — e.g., 
"has had 4 inspections with no offers and is starting to feel anxious" / 
"is comparing to a neighbour's recent sale that came in $80k higher" / 
"is confident and patient, just wants a regular update"]

Tone: honest, supportive, forward-looking. Specific to their situation.
No generic reassurances. No jargon.
Under 150 words.

IMPORTANT: Do not include a price adjustment recommendation. 
I will deliver that conversation in person if needed.

After generating:

  • Does not suggest a price adjustment (that’s your conversation)
  • References the vendor’s actual situation, not a generic update
  • Data cited matches your verified figures
  • Tone is appropriate for this vendor’s emotional state

Component 4: Buyer Market Snapshot Prompt

Write a short market snapshot for a buyer looking in [suburb] 
with a budget of approximately $[range].

Current market data:
- Median price: $[X] ([+/-X%] year-on-year)
- Median days on market: [X] days
- Clearance rate: [X]%
- Current stock levels: [higher / lower / similar to 12 months ago]
- Context: [any relevant rate or policy news]

Tone: honest about conditions — don't oversell the opportunity 
or catastrophise. Two short paragraphs only.

Paragraph 1: What the current market looks like for a buyer 
at this budget in this suburb.
Paragraph 2: What this means for their buying timeline and strategy.

Under 100 words total.

After generating:

  • Word count is under 100 — if longer, regenerate with “be concise”
  • No investment advice language
  • Honest about competition levels — not artificially optimistic

Component 5: Email Subject Line Options (6 Variants)

Run this prompt to generate subject lines for each report type:

Write 6 email subject line options for a real estate market update 
email for [suburb], [month].

Two subject lines for each approach:
1. Data-led (mentions a specific number or metric)
2. Narrative-led (describes the market in one phrase)
3. Personalised (sounds like it's written for the recipient specifically)

Under 50 characters each. No clickbait. No "you won't believe" language.

Component 6: Compliance Reminder Checklist

Complete before sending any market update.

Data Accuracy

  • All figures sourced from CoreLogic, RP Data, REI, or agency records
  • Comparable sales are verified (not AI-generated examples)
  • No figures provided without a source you can cite if asked
  • All percentages calculated from actual data (not AI estimates)

Legal / Compliance

  • No statements that could constitute financial, investment, or tax advice
  • No price predictions or future value claims
  • Vendor update does not contain price adjustment recommendation (deliver in person)
  • Content consistent with your agency’s marketing compliance guidelines
  • No misleading representations about market conditions

Quality

  • Report is readable by a non-industry person
  • No industry jargon unexplained
  • Agent has personally reviewed (not just the AI output) before sending
  • Personalised vendor update reflects the actual vendor’s situation

More resources at aibusinessaccelerator.au