The Blog Automation Kit

I am building a local learning center for my real estate business.

About me:
- Name and company: [your name, your company]
- The one place I am starting with: [neighborhood or town, state]
- Who I am writing for: [buyers, sellers, or both]

Do the research for me. Do not ask me for a list of questions.

1. Search the web and find the questions buyers and sellers in [neighborhood or town] are actually asking right now. Use Reddit threads for my metro, local Facebook group posts you can reach, Nextdoor discussions, Quora, Google's People Also Ask results, and recent local news comment sections. Include the awkward ones about price, commission, problems, and whether a neighborhood is any good.
2. Sort every question into Marcus Sheridan's Big 5: Cost, Problems, Comparisons, Reviews, Best.
3. Add five questions people think but are afraid to ask out loud.
4. Rank the full list by how often it comes up and how much it changes a buying or selling decision.
5. Give me the top ten to answer first. For each one, write the title the way a real person types it into Google or asks an AI assistant, and tell me in one line where you saw it being asked.
6. Find my five local news sources and give me the actual links: the business journal, the county planning and zoning page, the school board, new development announcements, and the neighborhood association. For each, tell me in one line what kind of story to watch for.

Mark anything you could not verify as [NEED SOURCE]. Do not invent questions, links, or facts about my market. Plain English a middle schooler could follow. No em dashes.

Optional, and worth it if you have them: [paste any questions you hear from real buyers and sellers, one per line]. Fold these in and rank them above anything you found, and mark which ones are mine.

This is the standing brief for all content you write for me. Follow it every time.

WHO WE ARE
- Company: [name], serving [area] since [year]
- What we do: [residential sales, property management, etc.]
- Approved facts about us: [years in business, number of agents, homes sold, awards, licenses. Only facts you can prove.]
- Where we publish: [website URL], [learning center URL]

WHO THE READER IS (StoryBrand, credit Donald Miller)
- The customer is the hero. We are the guide.
- Their goal: [example: sell without wasting money on the wrong repairs]
- What they are afraid of: [example: overspending, getting a low offer, being embarrassed by their home]
- Our job: explain the choices clearly and help them make a plan. Never make the article about us.

HOW WE ANSWER (They Ask, You Answer, credit Marcus Sheridan)
- Answer the real question in the first two sentences.
- Tell the truth, including drawbacks, uncertainty, and when another option or another company is a better fit.
- Show local evidence: real streets, real recent examples, real numbers with a source and a date.
- End with one useful next step the reader can take today.

VOICE
- Write like I talk: direct, warm, short sentences. [paste 3 short samples of your own writing here]
- No em dashes. No corporate words like "leverage" or "seamless." No hype.
- Use "you" and "your." Use real place names.

RULES
- Never invent a statistic, a school rating, a price, or a date. If you do not have it, write [NEED SOURCE] and I will fill it in.
- Every number gets a source name and a date next to it.
- Link to our existing pages when they help the reader: [paste your 5 to 10 most important URLs]
- Every article names the author and the company, and includes how to reach us.

Using my Brand Brief, write two connected pieces for [neighborhood or town].

PIECE A: A permanent neighborhood guide for [neighborhood]. This is the page we will keep updating for years. Cover what a buyer or seller actually needs: location and commute, home styles and typical price range, schools and services (facts only, with sources), what people love, what people complain about, and who this neighborhood fits and who it does not.

PIECE B: A learning center answer to this exact question: "[paste one question from Prompt 1, for example: What should I fix before selling my home in Midlothian?]"

Before writing, answer these five questions for me in a short list:
1. Who is this for?
2. What decision or worry keeps them up at night?
3. What is the honest answer, including drawbacks and uncertainty?
4. What local evidence or experience supports it?
5. What useful next step can the reader take?

Then write both pieces with this structure:
- Title that matches the way a real person asks the question.
- The direct answer in the first two sentences.
- The reasons why, in plain English.
- Local evidence: mark any fact you cannot verify as [NEED SOURCE].
- A short list of related questions people also ask, with one-paragraph answers to each.
- One next step (for example: a free pre-listing walk-through).
- Author name, company name, and city at the end.
- Suggested internal links between Piece A and Piece B and to my existing pages.

Keep it human. No em dashes. No filler. Do not stuff keywords. Write it so that a person, Google, and an AI assistant can all understand exactly what question this page answers.

Review the draft below before publishing. Be tough. Check every item and report pass or fail with a one-line fix for each fail.

1. Does the title match a question a real person would ask?
2. Is the direct answer in the first two sentences?
3. Is every number, date, school claim, and price tied to a named source and date? List any that are not.
4. Is the geography right? Street names, county, town, ZIP, commute times.
5. Is there real local evidence, or is it generic advice that could be about any town?
6. Does it tell the truth about drawbacks and uncertainty?
7. Is the reader the hero and are we the guide? Flag any paragraph that is mostly about us.
8. Is there one clear next step and a way to contact us?
9. Does it sound like a person wrote it? Flag em dashes, hype words, and repeated phrases.
10. Are internal links pointing to pages that actually exist?

Then list the three biggest risks of publishing this as is.

DRAFT:
[paste draft]

You are running my daily content loop for [neighborhood or market]. Do these steps in order and stop where it says stop.

1. READ: Open our content ledger at [link to a Google Sheet or Notion page]. List what is published, scheduled, and in draft. Never write about a question or story we already covered. If an existing page can be improved instead, say so.
2. RESEARCH: Check today's local sources: [local business journal URL], [county planning page], [school board page], [neighborhood association page], plus the questions agents heard this week: [paste]. Note the date and source of every fact.
3. CHOOSE today's mix from the ledger and the research. Our daily mix is: one local news story that touches real estate, one data piece from authorized sources, two related buyer or seller answers, and two evergreen guide updates. If you cannot fill a slot with a real, sourced piece, leave it empty. Never manufacture neighborhood data from county figures.
4. DRAFT each piece using my Brand Brief and Prompt 3. Connect each piece to its permanent neighborhood guide with internal links. Mark every unverified fact as [NEED SOURCE]. Match one approved photo per piece and confirm the rights.
5. STOP. Send the drafts to [owner name] for review. Do not publish anything on your own. [After the first few weeks, when the owner says so, change this line to: schedule the drafts at 6am, 9am, 11am, 1pm, 3pm, and 7pm Eastern and continue.]
6. AFTER APPROVAL: Publish through [your website editor], with the approved title, photo, links, author, and contact path.
7. VERIFY: Open each live public page. Confirm the title, links, photo, and contact form work.
8. LOG: Record the URL, the question or story it answers, the date, and the sources in the ledger.
9. REPORT: Send a short note: what was published, what is waiting on me, and what broke.

Safety rules: one batch per run. If the same job is already running, stop. If something fails twice, stop and report it. Never invent facts. Never create near-identical pages for different places.

My real estate website is [your website address] and it is built on [AgentFire, Sierra Interactive, Lofty, kvCORE, WordPress, or "I do not know"]. Tell me, step by step and in plain English: 1. Where the blog editor is and how to add and schedule a post. 2. Whether the platform has an API or an RSS import that would let a scheduled Claude job publish approved posts without me pasting them, and exactly what I would need to turn on. 3. How to add utm_source=content to the links in my posts so my CRM can tell content leads from everything else. If you are not sure about my platform, say so and tell me what to look for in my site's admin.

Write my weekly content brief email for the week of [date range]. Read the content ledger at [link] and the run reports from this week.

Send it to [your email, assistant email, or marketing email]. Subject line: "Weekly content brief: [market], [date range]".

Include, in this order, in plain English:
1. The scoreboard: how many pieces published, scheduled, and waiting on review.
2. Every piece published this week as a list: title, live link, the question or local story it answers, the neighborhood guide it links to, and the source and date behind its main fact.
3. Three things I should read closely this week, with the reason (a claim that needs a second look, a page that got attention, a story that is time-sensitive).
4. Anything that broke: failed runs, missing photos, links to pages that do not exist yet, duplicate topics.
5. Next week's plan: the questions and local stories in the queue, and any gaps in the ledger.
6. One reminder of a real conversation to have: a client or contact who would find one of this week's pieces useful, with the piece to send.

Keep it under 600 words. No em dashes. No hype. If a number cannot be verified, say so instead of guessing.

Take this approved article and turn it into four things, all in my voice, no em dashes, no hype:

1. A 60-second vertical video outline in bullet points. Open with the question. Give the direct answer in the first ten seconds.
2. A short social post that answers the question in three sentences and links to the article.
3. A client email I can send before a listing appointment. Two paragraphs. It should make the appointment more useful, not replace it.
4. Three follow-up questions a real customer would ask after reading this, so we can answer them next week.

APPROVED ARTICLE:
[paste article]

Run my monthly scorecard loop for [market]. Read these sources and note the date range you used:
1. Google Search Console: top 50 pages and top 50 queries by impressions and clicks, this month versus last month. [paste export or connect]
2. Bing Webmaster Tools: top pages and queries, same comparison. [paste export or connect]
3. Google Analytics 4: sessions and landing pages where the source is an AI assistant (chatgpt.com, gemini.google.com, perplexity.ai, copilot.microsoft.com, claude.ai), this month versus last month.
4. My CRM: every lead this month with a source of website, search, or AI, and the page it came through if we have it. Also pull signed clients from the last 90 days, not just this month, because a lead takes weeks to close. [paste export or connect]
5. Our content ledger at [link]: what we published this month.

Score every page on four things, measured separately: FOUND (search impressions and clicks), CITED (AI assistant referrals), ASKED (inquiries that mention the page or came through it), HIRED (signed clients traced back to the page, counted over the last 90 days). Show the top ten pages on each. Then show the ten pages that scored zero on all four, counting only pages published more than 30 days ago. A page published last week has not had time to be found, so leave it out and say how many pages you excluded for being too new.

Then write two things, in plain English:
A. A one-page scoreboard: the four totals versus last month, the three pages that moved the most, and the three questions people searched or asked that we have not answered yet.
B. Next month's queue: ten items for the daily loop, each one either a new question to answer, an existing page to refresh, or a neighborhood guide to expand, ranked by which of the four columns it is most likely to move. For each, give the working title, the reason, and the page it should link to.

Add the queue to the ledger at [link] with the status "queued" and the source "scorecard". Send the scoreboard to [email]. No em dashes. If a number cannot be verified, say so. Do not invent any pages, queries, or leads.

Set up three scheduled tasks for my content machine and walk me through anything you need from me.

1. DAILY LOOP: run Prompt 5 from my Blog Automation Kit every weekday at 6:00 am [your time zone]. For the first four weeks it must STOP after drafting and send the drafts to [your email or your assistant's email] for review. Do not publish anything on its own until I change that line.
2. FRIDAY BRIEF: run Prompt 6 every Friday at 8:00 am [your time zone] and email the brief to [your email, assistant, or marketing person].
3. SCORECARD LOOP: run Prompt 8 on the first business day of each month at 8:00 am [your time zone], email me the scoreboard, and add next month's queue to my ledger at [link to your ledger].

For each one, tell me what accounts you need connected (my website, Google Analytics, Google Search Console, Bing Webmaster Tools, my CRM), confirm the schedule back to me, and run each one once now as a test so I can see what the output looks like.

Walk me through verifying [my website] in Google Search Console, step by step, as if I have never opened it. Then show me how to check that my neighborhood guide page ([guide page link]) and my answer page ([answer page link]) are indexed, and how to link the two pages to each other. Plain English. One step at a time. Tell me what I should see on the screen at each step.

Here is my best page: [paste the page text]. Rewrite the opening so the direct answer to the question in the title is in the first two sentences. Cut anything that delays the answer. Keep my voice and every fact. Show me the before and after side by side.

Here is a page from my site: [paste the page text]. Do three things. 1. Add an author line with my name ([name]), my company ([company]), and my city ([city]). 2. Mark every claim that needs a source and a date as [NEED SOURCE]. 3. Find the most generic paragraph, the one that could be about any town, and replace it with a placeholder that tells me exactly what local example to put there.

Walk me through verifying [my website] in Bing Webmaster Tools, step by step, as if I have never opened it. Then show me how to see my top pages there and how to submit any page that is not indexed. Plain English. One step at a time. Tell me what I should see on the screen at each step.