AppRouteProductPivot tables
Product · Pivot tables

Build the app revenue report you actually need

Turn imported Stripe and RevenueCat transactions into a custom pivot table. Choose the fields, measures, filters, and comparison period instead of working from one fixed view.

Create your accountOpen pivot table

Revenue imports and revenue pivots require Pro or Team. Reports use personal-account revenue, not a combined team-workspace total.

Revenue pivot

Sample data
Rows
Measure
ProviderNet proceeds
Stripe$18,740
RevenueCat$12,940
Total$31,680

Simplified interactive example with illustrative USD transactions. These figures do not represent an AppRoute customer.

Report builder

Start with a question, then shape the table.

Revenue and click events use separate datasets. Choose Revenue for imported money movements, or Clicks for app-link traffic.

Arrange the report

Place provider, product, store, transaction kind, status, currency, or time on the rows and columns.

Choose the measure

Inspect gross revenue, net proceeds, refunds, known fees, transactions, customers, or revenue per customer.

Narrow the question

Filter the recorded fields, search the visible table, sort results, and compare the selected period with an earlier one.

Take the table with you

Export the visible pivot to CSV after the rows, columns, filters, and measures answer the question you started with.

Report recipes

Three useful tables to build first

How are the providers contributing?

Rows
Provider
Columns
Month
Measure
Net proceeds

Which products account for refunds?

Rows
Product
Columns
Store
Measure
Refunds

Where did recorded clicks come from?

Rows
UTM source
Columns
Operating system
Measure
Human clicks

Connect the source, choose Revenue, and build the view

Connect Stripe or RevenueCat in Dashboard → Integrations and let the import finish. Open Statistics → Pivot table, switch the dataset to Revenue, then choose your date range, row fields, column fields, and measures. Filter to one currency before comparing money totals.

Use the fields your provider supplies

Available details depend on the imported transaction. Products and customers may be missing, and fee totals include only known fees. Inspect the available values in the pivot's filters and compare the result with your source-provider report.

Filter currency before adding money totals

Money from different currencies is not added into one misleading total. Select a currency when the report contains more than one.

Treat customer ratios with care

Distinct-customer and revenue-per-customer subtotals are marked approximate because the same customer can appear in more than one group.

Revenue attribution from link clicks — coming soon

Imported revenue is not matched to an individual AppRoute click or link today. A time-period comparison can show two trends, but it does not prove campaign revenue or return on ad spend.

Where it fits

A flexible analysis layer for a small app team

Keep using Stripe for payments and RevenueCat for subscription infrastructure. Use AppRoute when you want to rearrange imported transaction fields visually, export the resulting table, and inspect recorded click data through the same report-building pattern.

Revenue imports and the Revenue dataset require Pro or Team. The pivot reads personal-account revenue rather than a combined team-workspace total. See plan details.

Continue exploring

Connect reporting to the rest of your app workflow.

Custom reporting

Ask a new question without waiting for a new dashboard.

Revenue imports and revenue pivots are available on Pro and Team. Click pivots remain a separate dataset.