Skip to content

SEO Weekly Workflow (OYN)

Goal

Every week, produce a decision-ready keyword report focused on ICP discovery and reporting: 1. New long-tail keyword opportunities from GUI deep-research outputs 2. Trend + confidence signals 3. Top quick-win opportunities (high intent + low competition) 4. Updated markdown + CSV exports for content planning

Automated Inputs

The weekly script now combines: - GUI deep-research context: - docs/gui/keyword-channel/gpt5-keyword-channel-deep-research-report.md - docs/gui/keyword-channel/perplexity-OYN Channel Strategy.md - docs/gui/keyword-channel/Grok-keyword-channel.txt - docs/gtm-channel-intent.md - Google Autocomplete (long-tail expansion) - Google Trends (if pytrends is available)

Run Weekly

python3 scripts/weekly-keyword-research.py

Outputs

  • Report: docs/keyword-research-weekly.md
  • Export: docs/keyword-research-weekly.csv

The report now includes: - Executive summary (keywords tracked, clusters ingested, confidence average) - Top 10 quick-win opportunities with rationale - Cluster opportunity snapshot - Trend + confidence overview - Rising/related queries and autocomplete long-tail ideas - Suggested actions for the next content sprint

The CSV now includes: - Cluster metadata (cluster, cluster_competition, intent_tags) - Trend classification + trend confidence - Overall confidence_score - opportunity_score and quick_win_reason - Research long-tail metadata from GUI docs

Weekly Process

  1. Refresh GUI deep-research docs when new keyword/channel research is available.
  2. Run the script to ingest new clusters and regenerate outputs.
  3. Review the Top 10 quick-win section and pick 3 priorities.
  4. Create/refresh content for selected keywords.
  5. Track outcomes and update next week's seed priorities.

The workflow should still complete and generate both files using: - GUI cluster/intent metadata - Autocomplete-derived long-tail signals

In this degraded mode, trend-specific fields may be empty/unknown, but confidence/opportunity scoring still runs from available signals.

Scope Guardrails

  • Scope is ICP keyword discovery + weekly reporting only.
  • No cold outreach implementation in this workflow.