SGA Status
The rule — Asana is the truth; SGA Status is a fast mirror of it. Never treat Status as a second place to edit canonical work.
SGA Status reads each client's Asana project and renders it as live pages: dashboards, weekly schedules, a cross-client rollup, team to-do lists, and monthly reports. You can edit most fields right in the app — it writes through to Asana and the mirror at once.
The pages and what each is for
| Page | URL | Use it to… |
|---|---|---|
| Clients | / |
See every client |
| Client dashboard | /{client} |
Initiatives, work items, deliverables, review link |
| Plan | /{client}/plan |
The Mon–Fri weekly schedule |
| History | /{client}/history |
Completed work by month, with hours |
| Deliverables | /{client}/deliverables |
Every published asset |
| Report | /report/{client} |
The monthly client report |
| Full View | /full-view |
Cross-client rollup by week |
| Team | /team |
A person's to-do list across all clients |
How the sync works
Asana → database, one way. Reads are database-first (fast, survives an Asana hiccup). The mirror refreshes three ways: a nightly cron (06:00 UTC), a manual "Refresh from Asana" button, and instant dual-write when you edit in the app. Deletions in Asana are reconciled on the next sync.
Permissions
Anyone with a company Google account can sign in and view. Editing (anything that writes to Asana) is gated to sessions whose email matches a real Asana workspace user. Everyone else is read-only.