Edit on GitHub
ChartMogul Lite link
Updated August 16, 2023
ChartMogul is a reporting and analytics solution.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | All tables |
Custom data | check | All fields with the custom_ prefix in the CUSTOMER table. |
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | ||
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step ChartMogul setup guide to connect ChartMogul with your destination using Fivetran connectors.
Sync overviewlink
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 informationlink
This schema applies to all ChartMogul connectors.
To zoom, open the ERD in a new window.