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 Name | Description |
|---|---|
| Campaign count | Total campaigns |
| Campaign actual cost | Actual campaign cost |
| Campaign all opportunities amount | All opportunity value |
| Campaign won opportunities amount | Won opportunity value |
| Campaign budgeted cost | Budgeted cost |
| Campaign expected response | Expected response |
| Campaign expected revenue | Expected revenue |
| Campaign total contacts | Contact count |
| Campaign converted leads | Converted leads |
| Campaign leads | Total leads |
| Campaign opportunities | Opportunity count |
| Campaign responses | Response count |
| Campaign won opportunities | Won opportunity count |
| Campaign num sent | Number sent |
Campaign Hierarchy Metrics
| Field Name | Description |
|---|---|
| Campaign total actual cost in hierarchy | Hierarchy actual cost |
| Campaign total budgeted cost in hierarchy | Hierarchy budgeted cost |
| Campaign total expected revenue in hierarchy | Hierarchy expected revenue |
| Campaign total num sent in hierarchy | Hierarchy num sent |
| Campaign total value opportunities in hierarchy | Hierarchy opp value |
| Campaign total value won opportunities in hierarchy | Hierarchy won value |
| Campaign total contacts in hierarchy | Hierarchy contacts |
| Campaign total converted leads in hierarchy | Hierarchy converted leads |
| Campaign total leads in hierarchy | Hierarchy leads |
| Campaign total opportunities in hierarchy | Hierarchy opportunities |
| Campaign total responses in hierarchy | Hierarchy responses |
| Campaign total won opportunities in hierarchy | Hierarchy won opps |
Object Counts
| Field Name | Description |
|---|---|
| Contact count | Total contacts |
| Leads | Total leads |
| Accounts | Total accounts |
| Opportunity count | Total opportunities |
| Task count | Total tasks |
Account Metrics
| Field Name | Description |
|---|---|
| Account number of employees | Employee count |
| Account annual revenue | Annual revenue |
Opportunity Metrics
| Field Name | Description |
|---|---|
| Opportunity amount | Opportunity value |
Task Metrics
| Field Name | Description |
|---|---|
| Task call duration | Call duration (seconds) |
Order Metrics
| Field Name | Description |
|---|---|
| Order total amount | Total order amount |
| Order total tax amount | Total tax |
| Order grand total amount | Grand total |
| Order total adjusted delivery amount | Adjusted delivery |
| Order total adjusted product amount | Adjusted product |
Contract Metrics
| Field Name | Description |
|---|---|
| Contract term (month) | Contract term |
| Order total adjusted delivery amount with tax | Order total adjusted delivery amount with tax |
| Order total adjusted product amount with tax | Order total adjusted product amount with tax |
| Order total adjusted delivery tax amount | Order total adjusted delivery tax amount |
| Order total adjusted product tax amount | Order total adjusted product tax amount |
| Order delivery adjustment distributed amounts | Order delivery adjustment distributed amounts |
| Order delivery adjustment distributed amounts with tax | Order delivery adjustment distributed amounts with tax |
| Order delivery adjustment distributed tax amounts | Order delivery adjustment distributed tax amounts |
| Order product adjustment distributed amounts | Order product adjustment distributed amounts |
| Order product adjustment distributed amounts with tax | Order product adjustment distributed amounts with tax |
| Order product adjustment distributed tax amount | Order product adjustment distributed tax amount |
| Order item unit price | Order item unit price |
| Order item gross unit price | Order item gross unit price |
| Order item list price | Order item list price |
| Order item quantity | Order item quantity |
| Order item available quantity | Order item available quantity |
| Order item adjusted line amount | Order item adjusted line amount |
| Order item adjusted line amount with tax | Order item adjusted line amount with tax |
| Order item rounded line amount | Order item rounded line amount |
| Order item rounded line amount with tax | Order item rounded line amount with tax |
| Order item total adjusted line tax amount | Order item total adjusted line tax amount |
| Order item total adjustment amount | Order item total adjustment amount |
| Order item total adjustment amount with tax | Order item total adjustment amount with tax |
| Order item total adjustment distributed amount | Order item total adjustment distributed amount |
| Order item total adjustment distributed tax amount | Order item total adjustment distributed tax amount |
| Order item total adjustment distributed amount with tax | Order item total adjustment distributed amount with tax |
| Order item total adjustment tax amount | Order item total adjustment tax amount |
| Order item total amount with tax | Order item total amount with tax |
| Order item total line adjustment amount | Order item total line adjustment amount |
| Order item total line adjustment amount with tax | Order item total line adjustment amount with tax |
| Order item total line adjustment tax amount | Order item total line adjustment tax amount |
| Order item total line amount | Order item total line amount |
| Order item total line tax amount | Order item total line tax amount |
| Order item total price | Order item total price |
| Order item total tax amount | Order item total tax amount |
Breakdowns
Campaign Breakdowns
| Field Name | Description |
|---|---|
| Campaign ID | Campaign identifier |
| Campaign description | Description |
| Campaign end date | End date |
| Campaign is active | Active status |
| Campaign name | Campaign name |
| Campaign start date | Start date |
| Campaign status | Status |
| Campaign type | Type |
| Campaign created date | Creation date |
| Campaign last modified date | Last modified |
Opportunity Breakdowns
| Field Name | Description |
|---|---|
| Opportunity ID | Opportunity identifier |
| Opportunity name | Name |
| Opportunity type | Type |
| Opportunity description | Description |
| Opportunity stage | Stage |
| Opportunity close date | Close date |
| Opportunity lead source | Lead source |
| Opportunity is closed | Closed status |
| Opportunity is won | Won status |
| Opportunity forecast category | Forecast category |
| Opportunity probability (%) | Win probability |
| Opportunity owner | Owner name |
| Opportunity account name | Account name |
Contact Breakdowns
| Field Name | Description |
|---|---|
| Contact ID | Contact identifier |
| Contact first name | First name |
| Contact last name | Last name |
| Contact email | |
| Contact phone | Phone |
| Contact department | Department |
| Contact title | Title |
| Contact lead source | Lead source |
| Contact mailing city | City |
| Contact mailing country | Country |
Lead Breakdowns
| Field Name | Description |
|---|---|
| Lead ID | Lead identifier |
| Lead first name | First name |
| Lead last name | Last name |
| Lead company | Company |
| Lead email | |
| Lead phone | Phone |
| Lead status | Status |
| Lead source | Source |
| Lead country | Country |
| Lead is converted | Conversion status |
Account Breakdowns
| Field Name | Description |
|---|---|
| Account ID | Account identifier |
| Account name | Account name |
| Account type | Type |
| Account industry | Industry |
| Account website | Website |
| Account phone number | Phone |
| Account billing city | Billing city |
| Account billing country | Billing country |
| Account shipping city | Shipping city |
| Account shipping country | Shipping country |
Task Breakdowns
| Field Name | Description |
|---|---|
| Task ID | Task identifier |
| Task subject | Subject |
| Task status | Status |
| Task priority | Priority |
| Task type | Type |
| Task owner | Owner name |
| Task due date | Due date |
Order Breakdowns
| Field Name | Description |
|---|---|
| Order ID | Order identifier |
| Order number | Order number |
| Order name | Order name |
| Order status | Status |
| Order type | Type |
| Ordered time | Order date |
| Order billing city | Billing city |
| Order billing country | Billing country |
| Order shipping city | Shipping city |
| Order shipping country | Shipping country |
Contract Breakdowns
| Field Name | Description |
|---|---|
| Contract ID | Contract identifier |
| Contract number | Contract number |
| Contract status | Status |
| Contract start date | Start date |
| Contract end date | End date |
| Campaign last activity date | Campaign last activity date |
| Campaign last referenced date | Campaign last referenced date |
| Campaign last viewed date | Campaign last viewed date |
| Opportunity next step | Opportunity next step |
| Opportunity forecast category name | Opportunity forecast category name |
| Opportunity has line item | Opportunity has line item |
| Opportunity created date | Opportunity created date |
| Opportunity last modified date | Opportunity last modified date |
| Opportunity last activity date | Opportunity last activity date |
| Opportunity fiscal quarter | Opportunity fiscal quarter |
| Opportunity fiscal year | Opportunity fiscal year |
| Opportunity fiscal period | Opportunity fiscal period |
| Opportunity last viewed date | Opportunity last viewed date |
| Opportunity last referenced date | Opportunity last referenced date |
| Opportunity has open activity | Opportunity has open activity |
| Opportunity has overdue task | Opportunity has overdue task |
| Opportunity account source | Opportunity account source |
| Opportunity account phone | Opportunity account phone |
| Opportunity account industry | Opportunity account industry |
| Opportunity account employee count | Opportunity account employee count |
| Opportunity account description | Opportunity account description |
| Opportunity age (weeks) | Opportunity age (weeks) |
| Opportunity value range | Opportunity value range |
| Opportunity product ID | Opportunity product ID |
| Opportunity product name | Opportunity product name |
| Opportunity product description | Opportunity product description |
| Opportunity product discount | Opportunity product discount |
| Opportunity product created date | Opportunity product created date |
| Opportunity product updated date | Opportunity product updated date |
| Opportunity product code | Opportunity product code |
| Task is completed | Task is completed |
| Task name ID | Task name ID |
| Task related to ID | Task related to ID |
| Task is high priority | Task is high priority |
| Task assigned to ID | Task assigned to ID |
| Task description | Task description |
| Task is deleted | Task is deleted |
| Task account ID | Task account ID |
| Task created date | Task created date |
| Task created by ID | Task created by ID |
| Task last modified date | Task last modified date |
| Task last modified by ID | Task last modified by ID |
| Task is archived | Task is archived |
| Task call type | Task call type |
| Task call result | Task call result |
| Task call object identifier | Task call object identifier |
| Task reminder date & time | Task reminder date & time |
| Task has a reminder | Task has a reminder |
| Task recurrence activity ID | Task recurrence activity ID |
| Task has recurring series of tasks | Task has recurring series of tasks |
| Task recurrence start date | Task recurrence start date |
| Task recurrence end date | Task recurrence end date |
| Task recurrence time zone | Task recurrence time zone |
| Task recurrence type | Task recurrence type |
| Task recurrence interval | Task recurrence interval |
| Task recurrence day of week | Task recurrence day of week |
| Task recurrence day of month | Task recurrence day of month |
| Task recurrence instance | Task recurrence instance |
| Task recurrence month of year | Task recurrence month of year |
| Repeat this task | Repeat this task |
| Task subtype | Task subtype |
| Contact account name | Contact account name |
| Contact account ID | Contact account ID |
| Contact assistant | Contact assistant |
| Contact assistant phone | Contact assistant phone |
| Contact birth date | Contact birth date |
| Contact owner | Contact owner |
| Contact created by | Contact created by |
| Contact created date | Contact created date |
| Contact is deleted | Contact is deleted |
| Contact description | Contact description |
| Contact do not call | Contact do not call |
| Contact email bounced date | Contact email bounced date |
| Contact email bounced reason | Contact email bounced reason |
| Contact email opt out | Contact email opt out |
| Contact fax | Contact fax |
| Contact fax opt out | Contact fax opt out |
| Contact home phone | Contact home phone |
| Contact is email bounced | Contact is email bounced |
| Contact last activity date | Contact last activity date |
| Contact last modified by | Contact last modified by |
| Contact last modified date | Contact last modified date |
| Contact last referenced date | Contact last referenced date |
| Contact last viewed date | Contact last viewed date |
| Contact mailing country code | Contact mailing country code |
| Contact mailing geocode accuracy | Contact mailing geocode accuracy |
| Contact mailing latitude | Contact mailing latitude |
| Contact mailing longitude | Contact mailing longitude |
| Contact mailing state/province | Contact mailing state/province |
| Contact mailing state/province code | Contact mailing state/province code |
| Contact mailing street | Contact mailing street |
| Contact mailing zip/postal code | Contact mailing zip/postal code |
| Contact mobile phone | Contact mobile phone |
| Contact full name | Contact full name |
| Contact other city | Contact other city |
| Contact other country | Contact other country |
| Contact other state/province | Contact other state/province |
| Contact other street | Contact other street |
| Contact other zip/postal code | Contact other zip/postal code |
| Contact other phone | Contact other phone |
| Contact photo URL | Contact photo URL |
| Contact reports to | Contact reports to |
| Contact salutation | Contact salutation |
| Lead title | Lead title |
| Lead state | Lead state |
| Lead mobile | Lead mobile |
| Lead owner ID | Lead owner ID |
| Lead owner name | Lead owner name |
| Lead owner email | Lead owner email |
| Lead owner department | Lead owner department |
| Lead last activity date | Lead last activity date |
| Lead is deleted | Lead is deleted |
| Lead converted account ID | Lead converted account ID |
| Lead converted contact ID | Lead converted contact ID |
| Lead converted opportunity ID | Lead converted opportunity ID |
| Lead converted date | Lead converted date |
| Lead created date | Lead created date |
| Lead last modified date | Lead last modified date |
| Account number | Account number |
| Account source | Account source |
| Account billing address | Account billing address |
| Account billing country code | Account billing country code |
| Account billing geocode accuracy | Account billing geocode accuracy |
| Account billing latitude | Account billing latitude |
| Account billing longitude | Account billing longitude |
| Account billing postal code | Account billing postal code |
| Account billing state | Account billing state |
| Account billing state code | Account billing state code |
| Account billing street | Account billing street |
| Account created by ID | Account created by ID |
| Account created date | Account created date |
| Account description | Account description |
| Account fax | Account fax |
| Account is deleted | Account is deleted |
| Account Jigsaw | Account Jigsaw |
| Account Jigsaw company ID | Account Jigsaw company ID |
| Account last activity date | Account last activity date |
| Account last modified by ID | Account last modified by ID |
| Account last modified date | Account last modified date |
| Account last referenced date | Account last referenced date |
| Account last viewed date | Account last viewed date |
| Account master record ID | Account master record ID |
| Account operating owner ID | Account operating owner ID |
| Account ownership | Account ownership |
| Account parent ID | Account parent ID |
| Account photo URL | Account photo URL |
| Account rating | Account rating |
| Account record type ID | Account record type ID |
| Account shipping address | Account shipping address |
| Account shipping country code | Account shipping country code |
| Account shipping geocode accuracy | Account shipping geocode accuracy |
| Account shipping latitude | Account shipping latitude |
| Account shipping longitude | Account shipping longitude |
| Account shipping postal code | Account shipping postal code |
| Account shipping state | Account shipping state |
| Account shipping state code | Account shipping state code |
| Account shipping street | Account shipping street |
| Account SIC code | Account SIC code |
| Account SIC description | Account SIC description |
| Account Site | Account Site |
| Account ticker symbol | Account ticker symbol |
| Account system modstamp | Account system modstamp |
| Order reference number | Order reference number |
| Order description | Order description |
| Order status code | Order status code |
| Order end date | Order end date |
| Order activated time | Order activated time |
| Order billing address | Order billing address |
| Order billing country code | Order billing country code |
| Order billing email address | Order billing email address |
| Order billing geocode accuracy | Order billing geocode accuracy |
| Order billing latitude | Order billing latitude |
| Order billing longitude | Order billing longitude |
| Order billing phone number | Order billing phone number |
| Order billing postal code | Order billing postal code |
| Order billing state | Order billing state |
| Order billing state code | Order billing state code |
| Order billing street | Order billing street |
| Order bill to contact ID | Order bill to contact ID |
| Order company authorized by ID | Order company authorized by ID |
| Order company authorized date | Order company authorized date |
| Order contract ID | Order contract ID |
| Order currency iso code | Order currency iso code |
| Order customer authorized by ID | Order customer authorized by ID |
| Order customer authorized date | Order customer authorized date |
| Order effective date | Order effective date |
| Order is reduction order | Order is reduction order |
| Order last referenced time | Order last referenced time |
| Order last viewed time | Order last viewed time |
| Order original ID | Order original ID |
| Order owner ID | Order owner ID |
| Order po date | Order po date |
| Order po number | Order po number |
| Order pricebook ID | Order pricebook ID |
| Order quote ID | Order quote ID |
| Order record type ID | Order record type ID |
| Order related ID | Order related ID |
| Order sales channel ID | Order sales channel ID |
| Order shipping address | Order shipping address |
| Order shipping country code | Order shipping country code |
| Order shipping geocode accuracy | Order shipping geocode accuracy |
| Order shipping latitude | Order shipping latitude |
| Order shipping longitude | Order shipping longitude |
| Order shipping postal code | Order shipping postal code |
| Order shipping state | Order shipping state |
| Order shipping state code | Order shipping state code |
| Order shipping street | Order shipping street |
| Order ship to contact ID | Order ship to contact ID |
| Order tax locale type | Order tax locale type |
| Order created date | Order created date |
| Order last modified date | Order last modified date |
| Order item ID | Order item ID |
| Order item description | Order item description |
| Order item end date | Order item end date |
| Order line number | Order line number |
| Order item delivery group ID | Order item delivery group ID |
| Order item number | Order item number |
| Order item original ID | Order item original ID |
| Order pricebook entry ID | Order pricebook entry ID |
| Order product ID | Order product ID |
| Order quote line item ID | Order quote line item ID |
| Order related order item ID | Order related order item ID |
| Order item service date | Order item service date |
| Order item type | Order item type |
| Order item type code | Order item type code |
| Order item created date | Order item created date |
| Order item last modified date | Order item last modified date |
| Contract account ID | Contract account ID |
| Contract activated by ID | Contract activated by ID |
| Contract activated time | Contract activated time |
| Contract billing address | Contract billing address |
| Contract billing city | Contract billing city |
| Contract billing country | Contract billing country |
| Contract billing country code | Contract billing country code |
| Contract billing geocode accuracy | Contract billing geocode accuracy |
| Contract billing latitude | Contract billing latitude |
| Contract billing longitude | Contract billing longitude |
| Contract billing postal code | Contract billing postal code |
| Contract billing state | Contract billing state |
| Contract billing state code | Contract billing state code |
| Contract billing street | Contract billing street |
| Contract company signed date | Contract company signed date |
| Contract company signed ID | Contract company signed ID |
| Contract customer signed date | Contract customer signed date |
| Contract customer signed ID | Contract customer signed ID |
| Contract customer signed title | Contract customer signed title |
| Contract description | Contract description |
| Contract is deleted | Contract is deleted |
| Contract last activity date | Contract last activity date |
| Contract last approved time | Contract last approved time |
| Contract last referenced time | Contract last referenced time |
| Contract last viewed time | Contract last viewed time |
| Contract owner expiration notice | Contract owner expiration notice |
| Contract owner ID | Contract owner ID |
| Contract pricebook ID | Contract pricebook ID |
| Contract record type ID | Contract record type ID |
| Contract shipping address | Contract shipping address |
| Contract shipping city | Contract shipping city |
| Contract shipping country | Contract shipping country |
| Contract shipping country code | Contract shipping country code |
| Contract shipping latitude | Contract shipping latitude |
| Contract shipping longitude | Contract shipping longitude |
| Contract shipping postal code | Contract shipping postal code |
| Contract shipping state | Contract shipping state |
| Contract shipping state code | Contract shipping state code |
| Contract shipping street | Contract shipping street |
| Contract special terms | Contract special terms |
| Contract status code | Contract status code |
| Contract created date | Contract created date |
| Contract last modified date | Contract last modified date |