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
Opens an editable copy you can change by voice or by hand. Free account, no card.
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 7 days of Pro. No card needed.
Related
- Flow diagram examples: all 37 worked process and data flow diagrams
- Order to cash process: a finance flow example
- Procure to pay process: a procurement flow example
- Employee onboarding: an HR flow example
- Invoice approval workflow: an approval flow example
- Support ticket escalation: a support flow example
- Flowchart template: copy, edit, and make your own
- For business analysts: capture an as-is process in swimlanes
- Live demo: describe a process and see the flow, no account needed