SEO Project Manager | Alcuin Abraham

Client onboarding, task automation, clear SEO operations

Calm SEO workflow built for real delivery.

This preview represents the product layer for a protected FastAPI app that manages SEO clients, stores onboarding details, generates tier-based task plans automatically, and tracks execution status.

Service tiers3

Task categories5

Status states4

What the backend app handles

Protected session auth and SQLite-backed project tracking.

FastAPI + SQLite

Client onboarding Structured intake Company profile, contacts, website, credentials, notes, and deadlines.

Task automation Tier templates Tier 1, Tier 2, and Tier 3 automatically create normalized task sets.

Execution tracking Live status updates Tasks move across Not Started, In Progress, Done, and Blocked.

Growth-ready Multi-page shell Dashboard, clients, and tasks entry points for future deeper views.

Preview canvas

Visual direction for the dashboard experience.

Static preview

Keyword movement

Template categories

Keyword researchCore

On-pageCore

Off-pageScale

TechnicalCore

ExtrasReporting

Priority queue

Example tasks from the real template model.

Baseline keyword set

Identify the primary commercial and branded keyword targets.

Tier 1+

Schema and structured data review

Validate structured data coverage on high-value pages.

Tier 2+

Quarterly roadmap refresh

Re-prioritize based on results, blockers, and business goals.

Tier 3

Notes

Practical implementation choices for this split-repo setup.

UI split

The polished portfolio preview stays here, while the real authenticated workspace runs from the backend repo under /SEO.

Security posture

Session auth protects the app. Credentials are collected because they were required, but should move to encrypted storage in production.

Extensibility

The backend exposes JSON endpoints so the static preview could later evolve into a richer frontend client.