Free tool · AI prompt

The Weekly Market Update Prompt

Paste this week's numbers with their source and get a 60-second script, a caption and an email, built around the one point that matters for a seller and a buyer this week. It shows every number beside the one you pasted, flags any prediction or promise, and writes around any gap instead of filling it.

Start All free tools

How it works

Three steps.

Copy the prompt into ChatGPT, Claude or Gemini, or open one with a click.
Paste this week's numbers and where they came from: new listings, under contract, closed, median price, days on market, months of supply.
Approve the one point, film the script in one take with the source on screen, and save the chat for next week.

Run it

Open in ChatGPT Open in Claude Open in Gemini

ChatGPT and Claude open with the prompt pasted. Gemini opens a fresh chat; the prompt is copied to your clipboard when you click, so paste it there.

What happens in the chat

Phase 1: the numbers. This week's figures with their source, a comparison period if you have one, and one thing you saw on the ground.
Phase 2: the one point. The single most useful takeaway for a seller and for a buyer, checked against what you saw.
Phase 3: the script. About 140 words with on-screen number cues, a caption under 150 words, an email under 200 with a subject line.
Phase 4: the check. Every number beside the one you pasted, plus flags for predictions, promises and groups of people.
Phase 5: the handoff. One take, source on screen, same chat next week.

What you end up with

A 60-second script with on-screen number cues
A caption under 150 words
An email under 200 words with a subject line
A number-by-number match against your source

The prompt

You are a plain-spoken script writer for a real estate agent. In this one chat we will write my weekly market update: a 60-second video script, a caption, and an email version, using only the numbers I paste. Ask one question at a time and wait for my answer.

GROUND RULES
- Every number comes from me and I say where it came from. If a number is missing, you say so and write around it. Never fill a gap with a guess or a national figure.
- No predictions, no guarantees, no "now is the time to buy." Say what happened and what it means for someone in a situation, then invite a conversation.
- Describe situations, never groups of people. Nothing about schools, safety or crime.
- Plain language, my voice if I paste my voice guide, no hype.

PHASE 1: THE NUMBERS
Ask me to paste this week's numbers for my market and the source: new listings, homes that went under contract, homes that closed, median price, average days on market, and months of supply, for the towns I sell in. Then ask for the same numbers from a month ago or a year ago if I have them, and for one specific thing I saw this week, such as a listing that drew many showings or one that sat.

PHASE 2: THE ONE POINT
Tell me the single most useful point in the numbers for someone selling and for someone buying in my market this week. Ask me if that matches what I saw on the ground. Fix it with my answer.

PHASE 3: THE SCRIPT
Write a 60-second script, about 140 words, in this shape: the one point in the first sentence, two numbers with their source, what it means for a seller and for a buyer in one line each, the thing I saw this week, and a closing line that invites a message. Mark where I should show a number on screen. Then write a caption under 150 words and an email version under 200 words with a subject line under 50 characters.

PHASE 4: THE CHECK
Show me every number in the script beside the number I pasted so I can match them. Flag any sentence that predicts, promises, or describes a group of people. Fix every flag.

PHASE 5: THE HANDOFF
Tell me to film it in one take, to put the source on screen with each number, and to save this chat so next week I paste the new numbers and ask you to run the same steps.

Begin Phase 1 now by asking for this week's numbers.

Read it once so you know what it will ask. Change the days, the pillars or the words it bans to fit how you work.

Keep going

Related.

FAQ

Questions, answered

Why does it refuse to predict?

Because a prediction that misses costs you the trust the update was building, and because it is not yours to make. The script says what happened, what it means for someone in a situation, and invites a conversation.

What if I only have three of the six numbers?

It writes around the gaps and tells you which ones it left out. It never fills a gap with a national figure or a guess.

Does this replace a monthly newsletter?

No. It feeds one. Four weekly updates give you the month's numbers and the month's story, and the email version drops straight into the newsletter.

Next step

Want the system that runs this every month?

30 minutes. Bring the result. Urban Marketing Edge maps the simplest plan for the office. No pitch deck.

Book a 30-minute strategy call