ListingCaption Β· Biz Dashboard
Last update: β€”
🌐 Public landing page β†— ← Sophia Life System
🌐 Website
Demo mode β€” Year 2 success snapshot. Toggle to Live for real data once Stripe + waitlist are wired.
MRR ?
$8,265/mo
+12.4% MoM Β· annual recurring
Paid users ?
241active
218 Pro Β· 23 Agency
Free trials ?
684active
28 hit cap this week
Waitlist ?
1,247total
+47 last 7 days
Churn ?
4.2%/mo
below 5% target
LTV/CAC ?
5.8x
LTV $691 Β· CAC $119
πŸš€ Build Progress 1 of 10 increments shipped ?
Phase 0 blocked on RAASCORE LLC + Mercury + Stripe activation. Same chain blocking Mind Over Money. Unblock one, unblock both.
πŸ“Š Today's Action β€” pulled from Paperclip dev_tasks ?
4
Buy listingcaption.io domain β€” Phase 1 Foundation
prereq: ~$40/yr Namecheap account funds. Use namecheap-domain-buyer skill. NOT blocked. Ready for Sophia dispatch.
πŸ› οΈ All Dev Tasks β€” Β· 7 Phases ?
#PhaseTitleStatusNotes
πŸ“£ LinkedIn Outreach Funnel last 30 days ?
Compounding monthly until target territory exhausted, then rotate states.
🎯 Target Markets USA only ?
StateAgentsStatusTrialsPaidMRR
Florida~220KActive31294$2,840
California~440KActive24168$2,114
Texas~180KActive18752$1,651
New York~210KQueued8819$721
Georgia~50KQueued368$311
National (rest)~600KPhase 7β€”β€”β€”
Active prospects ?
3,142
across all 3 channels
Sent (7d) ?
487
+12% vs prior 7d
Reply rate ?
9.4%
target β‰₯7%
Trials β†’ Paid (30d) ?
38
$1,102 new MRR
πŸ“° HARO β€” Help A Reporter Out journalist queries β†’ backlinks + PR ?
Queries scanned (24h)
214
across 8 categories
Matched (24h)
11
~5% match rate
Pitches sent (7d)
23
9 pending Matt review
Published (30d)
4
17% pitch→pub rate
Today's matched queries
OutletQueryMatch angleStatus
Inman"How are agents using AI tools daily?"Direct fit β€” caption time savingsDrafted
HousingWire"AI tools changing real estate marketing"Direct fit β€” case study angleDrafted
The Close"What tech do top-producing agents use?"Strong fit β€” productivity toolsPending
RISMedia"Time-saving hacks for listing agents"Direct fit β€” testimonial-readyPending
Sophia scans HARO 3x/day at 05:35, 12:35, 17:35 ET. Drafted pitches sit in lc_haro_pitches. Hit Send ⚑ to push to journalist inbox via Mailgun.
βœ‰οΈ Cold Email β€” direct outreach to brokerages via Mailgun ?
Total list
1,840
FL Β· CA Β· TX brokerages
Sent (7d)
214
~30/day Β· safe pace
Open rate
38.4%
subject lines working
Reply rate
7.1%
15 trials so far
3-step sequence
DaySubjectGoalSentOpenReply
1{first_name}, quick question about your listingsHook + free trial offer21438%7.1%
4Re: your listings β€” saw you have {recent_count} activeSpecificity + soft nudge14142%5.2%
9Closing the loop {first_name}Last-chance + breakup8835%9.0%
Sender domain: listingcaption.io Β· SPF βœ“ Β· DKIM βœ“ Β· DMARC βœ“
πŸ’Ό LinkedIn β€” direct DM to agents Phantombuster + Instantly.ai ?
Scraped (7d)
348
Phantombuster, ~50/day
Connects sent (7d)
347
at LinkedIn safe cap
Accept rate
36.2%
126 accepts
Reply rate
27.0%
34 conversations
3-step DM sequence
DayStepMessage previewSentReply
1Connect + opener"Fellow {city} agent here. Built a Chrome tool that turns listings into IG/FB/email captions in 3 seconds…"347β€”
3Follow-up"Hey {first_name}, the free access slots are filling up β€” we've had 30+ {city}-area agents sign up…"12622%
7Final touch"No worries if not the right time. I'll leave the link here in case you ever want to check it out: …"9811%
Active campaigns by state
StateCampaignStatusSentRepliesTrials
FloridaFL Real Estate Agents β€” Listing CaptionsActive142149
CaliforniaCA Real Estate Agents β€” Listing CaptionsActive118117
TexasTX Real Estate Agents β€” Listing CaptionsActive8796
New YorkNY Real Estate Agents β€” Listing CaptionsQueuedβ€”β€”β€”
GeorgiaGA Real Estate Agents β€” Listing CaptionsQueuedβ€”β€”β€”
Hard cap: 50 connects/day Β· Phantombuster $56/mo Β· Instantly.ai $37/mo
πŸ“Š Combined Reachout Funnel last 30 days, all channels ?
2,160
Prospects contacted
πŸ“° 23 Β· βœ‰οΈ 443 Β· πŸ’Ό 1,694
187
Replies / accepts
8.6% of prior
94
Conversations
50% of prior
52
Trial signups
55% of prior
14
Paid conversions
27% of prior
Blended CAC across reachout = $116. Healthy vs $691 LTV (5.95x). LinkedIn = highest volume, email = highest conversion %, HARO = highest LTV per signup (brokerage-tier accounts).
βš™οΈ Reachout Routing Rules how Sophia decides who to contact when ?
Prospect typePrimary channelFallbackDaily capSequence
Solo agent (LinkedIn-active)πŸ’Ό LinkedIn DMβœ‰οΈ Email if no profile50/day total3-step over 7 days
Brokerage ownerβœ‰οΈ Cold EmailπŸ’Ό LinkedIn DM30/day per inbox3-step over 14 days
Top-100 producer (per state)πŸ“° HARO mention + βœ‰οΈ personal emailβ€”5/week, hand-curated1-touch personal
Real estate journalistπŸ“° HARO query responseβœ‰οΈ Cold pitch3 pitches/daySingle response
RE training companyβœ‰οΈ Partnership emailβ€”2/weekCustom partnership pitch
πŸ’° 5-Year Revenue Projection realistic, single-figure ?
YearPaid users (EOY)EOY MRR /mo (peak)Avg MRR /mo (linear ramp)Annual revenue /yrCumulative
Year 195$2,755$1,378$16,530$16,530
Year 2340$9,860$6,308$75,690$92,220
Year 3720$20,880$15,370$184,440$276,660
Year 41,180$34,220$27,550$330,600$607,260
Year 51,580$45,820$40,020$480,240$1,087,500
Y5 peak $45,820/mo
How the math works. Each year ramps linearly from prior-EOY user count to new EOY count. Annual revenue = (start MRR + end MRR) Γ· 2 Γ— 12, NOT EOY Γ— 12 β€” that would treat year-end peak as if stable for all 12 months and overstate by 14–100%/yr.

5-yr cumulative ~$1.09M realistic. Y5 peak monthly run-rate ~$45,820/mo. Excludes any expansion to mortgage brokers, insurance brokers, or property managers (each ~1.5x multiplier opportunity). Excludes Agency-tier ($79/mo) revenue mix β€” current model assumes 100% Pro at $29/mo as conservative floor.
πŸ’Έ Operating Costs monthly run-rate at Y3 scale ?
ItemProviderCost/mo
OpenAI (gpt-4o-mini)OpenAI$58
Cloudflare WorkersCloudflare$5
Supabase ProSupabase$25
PhantombusterPhantombuster$56
Instantly.aiInstantly$37
MailgunMailgun$15
Stripe fees (~3%)Stripe$626
Domain + nginxNamecheap + VPS$4
Total Y3 OpEx$826/mo
Net margin at Y396.0%
πŸ›οΈ Polsia 13-Pillar Architecture ?

1. Niche Selection

US real estate agents. Validated. ~1.5M TAM.

2. Product Build

Chrome Manifest V3 + OpenAI gpt-4o-mini. Self-improving prompts via brand voice templates.

3. Pricing

Free 5/mo Β· Pro $29/mo Β· Agency $79/mo. Anchored against Canva ($150/yr) + CRM tools ($100+/mo).

4. Distribution

Chrome Web Store (organic) + LinkedIn outreach (Phantombuster + Instantly.ai).

5. Acquisition

3-step DM sequence. 50 connects/day cap. Compound across FL/CA/TX/NY/GA.

6. Conversion

Free→Pro at 25% (post-cap-hit). Stripe Customer Portal for self-serve cancel.

7. Retention

Daily-use product. Stickiness comes from brand voice templates (Pro). Target churn under 5%/mo.

8. Expansion

Solo Pro β†’ Agency. Brokerage seat-based pricing. Free agency-tier upgrade for first 10 users.

9. Operations

Cloudflare Worker (zero ops). Supabase (managed). All cron via VPS scheduled tasks.

10. Support

Tier-1 by Sophia agent. Tier-2 by Matt. Email-only at first; Intercom at $5K+ MRR.

11. Analytics

This dashboard. Cohort tracking. CAC by source state. LTV by tier.

12. Compliance

Form 5472 (foreign-owned LLC). Privacy policy on listingcaption.io/privacy. No PII storage.

13. Self-Improvement

ml-feedback-loop wired in Phase 7. Caption A/B testing. Auto-retire low-performing prompts.

πŸ”‘ API Keys stored in OpenClaw secrets, never in DB or HTML ?
Keys are read-only on this dashboard. To rotate, use the api-key-setup skill or edit OpenClaw secrets directly.
πŸ“„ Ogilvy Landing Page Copy ?
Open live landing page β†’
πŸ“˜ Driver's Guide how the build self-driver works ?

What it does: Every day at 11:00 BKK, the scheduled task picks the lowest sequence_order pending dev_task where product='ListingCaption' and status='pending'. It dispatches that task to Sophia (or matt-tagged tasks back to Matt's Telegram).

What it skips: Tasks with status='blocked' stay parked until the blocker is resolved (life_state SSOT auto-flips them when LLC/Mercury/Stripe land).

What it logs: Each run writes to claude_memory_log + updates the increment in listingcaption-productise-state.json.

How to override: Edit /var/www/listingcaption-productise-state.json directly, or add a row to act_requests with source='listingcaption-biz-dash'.

πŸ“• User Manual end-customer help (real estate agents) ?

Step 1. Click the ListingCaption icon in your Chrome toolbar. Pin it to make it always visible.

Step 2. Open any listing page β€” Zillow, Realtor.com, your CRM, anywhere the description is selectable text. Highlight the description text.

Step 3. Click the icon. Pick Instagram, Facebook, or email. Captions generate in 3 seconds.

Step 4. Copy. Paste. Post. You never left the page.

Need a different tone? Pro and Agency tiers can save 3 sample posts to teach the AI your voice.