Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This report shows the number of new customers created which have email addresses and / or mobile numbers. The customer is assigned to the salesperson using the first sales order linked to that account or assigned as an enquirer if no sales order.
This report shows status of email / mobile number and not that at time of creation.
Crystal report name New Customer Statistics 2
Selection Criteria
Run time choices, user selectable.
-
Date Range - checked against the customer creation date
-
Show Customer Details
-
Yes / No
-
-
Group by
-
Primary Salesperson / Creation User
-
-
Filter by
-
Customer Creation Date / Sales Order Creation Date
-
-
Restricted Company(ies) - when operating with company specific customers.
Use ‘Global Customer (bot linked to company' if companies not in use
Print Sequence
As indicated by blue numbered squares in the report example.
1 Salesperson or Creation User
2 Customer ID
Report Totals
As indicated by yellow numbered squares in the report example.
1 Salesperson or Creation User
2 Report Total
Printed Fields
Fields printed on the report.
-
Salesperson or Creation Username
-
Numbers of new customer collected
-
Numbers of emails collected
-
Numbers of mobile phone numbers collected
-
Customer ID
-
Full Customer Name
-
Email
-
Sales Order Number
-
Customer’s Mobile / Cell Number
-
Date Created or Order Placed
-
Email Marketing Preference
-
Post Marketing Preference
-
Phone Marketing Preference
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article