PREVIEW
ahcdi.net — Centralized Keyword Mining & pSEO Engine
Domain: ahcdi.net
Role: Centralized hub for harvesting search intent (Google Autocomplete), real-time trends (Google Trends), and social signals (Twitter/X) to power programmatic SEO across all Ucok AI Server projects.
🏗️ Architecture (Hetzner Local)
- Database: SQLite (
/home/ucok/web/ahcdi.net/data/mining.db)
- Language: Python 3.12 (using
/home/ucok/pro/ai-env)
- Scrapers:
harvester_google.py: Fetches Google Autocomplete suggestions for project seeds.harvester_trends.py: Fetches Google Trends (ID) using pytrends or direct scraping.harvester_twitter.py: Fetches Twitter Trending Topics (ID) via scraper/API.
- API/Feed: Internal JSON endpoints or shared CSV files for other workers/apps.
🎯 Target Projects & Seeds
| Project |
Target Topics |
Current Seeds |
| belumkerja.com |
Careers, Jobs, Salary, Interview tips |
"lowongan kerja", "gaji di", "cara melamar" |
| beasiswa.net |
Scholarships, University, Education |
"beasiswa s1", "kuliah gratis", "daftar kampus" |
| dokterdewa.com |
Health, Medicine, Wellness, Doctors |
"gejala penyakit", "dokter terbaik", "cara mengobati" |
| madahbakti.org |
Liturgy, Hymns, Church music |
"teks lagu mb", "not angka madah bakti" |
| lifetimecares.org |
Healthcare, Elder care, Home care |
"perawat lansia", "home care jakarta" |
🚀 Execution Plan
- Phase 1: Setup Infrastructure
- Create
data/ and scripts/ directories.
- Initialize SQLite schema for
keywords, trends, and trending_topics.
- Phase 2: Google Autocomplete Harvester
- Implement rotation logic for project seeds.
- Store results with intent classification (how-to, salary, etc.).
- Phase 3: Trends Harvester (Google & Twitter)
- Daily/Hourly cron to capture what's hot in Indonesia.
- Phase 4: Distribution
- Create a simple dashboard or API to expose keywords to other projects.
⚙ HARD CONSTRAINTS (enforced for all sites)
This domain MUST operate within these constraints — no exceptions:
- 100% Cloudflare serverless — Workers + D1 + R2 + KV + Workers AI + Vectorize. NEVER PM2, NEVER VPS, NEVER Docker in production path.
- 100% AI-automated — every customer interaction, every moderation decision, every transaction reconcile = AI. No manual queue, no live human chat support, no physical fulfillment.
- 1-operator solo — one person can run the entire operation from a phone. No team meetings, no shared inbox, no shift rotation.
- WhatsApp AI bot for all support (24/7, instant response, no SLA promises that need humans).
- Mayar QRIS for all Indonesian payments (subscription auto-renew, no manual invoicing).
- Indonesian UI primary — bahasa-first, English fallback only where unavoidable.
- Privacy — opt-in only, delete-on-request honored within 24h (cron-driven).
- No physical goods, no inventory — digital products + affiliate referrals only.
If the plan above describes any flow that violates these constraints, treat the plan as ASPIRATIONAL only and rework before building. The constraint trifecta wins.