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:

Azure Blob Storage

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

Available datasets:

Google Cloud Storage

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

Available datasets:

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:

Google BigQuery

Learn how to configure Google BigQuery as a destination in ChartMogul. 

Available datasets:

Snowflake

Learn how to configure Snowflake as a destination in ChartMogul.

Available datasets:

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:

• Email
• Intercom
• Slack