Overview
Built a marketing automation system for an agency that generates strategic content calendars. Input business details and goals, get a complete 4-week calendar with article titles, target keywords, competitive insights, and detailed briefs.
The Problem
Content planning was eating into time the agency needed for client work. Keyword research, competitor analysis, checking for duplicate topics, writing briefs, scheduling—all manual, all repetitive, all for every client.
What the System Does
- Takes business inputs: domain, goals, seed keywords, target audience, number of articles needed
- Expands keywords into topic clusters and checks search volumes
- Analyzes the existing sitemap to prevent cannibalization
- Checks what's ranking for each keyword and identifies gaps
- Distributes topics across 4 weeks with difficulty balancing (easier wins first)
- Adjusts for holidays, events, and market-specific considerations
- Generates a brief for each article with title, keywords, audience, required sections, and competitive gaps
Sample Output
Each calendar entry includes:
| Field | Content |
|---|---|
| Publish Date | Strategically scheduled |
| Title | Optimized for target keyword |
| Audience | Who this content is for |
| Keywords | Primary + secondary + long-tail |
| Brief | Sections to include, gaps to exploit, target length |
| Justification | Why this topic, why this timing |
Results
- Content planning reduced to review and approval
- Topic selection based on search demand and competitive gaps
- No cannibalization of existing content
- Consistent research depth applied to every piece
If content planning is a recurring time sink for your team, workflow automation can handle the research and scheduling. Let me know if you want to see how this could work for you.