Why this matters
Marketing dashboards overvalue volume. Product teams need to know which sources create activated, retained, paying users.
What you get
- Signup volume by source
- Activation and retention by source
- Paid conversion by source if revenue events exist
- Recommendations for where to spend or stop spending
Walk through it
Which landing sources produce good users?
I’ll compare acquisition source against activation and retention events.
POST /v1/projects/:project_id/analytics/query {
project_id: "default",
hogql: "SELECT properties.utm_source AS source, countIf(event = 'signup_completed') AS signups, countIf(event = 'activated') AS activated, activated / nullIf(signups, 0) AS activation_rate FROM events WHERE event IN ('signup_completed','activated') AND timestamp > now() - INTERVAL 30 DAY GROUP BY source ORDER BY signups DESC"
}
The output
The agent returns a source-quality table and flags sources with many signups but weak activation.
Setting it up
Persist UTM/source attribution onto signup and activation events. Anonymous pageviews are useful, but source must survive account creation.
Variations
- “Compare LinkedIn vs Google by paid conversion.”
- “Only show sources with at least 50 signups.”
- “Publish this as a marketing quality dashboard.”