Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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 Richard James Uri - SuiteCloud | WMS Tech | SuiteCommerce Advanced
----
- NetSuite Admin Corner | New to NetSuite
- Explore the NSC Webinars Category
- Join our poll and share your ideas! We want to know what you think. Don't forget to comment and make your voice heard!
- Expand your NetSuite knowledge by joining this month's Ask A Guru Live about Suitebuilder . RSVP on this event now!
Tagged:
0