If you're a real estate agent looking to stand out, creating monthly market update videos is one of the best ways to build authority, engage your audience, and stay top of mind with buyers and sellers.

In this guide, I’m walking you through the exact process I used to create a professional market stats video — including the tools, scripts, visuals, and editing steps.You can easily follow this workflow to create your own real estate content every month.

Let's dive in!

📈 EXAMPLE VIDEO - DENVER METRO MARKET UPDATE 📈

💻 COMPLETE VIDEO TUTORIAL WALKTHROUGH 💻

Step 1: Download Your Local Real Estate MLS Data

The first step is simple: log into your local MLS system. Once you're in, click on "Search" and choose "Residential" or whatever property type you're targeting.

From there, you can decide how broad or granular you want your data to be. You might search for an entire county, a specific zip code, or even draw a custom map around your farm area.

If you have an upcoming listing presentation, you could pull closed sales for just that subdivision to make your presentation hyper-local and impressive.

Before pulling the data, decide what status you want: active, pending, closed, or a combination. For most market updates, I recommend focusing on closed sales, as they provide the most concrete data for trends and pricing.

Once you've chosen your criteria, click "Results." If you're pulling a large dataset (over 5,000 records), you may need to split it into smaller sections. Select all the results you want, and prepare for the next step.

Pro Tip: Before downloading, make sure you've customized your MLS columns. Include key fields like List Price, Close Price, City, Zip Code, Days on Market, Seller Concessions, HOA fees, and any other data points you want to analyze. I'll link my full "MLS Columns Cheat Sheet" at the bottom of this post.

⬇️ The Complete Real Estate Market Intelligence Report: Trends, Analysis & Actionable Insights ⬇️

‼️ DOWNLOAD MY MLS COLUMN CHEAT SHEET! ‼️

Step 2: Upload Your Market Data and Analyze It

The first step is gathering your market stats for the timeframe you want to cover.

I uploaded my MLS market data for March 2024 and March 2025.Then, using ChatGPT, I prompted it with a very specific request to analyze the data and provide:

Total closed sales and percent change year-over-year
Median and average sales price trends
List-to-sale price ratios
Price per square foot
Days on market and seller concessions
Price range distributions
Segment breakdowns (by property type and bedroom count)

Pro Tip:When prompting ChatGPT, be as specific as possible.Ask it to only use the data provided, not guess or infer missing fields.

DOWNLOAD MY MARKET UPDATE PROMPT!

Step 3: Create the Script

Once the data analysis was complete, I asked ChatGPT to create a teleprompter-ready script.

Here’s what I asked for:

Casual and confident tone, like speaking to a client.
Fully written-out script with no stage directions or emojis.
About 60–75 seconds long.
Natural for reading aloud on camera.

This script will become the exact words you read while recording your video.

Prompt to Create Teleprompter-Ready Video Script for Reels:

Create a casual, engaging script that sounds like I'm speaking naturally to an audience of home buyers and sellers.

The script should be fully written out for a teleprompter, meaning no stage directions, no emojis, and no camera cues.

It should be conversational, clear, and flow easily when spoken aloud, about 60–75 seconds long.

I will be using a green screen, so the script should naturally allow for key visualizations (like price trends, graphs, or bullet points) to appear behind me without needing to mention them in the script.

Prioritize short, punchy sentences that feel authentic and are easy to read aloud without sounding robotic.

The tone should be confident, professional, and friendly — like I'm talking one-on-one to a client or friend

EXAMPLE: RESULTS - SCRIPT CREATED BY CHAT GPT:

Denver Real Estate Market Update — March 2025

Want to know what’s really happening in the Denver Metro real estate market right now? Here’s your March 2025 update in 60 seconds or less. Let’s dive in.

First, the market’s holding steady.Total home sales dipped just slightly compared to last year.The median home price came in at five hundred eighty-five thousand dollars, down about one percent year-over-year.This isn’t a crash — it’s more of a market breather.

Now, for buyers.There’s a little more room to negotiate right now.We’re seeing more sellers offer concessions.And if you're shopping over seven hundred fifty thousand dollars, there’s definitely more selection and a little less competition.

For sellers — here’s what you need to know.Homes that are priced right and show well are still selling fast.In fact, forty-one percent of homes went under contract in the first seven days.But if a home is overpriced, it’s sitting longer and often giving up concessions to close the deal.

Most of the action is still happening between three hundred thousand and seven hundred fifty thousand dollars.And interestingly, luxury sales over one million dollars are ticking up, but buyers are being a lot choosier in that range.

Bottom line — whether you’re buying or selling, strategy matters more than ever.If you want a game plan that actually works in today’s market, shoot me a message.I’m here to help you win.

Step 4: Record Your Video with a Teleprompter App

Next, I copied the script and pasted it into the CapCut Teleprompter tool on my phone.

Using CapCut’s teleprompter feature:

Adjust the text size and scroll speed to match your natural talking pace.
Record yourself reading the script, ideally using a tripod or stable setup.
Look slightly above the camera lens so you maintain eye contact.

This becomes your talking head video where you'll be on screen delivering your market update.

Step 5: Create Visuals to Layer Behind Your Video

To make the video more dynamic, I wanted key visual elements behind me.

Here’s how I did it:

I pasted the same script into Gamma.app, a simple design tool for creating visuals.
Gamma generated clean, vertical-style slides that match the flow of my script.
I customized fonts, colors, and layouts to fit my brand.
I then screen-recorded the slides while reading through them at the same pace as my teleprompter video.

This created a matching visual slideshow ready to layer behind my talking head video.

Learn how to create professional real estate market update videos step-by-step, from analyzing MLS data to scripting, recording with a teleprompter, and editing a finished vertical video for Reels or YouTube Shorts.

Use Gamma.App to create your creative media that will be displayed behind you while you talk on video.

Choose the option to create "Social" content and choose the "Stories" option from the dropdown.

Submit your request and have AI create your vertical social graphics.

My export created this content for the Denver Metro 2025 Market Stats for March 2025.

Lastly, you will want to use your phone to screen-record this document. You will open up the social content on your phone. You will then play the video recording that you previously recorded on your phone, and slowly scroll on your phone screen recording the associated visual content to match the speed of you talking about each topic.

DOWNLOAD MY SCREEN RECORDING BY CLICKING HERE

Step 6: Transfer Your Files from Phone to Computer

Now it’s time to get all your assets into your editing software.

I used two options:

AirDrop (if you have an iPhone and Mac/PC that supports it).
Cloud storage like Google Drive or Dropbox to upload and then download files onto my computer.

You’ll need both:

Your recorded talking head video
Your screen-recorded visuals

Step 7: Edit in CapCut to Create Your Final Reel

Using CapCut for PC:

Import both video files into your project.
Place your talking head video in the foreground.
Place your recorded visuals as the background layer.
Fine-tune the timing if needed so your words sync with the slides.
Add background music or sound effects if desired.
Export your final vertical video ready for Instagram Reels, TikTok, or YouTube Shorts!

Bonus Tip:Add simple text pop-ups or highlight important numbers to boost engagement even more.

Final Thoughts

This entire process may seem like a lot at first, but once you go through it once or twice, it becomes incredibly fast and efficient.

By creating professional, data-driven market update videos:

You build trust and authority with your audience.
You create valuable content for both buyers and sellers.
You stay top of mind every month — without needing expensive video production.

If you want help setting up a custom workflow like this for your real estate business, feel free to reach out!

My Blog

How to Create a High-Impact Real Estate Market Update Video (Step-by-Step Guide)