Rollup Jobs and their Schedules

When first installing any Causeview application, there are three scheduled rollups that happen every night. The purpose of these rollups is to populate missing fields in different records. These three rollups are known as:

1. The Contact Rollup
2. The Accounts Rollup
3. The Multilevel Campaign Rollup

There are two different kinds of nightly contact rollups, as well as the ability to perform a Quick Contact Rollup in real time for reporting purposes. 

The Delta Contact Rollup runs every night at 12:00 am. Its job is to calculate the fields on the Contact Record using Transaction Records. While this job is in progress, it looks in your organization's job history to check for the last successful rollup and finds only the Contacts that have new or updated Transactions since then and updates their record. 

If an organization needs all records to be recalculated nightly, then you can schedule a Full Contact Rollup. This job references all contacts in your organization and recalculates based on all transactions in your organization. Learn how to schedule a Full Contact Roll up.

Causeview also provides the option of performing a Quick Contact Rollup. If you are interested in making sure a Contact’s Rollup information is correct, you have the ability to click the button “Quick Contact Rollup” on any specific Contact Record. This job will ensure that the contact you are on when the button is pressed, is included in the rollup even if that contact has had no transactions since the last success Delta Contact Rollup. This type of rollup is not scheduled, but rather it is a manual process that does the same job as the Delta Contact Rollup in real time. 

The Accounts Rollup does the same job as the Delta Contact Rollup, but instead of calculating fields in the Contact Record, it calculates fields in the Account Record or as you may know in the Organizations Record. The job is scheduled to run every night at 3:00 am. While this job is in progress, it looks in your organization’s job history to check for the last successful rollup and finds only the Accounts that have new or updated Transactions since then and updates the Account fields.

The Multilevel Campaign Rollup is scheduled to run every night at 8:00 pm. Its job calculates multiple fields on the Campaign object. Instead of using Transaction Records, this rollup uses Allocation Records. The Multilevel Campaign Rollup runs very differently from the Contacts or Accounts Rollup because it follows a hierarchy. The job starts by finding any campaigns that do not have child campaigns. Once it has found all the campaigns with no children, it then calculates the information needed on the Campaign object. Once these calculations are completed, it takes the Parent Records of the childless campaigns and runs a job that rolls up the Parent Campaign objects and updates the Campaign object. The Multilevel Campaign Rollup also differs from the Contact and Account Rollups by adding all the totals from its child campaigns.