← Back to Skills Marketplace
419
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install content-strategy-analyzer
Description
Analyzes websites to generate multi-language content strategy, keyword research, and competitor analysis. Use when user provides a URL and needs industry ana...
README (SKILL.md)
Content Strategy Analyzer
Quick Start
- User inputs target website URL + target country/language + publish frequency
- Use scripts/crawl_website.py to crawl website content
- AI analysis (considering target language and country)
- Confirm/adjust competitor list
- Use scripts/generate_excel.py to generate content plan Excel
- Output complete report (in target language)
Dependencies
Required packages:
pip install requests beautifulsoup4 openpyxl
Workflow
Step 1: Collect User Requirements
Must ask user for:
- Target Website URL - Website to analyze
- Target Country - Country for content targeting (e.g., USA, UK, Germany, China)
- Target Language - Content language (e.g., English, Chinese, German, French)
- Publish Frequency - Weekly / Bi-weekly / Monthly
Step 2: Crawl Target Website
python3 scripts/crawl_website.py \x3CURL>
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
- Markdown format in conversation (target language)
- 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 |
Usage Guidance
Before installing or running this skill, consider the following:
- Clarify how the 'AI analysis' step is implemented: does it call an external 'Opencode AI' API? If so, ask the author for the endpoint and which credentials (API key) are required and why. The skill currently does not declare any env vars for that, which is an incoherence.
- Review the two included scripts yourself. They are small and straightforward: crawl_website.py issues an HTTP GET to the target URL and saves a JSON, generate_excel.py reads local JSON and writes an Excel file. There is no hidden network exfiltration in the scripts as provided.
- Note the crawler does not respect robots.txt or perform rate limiting. If you plan to crawl third-party sites, ensure you have permission and run it responsibly (or modify the script to check robots.txt and throttle requests).
- Because the SKILL.md is vague about how keyword and competitor analysis are generated, confirm whether the agent will use your account/model (and any associated billing) or call an external API. If the agent will call an external service, restrict or inspect outbound network access and do not provide secrets until you verify the service.
- If you will run this skill in a shared environment, consider executing it inside a sandbox/container and inspecting network traffic to confirm no unexpected endpoints are contacted.
- If you need the full promised feature (multi-country AI-driven competitor analysis), request that the skill author either include the integration code (with secure credential handling) or update the documentation to explain how the AI analysis step is performed.
Capability Analysis
Type: OpenClaw Skill
Name: content-strategy-analyzer
Version: 1.0.0
The skill is classified as suspicious due to significant vulnerabilities in its scripts. `scripts/crawl_website.py` is vulnerable to Server-Side Request Forgery (SSRF) as it fetches content from an arbitrary user-supplied URL without validation, potentially allowing access to internal network resources. `scripts/generate_excel.py` is vulnerable to path traversal, as it accepts arbitrary file paths for both input and output files via command-line arguments, which could lead to unauthorized reading or writing of files on the system.
Capability Assessment
Purpose & Capability
The skill claims to perform AI analysis using 'Opencode AI' (identify industry/competitors, generate keywords by country/language), but none of the provided code calls any external AI API or mentions endpoints/credentials. The two included Python scripts only crawl the provided URL and generate an Excel from local JSON. Either the SKILL.md overclaims capabilities or it omits the integration code/credential requirements.
Instruction Scope
Runtime instructions are mostly constrained: ask user for URL/country/language/frequency, run crawl_website.py to save website_data.json, then run generate_excel.py to make an Excel. The 'AI analysis' step is vague and unspecified (no prompts, no API calls), giving the agent wide discretion about how to perform the analysis. The crawler does not check robots.txt or rate limiting, and some extraction fields are unimplemented (headings/content_blocks are empty), which are implementation details rather than direct red flags.
Install Mechanism
No install spec is provided (instruction-only), and the declared Python dependencies (requests, beautifulsoup4, openpyxl) are reasonable and proportional to crawling and Excel generation. No remote downloads or execution of external archives are present.
Credentials
The skill declares no required environment variables or credentials, yet the documentation explicitly names an external AI service ('Opencode AI') for analysis. If that service requires an API key or endpoint, the skill should declare and justify those env vars. Currently there's a mismatch between claimed use of an external AI provider and the lack of any credential/config requirements.
Persistence & Privilege
The skill does not request persistent installation, does not set always:true, and does not modify other skills or system-wide settings. It runs local scripts and writes local files (website_data.json, content_plan.xlsx) only, which is expected for its purpose.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install content-strategy-analyzer - After installation, invoke the skill by name or use
/content-strategy-analyzer - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release - multi-language content strategy analyzer
Metadata
Frequently Asked Questions
What is 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 ana... It is an AI Agent Skill for Claude Code / OpenClaw, with 419 downloads so far.
How do I install Content Strategy Analyzer?
Run "/install content-strategy-analyzer" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Content Strategy Analyzer free?
Yes, Content Strategy Analyzer is completely free (open-source). You can download, install and use it at no cost.
Which platforms does Content Strategy Analyzer support?
Content Strategy Analyzer is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Content Strategy Analyzer?
It is built and maintained by yanzt (@yanzt); the current version is v1.0.0.
More Skills