The Claude Skill That Turns Showing Data Into a One Page Report for Your Seller

Jerad Larkin

5 hours ago

7 min read

Can a real estate agent see how many showings homes get before they go under contract? Yes. REcolorado's InfoSparks tracks showings to pending, and this free Claude skill pulls that data and builds a one page showing activity report in your own branding.

Download the showing activity report skill

Grab it here, then keep reading for the setup and the seller conversation it is built for.

Showing Activity Report Skill (ZIP): Click here to download the skill
On Instagram: comment SHOWINGS on the Reel and my account will send it to you
Branding: the skill asks for your name, brokerage and colors the first time you run it, so every report comes out as yours

The report is white labeled. My name is not on it anywhere, and neither is my company. It is your report to hand your seller.

Every seller asks the same question

Your listing has been on the market for six weeks. The seller calls and asks why it has not sold. You already know the answer, but the moment you say the word price, the conversation turns into a negotiation about whether you did your job.

Showing data changes that conversation, because it is not your opinion. It is a count of what buyers actually did.

That is what this skill pulls. It opens InfoSparks, the stats platform included with your REcolorado membership, applies the filters you give it, reads every metric on the page, and builds a one page report you can send to your seller or bring to the price reduction conversation.

Showings to pending is the number that settles it

Most agents look at days on market and price per square foot. Those matter, but they describe the outcome. Showing activity describes the demand that produced it.

InfoSparks defines the two showing metrics plainly. Showings to Pending is the number of showings scheduled per listing that went into pending status during the period. Showings Per Listing is the average number of showings scheduled on active listings for that period.

In plain English, showings to pending is roughly how many buyers walked through a home like yours before someone wrote an offer. That single number reframes a stale listing two different ways:

Your listing has far more showings than the median and no offer. Buyers are seeing it and choosing something else. That is a price or condition conversation, and the showing count is the evidence.
Your listing has far fewer showings than the median. Buyers are not getting through the door at all. That is an exposure problem: photos, remarks, syndication, marketing spend, or showing access.

Those are two completely different fixes, and guessing wrong costs your seller weeks. Both figures come from showings scheduled through the showing system, so treat them as a strong signal rather than a perfect count.

What is actually on the report

One page, print ready, built around the showing numbers instead of burying them:

Median and average showings to pending, at the top, in the largest type on the page
Showings per active listing
Median and average days in MLS
Months supply and active listing count
New, pending and closed listings for the month
Median and average closed price, sold price to list price percentage, and price per square foot
Three plain English takeaways written from the numbers that were actually pulled
An optional side by side block comparing your listing's own showings and days on market against the market medians

Every figure carries its year over year change, marked with a simple up or down arrow in neutral gray rather than red and green, because up is good for closed price and bad for days on market.

What you need before you run it

A Claude account, on a computer. Skills upload from the desktop or web app, not the phone. You can download the desktop app here.
The Claude in Chrome extension, connected. The skill drives your browser to pull the data. Without it, the skill will stop and tell you so.
An REcolorado membership with InfoSparks access, and an active login in that same Chrome browser. The skill never asks for your password.
About five minutes for the first run, and about two minutes for every run after that.

On a different MLS? Many associations run the same ShowingTime stats platform under their own web address. Swap your MLS's stats URL in when the skill asks and it will work the same way, though menu labels may differ slightly.

Setting it up, one time

Download the ZIP from the link at the top of this post.
Open Claude on a computer, go to Settings, then Skills, and upload the ZIP.
Run it once and answer the brand questions. Name, title, brokerage, phone, email, an optional logo, and two brand colors. If you do not know your hex codes, describe the colors and it will pick close ones and confirm them.
Paste the brand profile block it hands back into the top of the skill file. After that it never asks again and every report comes out in your colors.

Running it on a listing that is sitting

The quality of the report depends entirely on the filters, so aim them at homes your listing actually competes with:

Go tight on geography. A zip code or a subdivision beats a whole city. Buyers shopping your listing are not comparing it to a condo twenty minutes away.
Set a custom price band, roughly ten to fifteen percent either side of your list price, instead of using the preset brackets.
Match property subtype, beds and baths, and only add square footage or year built if you still have enough sales left.
Watch the sample size. If the month shows only a handful of pendings or closings, loosen one filter and rerun. The skill will flag a thin sample and note it on the report.
Give it your listing's own numbers. Total showings so far and days on market, straight from your showing service. That turns the report into a direct comparison instead of general market data.

How to use it with your seller

Lead with the showing number, not the price. A few lines that work:

Homes like ours are going under contract after about nine showings. We are at twenty five.
Buyers are seeing the house. They are choosing other homes at this price.
The typical home in our band sold in twenty one days at ninety nine percent of list. We are past that window.
Here is what the market did last month, in one page, so you can see it the way I see it.

The numbers do the arguing, which keeps you on the same side of the table as your seller. Bring the recommendation as a range rather than a single number and let the data carry the case for it.

What it will not do

Worth knowing before you run it, so nothing surprises you in front of a client:

InfoSparks runs about a month behind. The most recent data is the prior calendar month, and the report says so on the page.
It only counts scheduled showings. A showing that never got booked through the system does not appear.
It is not a CMA. It is market context and showing demand, not a line by line comparison of specific homes.
It will not invent a number. If a metric is unavailable, the report prints that instead of filling the gap, which is the whole point of handing it to a client.

Why I build these

I am an Account Executive with Chicago Title of Colorado, and I spend my days with agents across Denver Metro and the Front Range. The agents who win listings are the ones who show up with data and a plan, so I build the tools that make that easier and hand them over with no strings on them. When one of those listings goes under contract, I would like to be the title partner who makes the closing smooth.

Frequently asked questions

Is this skill really free?

Yes. Download it, use it, change it. There is no signup and nothing to buy from me. You do need your own Claude account and your own MLS access, since the data comes from your membership.

Will my name and brokerage be on the report?

Yes, once you answer the brand questions on the first run. Mine never is. The skill is written to carry your branding only, so you can send the report straight to a client.

What is the difference between showings to pending and showings per listing?

Showings to pending counts the showings on listings that went under contract, so it tells you what it took to get an offer. Showings per listing is the average across all active listings in the period, so it tells you how busy the market is overall.

Can I use this outside Colorado?

Usually. The skill points at REcolorado's InfoSparks by default, and many MLSs run the same platform at their own address. Give the skill your MLS stats URL and read the screen, since some associations label the filters a little differently.

How often should I run it?

Monthly is plenty for a listing that is sitting, since the underlying data only updates once a month. Run it again right before a price reduction conversation so you are working from the newest month.

Want the skill?

Download the showing activity report skill here, or comment SHOWINGS on the Reel over on Instagram and it will land in your DMs.

If you have a listing sitting and you want an analysis run on it, or you are looking for marketing ideas to get it in front of the right people, reach out to me.

Want more tools, tactics, and resources like this? Subscribe to my weekly emails at milehightitleguy.com. I share real estate marketing ideas, AI tools, and exclusive invites to upcoming classes and events across Colorado.