hello, i'm
Adrienne
Vermorel
Turning messy marketing data into something teams can trust — with a lot of help from AI.
what i write about:
latest cuts:
-
First-Touch, Last-Touch, and Linear Attribution in SQL
Build marketing attribution models in BigQuery with practical SQL patterns. Covers first-touch, last-touch, and linear attribution with dbt implementation.
bigquery dbt data modeling analytics -
Marketing Attribution in the Warehouse: A 2026 Guide
Build marketing attribution in your data warehouse with SQL. Covers heuristic models, Markov chains, Shapley values, identity resolution, and dbt patterns.
bigquery dbt ga4 analytics -
Building a Custom Materialization in dbt
Tutorial on building custom dbt materializations in BigQuery: zero-downtime table swaps with row-count validation and automated row-level security policies.
dbt bigquery data engineering data modeling -
Cross-Database Macros: Writing Once, Running Anywhere
Write dbt macros that work across BigQuery, Snowflake, and Databricks using the dispatch pattern. Covers key syntax differences and built-in functions.
dbt bigquery snowflake databricks
about me:
Analytics Engineer at unnest, where I turn messy marketing data into something teams can actually trust. I'm deep into AI-powered automation — my goal is to transfer as much of my know-how as possible to my coding agents and let them do the heavy lifting.
I write about dbt, modern data stack, and the growing overlap between data engineering and AI. I also volunteer my data and marketing skills for a French animal welfare organization, because every skill deserves a side quest.