Understanding your total sales performance is important but digging deeper into how your sales reps onboard new customers can reveal even more powerful insights.
One valuable metric to track is this: Which sales reps have onboarded customers whose very first sales order had the lowest value?
Why does this matter?
- It helps evaluate onboarding quality and pricing strategy.
- It supports coaching opportunities for reps closing very small initial deals.
- It provides insight into sales minimum thresholds.
- It highlights trends in early customer acquisition behavior.
Using SuiteQL, you can extract this insight directly from your NetSuite data.
SuiteQL Query: Smallest First Sales Order Value Per Rep
SELECT
e.entityid AS salesrep_name, -- Sales rep's display name
MIN(first_orders.first_order_total) AS smallest_first_order_value -- Among all first sales, the lowest value for this rep
FROM (
-- Subquery: For each customer, find their sales rep,
-- their first sales order date, and the value of that earliest order
SELECT
c.id AS customer_id, -- Customer internal ID
c.salesrep, -- Sales rep's internal ID
MIN(t.trandate) AS first_sales_order_date, -- Earliest sales order date for each customer
MIN(t.foreigntotal) AS first_order_total -- Smallest total among all sales orders on the customer's first order date
FROM transaction t
JOIN customer c ON t.entity = c.id
WHERE t.type = 'SalesOrd' -- Only consider sales orders
GROUP BY c.id, c.salesrep
) first_orders
JOIN employee e ON first_orders.salesrep = e.id -- Link each customer’s first sales info to their sales rep for display
GROUP BY e.entityid
ORDER BY smallest_first_order_value ASC -- Show reps with the lowest first order win at the top
- The subquery finds, for each customer, the date of their first sales order and the value (foreigntotal) of that order.
- The outer query groups those first purchase values by sales rep and finds the minimum for each, so you see the lowest initial customer order for each rep.
- ORDER BY lets you quickly spot which reps have had the smallest customer “first win.”
To easily execute a SuiteQL query, see NetSuite Admin Tip | Running SUITEQL Using a Suitelet
The sample code described herein is provided on an "as is" basis, without warranty of any kind, to the fullest extent permitted by law. Oracle + NetSuite Inc. does not warrant or guarantee the individual success developers may have in implementing the sample code on their development platforms or in using their own Web server configurations.
Oracle + NetSuite Inc. does not warrant, guarantee or make any representations regarding the use, results of use, accuracy, timeliness or completeness of any data or information relating to the sample code. Oracle + NetSuite Inc. disclaims all warranties, express or implied, and in particular, disclaims all warranties of merchantability, fitness for a particular purpose, and warranties related to the code, or any service or software related thereto.
Oracle + NetSuite Inc. shall not be liable for any direct, indirect or consequential damages or costs of any type arising out of any action taken by you or others related to the sample code.
We’d love to hear how you integrate SuiteQL into your NetSuite processes! Share your insights and experiences in the NetSuite Admin Corner.