Learn how to manage large Campaign Recipients Tables (CRT) in Amperity.
This article explains options for using CRS, truncating old data, and manually archiving historical records.
Problem
As the Campaign Recipients Table (CRT) grows over time, it can become very large and difficult to query efficiently.
Customers often ask:
Can we remove or truncate older data from CRT?
Is there a way to archive the data instead of deleting it?
What’s the best option for managing table size without losing key information?
Solution
There are a few ways to manage a large CRT depending on your needs — whether you want to optimize performance, reduce storage, or archive old data for future reference.
Below are the available options and best practices.
Option 1: Use the Campaign Recipients Summary (CRS) Table
Recommended for most users.
The Campaign Recipients Summary (CRS) table is an aggregated and optimized version of the CRT.
It’s faster to query, lighter in size, and supports most reporting use cases.
Benefits:
Significantly better performance on large datasets.
Contains key campaign and recipient metrics.
No data loss — it’s designed to summarize CRT data efficiently.
📘 Reference: See guides for using CRS for Campaigns and Journeys in the Amperity documentation.
Option 2: Truncate the CRT (Date-Based Deletion)
If your CRT is very large and you need to permanently remove older data:
You can request a date-based truncation, such as deleting records older than a specific date.
This process is not self-serve and requires Amperity Support or Engineering to perform safely.
Data removed this way is permanently deleted, so take a backup first if you want to keep it.
Important: Truncation is best used only when performance or storage issues become critical.
Option 3: Archive Older Data Manually
If you want to retain historical CRT data outside Amperity:
Export the older data you want to keep.
Store it securely in your organization’s preferred backup or cloud storage system.
After verifying the backup, you can request CRT truncation for the same date range.
Note: Amperity does not currently provide an automated archiving workflow. Manual extraction is required.
Best Practice Recommendations
Use CRS whenever possible for analytics and reporting.
Schedule manual exports for archival if long-term data retention is required.
Only request truncation when the table size begins to impact performance.
Always confirm backups before deleting or truncating any data.
Key Takeaways
CRS is the recommended way to handle large CRT datasets efficiently.
Truncation can be done by request, but data will be permanently removed.
Archiving is manual and should be completed before truncating data.
Contact Amperity Support if you need help identifying the right option for your account.
Related Documentation: