Produce a mail extract of clients from a particular area

Produce a mail extract of clients from a particular area

t3 comes with a fully customizable sales region system, allowing ranges of postcodes to be gathered together into a single area. These can be combined in a number of ways with tour departure, enquiry and booking dates to create extracts of clients from your mail list.

 

Sales Regions

To create your first sales region go to Marketing then Regions. Select the add new record icon, or New from the Action drop down menu. Enter a name for the sales region you are creating, ensuring there is a tick in Current, then click Save and close the sales regions window.

 

Postcode Ranges

The next step is to set up the postcode ranges that form this new sales region. Still within Marketing, click on Ranges. Select the sales region created in the previous step from the Region box, then select the add new record icon, or New from the Action drop down menu. Enter the postcode prefix letters, for example DN for Doncaster. Then the digits for that postcode range. If you wanted to include all postocdes for the Doncaster postcode area you could enter 1 to 99. This would ensure all possible postcodes are included in the range. If you wanted to target a smaller area you would put in the lowest number to the highest number. Click Save. Some sales regions could consist of multiple postcode ranges. If this is the case, just repeat the last part to add a new postcode range. Once all the required ranges have been created, close the postcode ranges window.

 

Rebuild Regions

Each time a sales region or postcode range is created or modified you need to Rebuild Regions. This will update the customers in the mail list and assign them to the correct sales region based on their postcode. In Marketing go to the Maintain drop down menu and select Rebuild Regions. Click Yes to confirm. Depending on the size of the mail list this stage could take some time. Once the rebuild has completed click OK to continue.

 

Extract Data

The final step is to extract the customer details. Still in Marketing select Extract 1. Extract 1 will return all customer contact details into Excel for the selected sales region by date of travel or enquiry. Only the sales regions ticked as being Current are available here. Select the desired sales region, enter a travelled between date range and an enquired between date range. To include all just select a large date range for both. The Excel workbook name should be automatically created however if you want to save to a different location just click the arrow to the right of the box. The Save Settings tick box is optional if you want to save the date ranges for subsequent extracts. Finally, click Run Extract. Once the extract has completed the pop up box will give you the option to either open in Excel by clicking Yes or continue in t3 by clicking No.


    • Related Articles

    • T3 Marketing

      Definition of Marketing: The activity of presenting, advertising, and selling a company's products in the best possible way. It’s often quoted that “Acquiring a new customer can cost five times more than retaining an existing customer” and T3 has ...
    • Merge Duplicate Clients

      If a client has multiple entries within the mail list, these records can be merged into one using the Consolidate Client tool within t3. In order to consolidate clients the the client id's of both entries must be known, one of these will be kept the ...
    • Consolidate marketing records

      Over time, it's possible that duplicated records may accumulate for the same client. To ensure accurate association of booking and tour history with passengers, you can take advantage of the consolidation tool. This tool facilitates the merging of ...
    • Creating Tours

      The following Article will take you though the process of creating a tour and also explaining all the available options that can be utilised to create your Day Excursions/Inclusive Tours Preparation Before creating tours it is strongly recommended ...
    • Cash Day Book

      The Cash Daybook is selected from the Financial menu on the t3 shell window and shows a table of all recent payments which have been entered into the system. The payments will have been entered against bookings, sundry sales, vouchers, through the ...