ChartMogul Tables
The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.
ChartMogul Tables
| Name | Description |
| Account | Account or company information including currency and timezone settings |
| Activities | Revenue activities across all customers with MRR movement tracking |
| ActivitiesExport | Export status for bulk activity downloads |
| BulkImportStatus | Status of bulk data import operations |
| Contacts | Contact persons associated with customer accounts |
| CustomerActivities | Revenue activities for a specific customer |
| CustomerAttributes | Customer attributes including tags and custom fields |
| CustomerInvoices | Invoices for a specific customer |
| CustomerNotes | Notes and call logs associated with customers |
| Customers | Customer records with subscription and revenue data |
| CustomerSearch | Search for customers by email or external ID |
| DataSources | Data source connections to billing systems |
| InvoiceLineItems | Individual line items from invoices with pricing details |
| Invoices | Invoice records with line items and transaction details |
| MetricsAll | Combined metrics including MRR, ARR, ARPA, ASP, LTV, and churn rates |
| MetricsARPA | Average Revenue Per Account metrics over time |
| MetricsARR | Annual Run Rate metrics over time |
| MetricsASP | Average Sale Price metrics over time |
| MetricsChurnRate | Customer churn rate metrics over time |
| MetricsCustomerCount | Active customer count metrics over time |
| MetricsLTV | Customer Lifetime Value metrics over time |
| MetricsMRR | Monthly Recurring Revenue metrics over time |
| MetricsMRRChurnRate | MRR churn rate metrics over time |
| Opportunities | Sales opportunities with deal tracking and forecasting |
| PlanGroupPlans | Plans within a specific plan group |
| PlanGroups | Collections of related billing plans |
| Plans | Billing plans with pricing and interval configuration |
| SubscriptionEvents | Subscription lifecycle events with revenue impact tracking |
| Subscriptions | Customer subscriptions with billing and revenue details |
| Tasks | Customer-related tasks with assignment and due date tracking |
| Transactions | Payment and refund transactions with fees |