NetSuite Admin Tip | Count Active Customers per Sales Rep Using SuiteQL

Understanding how Customers are distributed among Sales Representatives is important for monitoring workload, evaluating performance, and ensuring balanced account management. NetSuite Administrators and analysts often need quick visibility into which Sales Reps manage the largest number of active Customers. Using SuiteQL, you can quickly retrieve a list of sales representatives and the number of active customers assigned to each of them.

Sample Query: Active Customers Per Sales Rep

SELECT
    e.entityid AS salesrep_name,           -- Sales rep display name
    COUNT(DISTINCT c.id) AS customer_count -- Unique count of active customers per rep
FROM customer c
JOIN employee e ON c.salesrep = e.id       -- Join customer to their assigned sales rep