Table of Contents
How the System Tracks Your Content #
The Content Tracker uses three system fields — ItemID, Version, and Active — to maintain clean history, prevent conflicts, and keep your reporting accurate. These fields are managed automatically.
ItemIDs #
Each item receives a permanent ItemID when the row first initializes.
All future versions of that item share the same ID.
ItemIDs allow the system to:
- Group versions together
- Maintain a full timeline
- Prevent duplicate version pairs after pasting
- Link snapshot data and revision history
Do not edit ItemID manually. The system controls it.
Versions #
Every item starts at Version 1.
When you choose Create New Version, the system:
- Archives the current row
- Inserts a new row with the next version
- Updates VersionDate and LastUpdated
- Applies ChangeType if selected
- Logs the update in the Revisions sheet
Manual editing of the Version column is blocked.
Active Status #
Only one version of each ItemID should be active.
Active rows appear in dashboard metrics and snapshot reports.
Active is system-enforced when you:
- Create a new version
- Archive an item
Older versions stay visible in the sheet but are inactive and archived.
