Salesforce data warehouse table groups

  • Updated on Sep 18, 2025
  • Published on Aug 5, 2025
Prev Next

Table: LEAD

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_closed
Display name Closed date
Field type dimension
Data type string.time.date
date_created
Display name Date
Field type dimension
Data type string.time.date
lead_company
Display name Company
Description The company of the lead
Field type dimension
Data type string.text.value
lead_count
Display name Leads
Description Total number of leads
Field type metric
Data type int.number.value
lead_email
Display name Lead email
Description The email of the lead
Field type dimension
Data type string.text.email
lead_firstname
Display name Lead first name
Description The first name of the lead
Field type dimension
Data type string.text.value
lead_last_activity_date
Display name Lead last activity date
Description The last activity date of the lead
Field type dimension
Data type string.text.value
lead_lastname
Display name Lead last name
Description The last name of the lead
Field type dimension
Data type string.text.value
lead_phone
Display name Lead phone
Description The phone number of the lead
Field type dimension
Data type string.text.phone
lead_source
Display name Lead source
Description The source of lead
Field type dimension
Data type string.text.value
lead_status
Display name Lead status
Description The status of the lead
Field type dimension
Data type string.text.value
lead_title
Display name Lead title
Description The title of the lead
Field type dimension
Data type string.text.value
organization_name
Display name Organization name
Field type dimension
Data type string.text.value

Table: OPPORTUNITY

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_closed
Display name Closed date
Field type dimension
Data type string.time.date
date_created
Display name Date
Field type dimension
Data type string.time.date
opportunity_account_description
Display name Opportunity account description
Description The description of the opportunity account
Field type dimension
Data type string.text.value
opportunity_account_employee_count
Display name Opportunity account employee count
Description The employee count of the opportunity account
Field type dimension
Data type int.number.value
opportunity_account_industry
Display name Opportunity account industry
Description The industry of the opportunity account
Field type dimension
Data type string.text.value
opportunity_account_name
Display name Opportunity account name
Description Customer of the opportunity
Field type dimension
Data type string.text.value
opportunity_account_phone
Display name Opportunity account phone
Description The phone number of the opportunity account
Field type dimension
Data type string.text.phone
opportunity_amount
Display name Amount
Description The value of the opportunity
Field type metric
Data type float.currency.value
opportunity_amount_closed_won
Display name Amount won
Description The value of the won opportunities
Field type metric
Data type float.currency.value
opportunity_avg_per_closed
Display name Avg. amount per closed opportunity
Description Average value of an opportunity
Field type metric
Data type float.currency.value
opportunity_close_date
Display name Opportunity close date
Description The close date of the opportunity
Field type dimension
Data type string.time.date
opportunity_count
Display name Opportunity count
Description Total amount of opportunities
Field type metric
Data type int.number.value
opportunity_created_date
Display name Opportunity created date
Description The date when the opportunity was created
Field type dimension
Data type string.time.date
opportunity_description
Display name Opportunity description
Description The description for the opportunity
Field type dimension
Data type string.text.value
opportunity_forecast_category
Display name Forecast category
Description The forecast category for the opportunity
Field type dimension
Data type string.text.value
opportunity_forecast_category_name
Display name Forecast category name
Description The forecast category name for the opportunity
Field type dimension
Data type string.text.value
opportunity_has_line_item
Display name Has line item
Description Whether or not the opportunity has a line item
Field type dimension
Data type bool
opportunity_has_open_activity
Display name Has open activity
Description Whether or not the opportunity has open activity
Field type dimension
Data type bool
opportunity_has_overdue_task
Display name Has overdue task
Description Whether or not the opportunity has overdue tasks
Field type dimension
Data type bool
opportunity_id
Display name Opportunity ID
Description The ID of the opportunity
Field type dimension
Data type string.text.value
opportunity_is_closed
Display name Is opportunity closed
Description Whether or not the opportunity is closed
Field type dimension
Data type bool
opportunity_is_won
Display name Is opportunity won
Description Whether or not the opportunity is won
Field type dimension
Data type bool
opportunity_last_activity_date
Display name Opportunity last activity date
Description The date of the last activity for the opportunity
Field type dimension
Data type string.time.date
opportunity_last_modified_date
Display name Opportunity last modified date
Description The date when the opportunity was last modified
Field type dimension
Data type string.time.date
opportunity_last_referenced_date
Display name Opportunity last referenced date
Description The date when the opportunity was last referenced
Field type dimension
Data type string.time.date
opportunity_last_viewed_date
Display name Opportunity last viewed date
Description The date when the opportunity was last viewed
Field type dimension
Data type string.time.date
opportunity_lead_source
Display name Opportunity lead source
Description The lead source for the opportunity
Field type dimension
Data type string.text.value
opportunity_name
Display name Opportunity name
Description The name of the opportunity
Field type dimension
Data type string.text.value
opportunity_next_step
Display name Opportunity next step
Description The next step for the opportunity
Field type dimension
Data type string.text.value
opportunity_owner
Display name Opportunity owner
Description Owner of the opportunity
Field type dimension
Data type string.text.value
opportunity_probability
Display name Probability (%)
Description The probability for the opportunity
Field type dimension
Data type float.number.percentage
opportunity_stage_name
Display name Opportunity stage
Description The stage of the opportunity
Field type dimension
Data type string.text.value
opportunity_type
Display name Opportunity type
Description The type of the opportunity
Field type dimension
Data type string.text.value
organization_name
Display name Organization name
Field type dimension
Data type string.text.value