Studio notes · the working documents behind two deliverables

Data QC and brand film production, in full

The two documents clients ask to see after the summary: a complete data-cleaning log from a 500-row delivery survey, and the production paper trail of the 34-second brand spot.

Data QC log: 500-row delivery survey, cleaned to delivery standard

Data QC log: 500-row delivery survey, cleaned to delivery standard

Checks run, in order. (1) Schema and type validation. (2) Exact duplicate detection. (3) Fuzzy duplicates on normalised phone and address. (4) Missing values against a per-field policy: order date, phone and amount are critical, notes are not. (5) Range checks: no dates after the reporting period, positive amounts, quantities within fleet capacity. (6) Controlled-vocabulary normalisation of state names and product SKUs. (7) Unit consistency between kilograms and bags. (8) Cross-field logic: dispatch date not earlier than order date.

Findings and actions.

  • 500 rows received; 14 exact duplicates removed, leaving 486.
  • 3 near-duplicates confirmed by phone (the same order logged by two agents) removed, leaving 483.
  • 9 rows missing phone numbers recovered from paper dispatch slips; critical-field missing count now 0.
  • 2 orders dated after the reporting period (year typed as 2026 against a 2025 order book) corrected against dispatch slips.
  • 41 free-text state spellings normalised to the 36-state plus FCT vocabulary.
  • 6 rows with kilograms entered in the bag field converted at 25 kg per bag (declared conversion) and flagged for the source team.
  • 3 rows unrecoverable (no slip, no reachable caller) dropped with reason codes, leaving 480.

Result. 480 clean rows delivered with a per-row provenance flag. Post-fix counts: duplicates 0, critical missing 0, out-of-range 0, off-vocabulary 0, unit conflicts 0. Every count in this log is reproducible from the check scripts; the log ships with the data.

Brand film: storyboard, voice script and production notes

Storyboard, cut to the voice

0:00 to 0:05Mark reveal: the sprout and wordmark standing on the open field, tagline tracking in. Voice: “Oasis. Writing, research and design under one brand.”
0:05 to 0:11Three kinetic claims with gold rules. Voice: “Words that sell. Research that holds up. Design that carries the brand.”
0:11 to 0:14The two book covers sweep in from the edges of frame, tilted like held books, under a gold 2+ stamp. Voice: “Over two books produced end to end.”
0:14 to 0:18Book pages flash behind the word counter as it climbs to 94,800+, with 300+ endnotes and the source ledger named. Voice: “Over ninety-four thousand words, and over three hundred endnotes.”
0:18 to 0:21Nine work samples fan across the frame in a grand arc, numbered and titled, under a gold 9+ stamp. Voice: “Over nine work samples you can open today.”
0:21 to 0:26Eight service chips pop in sequence. Voice: “Editing, proposals, data and AI training, and farm-side knowledge.”
0:26 to 0:30The offer, two lines. Voice: “Send one real task. It comes back within forty-eight hours.”
0:30 to 0:34End card: the full logo standing on the open field, site address, byline. Voice: “Oasis. Work you can verify.”

Voice script, as recorded

Oasis. Writing, research and design under one brand. Words that sell. Research that holds up. Design that carries the brand. Over two books produced end to end. Over ninety-four thousand words, and over three hundred endnotes. Over nine work samples you can open today. Editing, proposals, data and AI training, and farm-side knowledge. Send one real task. It comes back within forty-eight hours. Oasis. Work you can verify.

Production notes

1920 × 1080 at 30 fps, 1,020 frames, H.264 video with stereo AAC audio, 34.0 seconds, about 7.2 MB, every frame drawn at double size and downsampled for clean edges. Every frame is drawn programmatically from the brand assets: the cropped monogram and logo, the indigo and gold sampled from the logo file itself. The mark and the wordmark stand directly on the field: no disc, no panel, no dedicated background anywhere. Scene changes are cut to the pauses of the recorded voice, with four-tenths-second crossfades, a soft vignette, a gold frame line and a slow push-in on every scene. The narration is a British-English studio voice, recorded dry and cut scene by scene to its own pauses. Under it runs an original underscore composed for this cut: a low string pad that swells scene by scene over a sub drone, a sparse felt-piano motif, and a soft boom marking every scene change. The score ducks beneath the narration whenever he speaks and breathes up in his pauses, sitting below the voice throughout. Voice and score were muxed after picture lock, the way a real spot is finished. The published master carries the author's own final pass over picture and mix.

The finished cut plays on the main page.