Kometrics

Retention by signup cohort: for each month customers joined, how much of that cohort (or of its starting MRR) is left N months later. Use for retention and "do newer customers stick better" questions.

cohort_retention

Everything about one customer: current MRR, status, subscriptions, recent MRR movements and recent invoices. Needs the customer id, which customer_search returns.

customer_detail

Find customers by name, email or id, or list the book ranked by MRR / recency. Leave the query empty to get the top customers. Use this to turn a name in the question into a customer id.

customer_search

The MRR forecast: the growth, expansion, contraction and churn rates measured off recent closed months, and the projection those rates imply. Use for "where will we be" questions.

forecast_baseline

The individual customer MRR movements behind a number: who churned, who expanded, who signed up, in a date window. Use this to explain WHY a metric moved.

movement_list

Time series for one Kometrics metric (MRR, ARR, churn rates, subscribers, ARPA, LTV, movements) over a date window. Use this for any "how did X change" question. Returns the periods, the headline comparisons, and the deep link to the same report page.

report_series

MRR currently sitting on customers in dunning (failed or overdue payments), with the customers behind it. Use for "what is at risk of not being collected" questions.

past_due_summary

Customers whose MRR is at risk right now: scheduled cancellations, dunning, recent downgrades, upcoming annual renewals, ending trials. Use for "who might we lose" questions.

risk_radar

Free trials over a period: how many started, how many converted to paying, the conversion rate and the median days to convert. Use for "how are trials converting" questions. Trials never count toward MRR.

trial_summary

Cash expected from subscription renewals in the next 30 / 60 / 90 days, split monthly vs annual, with the largest individual renewals. Use for cash-timing questions.

upcoming_renewals