[Placeholder] When you build analytics for an institution that takes evidence seriously — a research consortium, a regulator, a board — the first question after "what does the number say?" is "where did the number come from?" If the only honest answer is "trust me," you've already lost the audit.
Audit-trail-first is the simple discipline of making every output reachable backwards. Click a figure, see the query. Click the query, see the source rows. Click a transformation, see the commit that introduced it. Most projects can adopt the practice in three concrete moves.
Three moves
1. Every figure has a slug
[Placeholder] Slugs aren't for SEO here — they're for accountability. A figure called retention_30d_q3is searchable, comparable across decks, and re-derivable. A figure called "the slide deck I sent Tuesday" is none of those things.
2. Every transformation lives in a repo
[Placeholder] Manual spreadsheet steps are death. If a number depends on a colleague applying a filter at 11pm before sending the deck, you have no audit trail — you have a personal favour. Move the work into a scripted pipeline and the favour becomes a git log.
3. Source-of-truth is a single answer
[Placeholder] If three teams quote three different numbers for the same metric, you don't have a measurement problem — you have a governance problem. Naming the source-of-truth table (and writing it down) is more important than picking the "correct" number.
What this costs
[Placeholder] Audit-trail-first is slower up front. The first month of any engagement loses some "just put a number on the slide" velocity to a database, a job, and a doc. Past month two it pays compounding interest: every subsequent slide is faster and every audit becomes a one-paragraph email instead of a four-week project.
Where to start
[Placeholder] Most teams already have most of the pieces. What's missing is usually the connective tissue — a small "truth" repository, a habit of naming, and the willingness to stop using Excel as the system of record. We can stand the first version up in about two weeks.