ChartMogul Lite
ChartMogul is a reporting and analytics solution.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | CUSTOMER, DATA_SOURCE, INVOICE, PLAN, PLAN_GROUP, and SUBSCRIPTION_EVENT tables and their child tables. |
| History mode | ||
| Custom data | check | custom_ prefix in the CUSTOMER table. |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step-by-step ChartMogul setup guide to connect ChartMogul with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and child tables:
KEY_METRICMONTHLY_RECURRING_REVENUEANNUALIZED_RUN_RATEAVERAGE_REVENUE_PER_ACCOUNTAVERAGE_SALE_PRICECUSTOMER_COUNTCUSTOMER_CHURN_RATEMRR_CHURN_RATECUSTOMER_LIFETIME_VALUEACTIVITY
We re-import the following reporting tables once a day to capture updates and deletes:
MONTHLY_RECURRING_REVENUEANNUALIZED_RUN_RATEAVERAGE_REVENUE_PER_ACCOUNTAVERAGE_SALE_PRICECUSTOMER_COUNTCUSTOMER_CHURN_RATEMRR_CHURN_RATECUSTOMER_LIFETIME_VALUE
Schema information
This schema applies to all ChartMogul connectors.
Explore ChartMogul schema ERD