Delivery statistics filter not working due to 10,000 record limit in Adobe Campaign Standard Dynamic Reports
This article provides a workaround to mitigate the issue caused by a system limitation in Adobe Campaign Standard. The root cause—search logic scanning only the first 10,000 delivery records—remains unchanged. Reducing the data retention period helps bring the total number of records below this threshold, allowing filters to function correctly.
Description description
Environment
- Adobe Campaign Standard
- Any instance that has over 10,000 deliveries
Issue/Symptoms
The delivery statistics contains filter does not return the full results when specific keywords are applied. The issue is linked to limitations in search logic, which scans the first 10,000 delivery records. For example:
- Filtering deliveries using a keyword Welcome may yield partial or no results if there are over 10,000 deliveries in the instance.
- The issue is linked to limitations in search logic, which accesses up to the first 10,000 delivery records.
- The problem can also occur when there are more than 50 delivery results for a given filter condition.
Resolution resolution
Note: Starting June 1, 2025, the default data retention period for deliveries will be set to 2 years (730 days) on most Adobe Campaign Standard instances. This change increases the likelihood of encountering the delivery statistics filter issue, as more instances will exceed the 10,000 delivery record limit imposed by the system’s search logic.
To mitigate the issue caused by the 10,000-record scan limit in Adobe Campaign Standard’s delivery statistics filter, follow these steps:
- Modify the purge setting from
-1
(never delete) to365 days
(1 year). This adjustment ensures that older data is purged periodically, reducing clutter and improving filter performance. - Reduce the date range of your report to limit the number of deliveries being filtered. Ensure that fewer than 50 deliveries match your filtering criteria. This may help the filter return more accurate results, but it is not a guaranteed fix, especially in high-volume environments.
- After implementing the purge setting update or workaround, test the filter by applying different keywords and verifying if the expected results are displayed.
- Regularly monitor report behavior after making changes to ensure consistent functionality. If issues persist or new problems arise, contact Adobe Support for further assistance.
Related reading
- About Reporting: Troubleshooting in Campaign Standard Documentation
- Data Retention Settings in Campaign Standard Documentation