Editorial notes and applied thinking
Writing on spatial intelligence, measurement design, and the modeling assumptions behind modern analytics workflows.
Temporal interoperability, from a timestamp to the canonical hour-of-week slot
A local wall-clock time a system reported, the IANA zone it was in, the UTC instant it resolves to, the canonical hour-of-week slot (0-167, slot 0 = Monday 00:00 UTC), and the grain a platform actually executed are different objects. This knowledge base documents every conversion between them - DST gaps and folds, sub-hour offsets, broadcast days, dayparts, ISO weeks, and the edge cases that break them. The time analog of the geo-interop KB.
Rebuilding a geo test after the DMA goes away
Convert a market-keyed panel to a grid once, instead of re-keying it every time a platform changes vendors.
Digital advertising still runs on a television map
Television bought a geographic standard and licensed it. Digital, now the majority of ad investment, never built one of its own, so it rents the television map from whichever vendor its platforms subscribe to. This publication opens on a companion paper making that case with its sources, then eight interactive sections walk the alternative on a working metro, covering the grid, the crosswalk in both directions, activation, privacy, boundary drift and measurement.
Geographic interoperability, from source geometry to executable platform geography
The geography a buyer requested, the geometry that was supplied, the canonical H3 representation, the circles or IDs a platform actually executed, and the geography used for reporting are usually five different objects. This knowledge base documents every conversion between them - with containment rules, approximation classes, units, tolerances, and the edge cases that break them.
The canonical spatiotemporal unit
A shared unit of place and time for agentic decisioning and cross-channel measurement.
One coordinate system for every grain: rescaling spatial data with place embeddings
How a 128-dimension place embedding for every 460 m hex block turns grain mismatch into a solved join, and how it projects market-grain search interest down to the block.
Solving the airport problem: beyond the census ring
A breakdown of why ring-based trade area assumptions distort retail modeling and how a building-weighted spatial approach gives cleaner demand estimates.
The stability prior: future of marketing measurement
An argument for more stable measurement frameworks in MMM, with a focus on reducing coefficient volatility in modern modeling workflows.