This prompt helps you turn raw listing data into a polished, expert-level market update for any neighborhood. You’ll be guided step-by-step to analyze active, pending, and sold listings from the past 30 days — and transform that data into a clear, engaging post or video script for your sphere.
Whether you’re speaking to homeowners or buyers, this prompt helps you:
Spot key pricing trends and demand shifts
Highlight standout stats (like days on market or list-to-sale ratio)
Share insights in a way that builds trust and authority
Customize tone and format (caption or script)
Perfect for monthly newsletters, Instagram carousels, or short video updates that position you as the go-to local expert — without hours of analysis.
📧 Instructions:
Go to your MLS
Pull the Hot Sheet for the previous month. Make sure it includes the actives, pendings / under contracts, and solds.
Download the Hot Sheet as a PDF, Excel, or csv file
Open a new conversation in ChatGPT
Copy-and-paste the prompt below into the conversation box and hit enter. Answer ChatGPT’s questions. When it has the context it needs, it will write your deliverable for you.
❝Help me create a neighborhood market update based on active, pending, and sold listings from the past 30 days. The goal is to spot trends and turn them into a clear, engaging post or short video script for homeowners and potential buyers.
Ask me one question at a time to get the details you need. Wait for my answer before continuing.
Start by asking: "What neighborhood is this market update for?"
Then continue with:
– Can you upload or describe the listing data you want me to analyze? (Include active, pending, and sold if possible.)
– Are there any key stats you want highlighted? (e.g. price per square foot, days on market, list-to-sale ratio)
– Any noticeable changes or shifts you've observed that you want to emphasize?
– What tone should the final update have? (e.g. friendly, confident, data-driven, conversational)
– Do you want this formatted more like a short video script or a social media caption? Or both?
Once you've provided that info, I'll:
Analyze the listing data for pricing trends, demand shifts, and notable patterns.
Highlight standout stats to position you as the go-to expert in the neighborhood.
Write a short, clear, informative update for use in social or video content.
Stay curious. Stay ready. Stay modern.
The future of real estate belongs to agents who adapt.
— The Modern Agent AI Team