WAE - Data Analysis

WAE – Web Design, Data Analysis & IT Support

WAE's Data Analysis Service

WAE started proving data analysis due to a huge demand from our existing client base. Many of your clients use RomanCart and so we have become experienced in RomanCart sales analysis in particular. However we do not exclusively analyse RomanCart data. We will undertake data analysis projects big and small of almost any kind.

RomanCart does provide some useful summary information but WAE can provide you with much more specific details. Reports produced are in Excel format and are be adjusted in accordance with the client’s level of expertise. Below are the fields that are available for analysis from RomanCart. These fields can be exported from the Sales Manger in your RomanCart account.

If you are interested in this service contact us now for a free, No-obligation quote. It more affordable than you think and can make a big difference to your business.

RomanCart Fields Available for Analysis

Order Data
Export Field	Field explaination
Salesmainid	Order Reference number
subtotal	Order Total without Shipping Cost
discount	Total Discount received on order
totalprice	Order Total including Shipping Cost
priceincludestax	Specifies whether TAX is included in Total
totaltax	Total Tax
promdiscount	Total Promotional Discount received on order
totalshipping	Total Shipping
actualshippingtype	Shipping Type
createddate	The date the order was first submitted
status	The order Status as set in "Sales Manager"
psp	Payment Method
customeremailsent	Specifies whether customer email has been sent
storeemailsent	Specifies whether store email has been sent
currencycode	The currency of the order
acceptedtsandcs	Specifies whether customer accepted T&Cs
sourced	How did you hear about us
shippingstatusdate	The date the order was shipped
shippingstatus	Shipping Status
statusdate	Date when shipping status was set
itemname	Product name
price	Product Price
quantity	Quantity Ordered
acceptsemails	Did the customers opt out of mailing list

Customer Data
Export Field	Field explaination
Companyname	Billing Address - Company Name
title	Billing Address - Title
firstname	Billing Address - First Name
lastname	Billing Address - Last Name
address1	Billing Address - Address Line 1
address2	Billing Address - Address Line 2
town	Billing Address - Town
county	Billing Address - County
postcode	Billing Address - Postcode/Zip code
countrystate	Billing Address - State
dcompanyname	Delivery Address - Company Name
dtitle	Delivery Address - Title
dfirstname	Delivery Address - First Name
dlastname	Delivery Address - Last Name
daddress1	Delivery Address - Address Line 1
daddress2	Delivery Address - Address Line 2
dtown	Delivery Address - Town
dcounty	Delivery Address - County
dpostcode	Delivery Address - Postcode/Zip code
dcountry	Delivery Address - Country
dstate	Delivery Address - State
phone	Phone Number
email	Email Address

Below are some of questions we have provided answers to for our clients.

Questions we have answered:

How much money am I getting in from shipping on a monthly basis?

What is my most popular shipping method?

Where are my customers located?

What country are most my clients in?

On Average, how many of each of my products, do I sell per month?

Which is my most profitable product? (Required the cost price from client)

How much gross profit did I make last year on each of my products? (Required the cost price from client)

How many of my client receive discount?

Download and EXAMPLE report. (The data in the report is fictional and not accurate.) It is also just an Example; the information contained in the report will vary depending on the questions asked.