- Industry
- Education · exam preparation
- Period / scope
- Content database preparation
01
The challenge
- Videos, Shorts and streams sat in one feed, hiding the full history of each topic.
- Paraphrasing easily changed the expert’s language and lost strong examples, stories and phrases.
02
Key decisions
Exact speech lives separately
I keep the original transcript separate from edited copy and new scripts.
A quote stays verifiable while an article or script can still read naturally.
Keep the timestamp with the quote
I link arguments, stories and examples to the original video and timestamp.
The team can find the required idea directly and see its original context.
Results stay inside each format
For comparisons, I record the video format, publication date and date of the analytics export.
Shorts are compared with other Shorts, and long lessons with other long lessons.
03
What changed
The working database links topics, arguments, examples and quotes to original recordings. A writer can return to the context and select material for a new script.
More on the process and review
How the work is organised
- Catalogue
- Transcript
- Source check
- Ideas and examples
- Metric snapshot
- Topic map
- Production queue
How to assess the result
The value of the database is assessed through its use: which material enters scripts and how easily the team finds relevant passages.
What to check next
Track which stories and examples have been used, then update the catalogue after each release.
Working on a similar challenge?
Discuss my project