Use it when you want to begin seo and content analytics work without writing the first draft from scratch.
Content Performance Analysis AI Prompt
Analyze the performance of content assets and identify the content strategy that drives the most business value. Content data: {{content_data}} (URL, traffic, engagement, conver... Copy this prompt template, run it in your AI tool, and use related prompts to continue the workflow.
Analyze the performance of content assets and identify the content strategy that drives the most business value.
Content data: {{content_data}} (URL, traffic, engagement, conversions, publication date, content type)
Business goals: {{goals}} (lead generation, organic traffic, brand awareness)
1. Content performance metrics:
For each content piece:
- Organic sessions (and YoY trend)
- Average time on page
- Bounce rate
- Conversion rate to {{goal_action}} (CTA click, form submit, sign-up)
- Backlinks acquired
- Social shares
2. Content ROI:
- Organic traffic value: (monthly organic sessions) x (CPC equivalent for those keywords)
- Conversion value: conversions x average order value or LTV
- Cost to produce: estimated hours x fully-loaded cost per hour
- Content ROI = (traffic value + conversion value - production cost) / production cost
3. Content categorization analysis:
Group content by type (how-to, comparison, case study, thought leadership, etc.):
- Which content type drives the most traffic?
- Which content type has the highest conversion rate?
- Which content type earns the most backlinks?
- Recommendation: what type to produce more of?
4. Content decay analysis:
- For posts older than 12 months: is traffic growing, stable, or declining?
- High-traffic posts with declining trend: prioritize for refresh
- Low-traffic posts despite strong keyword intent: SEO or content quality issue
5. Content gap analysis:
- Which target keywords have no content?
- Which content pieces rank for keywords outside their intended topic? (Keyword cannibalization risk)
6. Top 10 content pieces to invest in:
- Ranked by: potential traffic uplift if refreshed or expanded
- Each with: current status, recommended action, and expected traffic gain
Return: content performance table, content ROI estimates, type analysis, decay list, gap analysis, and top 10 investment priorities.When to use this prompt
Use it when you want a more consistent structure for AI output across projects or datasets.
Use it when you want prompt-driven work to turn into a reusable notebook or repeatable workflow later.
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 performance metrics:, Organic sessions (and YoY trend), Average time on page. 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
Open your data context
Load your dataset, notebook, or working environment so the AI can operate on the actual project context.
Copy the prompt text
Use the copy button above and paste the prompt into the AI assistant or prompt input area.
Review the output critically
Check whether the result matches your data, assumptions, and desired format before moving on.
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 Performance Analysis 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 intermediate, so it works well as a guided starting point for that level of experience.
What type of prompt is this?+
Content Performance Analysis 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 Calendar Data Strategy, Keyword Opportunity Analysis, SEO Performance Audit.