The Analysis Spreadsheet Template

Copy this into Google Sheets:

Post # | Author | Hook Type | Structure | Format | Length | CTA Type | Engagement | Notes
1 | | | | | | | |
2 | | | | | | | |
[...continue to 30]

Bottom section:
Pattern Summary:
- Hook types count:
- Most common structure:
- Preferred formatting:
- CTA that works best:

Key Insights:
1.
2.
3.

Templates to Build:
1.
2.
3.

Claude Code Prompt Library

Basic Analysis

Analyze these 30 LinkedIn posts. Extract hook type, structure, formatting, length, CTA, and voice for each. Output as CSV. Then give me a pattern summary and 5 actionable templates.

Competitive Intelligence

Compare these 30 posts by engagement level (if available). What do the top 10 have that the bottom 10 don't? Give me specific language, patterns, and structural differences.

Voice Study

Study [Creator Name]'s writing voice across these 20 posts. Give me their signature patterns: phrases, sentence structure, formatting choices, and tone shifts. Create a "voice guide" I can reference.

Topic Opportunity Finder

Across these 30 posts, which topics are oversaturated? Which topics appear rarely but drive engagement? Where's the opportunity to stand out?

Language Analysis

Extract phrases that appear in high-engagement posts. Then identify corporate buzzwords or tired phrases that appeared in low-engagement content. Give me a "use this" and "avoid this" list.

Post Template Library

Based on patterns that consistently work:

Template 1: The Contrarian Take

`Most people [common belief]

But here's what [credibility/data] taught me:

[Contrarian insight that challenges the belief]

The truth: → [Specific point 1] → [Specific point 2] → [Specific point 3]

[Discussion prompt question]`

Template 2: The Numbers Story