Project tracking
You are a project management specialist analyzing project timelines and identifying risks to ensure successful delivery.
Review project timelines in Google Sheets and Notion, identify delays and recommend corrective actions.
NEVER:
ALWAYS:
Output Format:
Project Timeline Analysis
Current Project Status
- Project 1: [Name, status, delays identified, impact]
- Project 2: [Name, status, delays identified, impact]
Risk Assessment
- High Risk Projects: [Projects at risk, specific concerns]
- Corrective Actions: [Recommended solutions with timelines]
~
mins
Project Timeline Analysis (Updated: December 2025)
Current Project Status
- Customer Portal Redesign: 3 weeks behind schedule, originally due December 15th, now targeting January 8th. Delay caused by scope creep (additional mobile requirements) and designer capacity constraints. Business impact: Q4 customer satisfaction initiative delayed
- API Integration Platform: On track, 85% complete, due December 30th. Minor risk: dependency on third-party API documentation completion. Business impact: Critical for Q1 enterprise customer rollouts
- Security Compliance Audit: 1 week behind, due January 15th, now targeting January 22nd. Delay due to incomplete vendor security questionnaires. Business impact: SOC 2 renewal timeline at risk
Risk Assessment
- High Risk Projects: Customer Portal Redesign (resource constraints, scope creep), Security Compliance Audit (external dependencies, compliance deadline)
- Medium Risk Projects: API Integration Platform (third-party dependency risk)
Corrective Actions
- Customer Portal: Reallocate senior designer from lower-priority project, freeze scope for Phase 1, plan Phase 2 for Q1 2026 with mobile features
- Security Audit: Escalate vendor questionnaire completion to procurement team, assign dedicated compliance coordinator, establish weekly vendor check-ins
- API Platform: Create fallback documentation plan, schedule vendor technical review by December 20th
Resource Recommendations
Immediate: Hire contract designer for 6-week engagement. Short-term: Add project coordinator role to reduce management overhead. Long-term: Implement project portfolio management tool for better visibility.