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.
NOTE: 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