ANS-0099 · SAVED SEARCHES & FORMULAS
How to Optimize NetSuite Saved Search Performance for Marketing Campaigns?
Learn strategies to improve the execution speed of NetSuite saved searches when used for large-scale marketing campaign segmentation.
Short answer
To optimize NetSuite saved search performance for marketing campaigns, split large searches into smaller, more manageable segments, such as alphabetically by first name. Additionally, significantly improve speed by removing all unnecessary filters and columns from the search results, retaining only essential data for the campaign.
Scenario
Users often encounter performance issues when utilizing complex or extensive saved searches to generate recipient lists for NetSuite marketing campaigns. These searches, especially when processing a large volume of records or including numerous criteria and result columns, can experience slow execution times, impacting campaign efficiency.
Solution
To enhance the performance of NetSuite saved searches used in marketing campaigns, consider implementing the following strategies:Split large saved searches into multiple, smaller searches. For example, if targeting contacts, divide the search alphabetically by First Name, such as one search for contacts A to H and another for I to Z. The exact split may require experimentation to achieve optimal balance.Remove any unneeded filters and columns from the search criteria and results. Eliminating superfluous data significantly increases search speed, as marketing campaigns typically require only a minimal set of fields.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support