The number of new registered customer accounts created in the last 30 days, compared with the prior 30 days, the top-of-funnel acquisition signal.
At a glance
OpenCart distinguishes registered customers from guest checkouts. A registered customer creates an account row with a creation date; a guest checkout does not. This card counts registered accounts created in the last 30 days and shows the figure against the prior 30 days so you can see acquisition accelerating or decaying. Guest checkouts are a separate signal, because you cannot reliably re-market to a guest. There is no alert here; the delta is the story, and it pairs with order and revenue cards to tell whether growth is real.
| What it counts | COUNT(customers) where the account creation date falls in the last 30 days. Registered accounts only. |
| Guest checkouts | Excluded. A guest does not create a customer account row, so it cannot count as a new customer here. Guest orders still count in Order Volume. |
| Registered vs purchased | This counts account creation, not first purchase. A shopper who registers but does not buy still counts. That makes it a leading indicator, slightly ahead of first revenue. |
| Newsletter overlap | A new customer can opt into the newsletter at registration. That opt-in feeds Newsletter Opt-In Rate; this card is the denominator for that rate. |
| Multi-store | OpenCart records the store_id a customer registered under. The headline sums all stores; the detail view splits by store. |
| Vs prior period | The card shows current 30 days and prior 30 days, with the delta percent. Useful for spotting acquisition trend without a separate trend card. |
| Currency / tax | n/a, this is a count. |
| Time window | 30D vsP (rolling 30 days vs prior 30 days) |
| Alert trigger | None |
| Roles | owner, marketing |
Calculation
Worked example
A Polish home-fragrance merchant on OpenCart 3.0 runs both a registered-account flow and guest checkout. They compare 14 May 26 to 12 Jun 26 against 14 Apr 26 to 13 May 26.| Metric | Prior 30 days | Last 30 days | Delta |
|---|---|---|---|
| New registered customers (this card) | 420 | 512 | +21.9% |
| Of which opted into newsletter | 168 | 210 | +25.0% |
| Guest checkouts (separate) | 980 | 1,040 | +6.1% |
| Total orders | 1,610 | 1,790 | +11.2% |
- Registered acquisition outpaced guest checkout. New accounts rose 21.9 percent while guest checkouts rose only 6.1 percent. That shift matters: registered customers are reachable by email and convert to repeat at a much higher rate than guests, so a growing registered share strengthens future revenue beyond this month.
- The opt-in count grew faster than the account count. Newsletter opt-ins rose 25 percent against 21.9 percent account growth, so the opt-in rate edged up. That is the kind of detail Newsletter Opt-In Rate surfaces, and this card is its denominator.
- Registration is a leading indicator, not a revenue figure. Some of these 512 accounts registered but have not yet bought. They are a stockpile for the welcome flow and the first-purchase nudge, which is why the marketing role owns this card alongside the owner.
- There is no alert, by design. Acquisition naturally swings with campaigns and season, so a fixed threshold would fire constantly. The 30D-vs-prior delta is the signal, read alongside order and revenue trend rather than as a standalone alarm.
- A drop here is an early warning. If this number falls while revenue holds, returning customers are carrying the store. That is sustainable for a quarter or two, no longer. The value of watching the delta is that it warns before the revenue cards do.
Sibling cards merchants should reference together
| Card | Why pair it with New Customers (30d) |
|---|---|
| Total Customers | The base. New customers ÷ total customers is acquisition velocity. |
| Repeat Customer Rate | The retention complement. New customers grow the base; repeat rate decides whether they stay. |
| Newsletter Opt-In Rate | This card is the denominator for the opt-in rate. Together they show reachable acquisition. |
| Order Volume | New registrations should track order growth. A gap means registrations are not converting. |
| High-Value Customers Unengaged on Email | New acquisition only pays off if you keep them engaged. The two sit at opposite ends of the lifecycle. |
| Orders / Email Attribution | New opted-in customers are the input to email-driven revenue. |
Reconciling against OpenCart
Where to look in OpenCart admin: Customers → Customers, filtered by Date Added for the last 30 days, gives the registered-account count. Reports → Customers → Customers Online and the customer activity reports show engagement but not new-account counts directly. Marketing → Mail and the newsletter tooling show who can be emailed. The underlying data is thecustomer_id, date_added, newsletter, and store_id columns on oc_customer.
Other OpenCart views that look like the same number but are not:
- Sales → Orders unique customers: counts customers who ordered, not customers who registered. Includes guests in some configurations and excludes non-buying registrants.
- Reports → Customers → Customer Orders: a purchase report, not an acquisition report.
- Total customer count in the dashboard: the whole base, not the last-30-day cohort.
| Reason | Direction of divergence |
|---|---|
| Registration date vs first order. OpenCart records account creation date; some merchant reports count first-order date instead. A registrant who has not bought counts here but not in an order-based report. | Vortex IQ higher than order-based reports |
| Guest exclusion. We exclude guests; an admin “customers who ordered” view may include them. | Vortex IQ lower than a guest-inclusive view |
| Time zone. OpenCart admin uses the store timezone; Vortex IQ evaluates the 30-day window in UTC by default. Boundary registrations shift. | Boundary effects |
Multi-store. A store_id-filtered admin view shows one store; this card sums all by default. | Vortex IQ higher than a single-store view |
| Sync lag. Registrations in the last few minutes appear on the next sync. | Self-resolves at next sync |