Difference between revisions of "How to Use Vehicle Marketing"

From Catalyst
Jump to: navigation, search
(Bulk update)
 
(3 intermediate revisions by 2 users not shown)
Line 23: Line 23:
  
 
=== List ===
 
=== List ===
This option produces an list on screen of all customers that fall into the range you entered.  
+
This option produces an list on screen of all customers that fall into the range you entered.
  
 
Here is an example of the output:
 
Here is an example of the output:
Line 35: Line 35:
  
 
=== SMS Listing ===
 
=== SMS Listing ===
This option produces a file called {{DataValue|SMS.TXT}} in {{FilePath|<Platinum Installation Drive>sx\Sxco??}}. This is used in conjunction with the bulk messaging feature of the system (referred to in the "See also" section of this article and [[How do I send bulk SMS messages?|HERE]]) to allow you to send a single text message to a specific list of people.
+
This option produces a file called {{DataValue|SMS.TXT}} in {{FilePath|<Platinum Installation Drive>sx\Sxco??}}. This is used in conjunction with the bulk messaging feature of the system (referred to in the "See also" section of this article and [[How do I send bulk SMS messages?|here]]) to allow you to send a single text message to a specific list of people.
  
 
=== Email Listing ===
 
=== Email Listing ===
This option produces a file called {{DataValue|EMAIL.TXT}} in {{FilePath|<Platinum Installation Drive>sx\Sxco??}}. This is used in conjunction with the bulk messaging feature of the system (referred to in the "See also" section of this article and [[How do I send bulk email messages?|HERE]]) to allow you to send a single email to a specific list of people.
+
This option produces a file called {{DataValue|EMAIL.TXT}} in {{FilePath|<Platinum Installation Drive>sx\Sxco??}}. This is used in conjunction with the bulk messaging feature of the system (referred to in the "See also" section of this article and [[How do I send bulk email messages?|here]]) to allow you to send a single email to a specific list of people.
  
 
=== Letters ===
 
=== Letters ===
Line 61: Line 61:
 
MOT Due Date                              : <MOT DUE DATE>
 
MOT Due Date                              : <MOT DUE DATE>
  
According to our records, your vehicle is shortly due for its annual MOT inspection.  
+
According to our records, your vehicle is shortly due for its annual MOT inspection.
Should you like us to carry out your next MOT, please contact our highly experienced  
+
Should you like us to carry out your next MOT, please contact our highly experienced
 
service team on the number above to arrange a time and date that you will find convenient.
 
service team on the number above to arrange a time and date that you will find convenient.
 
Remember to book early to avoid disappointment.
 
Remember to book early to avoid disappointment.
  
Our fully equipped workshop and skilled technicians are prepared for all your MOT and  
+
Our fully equipped workshop and skilled technicians are prepared for all your MOT and
 
servicing needs.
 
servicing needs.
  
Line 74: Line 74:
  
 
Yours sincerely,
 
Yours sincerely,
 
 
  
 
<NAME OF SERVICE MANAGER>
 
<NAME OF SERVICE MANAGER>
Line 101: Line 99:
 
Address Line 3 Worthington
 
Address Line 3 Worthington
 
Address Line 4 WT1 7DQ
 
Address Line 4 WT1 7DQ
Address Line 5
+
Address Line 5
Postcode WT1 7DQ
+
Postcode WT1 7DQ
 
Tel No 0111 2123456
 
Tel No 0111 2123456
 
Mob No 07777 456987
 
Mob No 07777 456987
Line 120: Line 118:
 
* Select {{DataValue|Delimited}} and click {{Button|Next}}.
 
* Select {{DataValue|Delimited}} and click {{Button|Next}}.
  
{{Tip|text=At this point you will see the the data split into the appropriate columns in the preview section in the lower part of the window.}}  
+
{{Tip|text=At this point you will see the the data split into the appropriate columns in the preview section in the lower part of the window.}}
  
 
* Un-tick {{Button|Tab}} and tick {{Button|Semicolon}} by left clicking and click "Next".
 
* Un-tick {{Button|Tab}} and tick {{Button|Semicolon}} by left clicking and click "Next".
* Highlight each field in turn by clicking each column in the preview section in the lower part of the window and make sure each field is marked as {{DataValue|Text}} in the {{DataValue|Column Data Format}} section.  
+
* Highlight each field in turn by clicking each column in the preview section in the lower part of the window and make sure each field is marked as {{DataValue|Text}} in the {{DataValue|Column Data Format}} section.
 
* Click {{DataValue|Finish}}.
 
* Click {{DataValue|Finish}}.
  
This will show the data in Excel split into the appropriate columns.  
+
This will show the data in Excel split into the appropriate columns.
 
Go to {{Menu|File|Save As}} and save with an appropriate name and change the {{DataPrompt|Save As File Type}} to {{DataValue|Microsoft Office Excel Workbook (.XLS)}} and save to a location of your choice. You can then use this file with a word processor to merge this data onto a form letter.
 
Go to {{Menu|File|Save As}} and save with an appropriate name and change the {{DataPrompt|Save As File Type}} to {{DataValue|Microsoft Office Excel Workbook (.XLS)}} and save to a location of your choice. You can then use this file with a word processor to merge this data onto a form letter.
  
 
== See also ==
 
== See also ==
* [[How do I use the Retention Centre?]]
+
* [[Getting started - Retention Centre]]
  
{{KB_Tags|marketing, market, bulk, SMS, Email, export}}
+
{{KB_Tags|marketing, market, bulk, sms, email, export}}
 +
{{How}}

Latest revision as of 05:35, 19 June 2019

Historic Article

  • For help on finding out how up to date your Platinum system is, please click here
  • If you would like help on updating your current system to the latest version click here.
  • If you have any questions on the new update please Contact your Platinum dealer or our support team on 0116 230 1500 or by using our website support contact page.

Summary

This article explains how to produce the most popular types of reports and mailings such as MOT or Service reminders.

More Information

Go to " Unit Sales Marketing".

  • Here you will see all the reports available to you.
  • Select the type of report you require e.g. service reminder.
  • You will see all the types of output available from the marketing system.
List
SMS Listing
Email Listing
Letters
Letters + Labels
Labels Only
Export List
All reports include a filter that looks for the attribute in the "Bulk Messaging" section of an account called "Message Exclusion" or a feature on a vehicle called 'Message Exclusion'. If either of these are applied to the customer or the vehicle, then they will not appear on any of the above reports.

List

This option produces an list on screen of all customers that fall into the range you entered.

Here is an example of the output:

MOT Due    Stk No   Reg No     Customer Name   Contact Number  Mobile Number   Email
12/09/2009 90015654 RG51RVG    Mr John Smith   0111 2123456    07777 456987    ilikeale@hotmail.com
There is also a total number of customers at the bottom of the list which can be helpful to find out, for example, the number of envelopes you will need.

SMS Listing

This option produces a file called 'SMS.TXT' in '<Platinum Installation Drive>sx\Sxco??'. This is used in conjunction with the bulk messaging feature of the system (referred to in the "See also" section of this article and here) to allow you to send a single text message to a specific list of people.

Email Listing

This option produces a file called 'EMAIL.TXT' in '<Platinum Installation Drive>sx\Sxco??'. This is used in conjunction with the bulk messaging feature of the system (referred to in the "See also" section of this article and here) to allow you to send a single email to a specific list of people.

Letters

This option produces a letter for all customers that fall into the date range supplied. The Letter output is as follows:

<CUSTOMER ADDRESS LINE 1>
<CUSTOMER ADDRESS LINE 2>
<CUSTOMER ADDRESS LINE 3>
<CUSTOMER ADDRESS LINE 4>
<CUSTOMER ADDRESS LINE 5>
<CUSTOMER ADDRESS LINE 6>

<TODAYS DATE>

                           REMINDER

Dear <CUSTOMER NAME>

RE: Vehicle Reg. No                        : <VEHICLE REG>
Your Vehicle Ref No                        : <VEHICLE STOCK NO>
MOT Due Date                               : <MOT DUE DATE>

According to our records, your vehicle is shortly due for its annual MOT inspection.
Should you like us to carry out your next MOT, please contact our highly experienced
service team on the number above to arrange a time and date that you will find convenient.
Remember to book early to avoid disappointment.

Our fully equipped workshop and skilled technicians are prepared for all your MOT and
servicing needs.

We look forward to hearing from you.

With kind regards,

Yours sincerely,

<NAME OF SERVICE MANAGER>
On behalf of <COMPANY NAME>

Letters + Labels

This option produces the same letter as above for all customers that fall into the date range supplied, but also prints an address label for each letter to your dedicated label printer.

Labels Only

This option produces labels for all customers that fall into the date range supplied. This is good if you have pre-printed materials that you need to to post.

Export List

This option produces a text file that is Semicolon separated '.TXT' for use in Excel. This automatically appears on the screen in the program that opens '.TXT' files on your machine. Once the report is finished, this can be saved by going to " File Save As" then saving the file to a location of your choice.

Here is a listing of the information included:

COLUMNS			EXAMPLE RESULTS

Acc Code		CON001
Acc Name		Mr John Smith
Address Line 1		1 Ale Avenue
Address Line 2		Alesworth
Address Line 3		Worthington
Address Line 4		WT1 7DQ
Address Line 5
Postcode		WT1 7DQ
Tel No			0111 2123456
Mob No			07777 456987
Email			ilikeale@hotmail.com
Veh Ref			90015654
Reg			RG51RVG
MOT Due			12/09/2009

Opening the File in Excel

  • Open Excel.
  • Go to " File Open".
  • Browse to the Location of your saved file in the above step.
  • Change " Files of Type" to 'All Files'.
  • Left Click e.g. 'STPROEXP.TXT'.
    • This will open the 'Text Import Wizard Step 1 of 3' box.
  • Select 'Delimited' and click [Next].
At this point you will see the the data split into the appropriate columns in the preview section in the lower part of the window.
  • Un-tick [Tab] and tick [Semicolon] by left clicking and click "Next".
  • Highlight each field in turn by clicking each column in the preview section in the lower part of the window and make sure each field is marked as 'Text' in the 'Column Data Format' section.
  • Click 'Finish'.

This will show the data in Excel split into the appropriate columns. Go to " File Save As" and save with an appropriate name and change the "Save As File Type" to 'Microsoft Office Excel Workbook (.XLS)' and save to a location of your choice. You can then use this file with a word processor to merge this data onto a form letter.

See also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
marketing, market, bulk, sms, email, export