After a year of sending emails, your archive holds more value than you realize. This prompt categorizes every broadcast by topic and performance so you can build on your best content instead of starting from scratch every week.
Every founder who has been sending emails for more than six months has an archive problem. Hundreds of broadcasts sitting in Kit, searchable only by subject line or date, with no way to quickly find your best content on a specific topic or identify patterns in what has performed well.
An organized archive is a content strategy. When you can see your full body of work categorized by topic and sorted by performance, you know what you have covered, what is missing, and which areas of your expertise have resonated most with your audience.
This prompt does that categorization work for you in one conversation.
Paste the prompt below into Claude with your Kit connector active. Claude will read your full broadcast history and organize it for you.
Go through my entire Kit broadcast archive. For each email, note the subject line, send date, open rate, and click rate. Then categorize every broadcast into topic buckets based on the subject line and any content you can infer. After categorizing, tell me which topic areas I have covered most frequently, which topics have the highest average open rates, and which topics appear only once or twice and might represent a content gap.
Claude will return your archive organized into themes. You might find you have sent 20 emails about one topic and only three about another that consistently gets higher open rates. That gap is an immediate content opportunity.
The topic categories with the highest average open rates are your audience's priority interests. These should appear in your broadcast calendar more frequently than topics you enjoy writing about but that your audience opens less consistently.
Claude will flag topics that appear infrequently in your archive relative to how relevant they are. These are your planned content areas for the next 90 days. Add them to your editorial calendar before you close this conversation.
Copy the full categorized archive into a Google Doc or Notion table. Every future broadcast you write should be added to this document after it is sent. Over time it becomes the living map of your entire content history.
An organized archive is a strategic asset. Once you know what you have built, what has worked, and what is missing, every writing decision you make is grounded in real evidence instead of guesswork.
Free Download
Your future self will thank you for saving this.
Follow along for the next guide
New free guide every Tuesday. Find them first on Instagram, TikTok, or by subscribing to the email list. Pick your favorite way to stay close.
Want more?
One new free guide. Every Tuesday. No spam, no fluff, just the systems and prompts I'm building for clients, simplified for you.
Subscribe