Predefined Rollups
The sales application provides these predefined rollups:
| Predefined Rollup | Relationship | Rollup Value |
|
Total Number of Employees |
Account only |
The total number of employees in an account and its hierarchy |
|
Fiscal Year Total Potential Revenue |
Account only |
The current fiscal year potential revenue from an account and its hierarchy |
|
Decision Maker Contacts |
Account to Contact |
The total number of decision maker contacts |
|
Total Open Leads |
Account to Sales Lead |
The total count of the qualified and unqualified open leads of an account and its hierarchy |
|
Total Open Hot Leads |
Account to Sales Lead |
The total count of the qualified and unqualified hot leads of an account and its hierarchy |
|
Qualified Hot Leads |
Account to Sales Lead |
The count of leads that are qualified and hot |
|
Qualified Leads |
Account to Sales Lead |
The count of leads that are qualified |
|
Potential Revenue from Open Leads |
Account to Sales Lead |
The total potential revenue from open leads |
|
Total Open Critical Service Requests |
Account to Service Request |
The total count of the open, critical service requests that are in the new, in-progress, or waiting status of an account and its hierarchy |
|
Total Open Service Requests |
Account to Service Request |
The total count of service requests that are in the open, in-progress, and waiting statuses, associated with an account and its hierarchy |
|
Service Requests Closed in the Past Week |
Account to Service Request |
The count of Service Requests with the close date failing in the past 7 days |
|
Total Amount from Open Opportunity Quotes and Orders |
Account to Quotes and Orders |
The sum of amounts from the open and in-progress opportunity quotes and orders of an account and its hierarchy |
|
Total Open Activities |
Account to Activity |
The total count of open tasks of an account and its hierarchy |
|
Total Potential Revenue from Open Opportunities |
Account to Opportunity |
The sum of the potential revenue from the open opportunities of an account and its hierarchy |
|
Total Potential Revenue from Won Opportunities |
Account to Opportunity |
The sum of the potential revenue from the won opportunities of an account and its hierarchy |
|
Total Open Opportunities |
Account to Opportunity |
The total count of open opportunities of an account and its hierarchy |
|
Total Amount from Closed Opportunity Quotes and Orders |
Account to Opportunity |
The sum of the amount from the closed and won opportunity quotes and orders of an account and its hierarchy |
|
Next Opportunity Closing Date |
Account to Opportunity |
The date when the next opportunity is expected to close |
|
Last Call Made |
Account to Interaction |
The date when your team made a phone call to any of the contacts associated with an account or its hierarchy |
|
Total Calls Made |
Account to Interaction |
The total number of phone calls made to an account and its hierarchy |
|
Last Email Sent |
Account to Interaction |
The date when the last email was sent to any of the contacts associated with an account or its hierarchy |
|
Total Emails Sent |
Account to Interaction |
The total number of emails sent to an account and its hierarchy |
|
Total Touches |
Account to Interaction |
The total number of calls made or emails sent to an account and its hierarchy |
|
Last Touch |
Account to Interaction |
The date when an account and its hierarchy were last contacted, either by email or phone |
| Total Number of Open Leads Associated with a Contact | Contact to Sales Lead | The total number of qualified and unqualified open leads associated with a contact |
| Total Number of Open Hot Leads Associated with a Contact | Contact to Sales Lead | The total number of qualified and unqualified hot leads associated with a contact |
|
Total Number of Open Opportunities Associated with a Contact |
Contact to Opportunity | The total number of open opportunities associated with a contact |
|
Sum of Open Opportunities Revenues Associated with a Contact |
Contact to Opportunity | The cumulative total of revenue from the open opportunities associated with a contact |
|
Total Number of Open Service Requests Associated with a Contact |
Contact to Service Request | The total number of service requests that are in the open, in progress, or waiting statuses |
|
Total Number of Critical Open Service Requests Associated with a Contact |
Contact to Service Request | The total number of service requests in the open, in progress, or waiting statuses, marked as critical |
| Total Number of Touches with a Contact | Contact to Interaction | The total number of emails sent or calls made to a contact in the last 120 days |
|
Date of Last Touch with a Contact |
Contact to Interaction | The date when the last email was sent or call was made to a contact in the last 120 days |
|
Total Number of Calls Made to a Contact |
Contact to Interaction | The total number of phone calls made to a contact in the last 120 days |
|
Total Number of Emails Sent to a Contact |
Contact to Interaction | The total number of emails sent to a contact in the last 120 days |
|
Last Call Made to a Contact |
Contact to Interaction | The date when the last outbound phone call was made to a contact in the last 120 days |
|
Last Email Sent to a Contact |
Contact to Interaction | The date when the last email was sent to a contact in the last 120 days |
|
Date of Last Response from a Contact |
Contact to Interaction | The date when a last email or call was received from a contact in the last 120 days |
| Total Number of Responses Received from a Contact | Contact to Interaction | The total number of calls or emails received from a contact in the last 120 days |
| Total Number of Open Activities for a Contact | Contact to Activity |
The cumulative total of:
|
| Last Touch Date | Sales Lead to Interaction | The date when the last call or email was sent in the context of a lead |
| Last Call Made | Sales Lead to Interaction | The date when the last call was made in the context of a lead |
| Total Call Made | Sales Lead to Interaction | The total number of calls made in the context of a lead |
| Total Emails Sent | Sales Lead to Interaction | The total number of emails sent in the context of a lead |
| Total Touches | Sales Lead to Interaction | The total number of emails and calls made in the context of a lead |
| Last Email Sent | Sales Lead to Interaction | The date when the last email was sent in the context of a lead |
| Total Open Activities | Sales Lead to Interaction |
The cumulative total of:
|
| Total Open Opportunities | Campaign to Opportunity | The total number of open opportunities associated with a campaign |
| Total Won Opportunities | Campaign to Opportunity | The total number of won opportunities associated with a campaign |
| Total Revenue from Opportunities | Campaign to Opportunity | The total revenue from the open opportunities associated with a campaign |
| Total Opportunities | Campaign to Opportunity | The total number of opportunities associated with a campaign |
| Total Revenue from Open Opportunities | Campaign to Opportunity | The total revenue from the open opportunities associated with a campaign |
| Total Revenue from Won Opportunities | Campaign to Opportunity | The total revenue from the won opportunities associated with a campaign |
| Total Converted Leads | Campaign to Sales Lead | The total number of converted leads associated with a campaign |
| Total Leads | Campaign to Sales Lead | The total number of leads from a campaign |
| Total Hot Open Leads | Campaign to Sales Lead | The total number of unqualified or qualified leads ranked as hot that are associated with a campaign |
| Total Open Leads | Campaign to Sales Lead | The total number of unqualified or qualified open leads associated with a campaign |
| Total Revenue from Open Leads | Campaign to Sales Lead | The total amount from the unqualified and qualified leads associated with a campaign |
| Total Emails Sent | Opportunity to Interaction | The total number of emails sent in the context of an opportunity |
| Total Touches | Opportunity to Interaction | The total number of email and calls made in the context of an opportunity |
| Last Email Sent | Opportunity to Interaction | The date when the last email was sent in the context of an opportunity |
| Total Calls Made | Opportunity to Interaction | The total number of calls made in the context of an opportunity |
| Last Call Made | Opportunity to Interaction | The date when the last call was made in the context of an opportunity |
| Last Touch Date | Opportunity to Interaction | The date when the last call or email sent in the context of an opportunity |
| Total Open Activities | Opportunity to Activity |
The cumulative total of:
|