📄Managing Video Links and Duplicates in the AI Database
This document guides you through how to properly manage, tag, and provide feedback on video links inside the AI Video Tracking Sheet. It ensures all videos are accounted for, checked for duplicates, and ready for upload or transcription if needed.
🧩 How It Works
Inside the tracking sheet, you’ll find several columns:
-
✅ Checkbox Column:
Use this to mark each video as reviewed. Check it once you’ve confirmed the content and reviewed any issues like duplication. -
📝 Notes Column:
Use this to flag duplicates, uncertainties, or questions.
🔁 Handling Duplicates
If two entries appear to be the same video, follow these steps:
-
Compare Titles and Speakers
Look for differences in length, presenter, or version. -
If It's a Duplicate:
-
✅ Mark it in the notes section as:
Duplicate -
🗑 You don’t need to delete anything; the reviewer will handle removals.
-
-
If Unsure:
-
Write:
Duplicate - Not sure which is current -
The reviewer will determine which version to keep.
-
🆕 New or Unmatched Videos
If a link seems new or isn’t in the sheet yet:
-
📥 Upload it to the drive (if needed)
-
✍️ Add it to the sheet in the correct category.
-
🔄 If it needs transcription, flag it in the notes:
Needs transcription
❓ Common Notes to Use
-
Duplicate -
Duplicate - Not sure -
Not uploaded yet -
Needs transcription -
Check speaker/version
🧠 Review Process
The main reviewer will:
-
Check your notes
-
Confirm duplicates
-
Choose the most current version of any repeated videos
-
Handle deletions and upload gaps
✅ Best Practices
-
Always check before marking something a duplicate.
-
Be descriptive in the notes if unsure.
-
Don’t delete rows — just flag them.
-
Use consistent formatting so reviewers can move quickly.
🧵 Related Docs
-
[Video Upload Process Guide]
-
[Transcription Request SOP]
-
[Category Definitions & Examples]