Windsor brings all your ChartMogul data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
ChartMogul Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| activities__activity-arr | NUMERIC | activities.activity-arr | activities.activity-arr | activities |
| activities__activity-mrr | NUMERIC | activities.activity-mrr | activities.activity-mrr | activities |
| activities__activity-mrr-movement | NUMERIC | activities.activity-mrr-movement | activities.activity-mrr-movement | activities |
| activities__billing-connector-uuid | TEXT | activities.billing-connector-uuid | activities.billing-connector-uuid | activities |
| activities__currency | TEXT | activities.currency | activities.currency | activities |
| activities__customer-external-id | TEXT | activities.customer-external-id | activities.customer-external-id | activities |
| activities__customer-name | TEXT | activities.customer-name | activities.customer-name | activities |
| activities__customer-uuid | TEXT | activities.customer-uuid | activities.customer-uuid | activities |
| activities__date | DATE | activities.date | activities.date | activities |
| activities__description | TEXT | activities.description | activities.description | activities |
| activities__plan-external-id | TEXT | activities.plan-external-id | activities.plan-external-id | activities |
| activities__subscription-external-id | TEXT | activities.subscription-external-id | activities.subscription-external-id | activities |
| activities__type | TEXT | activities.type | activities.type | activities |
| activities__uuid | TEXT | activities.uuid | activities.uuid | activities |
| customer_daily_count__customers | NUMERIC | customer_daily_count.customers | customer_daily_count.customers | customer_daily_count |
| customer_daily_count__date | DATE | customer_daily_count.date | customer_daily_count.date | customer_daily_count |
| customer_monthly_count__customers | NUMERIC | customer_monthly_count.customers | customer_monthly_count.customers | customer_monthly_count |
| customer_monthly_count__date | DATE | customer_monthly_count.date | customer_monthly_count.date | customer_monthly_count |
| customer_quarterly_count__customers | NUMERIC | customer_quarterly_count.customers | customer_quarterly_count.customers | customer_quarterly_count |
| customer_quarterly_count__date | DATE | customer_quarterly_count.date | customer_quarterly_count.date | customer_quarterly_count |
| customer_weekly_count__customers | NUMERIC | customer_weekly_count.customers | customer_weekly_count.customers | customer_weekly_count |
| customer_weekly_count__date | DATE | customer_weekly_count.date | customer_weekly_count.date | customer_weekly_count |
| customers__address | OBJECT | customers.address | customers.address | customers |
| customers__arr | NUMERIC | customers.arr | customers.arr | customers |
| customers__attributes | OBJECT | customers.attributes | customers.attributes | customers |
| customers__billing-system-type | TEXT | customers.billing-system-type | customers.billing-system-type | customers |
| customers__billing-system-url | TEXT | customers.billing-system-url | customers.billing-system-url | customers |
| customers__chartmogul-url | TEXT | customers.chartmogul-url | customers.chartmogul-url | customers |
| customers__city | CITY | customers.city | customers.city | customers |
| customers__company | TEXT | customers.company | customers.company | customers |
| customers__country | COUNTRY | customers.country | customers.country | customers |
| customers__currency | TEXT | customers.currency | customers.currency | customers |
| customers__currency-sign | TEXT | customers.currency-sign | customers.currency-sign | customers |
| customers__customer_since | TEXT | customers.customer_since | customers.customer_since | customers |
| customers__data_source_uuid | TEXT | customers.data_source_uuid | customers.data_source_uuid | customers |
| customers__data_source_uuids | OBJECT | customers.data_source_uuids | customers.data_source_uuids | customers |
| customers__email | TEXT | customers.email | customers.email | customers |
| customers__external_id | TEXT | customers.external_id | customers.external_id | customers |
| customers__external_ids | OBJECT | customers.external_ids | customers.external_ids | customers |
| customers__free_trial_started_at | TEXT | customers.free_trial_started_at | customers.free_trial_started_at | customers |
| customers__id | TEXT | customers.id | customers.id | customers |
| customers__lead_created_at | TEXT | customers.lead_created_at | customers.lead_created_at | customers |
| customers__mrr | NUMERIC | customers.mrr | customers.mrr | customers |
| customers__name | TEXT | customers.name | customers.name | customers |
| customers__state | TEXT | customers.state | customers.state | customers |
| customers__status | TEXT | customers.status | customers.status | customers |
| customers__uuid | TEXT | customers.uuid | customers.uuid | customers |
| customers__zip | TEXT | customers.zip | customers.zip | customers |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |