What is the maximum number of rows returned per query in CRM Analytics?

In CRM Analytics, the maximum number of rows that can be returned per query is 25,000. This limit is established to optimize performance and ensure that analysis is manageable and efficient.

When dealing with large datasets, returning an excessive number of rows can lead to performance issues, such as slow response times and increased load on the system. By capping the result set, the platform promotes more efficient querying practices and encourages users to use filtering or aggregation techniques to narrow down data to the most relevant insights.

This limit is crucial for maintaining system responsiveness, allowing users to focus on actionable data without being overwhelmed by too much information at once. Thus, the cap of 25,000 rows ensures that users can work with substantial datasets while keeping performance manageable.