Reports
Both reports are drill-down tables. You choose one or more Group By dimensions, and each row expands into the next dimension.
How grouping works
Section titled “How grouping works”- In Group By, select one or more dimensions. They appear as numbered chips.
- Drag the chips to change the order of the hierarchy, or remove one with the ×.
- Click Apply Filters.
The first column, Dimension, shows the value of the first level (for example a date). Click the chevron of a row to load the next level for that value only. For example Date → Product → MID shows each day, then each product sold that day, then the MIDs that processed it.
Master report
Section titled “Master report”Reports → Master Report (/reports/master-report). Transaction KPIs by transaction date.
Group By and filters
Section titled “Group By and filters”- Group By: Date (default), Acquiring Bank, Product, Shop, Currency, MID.
- Filters: Date (default This Month), Billing Cycle, Payment Attempt, Transaction Type, Currency, Product, Shop Name, MID and PSP.
Columns
Section titled “Columns”Transactions are grouped into three categories:
- Orders — one-time payments (
ONE_TIME_PAYMENT). - Sub Start — first subscription charges (
SUBSCRIPTION_STARTandCAPTURE_PREAUTHORIZED). - Sub Renewal — renewals (
RECURRING_PAYMENT).
| Group | Column | Definition |
|---|---|---|
| Unique customers & approval rates | Customers — Count | Distinct customers with at least one transaction. |
| Customers — Billed | Distinct customers with at least one successful charge. | |
| Customers — Approval % | Billed ÷ Count. | |
| Orders / Sub Start / Sub Renewal — Attempts, Success, Approval % | Distinct customers who attempted / succeeded in each category, and the ratio. | |
| Transactions count | Total | Successful ÷ total transactions, with %. |
| Preauthorized, Captured | Customers with a successful pre-authorization / capture. | |
| Orders, Sub Start, Sub Renewal | Successful ÷ total transactions of each category. | |
| Transaction income | Orders, Sub Start, Sub Renewal | Number and amount of successful transactions of each category. |
| Income | Sum of the three categories. | |
| Cost | All Costs | Sum of refunds (negative amounts) in the period. |
Percentages are successes ÷ attempts, and show 0 % when there are no attempts.
Performance report
Section titled “Performance report”Reports → Performance Report (/reports/performance-report). A cohort report: it takes the customers who subscribed in a period and measures everything they’ve paid since.
Group By and filters
Section titled “Group By and filters”- Group By: Subscription Date (default), Acquiring Bank, Product, Shop.
- Subscription Date (default This Month) — selects the cohort by signup date.
- Transaction Date (default This Month) — limits which of the cohort’s transactions are counted. Widen it to measure lifetime value.
- Merchant Account.
Columns
Section titled “Columns”| Column | Definition |
|---|---|
| Customers | Customers in the cohort. |
| Subscribers | Customers of the cohort who are still subscribed. |
| Revenue | Sum of their successful transactions. |
| User Value | Revenue ÷ Customers. |
| Cost | Acquisition cost. |
| Profit | Revenue − Cost. |
| CPA | Cost ÷ Customers. |
| ROAS | Revenue ÷ Cost. |
| ROI | Profit ÷ Cost. |