Introduction

Datasources and destinations

Fields listing for Chartmogul

Customer Address Zip
Customer Address Zip
Field IDcustomers/address.address_zip
TypeTEXT
Data Typedimension
Customer Address City
Customer Address City
Field IDcustomers/address.city
TypeTEXT
Data Typedimension
Customer Address State
Customer Address State
Field IDcustomers/address.state
TypeTEXT
Data Typedimension
Customer Address Country
Customer Address Country
Field IDcustomers/address.country
TypeCOUNTRY_CODE
Data Typedimension
Customer ARR
Customer ARR
Field IDcustomers/arr
TypeNUMBER
Data Typemetric
Customer Billing System Type
Customer Billing System Type
Field IDcustomers/billing-system-type
TypeTEXT
Data Typedimension
Customer Billing System Url
Customer Billing System Url
Field IDcustomers/billing-system-url
TypeTEXT
Data Typedimension
Customer Chartmogul Url
Customer Chartmogul Url
Field IDcustomers/chartmogul-url
TypeTEXT
Data Typedimension
Customer City
Customer City
Field IDcustomers/city
TypeTEXT
Data Typedimension
Customer Company
Customer Company
Field IDcustomers/company
TypeTEXT
Data Typedimension
Customer Country
Customer Country
Field IDcustomers/country
TypeCOUNTRY_CODE
Data Typedimension
Customer Currency
Customer Currency
Field IDcustomers/currency
TypeTEXT
Data Typedimension
Customer Currency Sign
Customer Currency Sign
Field IDcustomers/currency-sign
TypeTEXT
Data Typedimension
Customer Customer Since
Customer Customer Since
Field IDcustomers/customer-since
TypeYEAR_MONTH_DAY
Data Typedimension
Customer Data Source Uuid
Customer Data Source Uuid
Field IDcustomers/data_source_uuid
TypeTEXT
Data Typedimension
Customer Data Source Uuids
Customer Data Source Uuids
Field IDcustomers/data_source_uuids
TypeTEXT
Data Typedimension
Customer Email
Customer Email
Field IDcustomers/email
TypeTEXT
Data Typedimension
Customer External Id
Customer External Id
Field IDcustomers/external_id
TypeTEXT
Data Typedimension
Customer External Ids
Customer External Ids
Field IDcustomers/external_ids
TypeTEXT
Data Typedimension
Customer Free Trial Started At
Customer Free Trial Started At
Field IDcustomers/free_trial_started_at
TypeYEAR_MONTH_DAY
Data Typedimension
Customer Id
Customer Id
Field IDcustomers/id
TypeNUMBER
Data Typedimension
Customer Lead Created At
Customer Lead Created At
Field IDcustomers/lead_created_at
TypeYEAR_MONTH_DAY
Data Typedimension
Customer MRR
Customer MRR
Field IDcustomers/mrr
TypeNUMBER
Data Typemetric
Customer Name
Customer Name
Field IDcustomers/name
TypeTEXT
Data Typedimension
Customer State
Customer State
Field IDcustomers/state
TypeTEXT
Data Typedimension
Customer Status
Customer Status
Field IDcustomers/status
TypeTEXT
Data Typedimension
Customer Uuid
Customer Uuid
Field IDcustomers/uuid
TypeTEXT
Data Typedimension
Customer Zip
Customer Zip
Field IDcustomers/zip
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
MRR Date
Date
Field IDdate
TypeYEAR_MONTH_DAY
Data Typemetric
MRR
Monthly Recurring Revenue
Field IDmrr
TypeNUMBER
Data Typemetric
ARR
Annual Recurring Revenue
Field IDarr
TypeNUMBER
Data Typemetric
LTV
Life Time Value
Field IDltv
TypeNUMBER
Data Typemetric
ARPA
Average Revenue Per Account
Field IDarpa
TypeNUMBER
Data Typemetric
ASP
Average Selling Price
Field IDasp
TypeNUMBER
Data Typemetric
Customer Count
Customer Count
Field IDcustomers
TypeNUMBER
Data Typemetric
Customer Churn Rate
Customer Churn Rate
Field IDcustomer-churn-rate
TypePERCENT
Data Typemetric
MRR Churn Rate
Monthly Recurring Revenue Churn Rate
Field IDmrr-churn-rate
TypePERCENT
Data Typemetric
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension