Project 14 / Revenue operations
Live Paid-Media ROI Control Room
Joins lifecycle revenue and normalized paid-media spend through a platform-agnostic attribution warehouse.
01 / Problem
Ad spend, lead sales and refunds sit in separate systems while click identifiers disappear across multi-page or later-visit conversions.
02 / System
Designed as a controlled operational pipeline.
The design persists six click-ID types, ingests Boberdoo-style lifecycle events, normalizes channel spend and exposes last-click, fallback, FX and wasted-spend views.
Latest click identifier selected
Sale and refund economics preserved
New channels added through configuration
03 / Reliability controls
What keeps the system honest.
04 / Verification
Actual n8n webhook
Actual n8n webhook passed lifecycle, replay, fallback, validation and warehouse-outage paths; warehouse and dashboard are implementation-ready specifications.
This is a locally verified engineering demonstration using synthetic data and controlled service adapters. It is not described as a production client deployment unless live evidence is added later.
Inspect the implementation.
Sanitized exports and test artifacts from this demonstration. No credentials or client data are included.
Lifecycle event normalization and warehouse writes.
Open file SQLBigQuery schema and viewsPartitioning, attribution, FX and reporting views.
Open file JSClick-ID persistence tagSix-platform first-party click-ID capture.
Open file JSONChannel configurationConfig-driven paid-media normalization.
Open file MDLooker Studio specificationDashboard pages, controls and performance rules.
Open file JSONMachine-readable executionLifecycle, replay, fallback and outage results.
Open file