Connect to Data Sources
Salesforce
Salesforce Supported Metrics and Breakdowns

Salesforce Metrics and Breakdowns

This page provides a comprehensive reference of all supported metrics and breakdowns available for Salesforce CRM data extraction through Adzviser.

Metrics

Campaign Metrics

Field NameDescription
Campaign countTotal campaigns
Campaign actual costActual campaign cost
Campaign all opportunities amountAll opportunity value
Campaign won opportunities amountWon opportunity value
Campaign budgeted costBudgeted cost
Campaign expected responseExpected response
Campaign expected revenueExpected revenue
Campaign total contactsContact count
Campaign converted leadsConverted leads
Campaign leadsTotal leads
Campaign opportunitiesOpportunity count
Campaign responsesResponse count
Campaign won opportunitiesWon opportunity count
Campaign num sentNumber sent

Campaign Hierarchy Metrics

Field NameDescription
Campaign total actual cost in hierarchyHierarchy actual cost
Campaign total budgeted cost in hierarchyHierarchy budgeted cost
Campaign total expected revenue in hierarchyHierarchy expected revenue
Campaign total num sent in hierarchyHierarchy num sent
Campaign total value opportunities in hierarchyHierarchy opp value
Campaign total value won opportunities in hierarchyHierarchy won value
Campaign total contacts in hierarchyHierarchy contacts
Campaign total converted leads in hierarchyHierarchy converted leads
Campaign total leads in hierarchyHierarchy leads
Campaign total opportunities in hierarchyHierarchy opportunities
Campaign total responses in hierarchyHierarchy responses
Campaign total won opportunities in hierarchyHierarchy won opps

Object Counts

Field NameDescription
Contact countTotal contacts
LeadsTotal leads
AccountsTotal accounts
Opportunity countTotal opportunities
Task countTotal tasks

Account Metrics

Field NameDescription
Account number of employeesEmployee count
Account annual revenueAnnual revenue

Opportunity Metrics

Field NameDescription
Opportunity amountOpportunity value

Task Metrics

Field NameDescription
Task call durationCall duration (seconds)

Order Metrics

Field NameDescription
Order total amountTotal order amount
Order total tax amountTotal tax
Order grand total amountGrand total
Order total adjusted delivery amountAdjusted delivery
Order total adjusted product amountAdjusted product

Contract Metrics

Field NameDescription
Contract term (month)Contract term
Order total adjusted delivery amount with taxMonetary value of order total adjusted delivery amount with tax in the account's reporting currency
Order total adjusted product amount with taxMonetary value of order total adjusted product amount with tax in the account's reporting currency
Order total adjusted delivery tax amountMonetary value of order total adjusted delivery tax amount in the account's reporting currency
Order total adjusted product tax amountMonetary value of order total adjusted product tax amount in the account's reporting currency
Order delivery adjustment distributed amountsOrder-level adjustment allocated to delivery line items
Order delivery adjustment distributed amounts with taxOrder-level adjustment allocated to delivery line items including tax
Order delivery adjustment distributed tax amountsOrder-level adjustment allocated to delivery line items representing tax only
Order product adjustment distributed amountsOrder-level adjustment allocated to product line items
Order product adjustment distributed amounts with taxOrder-level adjustment allocated to product line items including tax
Order product adjustment distributed tax amountOrder-level adjustment allocated to product line items representing tax only
Order item unit priceMonetary unit price recorded for the Salesforce order item
Order item gross unit priceMonetary gross unit price recorded for the Salesforce order item
Order item list priceMonetary list price recorded for the Salesforce order item
Order item quantityQuantity ordered for the Salesforce order item
Order item available quantityQuantity currently available for the Salesforce order item
Order item adjusted line amountMonetary adjusted line amount recorded for the Salesforce order item
Order item adjusted line amount with taxMonetary adjusted line amount with tax recorded for the Salesforce order item
Order item rounded line amountMonetary rounded line amount recorded for the Salesforce order item
Order item rounded line amount with taxMonetary rounded line amount with tax recorded for the Salesforce order item
Order item total adjusted line tax amountMonetary total adjusted line tax amount recorded for the Salesforce order item
Order item total adjustment amountMonetary total adjustment amount recorded for the Salesforce order item
Order item total adjustment amount with taxMonetary total adjustment amount with tax recorded for the Salesforce order item
Order item total adjustment distributed amountOrder-level adjustment allocated to product line items
Order item total adjustment distributed tax amountOrder-level adjustment allocated to product line items representing tax only
Order item total adjustment distributed amount with taxOrder-level adjustment allocated to product line items including tax
Order item total adjustment tax amountMonetary total adjustment tax amount recorded for the Salesforce order item
Order item total amount with taxMonetary total amount with tax recorded for the Salesforce order item
Order item total line adjustment amountMonetary total line adjustment amount recorded for the Salesforce order item
Order item total line adjustment amount with taxMonetary total line adjustment amount with tax recorded for the Salesforce order item
Order item total line adjustment tax amountMonetary total line adjustment tax amount recorded for the Salesforce order item
Order item total line amountMonetary total line amount recorded for the Salesforce order item
Order item total line tax amountMonetary total line tax amount recorded for the Salesforce order item
Order item total priceMonetary total price recorded for the Salesforce order item
Order item total tax amountMonetary total tax amount recorded for the Salesforce order item

Breakdowns

Campaign Breakdowns

Field NameDescription
Campaign IDCampaign identifier
Campaign descriptionDescription
Campaign end dateEnd date
Campaign is activeActive status
Campaign nameName of the campaign
Campaign start dateStart date
Campaign statusStatus
Campaign typeType
Campaign created dateCreation date
Campaign last modified dateLast modified

Opportunity Breakdowns

Field NameDescription
Opportunity IDOpportunity identifier
Opportunity nameName
Opportunity typeType
Opportunity descriptionDescription
Opportunity stageStage
Opportunity close dateClose date
Opportunity lead sourceLead source
Opportunity is closedClosed status
Opportunity is wonWon status
Opportunity forecast categoryForecast category
Opportunity probability (%)Win probability
Opportunity ownerOwner name
Opportunity account nameAccount name

Contact Breakdowns

Field NameDescription
Contact IDContact identifier
Contact first nameFirst name
Contact last nameLast name
Contact emailEmail
Contact phonePhone
Contact departmentDepartment
Contact titleTitle
Contact lead sourceLead source
Contact mailing cityCity
Contact mailing countryCountry

Lead Breakdowns

Field NameDescription
Lead IDLead identifier
Lead first nameFirst name
Lead last nameLast name
Lead companyCompany
Lead emailEmail
Lead phonePhone
Lead statusStatus
Lead sourceSource
Lead countryCountry
Lead is convertedConversion status

Account Breakdowns

Field NameDescription
Account IDAccount identifier
Account nameName of the account
Account typeType
Account industryIndustry
Account websiteWebsite
Account phone numberPhone
Account billing cityBilling city
Account billing countryBilling country
Account shipping cityShipping city
Account shipping countryShipping country

Task Breakdowns

Field NameDescription
Task IDTask identifier
Task subjectSubject
Task statusStatus
Task priorityPriority
Task typeType
Task ownerOwner name
Task due dateDue date

Order Breakdowns

Field NameDescription
Order IDOrder identifier
Order numberReference number assigned to the order
Order nameName of the order
Order statusStatus
Order typeType
Ordered timeOrder date
Order billing cityBilling city
Order billing countryBilling country
Order shipping cityShipping city
Order shipping countryShipping country

Contract Breakdowns

Field NameDescription
Contract IDContract identifier
Contract numberReference number assigned to the contract
Contract statusStatus
Contract start dateStart date
Contract end dateEnd date
Campaign last activity dateCalendar date associated with the campaign last activity event or record
Campaign last referenced dateCalendar date associated with the campaign last referenced event or record
Campaign last viewed dateCalendar date associated with the campaign last viewed event or record
Opportunity next stepPlanned next action or recorded outcome for the opportunity
Opportunity forecast category nameName of the opportunity forecast category
Opportunity has line itemWhether the opportunity has line item
Opportunity created dateCalendar date associated with the opportunity created event or record
Opportunity last modified dateCalendar date associated with the opportunity last modified event or record
Opportunity last activity dateCalendar date associated with the opportunity last activity event or record
Opportunity fiscal quarterFiscal quarter associated with the opportunity
Opportunity fiscal yearFiscal year associated with the opportunity
Opportunity fiscal periodFiscal period associated with the opportunity
Opportunity last viewed dateCalendar date associated with the opportunity last viewed event or record
Opportunity last referenced dateCalendar date associated with the opportunity last referenced event or record
Opportunity has open activityWhether the opportunity has open activity
Opportunity has overdue taskWhether the opportunity has overdue task
Opportunity account sourceTraffic source
Opportunity account phoneContact account phone stored for the opportunity
Opportunity account industryAccount industry classification assigned to the opportunity
Opportunity account employee countNumber of opportunity account employee events or records
Opportunity account descriptionDescription stored for the related opportunity account record
Opportunity age (weeks)Elapsed time represented by age (weeks) for the opportunity
Opportunity value rangeBucketed monetary range assigned to the opportunity
Opportunity product IDUnique identifier for the opportunity product in Salesforce
Opportunity product nameName of the opportunity product
Opportunity product descriptionDescription stored for the related opportunity product record
Opportunity product discountMonetary product discount stored for the opportunity
Opportunity product created dateCalendar date associated with the opportunity product created event or record
Opportunity product updated dateCalendar date associated with the opportunity product upd event or record
Opportunity product codeReference product code assigned to the opportunity
Task is completedWhether the task is completed
Task name IDUnique identifier for the task name in Salesforce
Task related to IDUnique identifier for the task related to in Salesforce
Task is high priorityWhether the task is high priority
Task assigned to IDUnique identifier for the task assigned to in Salesforce
Task descriptionDescription stored for the related task record
Task is deletedWhether the task is deleted
Task account IDUnique identifier for the task account in Salesforce
Task created dateCalendar date associated with the task created event or record
Task created by IDUnique identifier for the task created by in Salesforce
Task last modified dateCalendar date associated with the task last modified event or record
Task last modified by IDUnique identifier for the task last modified by in Salesforce
Task is archivedWhether the task is archived
Task call typeType of task call
Task call resultPlanned next action or recorded outcome for the task
Task call object identifierUnique platform or external identifier associated with the task
Task reminder date & timeCalendar date associated with the task reminder & time event or record
Task has a reminderWhether the task has a reminder
Task recurrence activity IDUnique identifier for the task recurrence activity in Salesforce
Task has recurring series of tasksWhether the task has recurring series of tasks
Task recurrence start dateCalendar date associated with the task recurrence start event or record
Task recurrence end dateCalendar date associated with the task recurrence end event or record
Task recurrence time zoneTime zone used to interpret dates and delivery for the related record
Task recurrence typeType of task recurrence
Task recurrence intervalRecurrence schedule setting for the task
Task recurrence day of weekRecurrence schedule setting for the task
Task recurrence day of monthRecurrence schedule setting for the task
Task recurrence instanceRecurrence schedule setting for the task
Task recurrence month of yearFiscal year associated with the task
Repeat this taskWhether Salesforce should create another instance after the task is completed
Task subtypeSubtype classification assigned to the task
Contact account nameName of the contact account
Contact account IDUnique identifier for the contact account in Salesforce
Contact assistantName of the contact's assistant
Contact assistant phoneContact assistant phone stored for the contact
Contact birth dateCalendar date associated with the contact birth event or record
Contact ownerUser responsible for the owner relationship on the contact
Contact created byUser responsible for the created by relationship on the contact
Contact created dateCalendar date associated with the contact created event or record
Contact is deletedWhether the contact is deleted
Contact descriptionDescription stored for the related contact record
Contact do not callWhether the contact is marked as do not call
Contact email bounced dateCalendar date associated with the contact email bounced event or record
Contact email bounced reasonEmail address stored for the related Salesforce record
Contact email opt outEmail address stored for the related Salesforce record
Contact faxContact fax stored for the contact
Contact fax opt outContact fax opt out stored for the contact
Contact home phoneContact home phone stored for the contact
Contact is email bouncedEmail address stored for the related Salesforce record
Contact last activity dateCalendar date associated with the contact last activity event or record
Contact last modified byUser responsible for the last modified by relationship on the contact
Contact last modified dateCalendar date associated with the contact last modified event or record
Contact last referenced dateCalendar date associated with the contact last referenced event or record
Contact last viewed dateCalendar date associated with the contact last viewed event or record
Contact mailing country codeReference mailing country code assigned to the contact
Contact mailing geocode accuracyMailing geocode accuracy stored for the contact
Contact mailing latitudeGeographic latitude of the related business or location
Contact mailing longitudeGeographic longitude of the related business or location
Contact mailing state/provinceMailing state/province stored for the contact
Contact mailing state/province codeReference mailing state/province code assigned to the contact
Contact mailing streetMailing street stored for the contact
Contact mailing zip/postal codeReference mailing zip/postal code assigned to the contact
Contact mobile phoneContact mobile phone stored for the contact
Contact full nameName of the contact full
Contact other cityOther city stored for the contact
Contact other countryGeographic contact other country associated with the user, delivery, or conversion
Contact other state/provinceOther state/province stored for the contact
Contact other streetOther street stored for the contact
Contact other zip/postal codeReference other zip/postal code assigned to the contact
Contact other phoneContact other phone stored for the contact
Contact photo URLURL associated with the contact photo record
Contact reports toParent contact or manager to whom the contact reports
Contact salutationSalutation classification assigned to the contact
Lead titleHuman-readable title of the related lead content
Lead stateState stored for the lead
Lead mobileMobile telephone number stored for the lead
Lead owner IDUnique identifier for the lead owner in Salesforce
Lead owner nameName of the lead owner
Lead owner emailEmail address stored for the related Salesforce record
Lead owner departmentOwner department classification assigned to the lead
Lead last activity dateCalendar date associated with the lead last activity event or record
Lead is deletedWhether the lead is deleted
Lead converted account IDUnique identifier for the lead converted account in Salesforce
Lead converted contact IDUnique identifier for the lead converted contact in Salesforce
Lead converted opportunity IDUnique identifier for the lead converted opportunity in Salesforce
Lead converted dateCalendar date associated with the lead converted event or record
Lead created dateCalendar date associated with the lead created event or record
Lead last modified dateCalendar date associated with the lead last modified event or record
Account numberReference number assigned to the account
Account sourceTraffic source
Account billing addressBilling address stored for the account
Account billing country codeReference billing country code assigned to the account
Account billing geocode accuracyBilling geocode accuracy stored for the account
Account billing latitudeGeographic latitude of the related business or location
Account billing longitudeGeographic longitude of the related business or location
Account billing postal codeReference billing postal code assigned to the account
Account billing stateBilling state stored for the account
Account billing state codeReference billing state code assigned to the account
Account billing streetBilling street stored for the account
Account created by IDUnique identifier for the account created by in Salesforce
Account created dateCalendar date associated with the account created event or record
Account descriptionDescription stored for the related account record
Account faxContact fax stored for the account
Account is deletedWhether the account is deleted
Account JigsawData.com or Jigsaw company identifier associated with the account
Account Jigsaw company IDUnique identifier for the account jigsaw company in Salesforce
Account last activity dateCalendar date associated with the account last activity event or record
Account last modified by IDUnique identifier for the account last modified by in Salesforce
Account last modified dateCalendar date associated with the account last modified event or record
Account last referenced dateCalendar date associated with the account last referenced event or record
Account last viewed dateCalendar date associated with the account last viewed event or record
Account master record IDUnique identifier for the account master record in Salesforce
Account operating owner IDUnique identifier for the account operating owner in Salesforce
Account ownershipOwnership classification assigned to the account
Account parent IDUnique identifier for the account parent in Salesforce
Account photo URLURL associated with the account photo record
Account ratingRating assigned to the related Salesforce record
Account record type IDUnique identifier for the account record type in Salesforce
Account shipping addressShipping address stored for the account
Account shipping country codeReference shipping country code assigned to the account
Account shipping geocode accuracyShipping geocode accuracy stored for the account
Account shipping latitudeGeographic latitude of the related business or location
Account shipping longitudeGeographic longitude of the related business or location
Account shipping postal codeReference shipping postal code assigned to the account
Account shipping stateShipping state stored for the account
Account shipping state codeReference shipping state code assigned to the account
Account shipping streetShipping street stored for the account
Account SIC codeReference sic code assigned to the account
Account SIC descriptionDescription stored for the related account sic record
Account SiteAccount website or site designation
Account ticker symbolPublic stock-market ticker symbol associated with the account
Account system modstampDate and time of the system modstamp lifecycle event for the account
Order reference numberReference reference number assigned to the order
Order descriptionDescription stored for the related order record
Order status codeReference status code assigned to the order
Order end dateCalendar date associated with the order end event or record
Order activated timeDate and time of the activated time lifecycle event for the order
Order billing addressBilling address stored for the order
Order billing country codeReference billing country code assigned to the order
Order billing email addressEmail address stored for the related Salesforce record
Order billing geocode accuracyBilling geocode accuracy stored for the order
Order billing latitudeGeographic latitude of the related business or location
Order billing longitudeGeographic longitude of the related business or location
Order billing phone numberPhone number stored for the related Salesforce record
Order billing postal codeReference billing postal code assigned to the order
Order billing stateBilling state stored for the order
Order billing state codeReference billing state code assigned to the order
Order billing streetBilling street stored for the order
Order bill to contact IDUnique identifier for the order bill to contact in Salesforce
Order company authorized by IDUnique identifier for the order company authorized by in Salesforce
Order company authorized dateCalendar date associated with the order company authorized event or record
Order contract IDUnique identifier for the order contract in Salesforce
Order currency iso codeCurrency used for the related Salesforce amounts and budgets
Order customer authorized by IDUnique identifier for the order customer authorized by in Salesforce
Order customer authorized dateCalendar date associated with the order customer authorized event or record
Order effective dateCalendar date associated with the order effective event or record
Order is reduction orderWhether the order is reduction order
Order last referenced timeDate and time of the last referenced time lifecycle event for the order
Order last viewed timeDate and time of the last viewed time lifecycle event for the order
Order original IDUnique identifier for the order original in Salesforce
Order owner IDUnique identifier for the order owner in Salesforce
Order po dateCalendar date associated with the order po event or record
Order po numberReference po number assigned to the order
Order pricebook IDUnique identifier for the order pricebook in Salesforce
Order quote IDUnique identifier for the order quote in Salesforce
Order record type IDUnique identifier for the order record type in Salesforce
Order related IDUnique identifier for the order related in Salesforce
Order sales channel IDUnique identifier for the order sales channel in Salesforce
Order shipping addressShipping address stored for the order
Order shipping country codeReference shipping country code assigned to the order
Order shipping geocode accuracyShipping geocode accuracy stored for the order
Order shipping latitudeGeographic latitude of the related business or location
Order shipping longitudeGeographic longitude of the related business or location
Order shipping postal codeReference shipping postal code assigned to the order
Order shipping stateShipping state stored for the order
Order shipping state codeReference shipping state code assigned to the order
Order shipping streetShipping street stored for the order
Order ship to contact IDUnique identifier for the order ship to contact in Salesforce
Order tax locale typeType of order tax locale
Order created dateCalendar date associated with the order created event or record
Order last modified dateCalendar date associated with the order last modified event or record
Order item IDUnique identifier for the order item in Salesforce
Order item descriptionDescription stored for the related order item record
Order item end dateCalendar date associated with the order item end event or record
Order line numberReference line number assigned to the order
Order item delivery group IDUnique identifier for the order item delivery group in Salesforce
Order item numberReference item number assigned to the order
Order item original IDUnique identifier for the order item original in Salesforce
Order pricebook entry IDUnique identifier for the order pricebook entry in Salesforce
Order product IDUnique identifier for the order product in Salesforce
Order quote line item IDUnique identifier for the order quote line item in Salesforce
Order related order item IDUnique identifier for the order related order item in Salesforce
Order item service dateCalendar date associated with the order item service event or record
Order item typeType of order item
Order item type codeReference item type code assigned to the order
Order item created dateCalendar date associated with the order item created event or record
Order item last modified dateCalendar date associated with the order item last modified event or record
Contract account IDUnique identifier for the contract account in Salesforce
Contract activated by IDUnique identifier for the contract activated by in Salesforce
Contract activated timeDate and time of the activated time lifecycle event for the contract
Contract billing addressBilling address stored for the contract
Contract billing cityBilling city stored for the contract
Contract billing countryGeographic contract billing country associated with the user, delivery, or conversion
Contract billing country codeCode identifying the related contract billing country
Contract billing geocode accuracyBilling geocode accuracy stored for the contract
Contract billing latitudeGeographic latitude of the related business or location
Contract billing longitudeGeographic longitude of the related business or location
Contract billing postal codeCode identifying the related contract billing postal
Contract billing stateBilling state stored for the contract
Contract billing state codeCode identifying the related contract billing state
Contract billing streetBilling street stored for the contract
Contract company signed dateCalendar date associated with the contract company signed event or record
Contract company signed IDUnique identifier for the contract company signed in Salesforce
Contract customer signed dateCalendar date associated with the contract customer signed event or record
Contract customer signed IDUnique identifier for the contract customer signed in Salesforce
Contract customer signed titleHuman-readable title of the related contract customer signed content
Contract descriptionDescription stored for the related contract record
Contract is deletedWhether the contract is deleted
Contract last activity dateCalendar date associated with the contract last activity event or record
Contract last approved timeDate and time of the last approved time lifecycle event for the contract
Contract last referenced timeDate and time of the last referenced time lifecycle event for the contract
Contract last viewed timeDate and time of the last viewed time lifecycle event for the contract
Contract owner expiration noticeAdvance-notice interval for alerting the contract owner before expiration
Contract owner IDUnique identifier for the contract owner in Salesforce
Contract pricebook IDUnique identifier for the contract pricebook in Salesforce
Contract record type IDUnique identifier for the contract record type in Salesforce
Contract shipping addressShipping address stored for the contract
Contract shipping cityShipping city stored for the contract
Contract shipping countryGeographic contract shipping country associated with the user, delivery, or conversion
Contract shipping country codeCode identifying the related contract shipping country
Contract shipping latitudeGeographic latitude of the related business or location
Contract shipping longitudeGeographic longitude of the related business or location
Contract shipping postal codeCode identifying the related contract shipping postal
Contract shipping stateShipping state stored for the contract
Contract shipping state codeCode identifying the related contract shipping state
Contract shipping streetShipping street stored for the contract
Contract special termsContractual terms or conditions stored for the contract
Contract status codeCode identifying the related contract status
Contract created dateCalendar date associated with the contract created event or record
Contract last modified dateCalendar date associated with the contract last modified event or record