ChartMogul Connector Reference

12 metrics70 dimensions

Fields

The ChartMogul connector exposes 82 fields (12 metrics, 70 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

ChartMogul Fields

ChartMogul activities fields

The activities report of the ChartMogul connector includes 23 fields.

ID	Type	Name	Description
activities__activity-arr	NUMERIC	(Deprecated) activities.activity-arr	Deprecated, use activities__activity_arr instead.
activities__activity-mrr	NUMERIC	(Deprecated) activities.activity-mrr	Deprecated, use activities__activity_mrr instead.
activities__activity-mrr-movement	NUMERIC	(Deprecated) activities.activity-mrr-movement	Deprecated, use activities__activity_mrr_movement instead.
activities__activity_arr	NUMERIC	activities.activity-arr	activities.activity-arr
activities__activity_mrr	NUMERIC	activities.activity-mrr	activities.activity-mrr
activities__activity_mrr_movement	NUMERIC	activities.activity-mrr-movement	activities.activity-mrr-movement
activities__billing-connector-uuid	TEXT	(Deprecated) activities.billing-connector-uuid	Deprecated, use activities__billing_connector_uuid instead.
activities__billing_connector_uuid	TEXT	activities.billing-connector-uuid	activities.billing-connector-uuid
activities__currency	TEXT	activities.currency	activities.currency
activities__customer-external-id	TEXT	(Deprecated) activities.customer-external-id	Deprecated, use activities__customer_external_id instead.
activities__customer-name	TEXT	(Deprecated) activities.customer-name	Deprecated, use activities__customer_name instead.
activities__customer-uuid	TEXT	(Deprecated) activities.customer-uuid	Deprecated, use activities__customer_uuid instead.
activities__customer_external_id	TEXT	activities.customer-external-id	activities.customer-external-id
activities__customer_name	TEXT	activities.customer-name	activities.customer-name
activities__customer_uuid	TEXT	activities.customer-uuid	activities.customer-uuid
activities__date	DATE	activities.date	activities.date
activities__description	TEXT	activities.description	activities.description
activities__plan-external-id	TEXT	(Deprecated) activities.plan-external-id	Deprecated, use activities__plan_external_id instead.
activities__plan_external_id	TEXT	activities.plan-external-id	activities.plan-external-id
activities__subscription-external-id	TEXT	(Deprecated) activities.subscription-external-id	Deprecated, use activities__subscription_external_id instead.
activities__subscription_external_id	TEXT	activities.subscription-external-id	activities.subscription-external-id
activities__type	TEXT	activities.type	activities.type
activities__uuid	TEXT	activities.uuid	activities.uuid

ChartMogul customers fields

The customers report of the ChartMogul connector includes 30 fields.

ID	Type	Name	Description
customers__address	OBJECT	customers.address	customers.address
customers__arr	NUMERIC	customers.arr	customers.arr
customers__attributes	OBJECT	customers.attributes	customers.attributes
customers__billing-system-type	TEXT	(Deprecated) customers.billing-system-type	Deprecated, use customers__billing_system_type instead.
customers__billing-system-url	TEXT	(Deprecated) customers.billing-system-url	Deprecated, use customers__billing_system_url instead.
customers__billing_system_type	TEXT	customers.billing-system-type	customers.billing-system-type
customers__billing_system_url	TEXT	customers.billing-system-url	customers.billing-system-url
customers__chartmogul-url	TEXT	(Deprecated) customers.chartmogul-url	Deprecated, use customers__chartmogul_url instead.
customers__chartmogul_url	TEXT	customers.chartmogul-url	customers.chartmogul-url
customers__city	CITY	customers.city	customers.city
customers__company	TEXT	customers.company	customers.company
customers__country	COUNTRY	customers.country	customers.country
customers__currency	TEXT	customers.currency	customers.currency
customers__currency-sign	TEXT	(Deprecated) customers.currency-sign	Deprecated, use customers__currency_sign instead.
customers__currency_sign	TEXT	customers.currency-sign	customers.currency-sign
customers__customer_since	TEXT	customers.customer_since	customers.customer_since
customers__data_source_uuid	TEXT	customers.data_source_uuid	customers.data_source_uuid
customers__data_source_uuids	OBJECT	customers.data_source_uuids	customers.data_source_uuids
customers__email	TEXT	customers.email	customers.email
customers__external_id	TEXT	customers.external_id	customers.external_id
customers__external_ids	OBJECT	customers.external_ids	customers.external_ids
customers__free_trial_started_at	TEXT	customers.free_trial_started_at	customers.free_trial_started_at
customers__id	TEXT	customers.id	customers.id
customers__lead_created_at	TEXT	customers.lead_created_at	customers.lead_created_at
customers__mrr	NUMERIC	customers.mrr	customers.mrr
customers__name	TEXT	customers.name	customers.name
customers__state	TEXT	customers.state	customers.state
customers__status	TEXT	customers.status	customers.status
customers__uuid	TEXT	customers.uuid	customers.uuid
customers__zip	TEXT	customers.zip	customers.zip

ChartMogul General fields

The General report of the ChartMogul connector includes 3 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The unique identifier for the account.
account_name	TEXT	Account Name	The name of the account.
date	DATE	Date	The date of the record.

ChartMogul other fields

The ChartMogul connector has 26 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
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
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20