Salesforce Reporting: Most-used fields
The table below gives information about most-used fields that you can import from Salesforce Reporting. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
Account CurrencyDimension
The default currency for currency amount fields in the account, if multi-currency is enabled.
Account DescriptionDimension
A textual description providing details about the Account.
Account IDDimension
The unique identifier for the account record.
Account NameDimension
The identifying name of the account.
Account Name: Account NameDimension
The name of the related Account record, obtained through a lookup relationship. This field is commonly displayed in reports to provide context for associated records and is available via the Salesforce Reports and Dashboards REST API or SOQL API.
Account Name: Created DateDimension
The date and time when the related Account record was created. This system field is retrieved through a lookup relationship and is available in reports via the Salesforce Reports and Dashboards REST API or SOQL API.
Account NumberDimension
An alphanumeric identifier assigned to the account.
Account OwnerDimension
The full name of the Salesforce user designated as the owner of the related Account.
Account Record TypeDimension
The record type assigned to the account, which can define different page layouts and picklist values.
Account SiteDimension
A field used to identify a specific location or division within an Account.
Account: AssistantDimension
The name of the assistant associated with a key contact or executive within the Account.
Activity IDDimension
The unique identifier for an activity record (Task or Event).
Activity TypeDimension
The type of activity, such as 'Call', 'Email', or 'Meeting'.
AgeDimension
The number of days since the opportunity was created or entered its current stage.
AmountDimension
The monetary value associated with a sales opportunity or transaction. This is a key financial metric on Opportunity records, accessible through reports and SOQL queries.
Application: Created DateDimension
The date and time when the Application record was initially created in Salesforce. This is an audit field automatically populated by the system.
AssignedDimension
A boolean indicator specifying if an activity or record has been assigned to a user.
Assigned RoleDimension
The role of the user to whom an activity or record is assigned.
Assigned Role DisplayDimension
The display name for the role of the user to whom an activity or record is assigned.
Campaign NameDimension
The name of the marketing campaign. This field is commonly used in reports to identify specific campaigns and can be accessed via the Salesforce Reports and Dashboards REST API or SOQL API.
Close DateDimension
The date when the sales opportunity is expected or actually closed.
Close MonthDimension
The calendar month in which the opportunity is expected to close, derived from the Expected Close Date.
ClosedDimension
A boolean indicator specifying if a record, such as an Opportunity or Case, has been closed.
Completed Date/TimeDimension
The date and time when an activity (Task or Event) was completed.
Contact IDDimension
The unique identifier for a Contact record.
Contact/Lead SourceDimension
The origin or source from which a Contact or Lead was acquired.
Contact: TitleDimension
The job title of the contact.
Create DateDimension
The date and time when the record was initially created.
Created AliasDimension
The alias or name of the user who created the record or asset.
Created ByDimension
The full name of the Salesforce user who originally created the record.
Created DateDimension
The date and time when the record was created.
DateDimension
A generic date field used in reports, often representing a significant timestamp such as creation date, last modification date, or a specific activity date, and commonly used for filtering report data.
DescriptionDimension
A free-text field for detailed notes or additional information about the record.
EmailDimension
The email address for a record, commonly found on Contact, Lead, User, or Person Account records, used for communication.
Email Activity NameDimension
The name or subject of an email message in Salesforce, representing an email activity. This corresponds to the 'Name' field on the EmailMessage object.
Event SubtypeDimension
A classification or sub-category for an Event record, often used to further define the nature of the event.
Expected Close DateDimension
The date when an opportunity is expected to close.
Fiscal PeriodDimension
The fiscal period (e.g., Quarter 1, Half 2) associated with the record's date, as defined by the organization's fiscal year settings.
Fiscal YearMetric
The fiscal year associated with the record's date, as defined by the organization's fiscal year settings.
Forecast CategoryDimension
The category that an opportunity's stage falls into for sales forecasting (e.g., Pipeline, Best Case, Commit, Closed).
Has ProductsDimension
Indicates whether products are associated with the opportunity.
Last ActivityDimension
The date of the most recent activity (e.g., task, event) associated with the record.
Last ModifiedDimension
The date and time when the record was last modified.
Last Modified AliasDimension
The alias of the Salesforce User who last modified the record.
Last Modified ByDimension
The user who last made changes to a record. This helps in auditing and tracking modifications.
Last Modified DateDimension
The date and time when the record was last modified.
Last Stage Change DateDimension
The date when the opportunity's sales stage was most recently updated.
Lead SourceDimension
The marketing or sales channel from which a Lead was generated, such as 'Web', 'Referral', or 'Trade Show'.
Lead StatusDimension
The current stage or status of a Lead in the sales process, such as 'New', 'Working', or 'Qualified'.
LocationDimension
The physical location associated with an activity or record.
Mailing State/ProvinceDimension
The state or province component of a mailing address for a Contact, Lead, or Account.
Monthly Schedule IDDimension
The unique identifier for a specific Monthly Schedule record. This is an automatically generated 18-character alphanumeric ID.
Monthly Schedule: IDDimension
The unique identifier for a specific Monthly Schedule record. This is an automatically generated 18-character alphanumeric ID.
Next StepDimension
A description of the next planned action or step to advance the opportunity.
Opened DateDimension
The date when a record, such as a Case or an Email activity, was opened.
Opportunity CurrencyDimension
The currency code (e.g., USD, EUR) specifically used for monetary values on the Opportunity record.
Opportunity IDDimension
The unique identifier for an Opportunity record.
Opportunity Lead SourceDimension
The marketing or sales channel from which the Lead that generated this Opportunity was sourced.
Opportunity NameDimension
The identifying name of the sales opportunity.
Opportunity Owner EmailDimension
The email address of the Salesforce user who is the owner of the opportunity.
Opportunity QuantityDimension
The total quantity of products or services included in the opportunity.
Opportunity Record TypeDimension
The categorization of an Opportunity record, allowing different business processes, page layouts, and picklist values (such as different opportunity stages) for various types of sales transactions.
Owner: Full NameDimension
The combined first and last name of the Salesforce user or queue who owns the record. This field represents the full name of the assigned owner.
Parent Account IDDimension
The unique identifier (ID) of the parent account in an account hierarchy. This field establishes a hierarchical relationship between accounts, linking a child account to its superior or parent account. For example, it can link a branch office to its corporate headquarters.
Person Account: BirthdateDimension
The birthdate of the person for a Person Account.
Person Account: EmailDimension
The email address of the person for a Person Account.
Person Account: First NameDimension
The first name of the person for a Person Account.
Person Account: Last NameDimension
The last name of the person for a Person Account.
Primary PartnerDimension
Represents the primary partner associated with a record, such as a company, organization, or individual involved in a key business relationship.
PrivateDimension
Indicates if the record is marked as private, affecting its visibility to other users.
Probability (%)Metric
The percentage indicating the likelihood of the opportunity successfully closing.
Push CountMetric
This field indicates the number of times an Opportunity's Close Date has been moved to a later calendar month. The count increments by one each time the Close Date is edited and saved into a future month, regardless of how many months it is advanced in a single edit. It does not increment for changes within the same calendar month or for moving the date earlier.
Sell Line: IDDimension
A unique identifier for a line item representing a product or service being sold. This often corresponds to a 'Quote Line' in Salesforce CPQ or an 'Order Item' in Salesforce Order Management.
Sent Email IDDimension
The unique identifier for an email message sent from or received within Salesforce. This ID is associated with the EmailMessage object, which represents an email record.
Sent Email: Created DateDimension
The date and time when the sent email activity record was created.
Sent Email: IDDimension
The unique identifier for a sent email activity record.
Sent Email: Owner NameDimension
The full name of the Salesforce User who sent the email.
Sent Email: Owner RoleDimension
The role of the Salesforce User who sent the email.
StageDimension
The current stage in the lifecycle of a record, such as a sales opportunity or case.
Stage DurationDimension
The amount of time a record has spent in its current or a specific stage within a workflow process.
Stage History: Created DateDimension
The date and time when a specific Stage History record was created, indicating when a stage change or event occurred. This is an audit field automatically populated by the system.
Stage History: Stage History NameDimension
The name of a specific stage in the history of a record's progression, such as an Opportunity Stage. This field captures the name of each stage as it was recorded over time.
StatusDimension
The current status of a record, such as a Lead, Task, or Case.
SubjectDimension
A brief summary or topic for an activity (Task, Event, Email) or other record.
Task SubtypeDimension
Categorizes the nature of a task, such as a Call, Email, or List Email, to help with task organization and search refinement.
Task/Event Record TypeDimension
The name of the record type assigned to a Task or Event, helping to categorize activities.
TitleDimension
The professional job title of an individual, such as a Contact, Lead, or User.
TypeDimension
This field specifies the format or category of the email template. Common types include 'Text' for plain text, 'HTML' for templates using a Classic Letterhead, or 'Custom' for custom HTML templates without a letterhead.
WonDimension
A boolean indicator specifying if an Opportunity has been successfully closed and won.