Tools Reference
Tool Stack Overview
| Tool | Purpose | Account Plan |
|---|---|---|
| SpyFu | Keyword research, competitor analysis, SERP data, CPC | Pro LTD — 10,000 units/month |
| NeuronWriter | Content optimization, term analysis, SERP comparison | Gold plan |
| opencode (DeepSeek) | AI content generation | Built-in, unlimited |
| Website Auditor | Technical SEO audits | Link-Assistant LTD |
| WordPress | Content publishing | Client sites |
| VisiData | CSV pipeline management | Free |
| Google Search Console | Performance tracking | Free |
wp-cli
- Purpose: Automated WordPress post creation from markdown files
- Installation: Installed on GC-SG-M8 server at
/usr/local/bin/wp - PHP: 8.3.30 with LiteSpeed
Key command for publishing:
wp post create \
--post_title="Title" \
--post_content="$(cat article.md | html-converter)" \
--post_status=draft \
--post_category="Category Name" \
--tags_input="tag1, tag2" \
--porcelain
The --porcelain flag returns only the new post ID, which feeds back into the pipeline CSV for tracking.
SpyFu API
- Base URL:
https://api.spyfu.com/apis/{api_group}/v2/{endpoint} - Auth: Basic Auth header or query parameter
- Rate limits: 5–1,000 RPS depending on endpoint
- Credentials: Stored in
.env(gitignored)
Key endpoints:
| Endpoint | CPM | Use Case |
|---|---|---|
getKeywordInformation | $0.20 | Core keyword metrics |
getRelatedKeywords | $2.50 | Semantic keyword expansion |
getQuestionKeywords | $1.00 | FAQ/content ideas |
seo/getTopCompetitors | $0.20 | SEO rivalry analysis |
getSerpAnalysisKeywords | $0.50 | Full SERP grid (1–100) |
warning
API credentials must never be written in documentation. Always reference .env instead.
NeuronWriter API
- Endpoint:
https://app.neuronwriter.com/neuron-api/0.5/writer - Auth:
X-API-KEYheader - Processing: ~60 seconds per query
Key methods:
| Method | Purpose |
|---|---|
/list-projects | List account projects |
/new-query | Create new content analysis |
/get-query | Retrieve recommendations (poll until ready) |
/evaluate-content | Score content without saving |
Website Auditor
Used for technical SEO audits including:
- Site crawl and broken link detection
- Duplicate/missing titles and meta descriptions
- H1/H2 structure analysis
- Thin content identification
- Indexability and canonical checks
- Sitemap and robots.txt validation