Subscribers + Revenue Data Schema
Below is the recommended options for sharing Revenue data with Sundial through a Warehouse. Sundial can work off of your raw data through Config-Driven-Data-Engineering if the data is not in the below schema.
Sundial can ingest other types of Subscriber / Revenue data schemas :
- Pull Revenue / Subscribers data directly from your Stripe App
- Work off of direct export of Revenue data from the following Apps. These should be exported to any of the supported Warehouses.
- RevenueCat Data Export
- Chartmogul Data Export.
Subscriber Events Data Schema
Sundial creates several Metrics and Insights from raw Subscriber Events Data. We auto generate insights around the following areas
- Subscriber Growth Insights
- Subscriber Retention Insights
- Trial Conversion Insights
- Revenue / Seats / Accounts Growth and Retention Insights.
- Aha Moment Insights on User Behaviour
Add as many segmentations as possible for more deeper Insights.
This schema is an event log of all subscription activity in your product
| event_date | user_id | workspace_id | start_date | end_date | plan_type | is_trial | Plan Amount | refund_amount | cancellation_date | segment_1 ex: Country | segment_2 ex: Platform | segment_3 ex: num_clicks |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020-01-01 | aaa_xxx | acct_10 | 2020-01-01 | 2020-02-01 | Team | False | 100 | 0 | USA | iOS | 20 | |
| 2020-01-10 | bbb_xxx | acct_10 | 2020-01-10 | 2020-01-24 | Trial | True | 0 | 0 | IND | android | 10 |
Subscribers/Revenue Daily Status Schema
For Workspace level Insights, a recommended schema is given below.
Sundial creates several Metrics and Insights from raw Workspace Data. We auto generate insights around the following areas
- Revenue / Seats / Accounts Growth and Retention Insights
- Workspace Activation Insights
- Aha Moment Insights
- Trial Conversion Insights.
Add as many segmentations as possible for more deeper insights.
This schema is a daily list of all workspaces with the ARR and Dimensions.
| event_date | workspace_id /user-id | plan_type | seats | is_trial | ARR | segment_1 ex: Country | segment_2 ex: Platform | segment_3 ex: num_clicks | ... |
|---|---|---|---|---|---|---|---|---|---|
| 2020-01-01 | acct_10 | Team | 10 | False | 100 | USA | iOS | 20 | |
| 2020-01-10 | acct_10 | Trial | 1 | True | 0 | IND | android | 10 |
User Events Data
To provide more User Event Data and get insights on how they impact your Subscribers and Revenue. Please share the user events data in the following format.
We need a connecting id between user events and subscriber events. This is usually the unique user_id.