1. Objective
This SOP defines how a Virtual Assistant (VA) compiles, writes, and sends a monthly or quarterly market update email — so the agent is consistently positioned as the local market expert in their database's inbox.
A market update email does something that a Just Listed email or a Just Sold post cannot: it signals that the agent has expertise, not just listings. The people who receive a well-researched market update — with real data, a clear interpretation, and a personal note — start to see the agent as their trusted market source. When they're ready to buy or sell, that's who they call.
The principle: Market data without interpretation is a press release. Market data with context — "here's what this means for sellers in our neighborhood" — is expertise. The VA pulls the data; the agent adds the interpretation.
Where this SOP starts: The recurring monthly or quarterly build date arrives.
Where this SOP ends: Agent-approved market update email is sent to the confirmed list.Success looks like: The agent's database receives a well-designed, data-accurate market update that sounds like the agent wrote it — on the first of the month, every month, without the agent having to ask for it.
2. Your Role & Boundaries
2a. What you handle independently
- Pulling market statistics from the agent's confirmed data sources
- Compiling the data into the standard market update format
- Writing the draft email content in the agent's brand voice
- Building the email in the agent's confirmed email platform
- Sending the approved email on the confirmed send date
- Logging open rates and click rates monthly
2b. What requires agent approval before acting
- Every market update email before it is sent — the agent reviews for data accuracy and adds the personal perspective section
- Any market interpretation or commentary — the VA presents data, the agent's voice provides context
- The distribution list — agent confirms which segments receive each update
- Any change to the standard data sources — if a data source changes, the agent confirms the new source
2c. What you never do
- You never negotiate on the agent's behalf under any circumstances.
- You never provide pricing, legal, or strategic opinions to any party.
- You never sign or initial any document on behalf of the agent, client, or any party.
- You never communicate directly with the other party's client.
- You never send the market update without agent approval — the agent must confirm the data is accurate.
- You never make specific market predictions or investment recommendations in any email — stick to data and factual interpretation.
- You never characterize a market in ways that could violate Fair Housing (e.g., characterizing neighborhood demographics as part of the market analysis).
Data accuracy is non-negotiable. If you cannot pull a stat from a confirmed source, leave a placeholder and flag it to the agent. An email with a wrong number damages credibility more than a slightly delayed email.
3. Schedule & Trigger
Trigger: Recurring calendar build date.
Monthly market update: Build begins on the 20th of each month for a 1st-of-the-following-month send.
Quarterly market update: Build begins 10 business days before the intended send date — typically the first week of January, April, July, and October.
Confirm frequency with agent during onboarding: Some agents send both — a lighter monthly update and a deeper quarterly one. Others send only one or the other. Build the workflow around what the agent has confirmed.
Sequence context: The market update data also feeds into the monthly newsletter (Monthly Email Newsletter Management) if the agent sends one. Coordinate to avoid pulling the same data twice or creating two emails that overlap significantly.
4. Frequency and Depth
| Frequency | Depth | Primary Purpose |
|---|---|---|
| Monthly | Lighter — key stats, brief interpretation, 200–300 words | Top-of-mind; quick read; maintain consistency |
| Quarterly | Deeper — trend analysis, year-over-year comparisons, 400–600 words | Market authority positioning; more analytical |
If the agent sends both, the monthly update is the quick read. The quarterly is the comprehensive one. They should be clearly differentiated — different subject lines, different visual weight.
5. Data to Gather
Pull all data from the agent's confirmed sources before building the email. Do not estimate or use round numbers — use the actual figures from the source.
Standard data points:
| Metric | This Month / Quarter | Prior Month / Quarter | Same Period Last Year |
|---|---|---|---|
| Active listings count | |||
| Median sale price | |||
| Average days on market | |||
| List-to-sale price ratio | |||
| Months of inventory | |||
| Total homes sold (volume) |
Months of inventory calculation (if not available directly):
Active listings ÷ Homes sold per month = Months of inventory
- Under 3 months = Seller's market (low inventory, high demand)
- 3–6 months = Balanced market
- Over 6 months = Buyer's market (high inventory, lower demand)
Data sources (confirm with agent during onboarding):
| Source | Type |
|---|---|
| Agent's MLS board market report | Most reliable — board publishes monthly |
| Agent's MLS search (agent runs search, VA records results) | Direct and current |
| Altos Research | Automated market data subscription (if agent subscribes) |
| County recorder / assessor data | Secondary source — may lag 30 days |
| Realtor.com / Zillow market trends | Public data — use as a secondary check, not primary source |
Document the source and pull date for every data point. If a number changes after the email is sent and the agent asks where it came from, the VA needs to be able to show exactly where it was pulled.
6. Narrative Layer
The data alone is not the email. The interpretation is what makes it worth reading.
For each key metric, write 1–2 sentences of interpretation — but frame it as data observation, not prediction:
| ✓ Do this | ✗ Not this |
|---|---|
| "Median sale prices are up 6% vs. this time last year, suggesting continued demand in the market." | "Prices are going to keep rising — now is the time to sell." |
| "Homes in this area are spending an average of 14 days on market — significantly faster than the 28-day average we saw last spring." | "The market is hot and this won't last — buyers need to move fast." |
| "Inventory has tightened to 1.8 months, which historically puts pricing pressure on the buyer side." | "It's a terrible time to be a buyer right now." |
The agent's personal perspective section is where the real interpretation goes. The VA builds the data section. The agent adds 2–4 sentences of their own voice:
- What they're seeing in real-time with clients
- What they'd tell a seller vs. a buyer right now
- What this data means for someone thinking about making a move
This section must come from the agent — not from the VA. Leave a clear placeholder: "[Agent Name] — please add your 2–4 sentence perspective on what this data means for buyers and sellers in our market.]"
7. Email Structure
Monthly Market Update
Subject: [City/Area] Market Update — [Month Year]
Hero: [Simple branded header with "Market Update" and the month/year]
Opening line: [One sentence orienting the reader — e.g., "Here's a quick look at how [City] real estate performed in [Month]."]
Key stats section: 3–4 metrics in a clean visual format (simple table or highlighted stat boxes)
- Median sale price: $[X] ([+/-X%] vs. last month)
- Days on market: [X] days (vs. [X] last month)
- Homes sold: [X] (vs. [X] last month)
- Months of inventory: [X] months
[Agent's personal perspective — 2–4 sentences — agent provides]
CTA: "Thinking about what this means for your home? Let's find out together." [Link to contact or home valuation tool]
Footer: Agent name, contact, unsubscribe link
Quarterly Market Update
The quarterly update follows the same structure but with additional sections:
- Year-over-year comparison (not just month-over-month)
- Brief trend narrative (2–3 sentences on the market trajectory over the past 12 months)
- Buyer's take and Seller's take (separate 1-paragraph sections — agent provides or approves)
- Optional: neighborhood spotlight (one specific neighborhood with its own stats)
8. Agent Review Workflow
Build deadline: 20th of the prior month (monthly) or 10 business days before send (quarterly)
Send review to agent:
Hi [Agent Name] — [Month / Quarter] market update draft is ready for your review.
[Link to draft in email platform OR attached PDF preview]
Data sources: [Brief list of where each stat was pulled — e.g., "MLS board report dated [date]"]
Needs your input: [AGENT PERSPECTIVE SECTION] — please add your 2–4 sentences on what this data means for buyers and sellers.
Planned send date: [Date]. Please approve by [Date - 2 days].
[VA Name]
After agent adds their perspective and approves, schedule the email for the confirmed send date.
9. Performance Tracking
Log the following after each send:
| Metric | Monthly | Quarterly |
|---|---|---|
| Send date | ||
| List size at send | ||
| Open rate | ||
| Click rate | ||
| Unsubscribes |
File the performance log in Marketing / Email / Market Update Performance Log.
Quarterly performance summary to agent:
Compile a one-page summary of open and click rate trends over the trailing 3 months. Include whether rates are trending up, down, or flat. This helps the agent make decisions about subject lines, send timing, or content adjustments.
10. List Management
Monthly tasks:
- Add new contacts to the database from the past month (open house sign-ins, new leads, referrals added to CRM — confirm which new contacts should receive this email)
- Honor all unsubscribes — process immediately, never send to an unsubscribed contact
- Log unsubscribes in the CRM with the unsubscribe date
Confirm with agent at onboarding: Does every new contact go on the market update list, or only specific segments?
11. Checklist
Data Gathering
- ☐ All standard data points pulled from confirmed sources
- ☐ Source and pull date documented for every data point
- ☐ Month-over-month and year-over-year comparisons calculated
Building
- ☐ Email built in agent's confirmed platform using approved template
- ☐ Data formatted clearly (table or stat boxes)
- ☐ Agent perspective section placeholder left clearly marked
- ☐ CTA and footer complete
Agent Review
- ☐ Draft sent to agent with source documentation and input request
- ☐ Agent added personal perspective section
- ☐ Agent approved email
- ☐ Final version scheduled for confirmed send date
Post-Send
- ☐ Send confirmed — no delivery errors
- ☐ Performance metrics logged (open rate, click rate, unsubscribes)
- ☐ New contacts added to list from past month
- ☐ Unsubscribes processed
12. Escalation Protocol
Escalate to the agent immediately in any of these situations:
- The monthly market update email is scheduled to send but agent approval has not been returned within 48 hours of the scheduled date
- An unsubscribe spike occurs after a send — flag the rate and the email content to the agent for review
- A contact replies to the market update email with a lead-level response (e.g., "I'm thinking of selling" or "Can we talk about the market?") — route to agent immediately, do not respond
- Market data for a month is unavailable or inconsistent across sources and the email cannot be completed accurately
- The email platform flags the send for a deliverability issue (spam score, domain authentication error) — hold the send and notify agent
Hi [Agent Name] — market update email issue needs your input before the [Date] send.
Issue: [Approval pending / unsubscribe spike / lead response received / data unavailable / deliverability flag]
Send date: [Scheduled date]
Status: [Draft ready / approval pending / hold on delivery issue]
Needed: [Approve draft / respond to lead / resolve data gap / check platform settings]
[VA Name]
If the agent is unreachable: Hold the email send until approval is received — do not send on schedule without it. Route any lead-level reply to the agent's email or messaging channel immediately with the full thread. Document deliverability issues in the email platform log.
13. Tools & Access
| Item | Details |
|---|---|
| Email platform | [Mailchimp / Constant Contact / ActiveCampaign / CRM — confirm during onboarding] |
| MLS market report | [Agent's board market report — confirm monthly release date and access] |
| Data log | [Google Sheet in Marketing / Email folder] |
| Performance log | [Marketing / Email / Market Update Performance Log] |
| Agent's preferred review channel | [For draft submission — email or platform link] |