Content Audit Process

Home / Content Processes / Content Audit Process

Last Edited: 2026-06-29 01:32

PRIORITY: Intent defines execution. Automation cannot begin until manual suggestions are locked.
SCRIPT SAFETY: Scripts must NOT be run under the OA PagePilot account. Use a separate, dedicated Google profile.

PROCESS MAP

Trigger: The Startup Coordinator initiates the Content Audit task.
Owner: Startup Coordinator → SEO Specialist
Entry Criteria:
- Customer Hub access granted.
- Client website live and accessible for auditing.

Owner: Content Auditor
Required Inputs:
- List of existing website pages and records.
Required Outputs:
- Manual review of each existing page for quality, SEO value, and overlap.
- Selection of Suggestion (Keep, Revamp, OA Content, Merge, Redirect, Remove) for every row.
- Field Logic Compliance: Supporting fields (OA Friendly, Merge/Redirect, OA Primary, Set New Primary URL) must be populated according to the Audit Sheet Field Logic rules.
- Primary record selection completed (ensuring only one Primary per related group).

➡️ Intent must be fully defined before automation steps can begin.

Owner: SEO Specialist
Required Inputs:
- Completed manual audit intent (Gate 1).
Required Outputs:
- Records script run (1st button) to stage Table 1.
- Live website records (Friendly URL CSV) pulled from the client site.
- Records pasted into Table 2.
- Comparison script run (2nd button) to identify PID status and Hub issues.

Owner: SEO Specialist
Required Outputs:
- Missing service page settings enabled in Customer Hub.
- "Use Service Content Pages" check box verified as checked.
- Friendly URL CSV re-downloaded and Table 2 updated with newly generated PIDs.
- Comparison script re-run until the "Customer Hub missing" section is empty.

➡️ All required service pages must have PIDs before moving to PID population.

Owner: SEO Specialist
Required Outputs:
- Missing PIDs Input populated for all applicable rows (Service, New, or Base types).
- "Apply Missing PIDs" script run (after Column U is populated).
- PIDs pushed to Output Records and all matching (301) records updated automatically.

Owner: SEO Specialist
Required Inputs:
- Reconciled records from Gate 4.
Required Outputs:
- The validation script runs automatically during a download attempt.
- Constraint Check: Each PID must have exactly one Primary record.
- Final CSV downloaded successfully (all affected rows marked "Yes" in Downloaded field).

➡️ Validation fails and download is blocked if multiple Primary records share a PID.

Owner: SEO Specialist → Design Coordinator
Required Outputs:
- CSV uploaded into the Friendly URL tool.
- Task assigned back to the Design Coordinator for implementation.
- Completion Checklist verified:
  - Audit completed.
  - Records reconciled.
  - Customer Hub missing section empty.
  - CSV uploaded to Friendly URL tool.

➡️ Process complete.

The following rules govern how the audit spreadsheet columns must be populated based on the Suggestion selected:

Suggestion (A)	OA Friendly (D)	Merge/Redirect (E)	Comments (F)	OA Primary (G)	Set New Primary URL (H)
OA Content	Required	-	Optional	Optional (req. D; H blank)	Optional (G must be off)
Keep	Optional	-	Optional	Optional (req. D; H blank)	Optional (G must be off)
Revamp	Optional	-	Required	Optional (req. D; H blank)	Optional (G must be off)
Merge	-	Required (No OA Content)	Required	-	-
Redirect	-	Required	Required	-	-
Remove	-	-	Required	-	-

OA Primary (G): Requires OA Friendly (D) to be populated; Set New Primary URL (H) must be blank.
Set New Primary URL (H): Only available if OA Primary (G) is turned off.