Why this matters
Campaign dashboards stop at leads. Product-led teams need to know which campaigns create activated, retained, paying users.
What you get
- Campaign cohorts by signup week
- Paid conversion and revenue
- Retention by campaign
- Payback estimate when spend is available
Walk through it
You
Which campaigns actually paid back?
Agent
I’ll group signup cohorts by campaign and join revenue events.
Endpoint: POST /v1/projects/:project_id/analytics/query
Exact shape: /v1/openapi.json?path=%2Fv1%2Fprojects%2F%7Bproject_id%7D%2Fanalytics%2Fquery&method=post
Custom HogQL goes in the OpenAPI-defined `query` field.
Concept fields:
query: "SELECT properties.utm_campaign AS campaign, countIf(event = 'signup_completed') AS signups, countIf(event = 'subscription_started') AS paid, sumIf(toFloat(properties.amount), event = 'subscription_started') AS revenue FROM events WHERE event IN ('signup_completed','subscription_started') AND timestamp > now() - INTERVAL 90 DAY GROUP BY campaign ORDER BY revenue DESC"The output
The agent returns campaigns ranked by quality and revenue, not just signup count.
Setting it up
Persist campaign attribution onto signup and revenue lifecycle events. If spend is not in Agentry, the agent can still rank revenue and conversion.
Variations
- “Only compare campaigns from last quarter.”
- “Show campaigns with high signups but low paid conversion.”
- “Publish this as a finance review dashboard.”