Calculate campaign payback by cohort

Tie acquisition campaigns to paid conversion, revenue, and retention so marketing and finance can see which campaigns pay back.

Published

difficulty advanced · time to value 10 minutes
#analytics #marketing #revenue #cohorts #acquisition #saas

Start from this 

Calculate campaign payback by signup cohort: campaign, spend if available, paid conversions, revenue, retention, and payback period.

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.”

Related playbooks

growth 5 minutes

Measure landing-page source quality

Compare acquisition sources by activation, retention, and paid conversion instead of only measuring clicks or signups.

growth 3 minutes

Track trial-to-paid conversion by acquisition source

Build the trial-to-paid funnel split by acquisition source. Surface the channel that converts 8x better than the rest.

growth 5 minutes

Compare self-serve vs sales-led user lifecycles

Split your funnel by how the user arrived — pricing-page vs demo. Compare activation, retention, expansion side by side.

Adapt this playbook in your own agent.

Ask your agent to map the starter prompt to your saved signal map, live events, and the current HTTP API before answering.

Set up Agentry in this repo by following https://agentry.sh/install.md. I authorize you to: run its device-code login and save the key to ~/.agentry/credentials.json, read this repo, propose an instrumentation plan for my approval, and edit code after I approve it.

+ Full access
5.5 Extra High
  1. 1. Open your repo in Codex, Claude Code, Cursor etc.
  2. 2. Paste the install prompt.
  3. 3. Your agent reads the install doc and shows you an implementation plan for approval.
← all playbooks