realtor-youtube-system

The Analytics module for the Realtor YouTube System. Reads the agent's real YouTube performance and turns it into plain-English insight — what's working, what's not, and WHY (weak title/thumbnail vs weak hook vs mid- video drop-off) — then feeds Ideation and the Coach. V1 needs ZERO technical setup: the agent exports their analytics CSV from YouTube Studio and uploads/pastes it; Claude parses and diagnoses it. (With the cohort's live data connection, the public layer pulls automatically — no export needed; the CSV stays for private depth. The agent never touches an API key.) Triggers on "how's my channel doing", "analyze my analytics", "how did my last video do", "review my YouTube stats", "here's my YouTube export".

Builds and maintains the agent's Content Dashboard in THEIR OWN Notion — one board for all their content, modeled on Mike Sherrard's real YouTube dashboard, with a YouTube long-form view, a Short-Form view, and a calendar. Seeded with the next ~2 weeks from their actual Game Plan (a rolling window that tops itself up — the full 90-day backlog stays in the plan doc), and then kept alive by the system: when a video gets made, its card fills with the full script, SEO package, lead magnet, and the top-3 proven reference videos — everything in one card. Bring-your-own Notion; never required. Triggers on "build my content board", "set up my board", "content board in notion", "notion board", "notion dashboard", "content dashboard", "put my plan in notion", "update my board", or after the Game Plan when the agent says yes to the board offer.

OPTIONAL Monday Kickoff for the Realtor YouTube System — OFF by default. The core system is fully on-demand (the agent just asks for their next batch of content); this exists only for agents who explicitly want a scheduled Monday message. When enabled, it runs the same Ideation flow (fresh research → ranked ideas with data-backed whys, gaps baked in), pre-builds the

The Coach for the Realtor YouTube System — on-demand only. The agent's YouTube coach, delivering Mike Sherrard's coaching: it reviews their real performance + market context and gives direct, motivating, framework-grounded coaching the way Mike would — names the win and why, the single highest-leverage fix with a specific tactic, and the mindset to keep going. Every point backed by their real numbers, never generic tips. Also runs a full channel audit on demand. Reads Analytics output, the Research Brief, and the AI Brain (goals, cadence, voice). Triggers on "audit my channel", "coach me", "how do I improve", "what should I fix", "review my channel", "I'm not getting views", "should I keep going".

The Consistency Engine for the Realtor YouTube System — solves the real reason most realtor channels die: they quit. Provides batch-day mode (plan one filming day = several ready scripts + the smartest filming order), streak tracking + gentle momentum nudges, and a guided 30/60/90-day ramp so beginners don't drown. Reads the AI Brain (cadence, goal), the Videos folders + channel (what's shipped), and uses Google Calendar for filming/batch days and reminders. Triggers on "plan a batch day", "help me film a batch", "set up my filming day", "keep me consistent", "what's my 30/60/90 plan", "am I on track", "plan my month".

The flagship FIRST deliverable of the Realtor YouTube System — a complete, personalized YouTube Game Plan built on Mike Sherrard's frameworks. It audits the agent's existing channel (scaled to however many videos they have — 100, 10, 2, or none), picks 3 high-intent content pillars for their market, generates exact search-optimized video titles per pillar, reverse-engineers their business goal into a content plan, and lays out a 90-day calendar + success metrics — assembled into one premium Google Doc stamped "Powered by Mike Sherrard Coaching Inc Frameworks." Runs automatically at the end of setup, or on demand. Triggers on "build my game plan", "my youtube game plan", "my youtube strategy", "my channel plan", "map my channel", "what's my youtube plan", "refresh my game plan", "give me my youtube strategy", or right after setup as the first thing the agent receives.

Workflow 1 of 2 — Ideation. The realtor's main entry point, and where everything starts — fully ON-DEMAND, the agent asks whenever they're ready for their next batch of content. It asks how many videos they want, pulls fresh market signals right then, and hands back ready-to-film ideas hyper-specific to their market — a BLEND of broad general/relocation ideas and niche-specific ideas, with coverage gaps automatically baked into the batch — each with a title and a one-line data-backed "why," in the agent's voice (the hook and thumbnail text are prepared behind the scenes and surface in Step 1 of Make This Video). When the agent picks one, it tells them to open a NEW chat for that video (one chat = one video) and run "Make This Video." Triggers on "what should I film", "find my next video", "give me ideas", "give me video ideas", "ideas for this week", "what to make next", "I want to make a video", "help me with my YouTube".

The Lead Engine for the Realtor YouTube System — turns each video into a lead capture. For a video, produces a complete Lead Magnet MAP — a page-by-page content + framework + offer + CTA spec the agent copies into their own design tool (we map; we do not design) — engineered from the avatar's real fear plus that video's topic. Runs inside that video's one chat as part of the video package (one chat = one video). Reads the AI Brain (offer, USP, avatars, CTA, booking link). Saves the "Lead Magnet Map" Google Doc in the video's folder. Triggers on "lead magnet for this video", "map my lead magnet", or "make a lead magnet" ONLY inside a video's chat. (A standalone "build my lead magnet" / "set up my lead capture" with no video in play belongs to the Lead Capture System — Plugin 5 — not here.)

Workflow 2 of 2 — Video Production. Run this in a NEW chat that becomes the video (one chat = one video). Given a chosen idea, it produces everything for that one video — step by step, in the agent's voice, all saved to that video's folder. It locks the packaging (title, hook, 3 thumbnail texts), writes the script, builds the SEO package, maps the lead magnet, and — after the agent films and publishes — repurposes it into shorts, a blog, an email, and social posts. Triggers on "make this video", "produce this video", "let's make the video", "build this video", or when a chosen idea is pasted into a fresh chat.

Monthly Market Report for the Realtor YouTube System — the highest-leverage video most agents never make. Once a month (or on demand) it pulls the agent's LOCAL market data (sourced + dated, never invented), then builds a clean presentation deck the agent simply screen-records (Loom/Zoom) slide by slide — with conversational talking points under every slide. The deck always covers what the numbers mean for three audiences — local buyers, local sellers, and people relocating in — so one recording serves every lead type. Saves the deck + talking points into that month's video folder; the normal pipeline (SEO, lead magnet, repurposing) follows. Triggers on "market report", "monthly market update", "run my market report", "market update video", "build my market presentation", "this month's market update".

Competitor Intelligence for the Realtor YouTube System — two jobs. (1) Outlier scan, weekly at most — watches competitor channels for videos that GENUINELY overperform (more than 2,000 views AND at least 3x the channel's subscriber count, and clearly above that channel's own norm) and reverse-engineers them into stronger, localized versions for the agent. (2) Evergreen competition analysis — maps the agent's market for channels over 2,000 subscribers, compiles their most popular videos that are 2+ years old (proven, durable demand), and helps the agent recreate them better. Reads the AI Brain for market, niche, and named competitors. Triggers on "what's working for competitors", "find outlier videos", "competitor research", "competition analysis", "what's blowing up in my niche", "what should I recreate".

The Repurposing Engine for the Realtor YouTube System — turns one long-form video/script into a full pack of written assets, no editing. From the script it writes short-form scripts (Reels/Shorts/TikTok), a blog post (to rank on Google as well as YouTube — the double-dip), an email newsletter, LinkedIn + Facebook posts, and an Instagram carousel script — all in the agent's voice. Reads the AI Brain. Saves a "Repurposing Pack" Google Doc in the video's folder. Triggers on "repurpose this", "turn this into posts", "blog + email from this video", "repurposing pack", "make shorts from this".

The Research Engine for the Realtor YouTube System. Gathers what's happening in the agent's specific market and niche right now — local real estate market data, local + lifestyle news, and rising search trends — and synthesizes a Research Brief that feeds Ideation and the Coach. Reads the agent's AI Brain for market, communities, niche, price band, and avatars so research is always local and specific, never generic. Runs fresh whenever the agent asks for ideas, or on demand. Triggers on "run my research", "what's happening in my market", "weekly research", "market research", "what's new in [city]", or as a step inside the optional Monday Kickoff when it is enabled.

Script Studio — writes the full video script (long-form, plus a short-form cut) for a chosen idea, in the agent's own voice, teleprompter-ready. Reads the AI Brain for voice, avatars, offer/CTA, and market so the script sounds like the agent and speaks to the right viewer, and pulls the chosen idea's packaging (title + hook) from Ideation. Runs every script through the Compliance Guardrail, then saves it as a clean Google Doc inside that video's folder. Triggers on "write my script", "script this", "script idea

The SEO Engine for the Realtor YouTube System. Makes a video findable on YouTube AND Google. For a chosen idea/script it produces a complete SEO package — title options, a full description with timestamped chapters, tags, hashtags, and a pinned comment — all in the agent's voice with their CTA and links. Reads the AI Brain (market, niche, communities, offer/CTA) and the script. Saves an "SEO Package" Google Doc in that video's folder. Triggers on "SEO for this", "write my description and tags", "SEO package", "optimize this video", or as a hand-off after scripting.

One-time onboarding for the Realtor YouTube System. READS everything from the agent's existing Realtor AI Brain (identity, market, niche, avatars, offer, voice) and only captures what's genuinely YouTube-specific — channel, goals, posting cadence — never re-asking what the AI Brain already knows. Then connects Google, provisions a clean Google Drive workspace (Videos + Setup), and delivers the agent's full YouTube Game Plan (built on Mike Sherrard's frameworks) as their first deliverable — no YouTube connection needed (V1 analytics come from their YouTube Studio export). Use when a real estate agent wants to set up / build / start / onboard their YouTube system or connect their channel. Triggers on "set up my YouTube system", "build my YouTube system", "start my YouTube system", "onboard me", "connect my YouTube channel".

Local-Event Triggers (Newsjacking) for the Realtor YouTube System. Watches the agent's specific market for timely events worth a video while they're hot — interest-rate decisions, new development or community launches, school-ranking changes, major infrastructure, big local news — and turns them into time-sensitive video suggestions flagged "film this week." Reads the AI Brain for communities, niche, and avatars. Checked fresh whenever the agent asks for ideas, or on demand. Triggers on "anything timely to film", "local news angles", "newsjack", "what's happening this week in [city]".