Skip to main content
Card class: Card

​
At a glance

Count of distinct customers who placed at least one Sales Order in the period. Distinct from the all-time customer count (which includes long-dormant accounts) and from new-customer count (those placing their first-ever SO). The active-customer count is the merchant’s working-account-base view: how many customers are buying right now.
What it countsCOUNT(DISTINCT customer.internalid WHERE customer placed >=1 SO in period AND SO.status NOT IN ('Cancelled')). Each customer counts once regardless of order volume in the period.
VAT / tax treatmentn/a, this is a count metric.
Shippingn/a.
Discountsn/a.
RefundsA customer whose only order in the period was refunded / cancelled is excluded.
Cancelled / voided ordersCustomers whose only orders were cancelled are excluded.
Currencyn/a; customer-count is currency-agnostic.
Channels / sourcesAll sources blended: web (SuiteCommerce / SCA), B2B portal, manual SO, EDI inbound. Per-channel views available via Ask Viq. NetSuite’s customer record is unified across channels (unlike commerce platforms where the same buyer can have separate records).
B2B vs B2C distinctionNetSuite distinguishes Customers (companies, B2B) from Sub-Customers (individual contacts under a parent company) and uses Customer Categories (DTC, Wholesale, Distributor, etc). The default count blends all; per-category breakdowns expose the B2B vs B2C split.
Time window30D
Alert triggerNone on the count directly; drops surfaced via Customer Churn Signals.
Rolesowner, marketing, finance

​
Calculation

Calculated automatically from your NetSuite data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.

​
Worked example

A US wholesale distributor on NetSuite OneWorld, 30D window 02 Apr 26 to 01 May 26.
SegmentActive customersActive customers prior 30DDeltaAvg orders / customerAvg revenue / customer
DTC consumer (web)4,8204,560+5.7%1.18$98
B2B Wholesale (parent companies)412408+1.0%4.6$14,200
B2B Sub-buyers (contacts within parents)1,8401,790+2.8%1.5$3,180
Distributor (highest tier)24240%8.4$84,000
Total7,0966,782+4.6%2.6$1,980
What the merchant should notice:
  1. **Distributor count is flat at 24 but each averages 84krevenue.∗∗Thetop−tiercustomersare0.3484k revenue.** The top-tier customers are 0.34% of the active-customer count and 28% of the revenue. Watch the absolute count carefully; losing one is a 84k/30d hole. Cross-reference Top B2B Accounts.
  2. B2B parent-company count up 1%, sub-buyer count up 2.8%. Healthy: existing parent accounts are activating more sub-buyers (more individuals at the buying companies are placing orders). NetSuite’s parent-sub structure makes this visible; commerce platforms cannot see this hierarchy.
  3. DTC consumer +5.7% is the headline growth. 260 net new active web customers; first-time-buyer cohort accounts for 180 of these (cross-reference new-customer subset card). Acquisition + reactivation are roughly 70/30.
  4. The “active” baseline of 7,096 vs the all-time customer record count of 38,400. Only 18.5% of total customers transacted in the last 30 days. This is normal for B2B distribution (where many customers have purchase cadences of 60 to 180 days). For a DTC fashion brand the equivalent ratio would be 8 to 12% (longer customer-life dormancy).
  5. Per-subsidiary view (OneWorld): US 5,210 active, UK 1,420, AU 466. The UK active-base grew 8% (+108 customers) on the back of a Q1 marketing push; UK growth is faster than US in percentage terms.
  6. Action playbook: because the top 24 distributor accounts produce 28% of revenue, the highest-leverage retention is making sure none of the 24 fell out of the active list. Cross-reference Customer Churn Signals filtered to Distributor category. If any distributor’s last-order is >45 days old (their typical cadence is 21 to 28 days), an account-management call this week is the right move.

​
Sibling cards merchants should reference together

CardWhy pair it with Active Customers
Top B2B AccountsThe top-N concentration view. Active count is anonymous; this drills to which accounts.
Customer Churn SignalsThe leading indicator for active-count drops. Customers whose last-order is past their typical cadence.
Customer Credit UtilisationActive customers near credit limits will stop ordering, pre-empting the churn drop.
B2B Payment Terms MixMix shift can mask growth: 100 new Net-30 + 50 lost Net-60 = active count flat but cash cycle different.
Top Customers by RevenueThe dollar concentration; Pareto check on active-base health.
Average SO ValueActive count × Avg SO Value × Orders-per-customer = period revenue.
shopify.unique_customersCross-connector: web active count should reconcile to Shopify unique customers within ±5%.

​
Reconciling against the vendor’s own dashboard

Where to look in NetSuite’s own dashboard:
Reports > Sales > Sales by Customer > Detail, set date range to the period, group by Customer. Distinct customer count = card value.
For per-Customer-Category breakdown: Saved Search > Transaction, criteria Type = Sales Order, Status NOT Cancelled, Date within period, group by Customer.category, count distinct. Why our number may legitimately differ:
ReasonDirectionWhy
Sub-Customer hierarchy treatmentEitherVortex IQ counts sub-customers as distinct active-customers (because each is a buyer). Some NS reports roll sub-customers up to the parent for a flat customer count. Configurable.
Cancelled-only customersVortex IQ lowerCustomers whose only orders cancelled are excluded; some NS reports include them.
Inactive customer flagEitherCustomers marked inactive may still appear in Vortex IQ if they transacted in the period; some NS reports exclude on the inactive flag.
Cross-connector reconciliation:
CardExpected relationshipNotes
shopify.unique_customersWeb subset only ≈ Shopify unique customersSame buyer with separate Shopify and NS customer records (sync issue) inflates Shopify count.
bigcommerce.unique_customersWeb subset only ≈ BC uniqueSame logic.
adobe_commerce.active_customersWeb subset only ≈ Adobe activeAdobe Commerce customer-group hierarchy may align with NS Sub-Customer model; check mapping.

​
Known limitations / merchant FAQs

What does “active” mean exactly? Customer placed at least one Sales Order in the 30-day window where the SO was not cancelled. NetSuite has no separate “Active customer” flag (the flag at Customer Status is sticky and lifecycle-based, not period-based). The active definition here is operational: are they buying right now? Why does my Shopify-connected store show different unique-customer counts on Shopify vs NetSuite? Three usual causes: (1) Sync mismatch, the same buyer has separate records on Shopify and NS because the email or customer-ID match failed at sync time. Vortex IQ catches this on the Commerce Orders Without NetSuite SO card. (2) Guest checkouts in Shopify may roll up to a single “Guest” customer in NS depending on configuration. (3) Sub-Customer treatment: Shopify sees one customer where NS sees one parent + 4 sub-buyers. B2B parent vs sub-customer: which should I count? Depends on the question. For “how many companies are buying”, count parents. For “how many individual buyers placed orders”, count sub-customers. Vortex IQ exposes both views; the default depends on your industry preference (B2B distributors typically prefer parent-level for account-management; B2B SaaS prefers sub-buyer for license tracking). A B2B account had no orders this period but has $200k of open SOs from 60 days ago. Are they active? By this card’s definition: no, because they did not create an SO in the 30D window. By a more inclusive definition (transaction activity in any form), yes. Vortex IQ exposes a “broad active” view via Ask Viq that includes customers with open SOs / Invoices / Receipts in the period. Use whichever matches your operational question. Why does my active-customer count fall in December and rebound in January? Seasonal cadence. B2B distributors typically see a 15 to 25% drop in December (retailer customers pause replenishment for the holiday) and a 30 to 40% rebound in January (Q1 reorder wave). For DTC the pattern reverses (December peak, January slump). Compare year-over-year, not month-over-month, in seasonal businesses. What if I want to count customers regardless of channel? That is the default. Vortex IQ blends web, B2B, manual, EDI sources by default. To split by channel, ask Ask Viq “show active customers by source channel”. Subsidiary view: same customer in two subsidiaries, do they count once or twice? Twice in OneWorld, by NetSuite’s data model. A customer with separate accounts in subsidiary A and subsidiary B has two customer records (NS does not unify). The consolidation count adds them. This is unusual for most merchants but common for global B2B distributors. My active-customer count rose 5% but revenue rose 25%. What’s happening? Customers are buying more per order or more often. Cross-reference Average SO Value and orders-per-customer. The healthy patterns are (a) ASV up + frequency stable (basket-size growth), (b) ASV stable + frequency up (engagement growth). The unhealthy pattern is ASV up sharply + frequency down (top-of-funnel weakness disguised by basket growth). A customer fell off the active list. What action? Depends on segment. For Distributor-tier, a same-day account-manager call. For Wholesale Tier, an automated re-engagement email + offer of a sales-rep call within 7 days. For DTC, a re-engagement email sequence (typically 2 to 4 emails over 30 to 45 days). Vortex IQ’s Customer Churn Signals card surfaces the priority list.

​
Tracked live in Vortex IQ Nerve Centre

Active Customers is one of hundreds of KPI pulses Vortex IQ tracks across NetSuite and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English. Start for free or book a demo to see this metric running on your own data.