Field Reference
The CSV is the control plane. Markdown is the work product. Fields marked auto are written by SCS; do not hand-edit them unless repairing data.
config/sites.csv
| Field | Owner | Notes |
|---|---|---|
site_id | manual | Lowercase slug; foreign key on every row |
prefix | manual | 2–4 uppercase characters; PID prefix |
domain | manual | Hostname |
name | manual | Display name |
status | manual | active, development, inactive |
focus | manual | Short content focus |
nw_project | manual | NeuronWriter project |
wp_root | manual | WordPress root on the server |
wp_url | manual | Site URL, e.g. http://opshell.dev |
wp_user | manual | System user for WP-CLI |
ssh_host | manual | SSH alias, e.g. GC-SG-M8 |
notes | manual | Free text |
created | auto | ISO date |
<workspace>-keywords.csv
Identity and intake
| Field | Owner | Notes |
|---|---|---|
pid | auto | PREFIX-NNNN; never reuse |
site_id | manual | Site registry foreign key |
title | manual | Working title |
keyword | manual | Primary query; one page per keyword |
created, updated | auto | ISO dates |
source, date_added | manual/auto | Import provenance |
sv, kd, intent, b_cpc, tm_clicks, organic_c, est_ot, device_m, device_d, serp_features | import | Demand metrics |
intent_source, intent_checked, intent_confidence | manual/auto | Intent evidence |
business_value, business_value_reason | manual | 1–5 and rationale |
serp_checked, serp_check_date, serp_content_types, serp_fit, serp_fit_reason | manual | SERP evidence |
source_confidence, source_confidence_notes | manual | Data provenance |
existing_page_action, existing_page_pid, existing_page_notes | manual | create / improve / consolidate / monitor / reject |
Decision
| Field | Owner | Notes |
|---|---|---|
decision | manual | go, hold, no |
decision_reason | manual | Required when decision is set |
decision_factors | manual | competition, knowledge, experience, eeat, business_value, cluster_gap, existing_page, effort |
decided_by, decided_on | manual | Person and ISO date |
Score and lifecycle
| Field | Owner | Notes |
|---|---|---|
n_sv, n_kd, gos | auto | Supporting score |
gos_tier | auto | P1–P4; not a priority verdict |
status | manual | Discovered → … → Tracking / Refresh / Consolidated / Pruned / Rejected |
notes | manual | Free text |
<workspace>-clusters.csv
| Field | Owner | Notes |
|---|---|---|
| shared keys | — | pid, site_id, title, keyword, dates |
sc_strategy | manual | Topical authority / Keyword cluster |
kc_type | manual | Topic, Pillar Page, Keyword Cluster, Sub Topic, Supporting |
topic | manual | SEO subject area |
pillar_pid, parent_pid | manual | Cluster relationships |
funnel | manual | TOFU / MOFU / BOFU |
coverage_status | manual | planned / in_progress / covered / gap / not_needed |
coverage_goal | manual | Whole-number target |
coverage_notes | manual | Scope and gaps |
entity_coverage | manual | Pipe-separated entities |
cluster_priority | manual | P0–P3 |
comp_gap | manual | Competitor gap notes |
notes | manual | Free text |
<workspace>-briefs.csv
| Field | Owner | Notes |
|---|---|---|
| shared keys | — | — |
brief_status | manual | Draft / Review / Approved / Rejected |
brief_depth | auto/manual | full / standard / light |
framework | manual | One of the seowriting frameworks |
content_type | manual | Editorial format |
word_count, tone, author_role | manual | Optional editorial guidance; length should follow scope and evidence, not a quota |
audience | manual | Who the page is for |
hook_angle | manual | Opening promise |
angle_type | manual | fresher data / first-hand experience / niche audience / contrarian / superior depth / better format |
differentiation | manual | One-sentence angle |
information_gain | manual | Original element |
cta, kpi, target | manual | Conversion and success metric |
model, prompt_instructions | manual | Generation notes |
reviewer, due_date | manual | Review owner and deadline |
nw_brief_path | manual | Optional path to the raw NeuronWriter export in research/<pid>/exports/ |
brief_path | auto | Same file as article_path (brief + article) |
article_path | auto | Article Markdown (brief + article in one file) |
notes | manual | Free text |
<workspace>-links.csv
| Field | Owner | Notes |
|---|---|---|
from_pid, to_pid | manual | Source and target pages |
anchor_text | manual | Required |
link_type | manual | hub / pillar / cluster / supporting / cross-cluster |
placement | manual | intro / body / faq / conclusion / sidebar |
status | manual | planned / added / verified / broken |
verified_date | manual | ISO date |
notes | manual | Free text |
created, updated | auto | ISO dates |
<workspace>-publishing.csv
| Field | Owner | Notes |
|---|---|---|
| shared keys | — | — |
wp_category, wp_tag | manual | WordPress taxonomy |
wp_authority_topic | manual | Authority topic path/name |
wp_content_format | manual | content_format taxonomy slug |
wp_status | manual | Draft / Pending / Scheduled / Published / Private |
wp_link | auto/manual | Permalink |
publish_date | manual | ISO date |
wp_post_id | auto | WordPress post ID |
wp_author_id | manual | WordPress user ID |
slug | manual | Post slug |
meta_title, meta_description | manual | SEOPress metadata |
schema_type | manual | Optional schema @type; when set it requires a matching schema_file |
schema_file | manual | Workspace-relative JSON-LD file, e.g. schemas/FS-9001.json; validated before check/publish |
featured_image | manual | Recorded; upload is not automated in the pilot |
qa_status | auto | Snapshot of wpw_review_status (pending = not_reviewed) |
qa_reviewer, qa_date, qa_scope, qa_notes | auto | QA snapshot |
index_status | manual | Indexation note |
notes | manual | Free text |
<workspace>-performance.csv
| Field | Owner | Notes |
|---|---|---|
| shared keys | — | — |
period | manual | YYYY-MM or YYYY-MM / YYYY-MM |
query | import | GSC query; query-level rows only |
url | import | Page URL |
pulled | import | ISO date of the pull |
gsc_clicks, gsc_impressions, gsc_ctr, gsc_position | import | Metrics |
notes | manual | Free text |
note
Blank means unknown or not reviewed. Never invent a metric or a review result.