Timestamp Architecture

Timestamps are the instrumentation that makes velocity analysis, aging analysis, and cycle time optimization possible. Every stage change, every activity, and every field modification should be timestamped automatically. The pipeline without timestamps is like a factory without sensors — you know what went in and what came out, but you have no idea what happened in between.

1. Stage Change Timestamps Automatically log the exact date and time a deal enters and exits each stage. This creates a complete chronological record of the deal's journey. Time in stage = exit timestamp minus entry timestamp. Aggregate time-in-stage across all deals to find bottleneck stages.
2. Activity Timestamps Log every customer-facing activity — calls, emails, meetings, proposal sends — with timestamps. Activity patterns relative to stage changes reveal what activities actually drive deals forward versus activities that happen but do not influence outcomes.
3. Field Change History Track when key fields change: amount, close date, stage. Amount changes show deal value drift. Close date changes show forecast reliability. Stage changes — especially backward moves — show deals that are regressing. The change history is the deal's story told in data.