ChartMogul Lite
ChartMogul is a reporting and analytics solution.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | |
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 |
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_METRIC
MONTHLY_RECURRING_REVENUE
ANNUALIZED_RUN_RATE
AVERAGE_REVENUE_PER_ACCOUNT
AVERAGE_SALE_PRICE
CUSTOMER_COUNT
CUSTOMER_CHURN_RATE
MRR_CHURN_RATE
CUSTOMER_LIFETIME_VALUE
ACTIVITY
We re-import the following reporting tables once a day to capture updates and deletes:
MONTHLY_RECURRING_REVENUE
ANNUALIZED_RUN_RATE
AVERAGE_REVENUE_PER_ACCOUNT
AVERAGE_SALE_PRICE
CUSTOMER_COUNT
CUSTOMER_CHURN_RATE
MRR_CHURN_RATE
CUSTOMER_LIFETIME_VALUE
Schema information
This schema applies to all ChartMogul connectors.
Explore ChartMogul schema ERD