Marketing AnalystSEO and Content AnalyticsAdvancedSingle prompt

Content Calendar Data Strategy AI Prompt

Build a data-driven content calendar strategy for the next quarter. Business goals: {{goals}} Current content performance data: {{performance_data}} Keyword research: {{keyword_... Copy this prompt template, run it in your AI tool, and use related prompts to continue the workflow.

Prompt text
Build a data-driven content calendar strategy for the next quarter.

Business goals: {{goals}}
Current content performance data: {{performance_data}}
Keyword research: {{keyword_data}}
Budget and capacity: {{capacity}} content pieces per month

1. Content audit and baseline:
   - Total content inventory: how many pieces exist?
   - Distribution by type: blog, video, infographic, case study, guide, etc.
   - Performance distribution: top 20% of content drives what % of traffic?
   - Underperformers: content with < 100 organic sessions per month despite 90+ days live

2. Opportunity prioritization matrix:
   Score each content opportunity on:
   - Search volume: how many monthly searches for the target keyword?
   - Keyword difficulty: how competitive is ranking for this keyword?
   - Business relevance: how closely does this keyword relate to our product/service?
   - Content gap: is there a piece already ranking well for this? (Avoid cannibalization)

   Priority score = (Search Volume x Business Relevance) / Keyword Difficulty

3. Content type strategy:
   Based on funnel stage goals:
   - Awareness (top of funnel): educational blog posts, infographics, videos
   - Consideration (middle): comparison guides, case studies, how-tos, webinars
   - Decision (bottom): testimonials, ROI calculators, free trials, demos
   What % of capacity should go to each stage?

4. Content calendar structure:
   - Month 1: focus on top 3 quick-win keyword opportunities
   - Month 2: focus on top 3 competitor gap opportunities
   - Month 3: focus on top 3 brand / thought leadership pieces
   For each piece: keyword target, content type, author, publish date, promotion plan

5. Distribution plan per piece:
   - SEO: internal linking to new content from existing high-traffic pages
   - Email: segment of subscribers most relevant to each topic
   - Social: platform and format most appropriate for each content type
   - Paid amplification: boost pieces with high conversion potential

6. Measurement plan:
   - 30-day: social shares, initial traffic
   - 90-day: organic ranking position, organic traffic
   - 180-day: conversions attributed, backlinks earned

Return: content audit summary, priority scoring table, type strategy, quarterly calendar, distribution plan, and measurement framework.

When to use this prompt

Use case 01

Use it when you want to begin seo and content analytics work without writing the first draft from scratch.

Use case 02

Use it when you want a more consistent structure for AI output across projects or datasets.

Use case 03

Use it when you want prompt-driven work to turn into a reusable notebook or repeatable workflow later.

Use case 04

Use it when you want a clear next step into adjacent prompts in SEO and Content Analytics or the wider Marketing Analyst library.

What the AI should return

The AI should return a structured result that covers the main requested outputs, such as Content audit and baseline:, Total content inventory: how many pieces exist?, Distribution by type: blog, video, infographic, case study, guide, etc.. The final answer should stay clear, actionable, and easy to review inside a seo and content analytics workflow for marketing analyst work.

How to use this prompt

1

Open your data context

Load your dataset, notebook, or working environment so the AI can operate on the actual project context.

2

Copy the prompt text

Use the copy button above and paste the prompt into the AI assistant or prompt input area.

3

Review the output critically

Check whether the result matches your data, assumptions, and desired format before moving on.

4

Chain into the next prompt

Once you have the first result, continue deeper with related prompts in SEO and Content Analytics.

Frequently asked questions

What does the Content Calendar Data Strategy prompt do?+

It gives you a structured seo and content analytics starting point for marketing analyst work and helps you move faster without starting from a blank page.

Who is this prompt for?+

It is designed for marketing analyst workflows and marked as advanced, so it works well as a guided starting point for that level of experience.

What type of prompt is this?+

Content Calendar Data Strategy is a single prompt. You can copy it as-is, adapt it, or use it as one step inside a larger workflow.

Can I use this outside MLJAR Studio?+

Yes. The prompt text works in other AI tools too, but MLJAR Studio is the best fit when you want local execution, visible Python code, and reusable notebooks.

What should I open next?+

Natural next steps from here are Content Performance Analysis, Keyword Opportunity Analysis, SEO Performance Audit.