Salesforce Fields
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 |
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 |