content-strategy-analyzer

# 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 |