How it works
ChartMogul writes each table to your bucket as a gzip-compressed CSV file or a Snappy-compressed Parquet file, whichever you choose.
Connecting. You create a Google Cloud service account with the Storage Object Admin role on the bucket, and upload its JSON key to ChartMogul.
Before you connect
- Use a separate bucket if you also send ChartMogul data to BigQuery.
Setting it up
In ChartMogul, go to Settings > Destinations and add Google Cloud Storage. The Google Cloud Storage guide walks through each step.
What ChartMogul exports
Every warehouse and storage destination gets the same two sets of tables.
Your source data
Customers, custom attributes, tags, contacts and their custom attributes, invoices and line items, transactions, subscription events, plans, opportunities and their custom attributes, notes and call logs, tasks, currency rates, and data sources.
ChartMogul’s calculations
Customers with their MRR, ARR, and status, subscriptions, MRR and CMRR movements, MRR per customer per month, MRR and quantity per customer per month per plan, MRR intervals, and plan groups.
When it runs
Daily, weekly, or monthly, and you can also send data on demand. Field-level schemas are in the developer docs.