Prompt: Analyze My Content Performance

This prompt analyze content performance takes your content data and shows you which topics, formats, and channels produce results so you can do more of what works and stop wasting time on what does not.

The Prompt

You are a content strategist and data analyst. Analyze my content performance.

Here is my content data:

| Title | Type | Platform | Date Published | Views/Impressions | Engagement (likes/comments/shares) | Clicks/CTR | Conversions (if tracked) |
| [paste your data rows] |

Business context:
- Business type: [what you sell]
- Content goal: [e.g., lead generation, brand awareness, SEO traffic, social following]
- Publishing frequency: [how often and on which platforms]
- Time period of this data: [e.g., last 3 months, last 6 months]

Analyze:

1. TOP PERFORMERS:
- Top 5 pieces of content by the metric that matters most to my goal
- What do they have in common? (Topic, format, length, timing, hook style)
- Pattern summary: "Your audience responds best to [X type] content about [Y topic] published on [Z day]"

2. UNDERPERFORMERS:
- Bottom 5 pieces of content
- What do they have in common?
- Are there any underperformers that deserved a second chance (good content, bad timing or distribution)?

3. TOPIC ANALYSIS:
- Which topics consistently get the most engagement?
- Which topics consistently get the most clicks/conversions?
- Topics that get engagement but not conversions (vanity metrics)
- Topics that get conversions but not engagement (hidden gems)

4. FORMAT ANALYSIS:
- Which content formats work best (long-form, short posts, video, carousel, etc.)?
- Best format for each platform

5. TIMING ANALYSIS:
- Best day of week for publishing
- Any monthly or seasonal patterns
- Optimal frequency: is publishing more actually producing more results?

6. CONTENT CALENDAR RECOMMENDATIONS:
Based on this analysis, what should my next 4 weeks of content look like?
- Topics to double down on
- Formats to prioritize
- Topics to stop covering
- One experiment to try based on what the data hints at

Show your reasoning for every conclusion. I want to learn to read my own data.

The Hidden Gems

Section 3's "conversions but not engagement" category is the most underrated insight. Content that nobody likes or comments on but consistently drives people to buy is content you should make more of, not less.

Data Minimums

You need at least 20 pieces of content over at least 60 days for this analysis to be useful. Smaller datasets produce unreliable patterns.

Build These Systems

Ready to implement? These step-by-step tutorials show you exactly how:

• How to Create AI-Powered Drip Campaign Optimizer - Optimize drip campaign timing and content using AI analysis of engagement data.
• How to Automate Case Study Generation with AI - Turn client data and results into polished case studies using AI.
• How to Create Automated Content Performance Reports - Track and report on content performance metrics automatically.