One record per video

Source With Jordan is Jordan Lewis's brand: real factories, real products, real interviews, all filmed by him. The filming was never the problem. Everything after it was.

A video was a file in a folder and nothing else. The caption lived in a chat. The cover lived somewhere else. The raw cut, the no-captions cut and the posted version were three files in three places.

What that looked like day to day

• You could not search for a video. You scrolled folders.
• A change request was a message, with no record of whether it got done.
• Posted and pending looked exactly the same.
• Nobody could see which posts were still missing a caption, a cover or a date.
• The plan said one thing, Drive said another, the account said a third.

The boring idea

Give every video one record, and hang everything off it: the files, the cuts, the cover, the caption, the status and the date.

Almost every content mess is a missing record. Once a video is a thing, not a file, the rest can hang off it.

Everything I built after that sits on the record. Lineup puts the plan and the media in one view across 300+ posts. Post Studio runs the review on a board, so a change request points at a specific slide instead of living in chat. The sync is two-way, so the planner and the board cannot disagree about what is approved.

Small automations that removed whole chores

• The no-captions cut is found by walking up the Drive folder tree, so clips stay attached to their video.
• When Drive has no usable thumbnail, ffmpeg pulls a real first frame.
• Every post flags what is missing, before posting day instead of on it.
• Every reel is matched to the supplier it was filmed at, and that link is written back to the supplier's record.

What changed

The account went from 700 followers to 117k, and passed 80k inside the first five months. Inbound went from nothing to hundreds of leads a day.

I will not claim a database made the videos good. Jordan did that on the factory floor. What the system did was make sure the team could keep up with him.