Documentation
Profit, ad spend and lifetime value
Revenue tells you what came in. The Profit report subtracts what it cost to get it: payment fees, cost of goods, ad spend, affiliate commissions and fixed costs. Cohorts show how much each month's new customers are worth over time. Find both in Revenue analytics on your dashboard.
Amounts never mix currencies. Profit uses one currency (the one you choose in Settings, or the currency most of your payments use) and lists payments and spend in other currencies separately, without converting them.
1. Add your costs
Open Settings → Revenue → Costs and fees:
| Field | Meaning |
|---|---|
| Profit currency | The currency the Profit report and cohorts use |
| Payment fee (%) | Your processor's percentage fee, applied to each payment (refunds are not charged a fee) |
| Fixed fee per payment | The flat part of the fee, such as 0.30 |
| Cost of goods (%) | Product, hosting or fulfilment cost as a share of net revenue |
| Fixed costs per month | Salaries, tools and rent. Spread evenly per day across the report's date range |
Admins and owners can change these; viewers can read them. Without saved costs, the report uses zero fees and says so.
2. Add ad spend
Meta ads sync automatically once connected in Settings → Integrations.
Any other platform (Google Ads, TikTok, LinkedIn, Microsoft, a spreadsheet): upload a CSV in Settings → Revenue → Ad spend (CSV). The file needs a date, campaign and spend column. Column names from common platform downloads are recognised:
| Column | Accepted headers |
|---|---|
| Date | date, day, reporting starts, start date, stat_time_day, by day |
| Campaign | campaign, campaign name, campaign_name, utm_campaign |
| Spend | spend, cost, amount spent, amount spent (USD), total cost |
| Source (optional) | source, utm_source, platform, network |
| Currency (optional) | currency, currency code |
| Clicks, impressions (optional) | clicks, link clicks, impressions, impr. |
Dates must be YYYY-MM-DD. Title lines above the header (as in Google Ads downloads) and "Total" rows are skipped. Rows for the same campaign and day are added together, so ad-group or ad-level exports work. If the file has no source column, enter the utm_source your ads use (for example google) before uploading. If it has no currency column, the site's reporting currency is used.
Uploading the same campaign-days again replaces them, so you can re-export a date range at any time without doubling spend. Limits: 1 MB and 3,000 campaign-days per file.
How spend matches visits
Spend rows match visits by utm_source and utm_campaign, case-insensitively. Tag your ad links with the same names you see in the ad platform:
https://example.com/?utm_source=google&utm_medium=cpc&utm_campaign=Brand
Matched campaigns get ROAS, CAC and profit in Campaign performance. Only full days inside the selected range count, so a range that starts mid-day doesn't overstate spend.
3. Affiliate commissions
In Settings → Revenue → Affiliate commissions, set what each ?ref= partner earns: a percentage, a fixed amount per customer, or both. A rule with the ref * applies to every partner without their own rule.
- First purchase rules pay on each referred customer's first payment, net of refunds of it.
- Recurring rules pay on every payment and renewal from the customers that partner referred.
Commission is only calculated in the rule's currency. The Affiliates panel shows the commission owed per partner and a bot share column: the share of that partner's sessions flagged as automated by traffic quality. A high bot share next to a large commission is worth checking before paying out.
Reports
Profit shows net revenue, then each cost, then profit and margin, with a breakdown by source. Ad spend is assigned to the source most of its campaign's visits came from. Spend with no matching visits appears as its own "(no visits)" row, so it is never silently dropped. Commissions and fixed costs appear only in the total.
Cohorts and lifetime value groups customers by the UTC month of their first payment in the last 12 months and shows cumulative net revenue per customer for each month after, plus the share who paid again that month. Lifetime value by first source shows which channels bring customers who keep paying. Customers who first paid more than a year ago are left out of cohorts rather than counted as new.
AI assistants (MCP)
The MCP tools profit and cohorts_ltv return the same reports in major currency units (for example 12.5 for $12.50), with the costs, notes and limits that produced them.
Free plan limits
Reports read at most 5,000 payments, 2,000 campaign visits and 3,000 spend rows per request, and say when a limit was reached. Results are cached for a minute. Spend imports use one database statement per 500 rows.