Skip to main content

Documentation Index

Fetch the complete documentation index at: https://support.detrics.io/llms.txt

Use this file to discover all available pages before exploring further.

Last updated: May 28, 2026
329 dimensions
48 metrics
This reference covers all available dimensions and metrics for Salesforce data through Detrics. Use this guide to understand what data you can extract and how to structure your queries.
Supported destinations:
Google Sheets

​
Dimensions

Dimensions are the attributes you can use to segment and group your Salesforce data.

​
Account

Account ID
Unique 18-character Salesforce ID for the account

Field Name: accountId
Type: dimension
Account Name
Name of the account (company)

Field Name: accountName
Type: dimension
Account Type
Picklist categorising the account (e.g. Customer, Prospect, Partner)

Field Name: accountType
Type: dimension
Account Industry
Industry the account operates in

Field Name: accountIndustry
Type: dimension
Account Rating
Rating picklist (Hot/Warm/Cold)

Field Name: accountRating
Type: dimension
Account Ownership
Ownership type (Public/Private/Subsidiary)

Field Name: accountOwnership
Type: dimension
Account Website
Account website URL

Field Name: accountWebsite
Type: dimension
Account Phone
Main phone number for the account

Field Name: accountPhone
Type: dimension
Account Fax
Fax number for the account

Field Name: accountFax
Type: dimension
Account Number
External account number (free-text identifier)

Field Name: accountAccountNumber
Type: dimension
Account Billing City
Billing-address city

Field Name: accountBillingCity
Type: dimension
Account Billing State
Billing-address state or province

Field Name: accountBillingState
Type: dimension
Account Billing Country
Billing-address country

Field Name: accountBillingCountry
Type: dimension
Account Billing Postal Code
Billing-address postal/ZIP code

Field Name: accountBillingPostalCode
Type: dimension
Account Billing Street
Billing-address street

Field Name: accountBillingStreet
Type: dimension
Account Shipping City
Shipping-address city

Field Name: accountShippingCity
Type: dimension
Account Shipping Country
Shipping-address country

Field Name: accountShippingCountry
Type: dimension
Account Owner ID
Salesforce User ID of the account owner

Field Name: accountOwnerId
Type: dimension
Account Owner Name
Full name of the user who owns the account

Field Name: accountOwnerName
Type: dimension
Account Parent ID
Parent account ID (for account hierarchies)

Field Name: accountParentId
Type: dimension
Account Parent Name
Parent account name

Field Name: accountParentName
Type: dimension
Account Created Date
Date the account was created

Field Name: accountCreatedDate
Type: dimension
Account Last Modified Date
Date the account was last edited

Field Name: accountLastModifiedDate
Type: dimension
Account Last Activity Date
Date of the most recent activity (task/event) on the account

Field Name: accountLastActivityDate
Type: dimension
Account Description
Free-text description of the account

Field Name: accountDescription
Type: dimension

​
Contact

Contact ID
Unique 18-character ID for the contact

Field Name: contactId
Type: dimension
Contact Salutation
Salutation prefix (e.g., Mr., Ms., Dr.)

Field Name: contactSalutation
Type: dimension
Contact First Name
First name of the contact

Field Name: contactFirstName
Type: dimension
Contact Last Name
Last name of the contact

Field Name: contactLastName
Type: dimension
Contact Full Name
Salesforce-computed full name (first + last)

Field Name: contactFullName
Type: dimension
Contact Email
Primary email address of the contact

Field Name: contactEmail
Type: dimension
Contact Phone
Primary phone of the contact

Field Name: contactPhone
Type: dimension
Contact Mobile Phone
Mobile phone of the contact

Field Name: contactMobilePhone
Type: dimension
Contact Title
Job title of the contact

Field Name: contactTitle
Type: dimension
Contact Department
Department within the company

Field Name: contactDepartment
Type: dimension
Contact Lead Source
Original source the contact came from (Web/Referral/etc.)

Field Name: contactLeadSource
Type: dimension
Contact Mailing City
City of the mailing address

Field Name: contactMailingCity
Type: dimension
Contact Mailing State
State of the mailing address

Field Name: contactMailingState
Type: dimension
Contact Mailing Country
Country of the mailing address

Field Name: contactMailingCountry
Type: dimension
Contact Mailing Postal Code
Postal/ZIP code of the mailing address

Field Name: contactMailingPostalCode
Type: dimension
Contact Account ID
ID of the account this contact belongs to

Field Name: contactAccountId
Type: dimension
Contact Account Name
Name of the account this contact belongs to

Field Name: contactAccountName
Type: dimension
Contact Owner ID
User ID of the contact owner

Field Name: contactOwnerId
Type: dimension
Contact Owner Name
Full name of the contact owner

Field Name: contactOwnerName
Type: dimension
Contact Created Date
Date the contact was created

Field Name: contactCreatedDate
Type: dimension
Contact Last Modified Date
Date the contact was last edited

Field Name: contactLastModifiedDate
Type: dimension
Contact Last Activity Date
Date of the most recent activity on the contact

Field Name: contactLastActivityDate
Type: dimension
Contact Birthdate
Birthdate of the contact

Field Name: contactBirthdate
Type: dimension
Contact Description
Free-text description of the contact

Field Name: contactDescription
Type: dimension
Contact Fax
Fax number of the contact

Field Name: contactFax
Type: dimension
Contact Home Phone
Home phone of the contact

Field Name: contactHomePhone
Type: dimension
Contact Other Phone
Other phone of the contact

Field Name: contactOtherPhone
Type: dimension
Contact Pronouns
Pronouns of the contact (feature must be enabled in org)

Field Name: contactPronouns
Type: dimension
Contact Gender Identity
Gender identity of the contact (feature must be enabled in org)

Field Name: contactGenderIdentity
Type: dimension

​
Lead

Lead ID
Unique 18-character ID for the lead

Field Name: leadId
Type: dimension
Lead Salutation
Salutation prefix (e.g., Mr., Ms., Dr.)

Field Name: leadSalutation
Type: dimension
Lead First Name
First name of the lead

Field Name: leadFirstName
Type: dimension
Lead Last Name
Last name of the lead

Field Name: leadLastName
Type: dimension
Lead Name
Salesforce-computed full name of the lead

Field Name: leadName
Type: dimension
Lead Email
Email address of the lead

Field Name: leadEmail
Type: dimension
Lead Phone
Phone number of the lead

Field Name: leadPhone
Type: dimension
Lead Company
Company name attached to the lead

Field Name: leadCompany
Type: dimension
Lead Title
Job title of the lead

Field Name: leadTitle
Type: dimension
Lead Status
Current status in the lead funnel (Open/Working/Converted/etc.)

Field Name: leadStatus
Type: dimension
Lead Source
Source the lead originated from

Field Name: leadSource
Type: dimension
Lead Industry
Industry of the lead

Field Name: leadIndustry
Type: dimension
Lead Rating
Rating (Hot/Warm/Cold)

Field Name: leadRating
Type: dimension
Lead Country
Country of the lead

Field Name: leadCountry
Type: dimension
Lead City
City of the lead

Field Name: leadCity
Type: dimension
Lead State
State of the lead

Field Name: leadState
Type: dimension
Lead Owner ID
User ID of the lead owner

Field Name: leadOwnerId
Type: dimension
Lead Owner Name
Full name of the lead owner

Field Name: leadOwnerName
Type: dimension
Lead Is Converted
Whether the lead has been converted to a contact/opportunity

Field Name: leadIsConverted
Type: dimension
Lead Converted Date
Date the lead was converted

Field Name: leadConvertedDate
Type: dimension
Lead Created Date
Date the lead was created

Field Name: leadCreatedDate
Type: dimension
Lead Last Modified Date
Date the lead was last edited

Field Name: leadLastModifiedDate
Type: dimension
Lead Converted Account ID
Account ID created when the lead was converted

Field Name: leadConvertedAccountId
Type: dimension
Lead Converted Account Name
Name of the account created on conversion

Field Name: leadConvertedAccountName
Type: dimension
Lead Converted Contact ID
Contact ID created when the lead was converted

Field Name: leadConvertedContactId
Type: dimension
Lead Converted Contact Name
Name of the contact created on conversion

Field Name: leadConvertedContactName
Type: dimension
Lead Converted Opportunity ID
Opportunity ID created when the lead was converted

Field Name: leadConvertedOpportunityId
Type: dimension
Lead Converted Opportunity Name
Name of the opportunity created on conversion

Field Name: leadConvertedOpportunityName
Type: dimension
Lead Description
Free-text description of the lead

Field Name: leadDescription
Type: dimension
Lead Has Opted Out Of Email
True if the lead has opted out of email communications

Field Name: leadHasOptedOutOfEmail
Type: dimension
Lead Pronouns
Pronouns of the lead (feature must be enabled in org)

Field Name: leadPronouns
Type: dimension
Lead Gender Identity
Gender identity of the lead (feature must be enabled in org)

Field Name: leadGenderIdentity
Type: dimension

​
Opportunity

Opportunity ID
Unique 18-character ID for the opportunity

Field Name: opportunityId
Type: dimension
Opportunity Name
Name of the opportunity (deal)

Field Name: opportunityName
Type: dimension
Opportunity Stage Name
Current stage in the sales pipeline

Field Name: opportunityStageName
Type: dimension
Opportunity Type
Type of opportunity (New Business/Existing Customer/etc.)

Field Name: opportunityType
Type: dimension
Opportunity Lead Source
Source that generated the opportunity

Field Name: opportunityLeadSource
Type: dimension
Opportunity Next Step
Description of the next planned step

Field Name: opportunityNextStep
Type: dimension
Opportunity Description
Free-text description of the opportunity

Field Name: opportunityDescription
Type: dimension
Opportunity Campaign ID
ID of the primary campaign source for this opportunity

Field Name: opportunityCampaignId
Type: dimension
Opportunity Campaign Name
Name of the primary campaign source

Field Name: opportunityCampaignName
Type: dimension
Opportunity Account ID
ID of the account this opportunity belongs to

Field Name: opportunityAccountId
Type: dimension
Opportunity Account Name
Name of the account this opportunity belongs to

Field Name: opportunityAccountName
Type: dimension
Opportunity Contact ID
ID of the primary contact on the opportunity

Field Name: opportunityContactId
Type: dimension
Opportunity Contact Name
Name of the primary contact on the opportunity

Field Name: opportunityContactName
Type: dimension
Opportunity Pricebook ID
ID of the pricebook used for line items

Field Name: opportunityPricebookId
Type: dimension
Opportunity Owner ID
User ID of the opportunity owner

Field Name: opportunityOwnerId
Type: dimension
Opportunity Owner Name
Full name of the opportunity owner

Field Name: opportunityOwnerName
Type: dimension
Opportunity Record Type ID
Record Type ID assigned to this opportunity

Field Name: opportunityRecordTypeId
Type: dimension
Opportunity Record Type Name
Name of the Record Type assigned to this opportunity

Field Name: opportunityRecordTypeName
Type: dimension
Opportunity Forecast Category Name
Forecast category (Pipeline/Best Case/Commit/Closed)

Field Name: opportunityForecastCategoryName
Type: dimension
Opportunity Is Closed
True when the opportunity is in a closed stage (won or lost)

Field Name: opportunityIsClosed
Type: dimension
Opportunity Is Won
True when the opportunity is in a closed-won stage

Field Name: opportunityIsWon
Type: dimension
Opportunity Has Open Activity
True when the opportunity has at least one open task/event

Field Name: opportunityHasOpenActivity
Type: dimension
Opportunity Created Date
Date the opportunity was created

Field Name: opportunityCreatedDate
Type: dimension
Opportunity Close Date
Expected (or actual) close date

Field Name: opportunityCloseDate
Type: dimension
Opportunity Last Stage Change Date
Timestamp when the opportunity stage last changed

Field Name: opportunityLastStageChangeDate
Type: dimension
Opportunity Last Modified Date
Date the opportunity was last edited

Field Name: opportunityLastModifiedDate
Type: dimension
Opportunity Last Activity Date
Date of the most recent activity on the opportunity

Field Name: opportunityLastActivityDate
Type: dimension

​
Case

Case ID
Unique 18-character ID for the case

Field Name: caseId
Type: dimension
Case Number
Auto-incrementing case number visible to users

Field Name: caseNumber
Type: dimension
Case Subject
Subject line of the case

Field Name: caseSubject
Type: dimension
Case Status
Current status of the case

Field Name: caseStatus
Type: dimension
Case Priority
Priority of the case (High/Medium/Low)

Field Name: casePriority
Type: dimension
Case Origin
Channel the case originated from (Web/Email/Phone/etc.)

Field Name: caseOrigin
Type: dimension
Case Type
Type categorisation

Field Name: caseType
Type: dimension
Case Reason
Reason the case was opened

Field Name: caseReason
Type: dimension
Case Description
Free-text description of the case

Field Name: caseDescription
Type: dimension
Case Account ID
ID of the account associated with the case

Field Name: caseAccountId
Type: dimension
Case Account Name
Name of the account associated with the case

Field Name: caseAccountName
Type: dimension
Case Contact ID
ID of the primary contact on the case

Field Name: caseContactId
Type: dimension
Case Contact Name
Name of the primary contact on the case

Field Name: caseContactName
Type: dimension
Case Owner ID
User/Queue ID owning the case

Field Name: caseOwnerId
Type: dimension
Case Owner Name
Name of the user/queue owning the case

Field Name: caseOwnerName
Type: dimension
Case Record Type ID
Record Type ID assigned to this case

Field Name: caseRecordTypeId
Type: dimension
Case Record Type Name
Name of the Record Type assigned to this case

Field Name: caseRecordTypeName
Type: dimension
Case Supplied Name
Name supplied by the user via Web-to-Case / Email-to-Case

Field Name: caseSuppliedName
Type: dimension
Case Supplied Email
Email supplied by the user via Web-to-Case / Email-to-Case

Field Name: caseSuppliedEmail
Type: dimension
Case Supplied Phone
Phone supplied by the user via Web-to-Case

Field Name: caseSuppliedPhone
Type: dimension
Case Supplied Company
Company supplied by the user via Web-to-Case

Field Name: caseSuppliedCompany
Type: dimension
Case Is Closed
True when the case status is closed

Field Name: caseIsClosed
Type: dimension
Case Is Escalated
True when the case has been escalated

Field Name: caseIsEscalated
Type: dimension
Case Created Date
Date the case was created

Field Name: caseCreatedDate
Type: dimension
Case Closed Date
Date the case was closed

Field Name: caseClosedDate
Type: dimension
Case Last Modified Date
Date the case was last edited

Field Name: caseLastModifiedDate
Type: dimension

​
Campaign

Campaign ID
Unique 18-character ID for the campaign

Field Name: campaignId
Type: dimension
Campaign Name
Name of the campaign

Field Name: campaignName
Type: dimension
Campaign Type
Campaign type (Email/Event/Webinar/etc.)

Field Name: campaignType
Type: dimension
Campaign Status
Campaign status (Planned/In Progress/Completed/Aborted)

Field Name: campaignStatus
Type: dimension
Campaign Description
Free-text description of the campaign

Field Name: campaignDescription
Type: dimension
Campaign Parent ID
Parent campaign ID (campaign hierarchies)

Field Name: campaignParentId
Type: dimension
Campaign Parent Name
Parent campaign name

Field Name: campaignParentName
Type: dimension
Campaign Owner ID
User ID of the campaign owner

Field Name: campaignOwnerId
Type: dimension
Campaign Owner Name
Full name of the campaign owner

Field Name: campaignOwnerName
Type: dimension
Campaign Is Active
Whether the campaign is active

Field Name: campaignIsActive
Type: dimension
Campaign Start Date
Planned start date of the campaign

Field Name: campaignStartDate
Type: dimension
Campaign End Date
Planned end date of the campaign

Field Name: campaignEndDate
Type: dimension
Campaign Created Date
Date the campaign was created

Field Name: campaignCreatedDate
Type: dimension
Campaign Last Modified Date
Date the campaign was last edited

Field Name: campaignLastModifiedDate
Type: dimension

​
Task

Task ID
Unique 18-character ID for the task

Field Name: taskId
Type: dimension
Task Subject
Subject of the task

Field Name: taskSubject
Type: dimension
Task Status
Current status of the task

Field Name: taskStatus
Type: dimension
Task Priority
Priority of the task

Field Name: taskPriority
Type: dimension
Task Type
Task subtype (Task/Call/Email/etc.)

Field Name: taskType
Type: dimension
Task Description
Free-text description of the task

Field Name: taskDescription
Type: dimension
Task Who ID
Polymorphic ID — Lead or Contact the task relates to

Field Name: taskWhoId
Type: dimension
Task What ID
Polymorphic ID — Account/Opportunity/Case/etc. the task relates to

Field Name: taskWhatId
Type: dimension
Task Account ID
Account ID derived from the WhatId or contact relationship

Field Name: taskAccountId
Type: dimension
Task Account Name
Account name derived from the task relationship

Field Name: taskAccountName
Type: dimension
Task Owner ID
User ID of the task owner

Field Name: taskOwnerId
Type: dimension
Task Owner Name
Full name of the task owner

Field Name: taskOwnerName
Type: dimension
Task Is Closed
True when the task is in a closed status

Field Name: taskIsClosed
Type: dimension
Task Activity Date
Due date of the task

Field Name: taskActivityDate
Type: dimension
Task Completed Date Time
Timestamp the task was completed

Field Name: taskCompletedDateTime
Type: dimension
Task Created Date
Date the task was created

Field Name: taskCreatedDate
Type: dimension
Task Is Recurrence
True when the task is part of a recurring series

Field Name: taskIsRecurrence
Type: dimension
Task Recurrence Start Date
Start date of the recurring series

Field Name: taskRecurrenceStartDateOnly
Type: dimension
Task Recurrence End Date
End date of the recurring series

Field Name: taskRecurrenceEndDateOnly
Type: dimension
Task Recurrence Time Zone
IANA timezone key for the recurring series

Field Name: taskRecurrenceTimeZoneSidKey
Type: dimension
Task Recurrence Type
Recurrence pattern type (Daily/Weekly/Monthly/Yearly)

Field Name: taskRecurrenceType
Type: dimension
Task Recurrence Interval
Interval between recurrences (e.g., every N days/weeks)

Field Name: taskRecurrenceInterval
Type: dimension
Task Recurrence Day Of Week Mask
Bitmask of selected weekdays for weekly recurrences

Field Name: taskRecurrenceDayOfWeekMask
Type: dimension
Task Recurrence Day Of Month
Day of month for monthly recurrences

Field Name: taskRecurrenceDayOfMonth
Type: dimension
Task Recurrence Instance
Which occurrence within the month (First/Second/Third/Fourth/Last)

Field Name: taskRecurrenceInstance
Type: dimension
Task Recurrence Month Of Year
Month of year for yearly recurrences

Field Name: taskRecurrenceMonthOfYear
Type: dimension
Task Recurrence Regenerated Type
Whether the next task is regenerated after completion

Field Name: taskRecurrenceRegeneratedType
Type: dimension

​
Event

Event ID
Unique 18-character ID for the event

Field Name: eventId
Type: dimension
Event Subject
Subject of the event (meeting)

Field Name: eventSubject
Type: dimension
Event Description
Free-text description of the event

Field Name: eventDescription
Type: dimension
Event Location
Location of the event (e.g., Zoom, room name, city)

Field Name: eventLocation
Type: dimension
Event Type
Event subtype

Field Name: eventType
Type: dimension
Event Who ID
Polymorphic ID — Lead or Contact the event relates to

Field Name: eventWhoId
Type: dimension
Event What ID
Polymorphic ID — Account/Opportunity/etc. the event relates to

Field Name: eventWhatId
Type: dimension
Event Account ID
Account ID derived from the event relationship

Field Name: eventAccountId
Type: dimension
Event Account Name
Account name derived from the event relationship

Field Name: eventAccountName
Type: dimension
Event Owner ID
User ID of the event owner

Field Name: eventOwnerId
Type: dimension
Event Owner Name
Full name of the event owner

Field Name: eventOwnerName
Type: dimension
Event Is All Day Event
True for all-day events (no specific start time)

Field Name: eventIsAllDayEvent
Type: dimension
Event Start Date Time
Event start timestamp

Field Name: eventStartDateTime
Type: dimension
Event End Date Time
Event end timestamp

Field Name: eventEndDateTime
Type: dimension
Event Activity Date Time
Activity timestamp (computed by Salesforce from start time)

Field Name: eventActivityDateTime
Type: dimension
Event Created Date
Date the event was created

Field Name: eventCreatedDate
Type: dimension
Event Is Recurrence
True when the event is part of a recurring series

Field Name: eventIsRecurrence
Type: dimension
Event Recurrence Start Date Time
Start timestamp of the recurring series

Field Name: eventRecurrenceStartDateTime
Type: dimension
Event Recurrence End Date
End date of the recurring series

Field Name: eventRecurrenceEndDateOnly
Type: dimension
Event Recurrence Time Zone
IANA timezone key for the recurring series

Field Name: eventRecurrenceTimeZoneSidKey
Type: dimension
Event Recurrence Type
Recurrence pattern type (Daily/Weekly/Monthly/Yearly)

Field Name: eventRecurrenceType
Type: dimension
Event Recurrence Interval
Interval between recurrences

Field Name: eventRecurrenceInterval
Type: dimension
Event Recurrence Day Of Week Mask
Bitmask of selected weekdays for weekly recurrences

Field Name: eventRecurrenceDayOfWeekMask
Type: dimension
Event Recurrence Day Of Month
Day of month for monthly recurrences

Field Name: eventRecurrenceDayOfMonth
Type: dimension
Event Recurrence Instance
Which occurrence within the month (First/Second/Third/Fourth/Last)

Field Name: eventRecurrenceInstance
Type: dimension
Event Recurrence Month Of Year
Month of year for yearly recurrences

Field Name: eventRecurrenceMonthOfYear
Type: dimension
Event Show As
Calendar visibility (Busy/Out Of Office/Free)

Field Name: eventShowAs
Type: dimension
Event Is Child
True for child events under a group event

Field Name: eventIsChild
Type: dimension
Event Is Group Event
True when the event is a group/multi-attendee event

Field Name: eventIsGroupEvent
Type: dimension
Event Group Event Type
Group event type (Group Event / Proposed)

Field Name: eventGroupEventType
Type: dimension

​
User

User ID
Unique 18-character User ID

Field Name: userId
Type: dimension
User Name
Display name (first + last)

Field Name: userName
Type: dimension
User First Name
First name

Field Name: userFirstName
Type: dimension
User Last Name
Last name

Field Name: userLastName
Type: dimension
Username
Login username (email-style)

Field Name: userUsername
Type: dimension
User Alias
Short alias for the user (≤8 chars)

Field Name: userAlias
Type: dimension
User Email
Email address

Field Name: userEmail
Type: dimension
User Title
Job title

Field Name: userTitle
Type: dimension
User Department
Department

Field Name: userDepartment
Type: dimension
User Company Name
Company name on the user record

Field Name: userCompanyName
Type: dimension
User Division
Division on the user record

Field Name: userDivision
Type: dimension
User Employee Number
Employee number on the user record

Field Name: userEmployeeNumber
Type: dimension
User Phone
Primary phone

Field Name: userPhone
Type: dimension
User Mobile Phone
Mobile phone

Field Name: userMobilePhone
Type: dimension
User Fax
Fax number

Field Name: userFax
Type: dimension
User Street
Street address

Field Name: userStreet
Type: dimension
User City
City

Field Name: userCity
Type: dimension
User State
State or province

Field Name: userState
Type: dimension
User Postal Code
Postal/ZIP code

Field Name: userPostalCode
Type: dimension
User Country
Country

Field Name: userCountry
Type: dimension
User Profile ID
ID of the assigned Profile

Field Name: userProfileId
Type: dimension
User Profile Name
Name of the assigned Profile

Field Name: userProfileName
Type: dimension
User Role ID
ID of the assigned Role

Field Name: userRoleId
Type: dimension
User Manager ID
ID of the user’s manager

Field Name: userManagerId
Type: dimension
User Manager Name
Name of the user’s manager

Field Name: userManagerName
Type: dimension
User Type
User license type (Standard, CustomerSuccess, etc.)

Field Name: userUserType
Type: dimension
User Time Zone
IANA timezone key

Field Name: userTimeZone
Type: dimension
User Locale
Locale key (e.g., en_US) — controls number/date formatting

Field Name: userLocaleSidKey
Type: dimension
User Language
UI language key (e.g., en_US, es)

Field Name: userLanguageLocaleKey
Type: dimension
User Email Encoding
Character encoding for outbound email (e.g., UTF-8)

Field Name: userEmailEncodingKey
Type: dimension
User Digest Frequency
Chatter digest email frequency (D/W/N)

Field Name: userDigestFrequency
Type: dimension
User Call Center ID
ID of the assigned Call Center (CTI)

Field Name: userCallCenterId
Type: dimension
User Receives Admin Info Emails
Whether the user receives admin info emails from Salesforce

Field Name: userReceivesAdminInfoEmails
Type: dimension
User Receives Info Emails
Whether the user receives marketing/info emails from Salesforce

Field Name: userReceivesInfoEmails
Type: dimension
User Forecast Enabled
Whether the user is enabled for forecasting

Field Name: userForecastEnabled
Type: dimension
User Is Active
Whether the user is currently active

Field Name: userIsActive
Type: dimension
User About Me
Free-text about-me field shown on the user profile

Field Name: userAboutMe
Type: dimension
User Last Login Date
Most recent login timestamp

Field Name: userLastLoginDate
Type: dimension
User Created Date
Date the user was created

Field Name: userCreatedDate
Type: dimension

​
User Preferences

User Activity Reminders Popup
Activity reminders popup preference

Field Name: userUserPreferencesActivityRemindersPopup
Type: dimension
User Event Reminders Default
Default state of the event reminders checkbox

Field Name: userUserPreferencesEventRemindersCheckboxDefault
Type: dimension
User Task Reminders Default
Default state of the task reminders checkbox

Field Name: userUserPreferencesTaskRemindersCheckboxDefault
Type: dimension
User Reminder Sound Off
Disable reminder sounds

Field Name: userUserPreferencesReminderSoundOff
Type: dimension
User Suppress Event SFX Reminders
Suppress event SFX reminders

Field Name: userUserPreferencesSuppressEventSFXReminders
Type: dimension
User Suppress Task SFX Reminders
Suppress task SFX reminders

Field Name: userUserPreferencesSuppressTaskSFXReminders
Type: dimension
User Reverse Open Activities View
Reverse the Open Activities list order

Field Name: userUserPreferencesReverseOpenActivitiesView
Type: dimension
User Disable All Feeds Email
Disable all Chatter feed emails

Field Name: userUserPreferencesDisableAllFeedsEmail
Type: dimension
User Disable Followers Email
Disable new-follower email notifications

Field Name: userUserPreferencesDisableFollowersEmail
Type: dimension
User Disable Profile Post Email
Disable profile-post email notifications

Field Name: userUserPreferencesDisableProfilePostEmail
Type: dimension
User Disable Change Comment Email
Disable change-comment email notifications

Field Name: userUserPreferencesDisableChangeCommentEmail
Type: dimension
User Disable Later Comment Email
Disable later-comment email notifications

Field Name: userUserPreferencesDisableLaterCommentEmail
Type: dimension
User Disable Like Email
Disable like email notifications

Field Name: userUserPreferencesDisableLikeEmail
Type: dimension
User Disable Message Email
Disable message email notifications

Field Name: userUserPreferencesDisableMessageEmail
Type: dimension
User Disable Endorsement Email
Disable endorsement email notifications

Field Name: userUserPreferencesDisableEndorsementEmail
Type: dimension
User Disable Feedback Email
Disable feedback email notifications

Field Name: userUserPreferencesDisableFeedbackEmail
Type: dimension
User Disable Mentions Post Email
Disable mentions-in-post email notifications

Field Name: userUserPreferencesDisableMentionsPostEmail
Type: dimension
User Disable Share Post Email
Disable share-post email notifications

Field Name: userUserPreferencesDisableSharePostEmail
Type: dimension
User Disable Bookmark Email
Disable bookmark email notifications

Field Name: userUserPreferencesDisableBookmarkEmail
Type: dimension
User Disable Reward Email
Disable reward email notifications

Field Name: userUserPreferencesDisableRewardEmail
Type: dimension
User Disable Work Email
Disable work email notifications

Field Name: userUserPreferencesDisableWorkEmail
Type: dimension
User Disable File Share Notifications (API)
Disable file-share notifications via API

Field Name: userUserPreferencesDisableFileShareNotificationsForApi
Type: dimension
User Disable Profile Post Comment Email
Disable profile-post comment email notifications

Field Name: userUserPreferencesDisProfPostCommentEmail
Type: dimension
User Disable Mentions Comment Email
Disable mentions-in-comment email notifications

Field Name: userUserPreferencesDisMentionsCommentEmail
Type: dimension
User Disable Comment After Like Email
Disable comment-after-like email notifications

Field Name: userUserPreferencesDisCommentAfterLikeEmail
Type: dimension
User Show Email To External Users
Expose email to external community users

Field Name: userUserPreferencesShowEmailToExternalUsers
Type: dimension
User Show Email To Guest Users
Expose email to guest users

Field Name: userUserPreferencesShowEmailToGuestUsers
Type: dimension
User Show Title To External Users
Expose title to external community users

Field Name: userUserPreferencesShowTitleToExternalUsers
Type: dimension
User Show Title To Guest Users
Expose title to guest users

Field Name: userUserPreferencesShowTitleToGuestUsers
Type: dimension
User Show Manager To External Users
Expose manager to external community users

Field Name: userUserPreferencesShowManagerToExternalUsers
Type: dimension
User Show Manager To Guest Users
Expose manager to guest users

Field Name: userUserPreferencesShowManagerToGuestUsers
Type: dimension
User Show Work Phone To External Users
Expose work phone to external community users

Field Name: userUserPreferencesShowWorkPhoneToExternalUsers
Type: dimension
User Show Work Phone To Guest Users
Expose work phone to guest users

Field Name: userUserPreferencesShowWorkPhoneToGuestUsers
Type: dimension
User Show Mobile Phone To External Users
Expose mobile phone to external community users

Field Name: userUserPreferencesShowMobilePhoneToExternalUsers
Type: dimension
User Show Mobile Phone To Guest Users
Expose mobile phone to guest users

Field Name: userUserPreferencesShowMobilePhoneToGuestUsers
Type: dimension
User Show Fax To External Users
Expose fax to external community users

Field Name: userUserPreferencesShowFaxToExternalUsers
Type: dimension
User Show Fax To Guest Users
Expose fax to guest users

Field Name: userUserPreferencesShowFaxToGuestUsers
Type: dimension
User Show Street To External Users
Expose street address to external community users

Field Name: userUserPreferencesShowStreetAddressToExternalUsers
Type: dimension
User Show Street To Guest Users
Expose street address to guest users

Field Name: userUserPreferencesShowStreetAddressToGuestUsers
Type: dimension
User Show City To External Users
Expose city to external community users

Field Name: userUserPreferencesShowCityToExternalUsers
Type: dimension
User Show City To Guest Users
Expose city to guest users

Field Name: userUserPreferencesShowCityToGuestUsers
Type: dimension
User Show State To External Users
Expose state to external community users

Field Name: userUserPreferencesShowStateToExternalUsers
Type: dimension
User Show State To Guest Users
Expose state to guest users

Field Name: userUserPreferencesShowStateToGuestUsers
Type: dimension
User Show Postal Code To External Users
Expose postal code to external community users

Field Name: userUserPreferencesShowPostalCodeToExternalUsers
Type: dimension
User Show Postal Code To Guest Users
Expose postal code to guest users

Field Name: userUserPreferencesShowPostalCodeToGuestUsers
Type: dimension
User Show Country To External Users
Expose country to external community users

Field Name: userUserPreferencesShowCountryToExternalUsers
Type: dimension
User Show Country To Guest Users
Expose country to guest users

Field Name: userUserPreferencesShowCountryToGuestUsers
Type: dimension
User Show Profile Pic To Guest Users
Expose profile picture to guest users

Field Name: userUserPreferencesShowProfilePicToGuestUsers
Type: dimension
User Lightning Experience Preferred
Whether the user prefers Lightning Experience

Field Name: userUserPreferencesLightningExperiencePreferred
Type: dimension
User Native Email Client
Use native email client preference

Field Name: userUserPreferencesNativeEmailClient
Type: dimension
User Enable Auto Subscribe For Feeds
Auto-subscribe to feeds for objects the user creates

Field Name: userUserPreferencesEnableAutoSubForFeeds
Type: dimension
User Sort Feed By Comment
Sort feed by most-recent comment

Field Name: userUserPreferencesSortFeedByComment
Type: dimension
User Favorites Show Top Favorites
Show top favorites in the favorites menu

Field Name: userUserPreferencesFavoritesShowTopFavorites
Type: dimension
User Receive No Approver Notifications
Receive no notifications as an approver

Field Name: userUserPreferencesReceiveNoNotificationsAsApprover
Type: dimension
User Receive Delegated Approver Notifications
Receive notifications as a delegated approver

Field Name: userUserPreferencesReceiveNotificationsAsDelegatedApprover
Type: dimension
User Show Forecasting Change Signals
Show forecasting change signals

Field Name: userUserPreferencesShowForecastingChangeSignals
Type: dimension
User Opt Out Of Touch
Opt out of touch UI on mobile

Field Name: userUserPreferencesOptOutOfTouch
Type: dimension
User Path Assistant Collapsed
Whether the Path assistant defaults to collapsed

Field Name: userUserPreferencesPathAssistantCollapsed
Type: dimension

​
Opportunity Line Item

Opportunity Line Item ID
Unique 18-character ID for the line item

Field Name: opportunityLineItemId
Type: dimension
Opportunity Line Item Name
Auto-computed name of the line item (Opp + Product)

Field Name: opportunityLineItemName
Type: dimension
Opportunity Line Item Description
Free-text description for the line item

Field Name: opportunityLineItemDescription
Type: dimension
Opportunity Line Item Opportunity ID
ID of the parent opportunity

Field Name: opportunityLineItemOpportunityId
Type: dimension
Opportunity Line Item Opportunity Name
Name of the parent opportunity

Field Name: opportunityLineItemOpportunityName
Type: dimension
Opportunity Line Item Product ID
ID of the referenced Product2

Field Name: opportunityLineItemProductId
Type: dimension
Opportunity Line Item Product Name
Name of the referenced product

Field Name: opportunityLineItemProductName
Type: dimension
Opportunity Line Item Product Code
SKU/product code from the referenced product

Field Name: opportunityLineItemProductCode
Type: dimension
Opportunity Line Item Service Date
Service date for the line item

Field Name: opportunityLineItemServiceDate
Type: dimension
Opportunity Line Item Pricebook Entry ID
ID of the underlying PricebookEntry

Field Name: opportunityLineItemPricebookEntryId
Type: dimension
Opportunity Line Item Created Date
Date the line item was created

Field Name: opportunityLineItemCreatedDate
Type: dimension
Opportunity Line Item Last Modified Date
Date the line item was last edited

Field Name: opportunityLineItemLastModifiedDate
Type: dimension

​
Product

Product ID
Unique 18-character ID for the product

Field Name: productId
Type: dimension
Product Name
Name of the product

Field Name: productName
Type: dimension
Product Code
SKU/code of the product

Field Name: productCode
Type: dimension
Product Description
Free-text description of the product

Field Name: productDescription
Type: dimension
Product Family
Product family (categorisation picklist)

Field Name: productFamily
Type: dimension
Product Is Active
Whether the product is active

Field Name: productIsActive
Type: dimension
Product External ID
External identifier on the product

Field Name: productExternalId
Type: dimension
Product SKU
Stock-keeping unit

Field Name: productStockKeepingUnit
Type: dimension
Product Created Date
Date the product was created

Field Name: productCreatedDate
Type: dimension
Product Last Modified Date
Date the product was last edited

Field Name: productLastModifiedDate
Type: dimension

​
Metrics

Metrics are the numerical values you can measure and analyze from your Salesforce campaigns.

​
Account

Account Count
Count of accounts (1 per row when joined with dimensions; total when alone)

Field Name: accountCount
Type: metric
Account Annual Revenue
Annual revenue reported on the account

Field Name: accountAnnualRevenue
Type: metric
Account Number Of Employees
Employee count reported on the account

Field Name: accountNumberOfEmployees
Type: metric

​
Contact

Contact Count
Count of contacts

Field Name: contactCount
Type: metric

​
Lead

Lead Count
Count of leads

Field Name: leadCount
Type: metric
Lead Annual Revenue
Annual revenue reported on the lead

Field Name: leadAnnualRevenue
Type: metric
Lead Number Of Employees
Employee count reported on the lead

Field Name: leadNumberOfEmployees
Type: metric

​
Opportunity

Opportunity Count
Count of opportunities

Field Name: opportunityCount
Type: metric
Opportunity Amount
Deal size in currency units

Field Name: opportunityAmount
Type: metric
Opportunity Expected Revenue
Amount × Probability — Salesforce-weighted forecast

Field Name: opportunityExpectedRevenue
Type: metric
Opportunity Probability
Stage probability of close (0–100)

Field Name: opportunityProbability
Type: metric
Opportunity Total Opportunity Quantity
Total quantity across all line items

Field Name: opportunityTotalOpportunityQuantity
Type: metric

​
Case

Case Count
Count of cases

Field Name: caseCount
Type: metric

​
Campaign

Campaign Count
Count of campaigns

Field Name: campaignCount
Type: metric
Campaign Budgeted Cost
Planned budget for the campaign

Field Name: campaignBudgetedCost
Type: metric
Campaign Actual Cost
Actual cost incurred for the campaign

Field Name: campaignActualCost
Type: metric
Campaign Expected Revenue
Forecasted revenue from the campaign

Field Name: campaignExpectedRevenue
Type: metric
Campaign Expected Response
Expected response count

Field Name: campaignExpectedResponse
Type: metric
Campaign Number Sent
Number of items sent (e.g., emails)

Field Name: campaignNumberSent
Type: metric
Campaign Number Of Leads
Rolled-up count of leads associated with the campaign

Field Name: campaignNumberOfLeads
Type: metric
Campaign Number Of Contacts
Rolled-up count of contacts associated with the campaign

Field Name: campaignNumberOfContacts
Type: metric
Campaign Number Of Converted Leads
Rolled-up count of converted leads

Field Name: campaignNumberOfConvertedLeads
Type: metric
Campaign Number Of Responses
Rolled-up count of campaign members who responded

Field Name: campaignNumberOfResponses
Type: metric
Campaign Number Of Opportunities
Rolled-up count of opportunities tied to the campaign

Field Name: campaignNumberOfOpportunities
Type: metric
Campaign Number Of Won Opportunities
Rolled-up count of won opportunities tied to the campaign

Field Name: campaignNumberOfWonOpportunities
Type: metric
Campaign Amount All Opportunities
Rolled-up amount of all opportunities tied to the campaign

Field Name: campaignAmountAllOpportunities
Type: metric
Campaign Amount Won Opportunities
Rolled-up amount of won opportunities tied to the campaign

Field Name: campaignAmountWonOpportunities
Type: metric
Campaign Hierarchy Number Sent
Sum across the campaign hierarchy of items sent

Field Name: campaignHierarchyNumberSent
Type: metric
Campaign Hierarchy Number Of Leads
Sum across the campaign hierarchy of leads

Field Name: campaignHierarchyNumberOfLeads
Type: metric
Campaign Hierarchy Number Of Contacts
Sum across the campaign hierarchy of contacts

Field Name: campaignHierarchyNumberOfContacts
Type: metric
Campaign Hierarchy Number Of Converted Leads
Sum across the campaign hierarchy of converted leads

Field Name: campaignHierarchyNumberOfConvertedLeads
Type: metric
Campaign Hierarchy Number Of Responses
Sum across the campaign hierarchy of responses

Field Name: campaignHierarchyNumberOfResponses
Type: metric
Campaign Hierarchy Number Of Opportunities
Sum across the campaign hierarchy of opportunities

Field Name: campaignHierarchyNumberOfOpportunities
Type: metric
Campaign Hierarchy Number Of Won Opportunities
Sum across the campaign hierarchy of won opportunities

Field Name: campaignHierarchyNumberOfWonOpportunities
Type: metric
Campaign Hierarchy Amount All Opportunities
Sum across the campaign hierarchy of all opportunity amount

Field Name: campaignHierarchyAmountAllOpportunities
Type: metric
Campaign Hierarchy Amount Won Opportunities
Sum across the campaign hierarchy of won opportunity amount

Field Name: campaignHierarchyAmountWonOpportunities
Type: metric

​
Task

Task Count
Count of tasks

Field Name: taskCount
Type: metric
Task Call Duration In Seconds
Call duration on the task (in seconds)

Field Name: taskCallDurationInSeconds
Type: metric

​
Event

Event Count
Count of events

Field Name: eventCount
Type: metric
Event Duration In Minutes
Duration of the event in minutes

Field Name: eventDurationInMinutes
Type: metric

​
User

User Count
Count of users

Field Name: userCount
Type: metric

​
Opportunity Line Item

Opportunity Line Item Count
Count of line items

Field Name: opportunityLineItemCount
Type: metric
Opportunity Line Item Quantity
Quantity ordered on the line item

Field Name: opportunityLineItemQuantity
Type: metric
Opportunity Line Item Unit Price
Per-unit price on the line item

Field Name: opportunityLineItemUnitPrice
Type: metric
Opportunity Line Item List Price
List price from the pricebook for the line item

Field Name: opportunityLineItemListPrice
Type: metric
Opportunity Line Item Discount
Discount applied to the line item (percent)

Field Name: opportunityLineItemDiscount
Type: metric
Opportunity Line Item Total Price
Total price (Quantity × UnitPrice) for the line item

Field Name: opportunityLineItemTotalPrice
Type: metric

​
Product

Product Count
Count of products in the catalog

Field Name: productCount
Type: metric

Fields Catalog

Browse all platforms

HubSpot Fields

HubSpot metrics & dimensions

Klaviyo Fields

Klaviyo metrics & dimensions

Mailchimp Fields

Mailchimp metrics & dimensions