Track how long projects stay in draft

To track how long projects stay in the draft stage, you can implement a simple yet effective system. Here’s a step-by-step approach tailored for websites, content management, or project tracking environments:

1. Add a Timestamp When a Project Enters Draft Status

Ensure every project receives a timestamp the moment it is marked as “Draft.” This can be done automatically with a field like:

• draft_started_at = current datetime when status changes to “Draft”

2. Update Timestamp Only on First Draft Status

Avoid resetting the draft_started_at if the project toggles between statuses. This ensures you’re tracking the full draft duration.

3. Calculate Duration in Draft

Use the current date minus the draft_started_at date to calculate how long the project has stayed in draft. Example in Python:

python
CopyEdit
from datetime import datetime

draft_started_at = datetime.strptime("2024-04-01", "%Y-%m-%d")
current_time = datetime.now()
days_in_draft = (current_time - draft_started_at).days

print(f"Project has been in draft for {days_in_draft} days.")

4. Display Draft Age in Your Dashboard

Add a column like “Days in Draft” to your project overview or CMS dashboard. This improves visibility and accountability.

5. Set Alerts or Flags

Optionally, trigger alerts or visual flags for drafts older than a specific number of days (e.g., 30 days). For example:

• Yellow flag: 15+ days

• Red flag: 30+ days

6. Export Reports

Generate weekly or monthly reports that show:

• Average time in draft

• Projects exceeding draft duration thresholds

• Projects recently moved out of draft

7. Use Status Transitions Logs (Advanced Option)

Keep a log of all status changes for each project. This allows more advanced metrics, like time between all stages, not just “draft” duration.

json
CopyEdit
[
  {
    "project_id": "123",
    "status_log": [
      {"status": "Draft", "timestamp": "2024-04-01T12:00:00"},
      {"status": "In Review", "timestamp": "2024-04-20T14:00:00"}
    ]
  }
]

From this log, calculate draft duration as the difference between the “Draft” and the next status timestamp.

8. Visualize Draft Duration Trends

Use charts to visualize:

• Weekly average draft time

• Projects with longest draft periods

• Decreasing/increasing trends over time

This system can be implemented in most project management tools, custom databases, or CMS platforms with basic tracking logic. Let me know if you need sample code for a specific stack (e.g., Airtable, Notion, WordPress, Django, etc.).