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:

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:

Source Data
  • Contacts
  • Currency Rates
  • Custom Attributes
  • Customers
  • Invoice Line Items
  • Invoices
  • Plans
  • Subscription Events
  • Tags
  • Transactions
  • Data Sources
Calculated Data
  • Customers
  • MRR Movements

Azure Blob Storage

Learn how to configure Azure Blog Storage as a destination in ChartMogul

Available datasets:

Source Data
  • Contacts
  • Currency Rates
  • Custom Attributes
  • Customers
  • Invoice Line Items
  • Invoices
  • Plans
  • Subscription Events
  • Tags
  • Transactions
  • Data Sources
Calculated Data
  • Customers
  • MRR Movements

Google Cloud Storage

Learn how to configure Google Cloud Storage as a destination in ChartMogul

Available datasets:

Source Data
  • Contacts
  • Currency Rates
  • Custom Attributes
  • Customers
  • Invoice Line Items
  • Invoices
  • Plans
  • Subscription Events
  • Tags
  • Transactions
  • Data Sources
Calculated Data
  • 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:

Source Data
  • Contacts
  • Currency Rates
  • Custom Attributes
  • Customers
  • Invoice Line Items
  • Invoices
  • Plans
  • Subscription Events
  • Tags
  • Transactions
  • Data Sources
Calculated Data
  • Customers
  • MRR Movements

Google BigQuery

Learn how to configure Google BigQuery as a destination in ChartMogul

Available datasets:

Source Data
  • Contacts
  • Currency Rates
  • Custom Attributes
  • Customers
  • Invoice Line Items
  • Invoices
  • Plans
  • Subscription Events
  • Tags
  • Transactions
  • Data Sources
Calculated Data
  • Customers
  • MRR Movements

Snowflake

Learn how to configure Snowflake as a destination in ChartMogul.

Available datasets:

Source Data
  • Contacts
  • Currency Rates
  • Custom Attributes
  • Customers
  • Invoice Line Items
  • Invoices
  • Plans
  • Subscription Events
  • Tags
  • Transactions
  • Data Sources
Calculated Data
  • 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: