Reducing Activity Table Size

One feature of SugarChimp is to sync Mailchimp campaign activity (such as sends, opens, and clicks) to your CRM. When that data is brought over, they're stored in SugarChimp-specific tables and displayed within the Mailchimp Activities sub panel and in reports. These tables are:

sugarchimpactivity
sugarchimpactivity_contacts
sugarchimpactivity_leads
sugarchimpactivity_prospects

Over time, these tables get larger as activity data is synced. If you have high volume or have been with SugarChimp many years, it is recommended that you follow these high volume recommendations which includes not keeping campaign activity data for long lengths of time.

To reduce these table sizes right away, you can either:

• Fully truncate the tables. This solution is fine if you don't want to keep any campaign activities and instead want to start fresh with empty tables.
• Delete activities older than a certain timeframe. For those who wish to keep recent activities, such as within the last 30 days, use the date created or date entered column to delete older activities that no longer need to remain in your CRM.

Note: You will retain access to these activities from directly in Mailchimp should you ever need to reference them again.

In addition to reducing the table sizes using one of the solutions above you can prevent the tables from getting large in the future by setting SugarChimp to automatically delete synced activities beyond a certain number of days. Since a lot of customers don't regularly review campaigns sent beyond 90 or 180 days, for example, those activities can be deleted from Sugar. Updating that setting for SugarChimp is done through the console using the steps below:

1. From within SugarChimp's Health Status page, right-click anywhere on the page and select Inspect.
2. Click the Console tab
3. Copy/paste the following into the console and press Enter:

SUGAR.App.api.call('get',SUGAR.App.api.buildURL('SugarChimp/setting/remove_activities_after_days/90'),{},{});