Computed Properties - Computations for System Properties

The expressions for computed system Properties are listed below:

• Interaction Properties

• Contact Properties

• Target Properties

• Campaign Properties

• Account Properties

Interaction Properties

System Property	Expression
Resolution time for an Interaction	The time taken for the state of all Interactions to change from Open to Resolved. The value for this Property is calculated by adding the time taken for each Interaction's state to be changed from Open to Resolved. Formula: SUM (All intervals for Interaction state to change from Open to Resolved).
Response time for an Interaction	The average time taken to respond to an Open Interaction. The value for this Property is calculated as the average of the intervals between the Open state and the immediate response following the Open state, for all Interactions. The state of an Interaction can be changed to Open any number of times. The value for the Response time for an Interaction Property includes the response time for an Interaction after each time its state is changed to Open. Formula: AVERAGE (All intervals between Interaction state changing to Open and the first response after each time the state is changed to Open).

System Property

Expression

Resolution time for an Interaction

The time taken for the state of all Interactions to change from Open to Resolved. The value for this Property is calculated by adding the time taken for each Interaction's state to be changed from Open to Resolved.

Formula: SUM (All intervals for Interaction state to change from Open to Resolved).

Response time for an Interaction

The average time taken to respond to an Open Interaction. The value for this Property is calculated as the average of the intervals between the Open state and the immediate response following the Open state, for all Interactions.

The state of an Interaction can be changed to Open any number of times. The value for the Response time for an Interaction Property includes the response time for an Interaction after each time its state is changed to Open.

Formula: AVERAGE (All intervals between Interaction state changing to Open and the first response after each time the state is changed to Open).

Contact Properties

System Property	Expression
Base Cost	The cost associated with each Contact imported from an external data source. The value for this Property is calculated by dividing the total cost of the external data source by the number of Contacts imported. Formula: Total cost of the External Data Source / Number of Contacts imported.
Total Cost	The sum of all Target costs associated with the Contact, when the Contact is added as a Target in a Campaign. Formula: Base Cost + SUM(Target.Cost).
Actual Value	The total revenue generated from Orders associated with the Contact. The total revenue is calculated by multiplying the Base Price of the Product with the quantity purchased by the Contact, then deducting the discount offered, and multiplying by the Probability Percentage. Formula: SUM((Base Price * Quantity) - (Base Price * Quantity * discount/100)) * Opportunity.Probability/100.
Contact ROI	The return on investment for a Contact. The value for this Property is calculated as the percentage of the difference between the revenue from Orders associated with the Contact, and the total cost of the Contact. Formula: [SUM(Order.Revenue) – Total cost] / Total cost * 100 %

Target Properties

System Property	Expression
Base cost	A Contact added to a Campaign becomes a Target when it progresses from one Step to another in the Campaign Workflow. The Base cost Property computes the cost associated with each such Contact when the Contact is imported from an external data source. The value for this Property is calculated by dividing the total cost of the external data source by the number of Contacts imported. Formula: Total cost of the External Data Source / Number of Contacts imported.
Cumulative cost	The sum of all costs associated with each Step in a Campaign through which the Target has progressed. Formula: SUM(Target.Cost).

System Property

Expression

Base cost

A Contact added to a Campaign becomes a Target when it progresses from one Step to another in the Campaign Workflow. The Base cost Property computes the cost associated with each such Contact when the Contact is imported from an external data source.

The value for this Property is calculated by dividing the total cost of the external data source by the number of Contacts imported.

Formula: Total cost of the External Data Source / Number of Contacts imported.

Cumulative cost

The sum of all costs associated with each Step in a Campaign through which the Target has progressed.

Formula: SUM(Target.Cost).

Campaign Properties

System Property	Expression
Campaign ROI	The return on investment for the Campaign. This computation is the difference between the revenue generated from the Campaign, and the cost incurred. Formula: [SUM(Order.Revenue) – SUM(Campaign. Cost)] / SUM(Campaign.Cost) * 100%.
Campaign Cost	The total cost incurred on all Targets in the Campaign. Formula: SUM(Target.Cost).

System Property

Expression

Campaign ROI

The return on investment for the Campaign. This computation is the difference between the revenue generated from the Campaign, and the cost incurred.

Formula: [SUM(Order.Revenue) – SUM(Campaign. Cost)] / SUM(Campaign.Cost) * 100%.

Campaign Cost

The total cost incurred on all Targets in the Campaign.

Formula: SUM(Target.Cost).

Account Properties

System Property	Expression
Percentage Success	The percentage of Opportunities associated with the Account, which were converted into Orders. Formula: SUM(Order.Revenue) / SUM(Opportunity.Revenue).
Total value	The total revenue generated from Orders associated with the Account. Formula: SUM(Order. Revenue).
Projected Value	The total revenue expected from all Opportunities associated with the Account. Formula: SUM((Base Price * Quantity) - (Base Price * Quantity * Discount/100)) * Opportunity.Probability/100.
Total cost	The total cost of all Contacts associated with the Account. Formula: SUM(Contact.Total cost).

Note

• Orders can be linked to either Contacts or Accounts, or both. If an Order is linked to a Contact only, it is typically a business to consumer scenario. Hence, the revenue for the Contact can be calculated as SUM(Order.revenue).

• If an Order is linked to an Account, it is typically a business to business scenario. The formula SUM(Order.revenue) computes the revenue from the Account.

• If an Order is linked to an Account and a Contact, the revenue is calculated for both the Contact and the Account.