At a glance
Daily distinct-customer count over trailing 90 days. The trend chart for Customer Count, with optional new-vs-returning split. Adobe Commerce merchants often see a 7-day weekly pattern (B2B procurement-heavy weekday peaks, consumer weekend dips) plus monthly cycles (B2B end-of-month PO clustering).
Calculation
Worked example
A homewares brand on Adobe Commerce 2.4.6, US/UK/B2B Store Views. 90-day window ending Monday 4 May 26. 90-day overview:
Weekly pattern (median day-of-week):
New-vs-returning split (90D total):
What this is telling marketing:
- Weekday-heavy customer pattern. Tuesday and Wednesday are peak; weekend dips reflect B2B-mix dominance (B2B is overwhelmingly weekday).
- 40.6% new customer rate over 90 days is a healthy acquisition cadence. Consumer-side; on B2B it’s typically <5%.
- The Mother’s Day spike (542 on the peak day, ~70% above 7-day moving average) is a campaign-driven event. Useful to see how the cohort acquired performs over the next 90 days for ROAS attribution.
- The Christmas Day trough (184) is the lowest single day. Expected: most B2B and consumer activity pauses Christmas Day. Use this baseline rather than the moving average for “is the business operating normally” detection on holidays.
- Cross-checking New Customers trend: new-customer rate has been stable at ~40% for 6 of the 12 weeks; rose to ~50% in weeks 8 and 9 (Mother’s Day campaign push) then receded. The campaign created a transient lift in new-customer share.
- Cross-checking Repeat Customer Rate: 59.4% returning over 90 days is in the healthy range; well-retained brands run 55-70%, struggling ones below 50%.
- Strategic question: should the merchant invest in a Saturday-Sunday weekend campaign to lift weekend customer count? The 40% weekday-vs-weekend gap is a B2B effect; converting consumer weekend traffic better could close the gap. Cross-check with paid-traffic conversion rates by day-of-week.
Sibling cards merchants should reference together
Reconciling against the vendor’s own dashboard
Where to look in Adobe Commerce Admin:Reports > Customers > Customers by Number of Orders with a date range gives the per-customer activity, not a daily trend. Manual aggregation needed for the daily series.
Sales > Orders with date filter, group by date manually via export.
Dashboard > Last Orders is real-time but only shows the last 5 orders.For B2B (Adobe Commerce paid edition):
Customers > Companies with order history, manual per-Company timeline.Why our number may legitimately differ from a manual Admin computation:
Cross-connector reconciliation (when these connectors are connected for this merchant):