Skip to main content
GET
/
v0
/
revenue_by_metric
Get revenue grouped by a chosen column
curl --request GET \
  --url https://api.formo.so/v0/revenue_by_metric \
  --header 'Authorization: Bearer <token>'
{
  "meta": [
    {
      "name": "project_id",
      "type": "String"
    },
    {
      "name": "pathname",
      "type": "String"
    },
    {
      "name": "sum_revenue",
      "type": "Float64"
    }
  ],
  "data": [
    {
      "project_id": "proj_abc",
      "pathname": "app.example.com/trade",
      "sum_revenue": 8412.55
    },
    {
      "project_id": "proj_abc",
      "pathname": "app.example.com/earn",
      "sum_revenue": 2184.3
    },
    {
      "project_id": "proj_abc",
      "pathname": "app.example.com/swap",
      "sum_revenue": 1287.2
    }
  ],
  "rows": 3,
  "rows_before_limit_at_least": 8
}
Returns total revenue broken down by metric_column. The required metric_column query parameter selects the dimension to group by — for example pathname, referrer, utm_source, or location.

Authorizations

Authorization
string
header
required

Workspace API key (e.g. formo_xxx). Create one in the Formo dashboard under Team Settings > API Keys.

Query Parameters

date_from
string<date>

Inclusive start date (YYYY-MM-DD). Defaults to 7 days before date_to.

date_to
string<date>

Inclusive end date (YYYY-MM-DD). Defaults to today.

metric_column
enum<string>
required

Column to group revenue by. Use channel for the 12-channel acquisition classifier (see docs/channels.md). Unknown values return zero rows.

Available options:
pathname,
origin,
channel,
referrer,
referrer_url,
ref,
utm_source,
utm_medium,
utm_campaign,
utm_content,
utm_term,
builder_codes,
location,
device,
browser,
os,
rdns,
provider_name,
chain_id,
event
limit
integer
default:50

Maximum results to return (default 50, max 1000)

Required range: 1 <= x <= 1000
offset
integer
default:0

Number of results to skip for pagination (default 0)

Required range: 0 <= x <= 100000

Response

Revenue by metric

Raw Tinybird pipe response. The data array contains the analytics rows; the exact row shape depends on the endpoint.

data
object[]
meta
object[]
rows
integer
rows_before_limit_at_least
integer
statistics
object