From spreadsheet reporting to a live growth stack
A DTC brand ran paid across Meta and Google, reported in spreadsheets, and had no idea which channel actually drove repeat purchases. Front-end clicks and back-end conversions lived in different systems, so nothing tied cleanly to revenue.
I designed the event schema, stitched front-end and back-end conversions on a shared transaction ID so attribution held before a user ever identified, and piped everything into a warehouse.
Revenue tied back to the campaigns that drove it, and closed-loop reporting was live in four weeks.