Customer List Report

Customer List Report

Purpose

The Customer List provides an extract of all customers based on various criteria provided when generating the report. Note that the filters allow a wide range of options. Common use of the customer list is to produce email campaigns as well as see what customer's are currently on the mailing list. The option "Customers on Mailing List" refers to the Mailing List field when making a reservation on the Driver Details tab. Customer's have the option of not being sent marketing material if they opt out of this option.


If you have less than 100,000 customers, you can run this report for a date range of 5 years. For more than 100,000 customers, the date range cannot be more than 1 year. 

Accessing the Customer List Report

Reports > Other Reports > Customer List



Parameters / Filters 

Pickup location or Region
Select either a location or region. All Locations will be the default setting. When generating the report, if you have selected a region, this will override the location.
Brand
Select all or a pre existing brand.
Category
Select all or a single vehicle category.
Data In
Select on the drop list, what details from the customer you want to be shown in the report:
  1. Email Only (Selected for the example below)
  2. Email & Address 
  3. Mobile Only
  4. Mobile & Address
  5. Address
  6. N/A - Includes all of the above options
Country
Select all or a single country.
Customer Selection
Select either:
  1. All customers (Selected for the example below) OR 
  2. Customers on the mailing list
Source 
Select the rental source - i.e. how the customer booked the reservation, e.g. Online, Agent etc.
Agency
Select all or a single agency where the customer booked from. Selecting "All Agencies" will also include customers that didn't book from an agent.
Order By
You can decide whether you want the report to be ordered by:
  1. Last Name (Selected for the example below) OR
  2. Post Code
Booking Information 
You can decide if you want the report to:
  1. Exclude Booking Details (Selected for the example below)
  2. Include Booking Details
  3. Include Insurance
Booking Date
You can decide if you want the report to run results of bookings that were:
  1. Entered from a specific date (Selected for the example below)
  2. Being dropped off from a specific date
  3. Being picked up from a specific date
Dates From & To
Depending on what you selected on the options above, now set your date range by clicking on the drop down options or calendar. As mentioned, this report's date range cannot be more than twelve months. If you need more data, you must run multiple twelve-month reports.
Customer Status
You can decide if you want the report to include:
  1. Customers that are currently hiring a vehicle
  2. Hired customers only (Selected for the example below)
  3. Customers that haven't hired the vehicle yet
  4. Customers with pending quotations
No. Days Rented From
You can filter the customers that you want to see on this report by the number of days they have rented a vehicle for. Note that to include Non Revenue booking customers to the list, please set the number to 0.

Once you have set the Parameters / Filters, click "View" to run the report. 

Example



Field Descriptions.

The following fields are for when the Data In filter is set to Email Only.
Company
If applicable, the company the customer is associated with will show under this heading.
ABN
If applicable, the customer's Australian Business Number will show under here.
Customer ID
The customer's ID within your RCM system.
Last Name
The customer's last name.
First Name
The customer's first name.
Email
The customer's email address.
Passport #
If applicable, the customer's passport # will show here.
Country
The country the customer lives in.
Mailing List
Includes whether the customer is subscribed to your mailing list.

Depending on what Data In value is selected, the report may also include any combination of the following fields:
DOB
The customer's date of birth.
Mobile
The customer's mobile number.
Phone
The customer's phone number
Address
The street address recorded against the customer.
City
The city recorded against the customer's address.
State Provinces
The state or Province recorded against the customer's address.
Postcode
The customer's postcode.
Licence #
The customer's licence number.


Printing/Exporting

Click here for details on how to print or export a report from RCM.


    Important Articles


      • Related Articles

      • Company List Report

        Purpose The Company List gives a report of all the companies that have made reservations. This report can be run for a specific location or it can be run for all locations. Furthermore, you are also able to restrict the companies on their status. ...
      • Customer Notes Report

        Purpose: The Customer Notes report will allow you to see any notes that have been added to a customer during the report period. An example of when a note is added to a customer is when a customer is either added to or removed from the Do Not Rent ...
      • Membership List

        Purpose The Membership list allows you to view or print your existing Customer records that have a membership number assigned.  A membership number is used to identify individual customers that may be a VIP,  member of a promotional plan or a mailing ...
      • Infringement List

        Purpose The Infringement List allows you to search for specific infringement records as well as view, edit and delete these records. After finding the desired infringement record, the Infringement List also allows you to print and email both ...
      • Agent Booking List

        Purpose: The Agent Booking List report lets you view bookings made by agents. You can filter the results by location, booking type and date. This can be useful for getting an overview of bookings that are made by agents, you can also view the value ...