How to View Total Subscription Amount Across Multiple Currencies in Kapa.ai
kapa.ai how to see the total subscription amount received from users as subscription amount event sent from App side contains multiple currencies
kapa.ai how to see the total subscription amount received from users as subscription amount event sent from App side contains multiple currencies
To analyze total subscription revenue when events contain multiple currencies, Mixpanel’s guidance is to standardize amounts into a single “base” currency at ingest time and then aggregate that. The knowledge sources only partially cover this, so some implementation details may depend on your own systems.From the docs: - Each revenue event should include amount, currency, and an identifier like user_id or account_id.[Grow revenue]
- For multi-currency, you should also send:
- base_currency (e.g. "USD")
- base_ccy_amount (the converted numeric amount in that base currency)[Grow revenue]Once you have that: 1. Ensure events are structured like (example):
"event": "subscription_payment_success",
"properties": {
"amount": 100,
"currency": "EUR",
"base_currency": "USD",
"base_ccy_amount": 108.5,
"user_id": "123"
}
}
```LBKSLBKS2. **In an Insights report**:
- Event: your subscription revenue event (e.g. `subscription_payment_success`).
- Measurement: **Aggregate Property → Sum**.
- Property: `base_ccy_amount`. This gives **total revenue in the base currency** across all users/events.[[Aggregate property](https://docs.mixpanel.com/docs/reports/insights#aggregate-property)]LBKS3. If you want **ARPU or per-user metrics**, use:
- Measurement: **Aggregate Property per User → Sum** on `base_ccy_amount`, then aggregate by **Average** to get ARPU over a period.[[Aggregate per user](https://docs.mixpanel.com/docs/reports/insights#aggregate-property-per-user); [ARPU definition](https://docs.mixpanel.com/docs/features/revenue-analytics#common-use-cases)]LBKSIf you are using **Warehouse Connectors + Revenue Analytics**, the same principle applies: your mirrored purchase/subscription data should already include a normalized revenue field (like `base_ccy_amount`), which you then sum in Insights or use in other revenue metrics.[[Revenue overview](https://docs.mixpanel.com/docs/features/revenue-analytics); [Grow revenue](https://docs.mixpanel.com/guides/guides-by-use-case/grow-your-usership/grow-revenue#what-is-revenue-analytics)]LBKSIf your current events do **not** include `base_ccy_amount`, the docs don’t describe an automatic Mixpanel-side conversion; you’d need to add that conversion in your app, backend, or warehouse before sending/syncing to Mixpanel.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
yeah, thinking of implementing a json on app side, to convert the purchase currency/value into based currency/value will pass them as params in mixpanel accordingly will apply formula on mixpanel board to calculate the revenue numbers in base currency will keep on updating the json on regular basis
Yea, that should work