Off by more: no file, a DM to meBrowsersnapshotAPI pullread onlyReconcileThu to Wed weekIntegritycheckswithin 1%Weekly reportevery ThursdayLedger entry+ returns fileChecked before anyone reads a number

Systems · 2025 to 2026

Systems that keep marketing running

A weekly report that checks itself, a media library every team can find things in, and an operations hub with one ledger. Built so the team could run on them.

Role
Builder and operator
Scope
Reporting pipeline, media library, operations hub, scheduled routines
Tools
impact.com API, Box, Slack, SharePoint, Claude
Scale
150+ raw shoots and 100+ finished projects in the library
Period
2025 to 2026

The problem

Weekly reporting across creator, affiliate and content programs was eating the time that should have gone into the work being reported on.

The decision

Automate the collection and the hygiene, put integrity checks in front of the numbers, and keep the judgment manual.

Why it works

The integrity checks are the part that matters. A report nobody trusts gets quietly redone by hand, which costs more than not automating it at all.

The machine does collection and consistency. A person does interpretation. That split is why these routines outlived the novelty and became how the team works.

The team map: who signs off, who executes
Signs offCOObudget, brandCMOstrategyCreativeDirectorCross channelcoordinatorAgenciesand creatorsEngineeringfitment checkVideo teamDevelopersPPCCustomerserviceExecutes with
Who owns what. One row per kind of request.
RequestOwnerSigns offWho assists
Sale campaignCreative: banner brief and developer ticketCOO and CMO lock the offerVideo and creative post the assets, developers push the site live, PPC swaps the ads, then blog and email
Creator proposalMe: I assemble itCMO first, then a second approverEngineering checks fitment
Shoot logisticsMe: casting outreach, props, creator schedulingVideo Manager, on anything sent to talentVideo team
Finished videoVideo team: names the file onceWhoever requested itChannel owners, tagged when it lands
FAQ wordingMe: drafted from what customers askCustomer service, three at a time 

The rule behind it: channel lead first, the COO for anything cross channel, budget or brand, the CMO for strategy. No step is complete until the named approver signs. Written by department, never by person.

What is in it

Frame.ioreviewSharePointin progressBox libraryfinalsRawfootageVideoImagePrint3D150+raw shoots100+finished projectsOne home per stage: review, in progress, final

The media library

I designed, categorized and rolled out the company's Box media library for raw footage, video, image, print and 3D. It holds 150+ raw shoots and 100+ finished video projects since 2025 and feeds every campaign. One rule keeps it clean: Frame.io for review, SharePoint for work in progress, Box for finals.

Off by more: no file, a DM to meBrowsersnapshotAPI pullread onlyReconcileThu to Wed weekIntegritycheckswithin 1%Weekly reportevery ThursdayLedger entry+ returns fileChecked before anyone reads a number

The weekly report

A browser snapshot and a read only API pull of the same period, reconciled, then checked before anyone reads a number. Revenue has to match the summed actions within 1%, or no file is written and I get a message. The report is assembled in my voice for the weekly marketing report.

RoutineRoutineRoutineReturnsdrop boxSinglewriterweekdaysOne ledgerOpen workviewArchiveclosed workFrozen IDs. Nothing deleted. The ledger wins.

The operations hub

One ledger, a returns drop box and a rebuilt view of open work on a weekday schedule. Single writer, frozen IDs, nothing deleted. Closed work moves to an archive, and if two views disagree the ledger wins.

OneDriveSharePoint9 projects into 56,860files classified1,003copied, verified0 errors15scheduled taskson new paths

The migration

In November 2026 I moved the marketing working files from OneDrive to SharePoint: 6,860 files classified, 1,003 copied and verified with no errors, fifteen scheduled tasks pointed at new paths, nine channel ledgers, nine projects ported into five.