Streamlining Content Workflows for a Top Marketing Agency

A boutique content marketing agency was hitting a growth ceiling. They had a roster of talented writers, but the operational drag of content ideation, SEO research, and creating detailed briefs was eating up over 40% of their team’s billable hours.

They wanted to scale to take on more enterprise clients, but hiring more account managers simply to write briefs wasn’t financially viable.

The Challenge

Writers were getting bogged down in the structural setup and spending less time doing what they did best: writing compelling, creative copy.

The Solution

I built a custom internal tool using Retool and Claude 3.5 Sonnet.

graph TD
    A[Keyword Input] --> B(SERP Scraper)
    B -->|Top 10 URLs| C[Headings Extractor]
    B -->|Content| D[NLP Entity Analysis]
    C --> E[Claude 3.5 Sonnet]
    D --> E
    E -->|System Prompt| F[Identify Content Gaps]
    F --> G[Generate Structured Outline]
    G --> H[Export to Google Docs]
    
    style A fill:#f97316,stroke:#ea580c,stroke-width:2px,color:#fff
    style H fill:#10b981,stroke:#059669,stroke-width:2px,color:#fff

Now, when an Account Manager starts a new article, they simply paste the target keyword and the client’s brand voice URL into the tool. The system then automatically:

• Scrapes the top 10 ranking articles for that keyword.
• Identifies missing subtopics and content gaps.
• Generates a comprehensive, SEO-optimized 1,500-word brief.
• Drafts a “shitty first draft” (SFD) that writers can use as a starting block.

The Results

By using AI as an exoskeleton for their creative team, the agency unlocked massive scale.

• 3x Content Velocity: Writers no longer stare at a blank page. They start with a highly-researched framework, tripling their output.
• 15 Hours Saved Weekly: Account managers and writers reclaimed nearly two full days a week previously lost to administrative research.
• 22% Higher Margins: With the ability to service more clients without expanding headcount, the agency’s profit margins surged.

Steal My Workflow

This is the exact prompt running inside their brief generation tool. We use this to instantly extract the gaps in the SERPs before the writer even starts drafting.

<role>
You are an elite, highly technical SEO Content Strategist. Your expertise lies in Reverse-Engineering SERP intent and architecting comprehensive Content Briefs that guarantee page 1 rankings.
</role>

<input_data>
TARGET_KEYWORD: {keyword}
SEARCH_VOLUME: {search_volume}
KD_SCORE: {keyword_difficulty}

COMPETITOR_HEADINGS_DUMP (Top 10 SERP Results):
{competitor_headings_json}

NLP_ENTITIES_EXTRACTED:
{nlp_entities_json}
</input_data>

<analysis_protocol>
1. SERP Intent Analysis: Determine exactly what the user is trying to accomplish (Informational, Navigational, Transactional, or Commercial Investigation).
2. Content Gap Identification: Cross-reference the {competitor_headings_json} to identify missing subtopics. What are the top 10 articles failing to answer?
3. Entity Coverage: Ensure all relevant {nlp_entities_json} are naturally mapped to specific H2s or H3s.
</analysis_protocol>

<output_schema format="markdown">
You must output a highly structured Markdown document with the following exact sections:

# 1. Search Intent & Angle
[Provide a 2-sentence summary of the user's core intent and the unique angle our article must take to stand out.]

# 2. Competitive Content Gaps
[List at least 3 specific gaps/questions that none of the top 10 competitors answered adequately.]

# 3. Recommended Heading Structure
[Provide a deeply nested H2/H3 outline. It MUST be logically structured and encompass the content gaps.]

# 4. NLP Entities & LSI Keywords
[Provide a bulleted list of the top 15 essential semantic terms to include naturally in the body copy.]
</output_schema>