Infrastructure
LinkedIn Ads ➡️ Snowflake, with 3-legged OAuth in the middle
LinkedIn's Marketing API needs a browser to authorize. Scheduled pipelines don't have browsers. I store the refresh token in Snowflake.
Digital Analytics
Posts related to tracking and the measurement of digital behavior
Digital Analytics
My GTM container had 282 undocumented objects
I gave an agent a dependency graph to make it write notes on my GTM containers
Digital Analytics
A simple first-party tracking approach
Own your data: A simple, almost-free first‑party tracking stack
Digital Analytics
Access Log Data Model
How to make sense and use of server-side tracking logs from a webserver
Digital Analytics
Conversions without cookies
How to track conversions from Google Ads and Meta without any cookies
Digital Analytics
Multi-Input Lookup Variable in GTM
How to use lookup variables in GTM with multiple input fields
Lakehouse
Pub/Sub messages to Snowflake
Pub/Sub is an asynchronous and scalable messaging service that decouples services producing messages from services processing those messages c.f. cloud.google.com/pubsub/docs/overview Some streaming processes rely on messages being received and provided by a message bus. It doesn't really matter if this bus
Digital Analytics
Server-side tag-management and consent
Collecting consent in server-side tracking