Zoho CRM data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: LEAD

change_log_date
Display name 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
Display name Change log datetime
Description The timestamp of the last modification made to the record
Field type dimension
Data type string.time.datetime
converted_account_id
Display name Converted account ID
Description The account ID created when the lead is converted
Field type dimension
Data type string.text.value
converted_contact_id
Display name Converted contact ID
Description The contact ID created when the lead is converted
Field type dimension
Data type string.text.value
converted_date
Display name Converted date
Description The date when the lead was converted
Field type dimension
Data type string.time.date
converted_deal_id
Display name Converted deal ID
Description The deal ID created when the lead is converted
Field type dimension
Data type string.text.value
converted_time
Display name Converted datetime
Description The timestamp when the lead was converted
Field type dimension
Data type string.time.datetime
created_by_id
Display name Created by ID
Description The user ID who created the record
Field type dimension
Data type string.text.value
created_date
Display name Created date
Description The date when the record was created
Field type dimension
Data type string.time.date
created_time
Display name Created datetime
Description The timestamp when the record was created
Field type dimension
Data type string.time.datetime
dataSourceName
Display name 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
date
Display name Date
Field type dimension
Data type string.time.date
last_activity_date
Display name 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
Display name Last activity datetime
Description The timestamp of the last activity performed on the record
Field type dimension
Data type string.time.datetime
last_enriched_date
Display name 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
Display name Last enriched datetime
Description The timestamp of the last time the record's information was enriched
Field type dimension
Data type string.time.datetime
lead_annual_revenue
Display name Lead annual revenue
Description The estimated annual revenue of the lead or company
Field type metric
Data type float.currency.value
lead_city
Display name Lead city
Description The city where the lead or company is located
Field type dimension
Data type string.geo.city
lead_company
Display name Lead company
Description The name of the company
Field type dimension
Data type string.text.value
lead_converted
Display name Lead is converted
Description Indicates whether the lead has been converted into an account, contact, and deal
Field type dimension
Data type bool
lead_country
Display name Lead country
Description The country where the lead or company is located
Field type dimension
Data type string.geo.country
lead_description
Display name Lead description
Description A detailed description of the lead or company
Field type dimension
Data type string.text.value
lead_designation
Display name Lead title
Description The title or job position of the lead
Field type dimension
Data type string.text.value
lead_email
Display name Lead email
Description The primary email address of the lead or company
Field type dimension
Data type string.text.email
lead_email_opt_out
Display name Lead email opt out
Description Indicates whether the lead has opted out of email communications
Field type dimension
Data type bool
lead_enrich_status
Display name Lead enrich status
Description The status of the enrichment process for the lead
Field type dimension
Data type string.text.value
lead_fax
Display name Lead fax
Description The fax number of the lead or company
Field type dimension
Data type string.text.value
lead_first_name
Display name Lead first name
Description The first name of the lead
Field type dimension
Data type string.text.value
lead_full_name
Display name Lead name
Description The full name of the lead
Field type dimension
Data type string.text.value
lead_id
Display name Lead ID
Description The unique identifier of the lead
Field type dimension
Data type string.text.value
lead_industry
Display name Lead industry
Description The industry of the lead or company
Field type dimension
Data type string.text.value
lead_last_name
Display name Lead last name
Description The last name of the lead
Field type dimension
Data type string.text.value
lead_locked
Display name Lead locked
Description Indicates whether the lead is locked from editing
Field type dimension
Data type bool
lead_mobile
Display name Lead mobile
Description The mobile phone number of the lead
Field type dimension
Data type string.text.phone
lead_no_of_employees
Display name Lead employees
Description The number of employees in the company
Field type metric
Data type int.number.value
lead_phone
Display name Lead phone
Description The phone number of the lead or company
Field type dimension
Data type string.text.phone
lead_rating
Display name Lead rating
Description A rating assigned to the lead
Field type dimension
Data type string.text.value
lead_record_status
Display name Lead record status
Description The status of the record (e.g., active, inactive, deleted)
Field type dimension
Data type string.text.value
lead_salutation
Display name 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_secondary_email
Display name Lead secondary email
Description A secondary email address of the lead or company
Field type dimension
Data type string.text.email
lead_skype_id
Display name Lead Skype ID
Description The Skype ID of the lead or company
Field type dimension
Data type string.text.value
lead_source
Display name Lead source
Description The source from which the lead originated (e.g., website, email, phone)
Field type dimension
Data type string.text.value
lead_state
Display name Lead state
Description The state or province where the lead or company is located
Field type dimension
Data type string.geo.region
lead_status
Display name Lead status
Description The current status of the lead (e.g., new, contacted, qualified)
Field type dimension
Data type string.text.value
lead_street
Display name Lead street
Description The street address of the lead or company
Field type dimension
Data type string.geo.street
lead_tag
Display name Lead tag
Description A tag or label associated with the lead
Field type dimension
Data type string.text.value
lead_twitter
Display name Lead Twitter
Description The Twitter handle of the lead or company
Field type dimension
Data type string.text.value
lead_unsubscribed_mode
Display name Lead unsubscribed mode
Description The mode in which the lead is unsubscribed from email communications
Field type dimension
Data type string.text.value
lead_website
Display name Lead website
Description The website of the lead or company
Field type dimension
Data type string.text.url
lead_zip_code
Display name Lead zip code
Description The ZIP or postal code of the lead or company
Field type dimension
Data type string.geo.zip
modified_by_id
Display name Modified by ID
Description The user ID who last modified the record
Field type dimension
Data type string.text.value
modified_date
Display name Modified date
Description The date of the last modification made to the record
Field type dimension
Data type string.time.date
modified_time
Display name Modified datetime
Description The timestamp of the last modification made to the record
Field type dimension
Data type string.time.datetime
owner_id
Display name Owner ID
Description The user ID assigned as the owner of the record
Field type dimension
Data type string.text.value
unsubscribed_date
Display name Unsubscribed date
Description The date when the record unsubscribed from email communications
Field type dimension
Data type string.time.date
unsubscribed_time
Display name Unsubscribed datetime
Description The timestamp when the record unsubscribed from email communications
Field type dimension
Data type string.time.datetime

Table: DEAL

account_id
Display name Account ID
Description The unique identifier of the account
Field type dimension
Data type string.text.value
amount
Display name Deal amount
Description The monetary value of the deal
Field type metric
Data type float.currency.value
campaign_source_id
Display name Campaign source ID
Description The campaign ID that led to this deal
Field type dimension
Data type string.text.value
change_log_date
Display name 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
Display name Change log datetime
Description The timestamp of the last modification made to the record
Field type dimension
Data type string.time.datetime
closing_date
Display name Closing date
Description The expected date when the deal will be closed
Field type dimension
Data type string.time.date
closing_time
Display name Closing datetime
Description The expected time when the deal will be closed
Field type dimension
Data type string.time.datetime
contact_id
Display name Contact ID
Description A unique identifier for the contact
Field type dimension
Data type string.text.value
created_by_id
Display name Created by ID
Description The user ID who created the record
Field type dimension
Data type string.text.value
created_date
Display name Created date
Description The date when the record was created
Field type dimension
Data type string.time.date
created_time
Display name Created datetime
Description The timestamp when the record was created
Field type dimension
Data type string.time.datetime
dataSourceName
Display name 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
date
Display name Date
Field type dimension
Data type string.time.date
deal_description
Display name Deal description
Description A detailed description of the deal
Field type dimension
Data type string.text.value
deal_id
Display name Deal ID
Description Unique identifier for the deal record
Field type dimension
Data type string.text.value
deal_lead_source
Display name Deal lead source
Description The source from which the lead originated
Field type dimension
Data type string.text.value
deal_locked
Display name Deal locked
Description Indicates whether the deal record is locked
Field type dimension
Data type bool
deal_name
Display name Deal name
Description The name of the deal
Field type dimension
Data type string.text.value
deal_next_step
Display name Deal next step
Description The next action planned for the deal
Field type dimension
Data type string.text.value
deal_reason_for_loss
Display name 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_record_status
Display name Deal record status
Description The current status of the deal record
Field type dimension
Data type string.text.value
deal_stage
Display name Deal stage
Description The current stage of the deal in the sales pipeline
Field type dimension
Data type string.text.value
deal_tag
Display name Deal tag
Description A tag assigned to the deal for categorization
Field type dimension
Data type string.text.value
deal_type
Display name Deal type
Description The type of deal
Field type dimension
Data type string.text.value
expected_revenue
Display name Deal expected revenue
Description The estimated revenue expected from the deal
Field type metric
Data type float.currency.value
last_activity_date
Display name 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
Display name Last activity datetime
Description The timestamp of the last activity performed on the record
Field type dimension
Data type string.time.datetime
lead_conversion_time
Display name 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
modified_by_id
Display name Modified by ID
Description The user ID who last modified the record
Field type dimension
Data type string.text.value
modified_date
Display name Modified date
Description The date of the last modification made to the record
Field type dimension
Data type string.time.date
modified_time
Display name Modified datetime
Description The timestamp of the last modification made to the record
Field type dimension
Data type string.time.datetime
overall_sales_duration
Display name 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
owner_id
Display name Owner ID
Description The user ID assigned as the owner of the record
Field type dimension
Data type string.text.value
probability
Display name Deal probability (%)
Description The probability of the deal closing successfully
Field type metric
Data type float.number.percentage
sales_cycle_duration
Display name Deal sales cycle duration
Description The duration of the sales cycle for the deal
Field type metric
Data type int.number.value