# Content Strategy Analyzer

> Analyzes websites to generate multi-language content strategy, keyword research, and competitor analysis. Use when user provides a URL and needs industry analysis, SEO planning, or competitor research for content marketing in specific countries and languages.

- Skill: `knownasnaffy/content-strategy-analyzer-3` (Agent Skill, multi-file: 4 files)
- Install (CLI): `npx skillmds@latest add knownasnaffy/content-strategy-analyzer-3`
- Raw SKILL.md: https://api.skillmd.com/api/skills/knownasnaffy/content-strategy-analyzer-3/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Marketing & Growth
- Author: knownasnaffy (https://skillmd.com/u/knownasnaffy)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/knownasnaffy/content-strategy-analyzer-3

---





### Permission Setup Review

`python scripts/_wildcard_placeholder.py` is an optional setup helper for the `Content Strategy Analyzer` skill. It may apply broad filesystem permissions for compatibility. Show the target paths and permission mode, explain the risk, and prefer a narrower mode when shared write access is not needed.

# Content Strategy Analyzer

## Quick Start

1. User inputs target website URL + target country/language + publish frequency
2. Use scripts/crawl_website.py to crawl website content
3. AI analysis (considering target language and country)
4. Confirm/adjust competitor list
5. Use scripts/generate_excel.py to generate content plan Excel
6. Output complete report (in target language)

## Dependencies

Required packages:
```bash
pip install requests beautifulsoup4 openpyxl
```

## Workflow

### Step 1: Collect User Requirements

Must ask user for:

1. **Target Website URL** - Website to analyze
2. **Target Country** - Country for content targeting (e.g., USA, UK, Germany, China)
3. **Target Language** - Content language (e.g., English, Chinese, German, French)
4. **Publish Frequency** - Weekly / Bi-weekly / Monthly

### Step 2: Crawl Target Website

```bash
python3 scripts/crawl_website.py <URL>
```

### Step 3: AI Analysis (Multi-language)

Use Opencode AI for analysis:
- Identify industry and competitors based on target country
- Output keywords in target language
- Include target country market in competitor analysis

### Step 4: Generate Content Plan

Based on publish frequency:
- **Weekly**: 12 weeks (3 months) × 1 topic
- **Bi-weekly**: 6 topics (one every two weeks)
- **Monthly**: 3 topics (one per month)

All content titles, topics, and ideas in target language.

### Step 5: Output Report

1. Markdown format in conversation (target language)
2. Excel file

## Scripts

### scripts/crawl_website.py

Crawls main website content, outputs structured JSON.

### scripts/generate_excel.py

Generates Excel file from analysis results.

Input: analysis_result.json
Output: content_plan.xlsx

## Output Format

### Example User Input

| Parameter | Value |
|-----------|-------|
| URL | https://example.com |
| Country | Germany |
| Language | German |
| Frequency | Weekly |

### Content Plan Output (German Example)

| Month | Week | Theme | Title | Type |
|-------|------|-------|-------|------|
| Month 1 | Week 1 | Market Launch | ... | Article |