Destinations
Use destinations to export data outside of ChartMogul, for instance, to object storage services or data warehouses.
Datasets available for export are divided into two categories:
- Source Data — data imported from a billing source, transformed to the ChartMogul data model
- Calculated Data — data calculated in ChartMogul, such as MRR movements
Read a detailed reference of the available datasets.
Object storage destinations
The first step in setting up an export of data from ChartMogul to an object storage service is to create a destination in ChartMogul UI. This will configure how the data will flow from ChartMogul to your object storage solution.
Amazon S3
Learn how to configure Amazon S3 as a destination in ChartMogul.
Available datasets:
- Contacts
- Currency Rates
- Custom Attributes
- Customers
- Invoice Line Items
- Invoices
- Plans
- Subscription Events
- Tags
- Transactions
- Data Sources
- Customers
- MRR Movements
Azure Blob Storage
Learn how to configure Azure Blog Storage as a destination in ChartMogul.
Available datasets:
- Contacts
- Currency Rates
- Custom Attributes
- Customers
- Invoice Line Items
- Invoices
- Plans
- Subscription Events
- Tags
- Transactions
- Data Sources
- Customers
- MRR Movements
Google Cloud Storage
Learn how to configure Google Cloud Storage as a destination in ChartMogul.
Available datasets:
- Contacts
- Currency Rates
- Custom Attributes
- Customers
- Invoice Line Items
- Invoices
- Plans
- Subscription Events
- Tags
- Transactions
- Data Sources
- Customers
- MRR Movements
Data warehouses
The first step in setting up an export of data from ChartMogul to a data warehouse is to create a destination in ChartMogul UI. This will configure how the data will flow from ChartMogul to your data warehousing solution.
Amazon Redshift
Learn how to configure Amazon Redshift as a destination in ChartMogul.
Available datasets:
- Contacts
- Currency Rates
- Custom Attributes
- Customers
- Invoice Line Items
- Invoices
- Plans
- Subscription Events
- Tags
- Transactions
- Data Sources
- Customers
- MRR Movements
Google BigQuery
Learn how to configure Google BigQuery as a destination in ChartMogul.
Available datasets:
- Contacts
- Currency Rates
- Custom Attributes
- Customers
- Invoice Line Items
- Invoices
- Plans
- Subscription Events
- Tags
- Transactions
- Data Sources
- Customers
- MRR Movements
Snowflake
Learn how to configure Snowflake as a destination in ChartMogul.
Available datasets:
- Contacts
- Currency Rates
- Custom Attributes
- Customers
- Invoice Line Items
- Invoices
- Plans
- Subscription Events
- Tags
- Transactions
- Data Sources
- Customers
- MRR Movements
Webhooks
ChartMogul webhooks allow you to send MRR movements as a JSON payload. Real-time MRR movements serve as the events that trigger the webhook.
Learn how to register a webhook in ChartMogul.
Here’s an example JSON payload:
{ "date": "2023-11-02T14:00:00.000Z", "type": "mrr_movement", "customer": { "name": "Nina Blues", "uuid": "cus_728b0b6e-7a44-4275-920b-0d0ef833a9a3", "email": "[email protected]", "status": "active", "company": "Hunter Technologies", "currency": "USD", "current_arr": 30000, "current_mrr": 2500, "external_id": "cus_0001", "external_ids": [ "cus_0001" ], "currency_symbol": "$", "data_source_uuid": "ds_35542640-d9f1-11ed-9c30-7727168c74a5" }, "description": "reactivated an old account with Platinum annual plan", "subscription": { "external_id": "c7209380-798b-11ee-941a-c32899dd4de8" }, "movement_type": "reactivation", "account_currency": "USD", "invoice_currency": "USD", "account_currency_symbol": "$", "invoice_currency_symbol": "$", "movement_amount_in_cent": 2500, "mrr_movement_in_account_currency": 2500, "mrr_movement_in_invoice_currency": 2500 }
Read a detailed description of fields contained in the payload.
Other destinations
ChartMogul also allows you to configure the following destinations: