Zoho CRM fields

14 metrics156 dimensionsCustom fields

Search fields

ACCOUNT

account_id

Field label	Account ID
Description	The unique identifier of the account
Field type	dimension
Data type	string.text.value

account_name

Field label	Account name
Description	The name of the account
Field type	dimension
Data type	string.text.value

account_number

Field label	Account number
Description	The account number
Field type	dimension
Data type	string.text.value

account_site

Field label	Account site
Description	The site associated with the account
Field type	dimension
Data type	string.text.url

account_type

Field label	Account type
Description	The type of the account
Field type	dimension
Data type	string.text.value

account_ownership

Field label	Ownership
Description	The ownership of the account
Field type	dimension
Data type	string.text.value

account_industry

Field label	Industry
Description	The industry of the account
Field type	dimension
Data type	string.text.value

account_sic_code

Field label	SIC code
Description	The SIC code of the account
Field type	dimension
Data type	string.text.value

account_ticker_symbol

Field label	Ticker symbol
Description	The ticker symbol of the account
Field type	dimension
Data type	string.text.value

account_website

Field label	Website
Description	The website of the account
Field type	dimension
Data type	string.text.url

account_phone

Field label	Phone
Description	The phone number of the account
Field type	dimension
Data type	string.text.phone

account_fax

Field label	Fax
Description	The fax number of the account
Field type	dimension
Data type	string.text.value

account_description

Field label	Description
Description	The description of the account
Field type	dimension
Data type	string.text.value

account_tag

Field label	Tag
Description	The tag associated with the account
Field type	dimension
Data type	string.text.value

account_locked__s

Field label	Locked
Description	Indicates whether the account is locked from editing
Field type	dimension
Data type	bool

account_enrich_status__s

Field label	Enrich status
Description	The status of the enrichment process for the account
Field type	dimension
Data type	string.text.value

account_rating

Field label	Rating
Description	The rating of the account
Field type	dimension
Data type	string.text.value

account_billing_street

Field label	Billing street
Description	The billing street address of the account
Field type	dimension
Data type	string.geo.street

account_billing_city

Field label	Billing city
Description	The billing city of the account
Field type	dimension
Data type	string.geo.city

account_billing_state

Field label	Billing state
Description	The billing state of the account
Field type	dimension
Data type	string.geo.region

account_billing_country

Field label	Billing country
Description	The billing country of the account
Field type	dimension
Data type	string.geo.country

account_shipping_street

Field label	Shipping street
Description	The shipping street address of the account
Field type	dimension
Data type	string.geo.street

account_shipping_city

Field label	Shipping city
Description	The shipping city of the account
Field type	dimension
Data type	string.geo.city

account_shipping_state

Field label	Shipping state
Description	The shipping state of the account
Field type	dimension
Data type	string.geo.region

account_shipping_country

Field label	Shipping country
Description	The shipping country of the account
Field type	dimension
Data type	string.geo.country

accounts

Field label	Accounts
Description	Total number of accounts
Field type	metric
Data type	int.number.value

account_employees

Field label	Employees
Description	The number of employees in the account
Field type	metric
Data type	int.number.value

account_annual_revenue

Field label	Annual revenue
Description	The annual revenue of the account
Field type	metric
Data type	float.currency.value

CONTACT

contact_id

Field label	Contact ID
Description	A unique identifier for the contact
Field type	dimension
Data type	string.text.value

contact_full_name

Field label	Contact name
Description	The full name of the contact
Field type	dimension
Data type	string.text.value

contact_first_name

Field label	First name
Description	The contact's first name
Field type	dimension
Data type	string.text.value

contact_last_name

Field label	Last name
Description	The contact's last name
Field type	dimension
Data type	string.text.value

contact_title

Field label	Title
Description	The contact's job title or position
Field type	dimension
Data type	string.text.value

contact_email

Field label	Email
Description	The contact's primary email address
Field type	dimension
Data type	string.text.email

contact_secondary_email

Field label	Secondary email
Description	The contact's secondary email address
Field type	dimension
Data type	string.text.email

contact_phone

Field label	Phone
Description	The contact's primary phone number
Field type	dimension
Data type	string.text.phone

contact_home_phone

Field label	Home phone
Description	The contact's home phone number
Field type	dimension
Data type	string.text.phone

contact_other_phone

Field label	Other phone
Description	An alternative phone number associated with the contact
Field type	dimension
Data type	string.text.phone

contact_assistant_phone

Field label	Assistant phone
Description	The phone number of the contact's assistant
Field type	dimension
Data type	string.text.phone

contact_fax

Field label	Fax
Description	The contact's fax number
Field type	dimension
Data type	string.text.value

contact_mobile

Field label	Mobile
Description	The contact's mobile phone number
Field type	dimension
Data type	string.text.phone

contact_lead_source

Field label	Lead source
Description	The source from which the contact was generated (e.g., website, phone call)
Field type	dimension
Data type	string.text.value

contact_department

Field label	Department
Description	The department or team the contact belongs to
Field type	dimension
Data type	string.text.value

contact_date_of_birth

Field label	Date of birth
Description	The contact's birthday
Field type	dimension
Data type	string.time.date

contact_assistant

Field label	Assistant
Description	The name of the contact's assistant
Field type	dimension
Data type	string.text.value

contact_email_opt_out

Field label	Email opt out
Description	Indicates whether the contact has opted out of email communications
Field type	dimension
Data type	bool

contact_skype_id

Field label	Skype ID
Description	The contact's Skype username
Field type	dimension
Data type	string.text.value

contact_salutation

Field label	Salutation
Description	The contact's salutation (e.g., Mr., Ms., Mrs.)
Field type	dimension
Data type	string.text.value

contact_twitter

Field label	X (Twitter)
Description	The contact's X (Twitter) username
Field type	dimension
Data type	string.text.value

contact_description

Field label	Description
Description	A general description of the contact or account
Field type	dimension
Data type	string.text.value

contact_tag

Field label	Tag
Description	A keyword or label associated with the contact
Field type	dimension
Data type	string.text.value

contact_locked__s

Field label	Locked
Description	Indicates whether the record is locked from editing
Field type	dimension
Data type	bool

contact_enrich_status__s

Field label	Enrich status
Description	The enrichment status of the contact (e.g., enriched, not enriched, failed)
Field type	dimension
Data type	string.text.value

contact_unsubscribed_mode

Field label	Unsubscribed mode
Description	Indicates whether the contact has unsubscribed from email communications
Field type	dimension
Data type	string.text.value

contact_mailing_street

Field label	Mailing street
Description	The street address where the contact resides or works
Field type	dimension
Data type	string.geo.street

contact_mailing_city

Field label	Mailing city
Description	The city where the contact resides or works
Field type	dimension
Data type	string.geo.city

contact_mailing_state

Field label	Mailing state
Description	The state or province where the contact resides or works
Field type	dimension
Data type	string.geo.region

contact_mailing_zip

Field label	Mailing zip
Description	The ZIP or postal code where the contact resides or works
Field type	dimension
Data type	string.geo.zip

contact_mailing_country

Field label	Mailing country
Description	The country where the contact resides or works
Field type	dimension
Data type	string.geo.country

contact_other_street

Field label	Other street
Description	An alternative street address associated with the contact
Field type	dimension
Data type	string.geo.street

contact_other_city

Field label	Other city
Description	An alternative city associated with the contact
Field type	dimension
Data type	string.geo.city

contact_other_state

Field label	Other state
Description	An alternative state or province associated with the contact
Field type	dimension
Data type	string.geo.region

contact_other_zip

Field label	Other zip
Description	An alternative ZIP or postal code associated with the contact
Field type	dimension
Data type	string.geo.zip

contact_other_country

Field label	Other country
Description	An alternative country associated with the contact
Field type	dimension
Data type	string.geo.country

contacts

Field label	Contacts
Description	Number of contacts
Field type	metric
Data type	int.number.value

DATASOURCE

dataSourceName

Field label	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value
Destinations	API, Data warehouse

system_metadata.data_source_logins

Field label	Data source logins
Description	The data source login accounts that were used to authenticate against the data source
Field type	dimension
Data type	string.text.json

system_metadata.data_source_login_owners

Field label	Data source login owners
Description	The Supermetrics users that created the data source login connections
Field type	dimension
Data type	string.text.json

DEAL

deal_id

Field label	Deal ID
Description	Unique identifier for the deal record
Field type	dimension
Data type	string.text.value

deal_name

Field label	Deal name
Description	The name of the deal
Field type	dimension
Data type	string.text.value

deal_description

Field label	Deal description
Description	A detailed description of the deal
Field type	dimension
Data type	string.text.value

deal_tag

Field label	Deal tag
Description	A tag assigned to the deal for categorization
Field type	dimension
Data type	string.text.value

deal_locked

Field label	Deal locked
Description	Indicates whether the deal record is locked
Field type	dimension
Data type	bool

deal_stage

Field label	Deal stage
Description	The current stage of the deal in the sales pipeline
Field type	dimension
Data type	string.text.value

deal_type

Field label	Deal type
Description	The type of deal
Field type	dimension
Data type	string.text.value

deal_lead_source

Field label	Deal lead source
Description	The source from which the lead originated
Field type	dimension
Data type	string.text.value

deal_reason_for_loss

Field label	Deal reason for loss
Description	The reason why the deal was lost if it's not closed
Field type	dimension
Data type	string.text.value

deal_next_step

Field label	Deal next step
Description	The next action planned for the deal
Field type	dimension
Data type	string.text.value

deal_record_status

Field label	Deal record status
Description	The current status of the deal record
Field type	dimension
Data type	string.text.value

deals

Field label	Deals
Description	The total number of deals
Field type	metric
Data type	int.number.value

amount

Field label	Deal amount
Description	The monetary value of the deal
Field type	metric
Data type	float.currency.value

probability

Field label	Deal probability (%)
Description	The probability of the deal closing successfully
Field type	metric
Data type	float.number.percentage

expected_revenue

Field label	Deal expected revenue
Description	The estimated revenue expected from the deal
Field type	metric
Data type	float.currency.value

lead_conversion_time

Field label	Deal lead conversion time
Description	Time elapsed between the lead creation date and the date the lead was converted to a contact
Field type	metric
Data type	int.number.value

overall_sales_duration

Field label	Deal overall sales duration
Description	The total time taken for the deal to reach its current stage
Field type	metric
Data type	int.number.value

sales_cycle_duration

Field label	Deal sales cycle duration
Description	The duration of the sales cycle for the deal
Field type	metric
Data type	int.number.value

LEAD

lead_id

Field label	Lead ID
Description	The unique identifier of the lead
Field type	dimension
Data type	string.text.value

lead_full_name

Field label	Lead name
Description	The full name of the lead
Field type	dimension
Data type	string.text.value

lead_first_name

Field label	Lead first name
Description	The first name of the lead
Field type	dimension
Data type	string.text.value

lead_last_name

Field label	Lead last name
Description	The last name of the lead
Field type	dimension
Data type	string.text.value

lead_designation

Field label	Lead title
Description	The title or job position of the lead
Field type	dimension
Data type	string.text.value

lead_company

Field label	Lead company
Description	The name of the company
Field type	dimension
Data type	string.text.value

lead_email

Field label	Lead email
Description	The primary email address of the lead or company
Field type	dimension
Data type	string.text.email

lead_secondary_email

Field label	Lead secondary email
Description	A secondary email address of the lead or company
Field type	dimension
Data type	string.text.email

lead_phone

Field label	Lead phone
Description	The phone number of the lead or company
Field type	dimension
Data type	string.text.phone

lead_fax

Field label	Lead fax
Description	The fax number of the lead or company
Field type	dimension
Data type	string.text.value

lead_mobile

Field label	Lead mobile
Description	The mobile phone number of the lead
Field type	dimension
Data type	string.text.phone

lead_website

Field label	Lead website
Description	The website of the lead or company
Field type	dimension
Data type	string.text.url

lead_source

Field label	Lead source
Description	The source from which the lead originated (e.g., website, email, phone)
Field type	dimension
Data type	string.text.value

lead_status

Field label	Lead status
Description	The current status of the lead (e.g., new, contacted, qualified)
Field type	dimension
Data type	string.text.value

lead_record_status

Field label	Lead record status
Description	The status of the record (e.g., active, inactive, deleted)
Field type	dimension
Data type	string.text.value

lead_industry

Field label	Lead industry
Description	The industry of the lead or company
Field type	dimension
Data type	string.text.value

lead_email_opt_out

Field label	Lead email opt out
Description	Indicates whether the lead has opted out of email communications
Field type	dimension
Data type	bool

lead_skype_id

Field label	Lead Skype ID
Description	The Skype ID of the lead or company
Field type	dimension
Data type	string.text.value

lead_salutation

Field label	Lead salutation
Description	The salutation to use when addressing the lead (e.g., Mr., Ms., Dr.)
Field type	dimension
Data type	string.text.value

lead_twitter

Field label	Lead Twitter
Description	The Twitter handle of the lead or company
Field type	dimension
Data type	string.text.value

lead_description

Field label	Lead description
Description	A detailed description of the lead or company
Field type	dimension
Data type	string.text.value

lead_rating

Field label	Lead rating
Description	A rating assigned to the lead
Field type	dimension
Data type	string.text.value

lead_tag

Field label	Lead tag
Description	A tag or label associated with the lead
Field type	dimension
Data type	string.text.value

lead_locked

Field label	Lead locked
Description	Indicates whether the lead is locked from editing
Field type	dimension
Data type	bool

lead_converted

Field label	Lead is converted
Description	Indicates whether the lead has been converted into an account, contact, and deal
Field type	dimension
Data type	bool

lead_enrich_status

Field label	Lead enrich status
Description	The status of the enrichment process for the lead
Field type	dimension
Data type	string.text.value

lead_unsubscribed_mode

Field label	Lead unsubscribed mode
Description	The mode in which the lead is unsubscribed from email communications
Field type	dimension
Data type	string.text.value

lead_street

Field label	Lead street
Description	The street address of the lead or company
Field type	dimension
Data type	string.geo.street

lead_city

Field label	Lead city
Description	The city where the lead or company is located
Field type	dimension
Data type	string.geo.city

lead_state

Field label	Lead state
Description	The state or province where the lead or company is located
Field type	dimension
Data type	string.geo.region

lead_zip_code

Field label	Lead zip code
Description	The ZIP or postal code of the lead or company
Field type	dimension
Data type	string.geo.zip

lead_country

Field label	Lead country
Description	The country where the lead or company is located
Field type	dimension
Data type	string.geo.country

leads

Field label	Leads
Description	The total number of leads
Field type	metric
Data type	int.number.value

lead_annual_revenue

Field label	Lead annual revenue
Description	The estimated annual revenue of the lead or company
Field type	metric
Data type	float.currency.value

lead_no_of_employees

Field label	Lead employees
Description	The number of employees in the company
Field type	metric
Data type	int.number.value

OWNER

created_by_id

Field label	Created by ID
Description	The user ID who created the record
Field type	dimension
Data type	string.text.value

modified_by_id

Field label	Modified by ID
Description	The user ID who last modified the record
Field type	dimension
Data type	string.text.value

owner_id

Field label	Owner ID
Description	The user ID assigned as the owner of the record
Field type	dimension
Data type	string.text.value

QUERY

system_metadata.query_date_range_start

Field label	Start date
Description	The start date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_date_range_end

Field label	End date
Description	The end date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_timezone

Field label	Timezone
Description	The timezone that is supplied to the query
Field type	dimension
Data type	string.time.timezone

system_metadata.query_filters

Field label	Filters
Description	All filters used in the query
Field type	dimension
Data type	string.text.json

system_metadata.query_date_start

Field label	Start
Description	When the query was started
Field type	dimension
Data type	string.time.datetime

system_metadata.query_date_end

Field label	End
Description	When the query completed
Field type	dimension
Data type	string.time.datetime

system_metadata.query_duration

Field label	Duration
Description	The duration in seconds of the query
Field type	dimension
Data type	int.duration.seconds

system_metadata.query_accounts

Field label	Accounts
Description	A list of accounts of which the data was pulled from
Field type	dimension
Data type	string.text.json

RELATED OBJECT

converted_account_id

Field label	Converted account ID
Description	The account ID created when the lead is converted
Field type	dimension
Data type	string.text.value

converted_contact_id

Field label	Converted contact ID
Description	The contact ID created when the lead is converted
Field type	dimension
Data type	string.text.value

converted_deal_id

Field label	Converted deal ID
Description	The deal ID created when the lead is converted
Field type	dimension
Data type	string.text.value

campaign_source_id

Field label	Campaign source ID
Description	The campaign ID that led to this deal
Field type	dimension
Data type	string.text.value

reporting_to_id

Field label	Reporting to ID
Description	The unique identifier of the contact's supervisor or manager
Field type	dimension
Data type	string.text.value

vendor_id

Field label	Vendor name ID
Description	The unique identifier of the vendor associated with the contact
Field type	dimension
Data type	string.text.value

parent_account_id

Field label	Parent account ID
Description	The ID of the parent account.
Field type	dimension
Data type	string.text.value

TIME

today

Field label	Today
Description	Today's date, e.g. 2017-01-31
Field type	dimension
Data type	string.time.date
Destinations	API, Data warehouse

year

Field label	Year
Field type	dimension
Data type	string.time.year

year_of_week

Field label	Year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

year_of_week_iso

Field label	Year of week (Mon-Sun)
Field type	dimension
Data type	string.time.year

year_month

Field label	Year & month
Field type	dimension
Data type	string.time.yearmonth

month

Field label	Month
Field type	dimension
Data type	string.time.month

year_week

Field label	Year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

year_week_iso

Field label	Year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

week

Field label	Week (Sun-Sat)
Field type	dimension
Data type	string.time.week

week_iso

Field label	Week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

day_of_month

Field label	Day of month
Field type	dimension
Data type	string.time.dayofmonth

day_of_week_name

Field label	Day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

day_of_week_name_iso

Field label	Day of week (Mon-Sun)
Field type	dimension
Data type	string.time.dayofweekiso

date

Field label	Date
Field type	dimension
Data type	string.time.date

atom

Field label	Datetime
Field type	dimension
Data type	string.time.datetime

TIMESTAMP

created_date

Field label	Created date
Description	The date when the record was created
Field type	dimension
Data type	string.time.date

created_time

Field label	Created datetime
Description	The timestamp when the record was created
Field type	dimension
Data type	string.time.datetime

modified_date

Field label	Modified date
Description	The date of the last modification made to the record
Field type	dimension
Data type	string.time.date

modified_time

Field label	Modified datetime
Description	The timestamp of the last modification made to the record
Field type	dimension
Data type	string.time.datetime

last_activity_date

Field label	Last activity date
Description	The date of the last activity performed on the record
Field type	dimension
Data type	string.time.date

last_activity_time

Field label	Last activity datetime
Description	The timestamp of the last activity performed on the record
Field type	dimension
Data type	string.time.datetime

converted_date

Field label	Converted date
Description	The date when the lead was converted
Field type	dimension
Data type	string.time.date

converted_time

Field label	Converted datetime
Description	The timestamp when the lead was converted
Field type	dimension
Data type	string.time.datetime

unsubscribed_date

Field label	Unsubscribed date
Description	The date when the record unsubscribed from email communications
Field type	dimension
Data type	string.time.date

unsubscribed_time

Field label	Unsubscribed datetime
Description	The timestamp when the record unsubscribed from email communications
Field type	dimension
Data type	string.time.datetime

change_log_date

Field label	Change log date
Description	The date of the last modification made to the record
Field type	dimension
Data type	string.time.date

change_log_time

Field label	Change log datetime
Description	The timestamp of the last modification made to the record
Field type	dimension
Data type	string.time.datetime

last_enriched_date

Field label	Last enriched date
Description	The date of the last time the record's information was enriched
Field type	dimension
Data type	string.time.date

last_enriched_time

Field label	Last enriched datetime
Description	The timestamp of the last time the record's information was enriched
Field type	dimension
Data type	string.time.datetime

closing_date

Field label	Closing date
Description	The expected date when the deal will be closed
Field type	dimension
Data type	string.time.date

closing_time

Field label	Closing datetime
Description	The expected time when the deal will be closed
Field type	dimension
Data type	string.time.datetime