Segment open house sign-in sheets for conversion

Sort raw open house attendee notes into targeted buyer tiers with tailored communication angles and fast follow-up timelines.

Prompt

Prompt
Act as a real estate lead conversion specialist. Analyze the raw open house sign-in list and attendee notes I provide to categorize every visitor into actionable sales segments.\n\nRules:\n- Assign each contact to one of four specific categories: Active Unrepresented Buyer, Represented Buyer, Local Curious Neighbor, or Future Move-Up / Relocation Seller.\n- Evaluate buyer urgency, purchase timeline, and specific property objections or likes based on the notes.\n- For each segment, define the exact follow-up channel (call, text, or email), the recommended send window (within 2 hours, 24 hours, or 48 hours), and the specific value offer to send.\n- Never invent missing details; if an attendee's status is unclear, mark them for clarification.\n\nOutput format: A Markdown table with columns Name, Segment, Urgency Level, Recommended Delivery Window, and Tailored Hook, followed by 3 short copy-and-paste follow-up message templates matched to the dominant segments.\n\nHere are the open house attendee notes:

Example output

Example for: sign-in notes from a suburban 4-bedroom open house with 4 visitors\n\n| Name | Segment | Urgency Level | Recommended Delivery Window | Tailored Hook |\n|---|---|---|---|---|\n| David & Sarah Chen | Active Unrepresented Buyer | High (Lease ends in 45 days) | Within 2 hours (Call/Text) | Off-market listing on Oak Avenue with main-floor primary suite |\n| Marcus Vance | Local Curious Neighbor | Low (Lives two doors down) | Within 48 hours (Email) | Neighborhood recent sales summary and estimated impact on local equity |\n| Elena Rostova | Represented Buyer (Agent: Tom W.) | High (Pre-approved, loves yard) | Within 24 hours (Email agent + courtesy CC) | Offer deadline details and disclosure packet link for her agent |\n| Rachel Miller | Unclear / Future Move-Up | Medium (Casually looking, owns condo) | Within 24 hours (Text) | Clarify timeline; offer soft home-valuation estimate on her condo |\n\n### Follow-Up Templates\n\n1. Active Unrepresented Buyer (Text):\n\"Hi David, thanks for stopping by 742 Evergreen today. You mentioned needing a main-floor master bedroom before your lease ends in June. We have a similar home coming up three streets over next week that isn't publicly listed yet. Would you like a sneak peek before it hits the MLS?\"\n\n2. Represented Buyer Courtesy Follow-Up (Email to Buyer Agent):\n\"Hi Tom, your client Elena stopped by our open house at 742 Evergreen today and spent 25 minutes reviewing the backyard and floor plan. She mentioned you are preparing an offer. Sellers are reviewing offers this Tuesday at 5:00 PM. Here is the direct link to the disclosure package and title report for your convenience.\"\n\n3. Neighborhood Homeowner (Email):\n\"Hi Marcus, great meeting you at 742 Evergreen this afternoon. As a neighbor on the block, I wanted to let you know we had 18 groups tour the property today, showing strong buyer demand in our subdivision. I will send you the final sale price once it closes so you can track local property values.\"

Written by AI from this prompt. Your results will vary.

Paste your handwritten or digital open house sign-in notes directly after the prompt in ChatGPT, Claude, or Gemini. As a follow-up, ask the model to draft a text-message cadence for any specific buyer who expressed high purchase intent.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Real Estate
Real Estate

Write a clear seller recap after an open house

Turn rough open house notes into an organized, professional report for home sellers. Keeps clients informed on visitor numbers, direct feedback, and immediate next steps.