Marketing attribution data pipeline diagram
This is a worked example. Wavelength built the diagram below from the description on this page. Nobody drew it by hand.
What was said
Website visits are tracked in Google Analytics 4. GA4 exports raw events to BigQuery every day. Ad spend from Google Ads and LinkedIn Ads also lands in BigQuery through Supermetrics. dbt joins the events and the spend into an attribution model. The marketing team reads cost per pipeline in Looker.
The diagram
What is in this flow
- Systems: Google Analytics 4, Google Ads, LinkedIn Ads, Supermetrics, dbt and Looker.
- Data stores: BigQuery.
- People and teams: Marketing Team.
- Size: 9 steps and 8 connections.
Mermaid code
Copy this into any Markdown file, GitHub README, or Mermaid Live to render the same flow.
flowchart TD
n1(["Website Visits")]
n2{{"Google Analytics 4"}}
n3[("BigQuery")]
n4{{"Google Ads"}}
n5{{"LinkedIn Ads"}}
n6{{"Supermetrics"}}
n7{{"dbt"}}
n8{{"Looker"}}
n9("Marketing Team")
n1 -->|tracked in| n2
n2 -->|exports raw events daily| n3
n4 -->|lands via| n6
n5 -->|lands via| n6
n6 -->|loads into| n3
n3 -->|joins events and spend| n7
n7 -->|provides attribution model| n8
n8 -->|reads cost per pipeline| n9Map your own process
Describe your version out loud, or paste the transcript of a call. Wavelength draws the flow as you talk, and you can edit it by voice, by prompt, or by hand.
Every new account starts with 14 days of Pro. No card needed.