|
Column
|
Description
|
|
Last Name
|
Customer's last name.
|
|
First Name
|
Customer's first name.
|
|
Address
|
Customer's address.
|
|
Contact
|
Customer's contact information.
|
|
Recurring ID
|
TransFirst® customer ID. If no TransFirst ID is established, this field contains the number 1.
|
|
License
|
Customer's license plate on file.
|
|
RFID
|
RFID tag number associated with the plate shown.
|
|
Revenue
|
Revenue from non-club purchases and recurring Club Fees. Revenue is summed by the grouping and date range.
You may see revenue of $0.00 for the vehicle. This may be the case if the price of the service redeemed (For example, $5.66) was offset by the price of the discount (For example, $5.66).
|
|
Upgrade Revenue
|
Revenue from upgrades and extra services.
|
|
Total Revenue
|
Revenue and upgrade revenue.
|
|
Total Wash
|
Total washes (redeemed) by members for the time frame.
|
|
Avg. Visit in Days
|
Average number of days between visits. This takes into account the date range of the report. For example, if the date range is a month, Average Days Between Visits accounts for the number of visits only for the number of days in the month. It would not represent the average since the customer joined the club. To see the average number of visits since a customer joined the club, you can adjust the date range.
|
|
Upgrade Qty.
|
Number of times the customer purchased an upgrade in addition to the included service.
|
|
Upgrade Revenue %
|
Percentage of revenue coming from upgrades. Upgrade Revenue divided by Total Revenue.
|
|
Upgrade Vehicle %
|
Upgrade Quantity divided by Total Wash, expressed as a percentage. Say the vehicle visited 10 times. An upgrade wash purchased 5 times. The Upgrade Vehicle% is 50 percent.
|
|
Revenue / Wash
|
Average Revenue per wash.
|
|
Upgrade Rev / Wash
|
Average Upgrade Revenue per wash.
|
|
Total Rev./Wash
|
Average Total Revenue (club revenue and upgrades) per wash.
|
|
Site
|
Site location shows at which site the customer redeemed a wash. If the member has a choice of six sites and visits each, there will be a transaction from each site displayed here.
|
|
Transaction ID
|
Unique identification number for the transaction.
|
|
Posted Date
|
Date the purchase was recorded in the system.
|
|
Service
|
The service redeemed, along with discounts, upgrades, etc.
|
|
Amount
|
Dollar amount of the service redeemed or discount applied.
|