Difference between revisions of "ProDon:Mailing History"

From Logilys
Jump to: navigation, search
(Creating a Recall List)
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Header_ProDon | | 4.6.5.10 | Nadia Carrier | | 2011/09/26 }}  
+
{{Header_TOC}}<br>
  
 
== Introduction  ==
 
== Introduction  ==
Line 29: Line 29:
 
<br>  
 
<br>  
  
{| width="50%" cellspacing="1" cellpadding="1" border="1" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" style="width: 582px; height: 1291px;" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
Line 60: Line 60:
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
'''<span style="color: rgb(255, 0, 0);">E: </span>'''The comment "Pending payment" will automatically be entered in the "Response" field if the transaction linked to the mailing is "To be received" or "To be paid". For more information concerning the transaction types, [[Click here]].  
+
'''<span style="color: rgb(255, 0, 0);">E: </span>'''The comment "Pending payment" will automatically be entered in the "Response" field if the transaction linked to the mailing is "To be received" or "To be paid". For more information concerning the transaction types, [[Click here|click here]].  
  
 
| width="50%" |  
 
| width="50%" |  
Line 74: Line 74:
 
|}
 
|}
  
<br>
+
<br>  
  
 
== Creating Mailing Histories  ==
 
== Creating Mailing Histories  ==
Line 90: Line 90:
 
The mailing history can be used on an individual basis.  
 
The mailing history can be used on an individual basis.  
  
{| width="50%" cellspacing="1" cellpadding="1" border="1" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" style="width: 649px; height: 441px;" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
Line 115: Line 115:
 
<br>  
 
<br>  
  
{| width="50%" cellspacing="1" cellpadding="1" border="1" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" style="width: 528px; height: 988px;" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
Line 159: Line 159:
 
<br>  
 
<br>  
  
<br>
+
<br>  
  
 
=== Creating Mailing Histories from Mass Mailing  ===
 
=== Creating Mailing Histories from Mass Mailing  ===
Line 167: Line 167:
 
<br>  
 
<br>  
  
{| cellspacing="1" cellpadding="1" border="1" style="width: 448px; height: 564px;" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 448px; height: 564px;"
 
|-
 
|-
 
| [[Image:Mailing History 004.png]]
 
| [[Image:Mailing History 004.png]]
Line 182: Line 182:
 
<br>  
 
<br>  
  
{| width="50%" cellspacing="1" cellpadding="1" border="1" class="wikitable"
+
{| width="656" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 
|-
 
|-
 
|  
 
|  
Line 197: Line 197:
 
<br>  
 
<br>  
  
{| width="50%" cellspacing="1" cellpadding="1" border="1" class="wikitable"
+
{| width="654" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 
|-
 
|-
 
|  
 
|  
Line 218: Line 218:
 
<br>  
 
<br>  
  
{| cellspacing="1" cellpadding="1" border="1" style="width: 535px; height: 330px;" class="wikitable"
+
{| width="486" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 
|-
 
|-
 
|  
 
|  
Line 229: Line 229:
 
<br>  
 
<br>  
  
{| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 536px; height: 681px;"
+
{| width="519" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
Line 235: Line 235:
  
 
|-
 
|-
| colspan="2" style="text-align: center;" | [[Image:Mailing History 008.png]]<br>
+
| style="text-align: center;" colspan="2" | [[Image:Mailing History 008.png]]<br>
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
Line 266: Line 266:
 
|}
 
|}
  
<br>
+
<br>  
  
 
== Consulting Mailing Histories  ==
 
== Consulting Mailing Histories  ==
Line 283: Line 283:
 
The individual management of the mailing histories can be done in the client files.<br>  
 
The individual management of the mailing histories can be done in the client files.<br>  
  
{| width="50%" cellspacing="1" cellpadding="1" border="1" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" style="width: 450px; height: 466px;" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
Line 318: Line 318:
 
|}
 
|}
  
<br>
+
<br>  
  
 
== Modification of Mailing Histories  ==
 
== Modification of Mailing Histories  ==
Line 339: Line 339:
 
It is also possible to massively modify or delete mailing histories. This option is particularly useful if the mailing is not linked to transactions.  
 
It is also possible to massively modify or delete mailing histories. This option is particularly useful if the mailing is not linked to transactions.  
  
{| width="50%" cellspacing="1" cellpadding="1" border="1" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" style="width: 602px; height: 356px;" class="wikitable"
 
|-
 
|-
 
|  
 
|  
Line 352: Line 352:
 
<br>  
 
<br>  
  
{| width="50%" cellspacing="1" cellpadding="1" border="1" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" style="width: 520px; height: 602px;" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
Line 368: Line 368:
 
|}
 
|}
  
<br>
+
<br>  
  
 
== Creating a Recall List  ==
 
== Creating a Recall List  ==
  
It is also possible to create a [[ProDon:Customized Lists|customized list]] to find the clients meeting certain mailing criteria. For instance, to find all the clients who have not responded to the invitation for the Golf Tournament 2011, so that you can send them a second invitation. To know how to create a customized list on mailing criteria, [[ProDon:Customized Lists|click here]].
+
It is also possible to create a [[ProDon:Customized Lists|customized list]] to find the clients meeting certain mailing criteria. For instance, to find all the clients who have not responded to the invitation for the Golf Tournament 2011, so that you can send them a second invitation. To know how to create a customized list on mailing criteria, [[ProDon:Customized Lists|click here]].  
  
 
== Mailing Analyses  ==
 
== Mailing Analyses  ==
Line 394: Line 394:
 
<br>  
 
<br>  
  
{{Footer_ProDon}}
+
{{Footer_ProDon_Version|4.6.5.9}}<br>

Latest revision as of 07:41, 5 May 2016

Mailing History


Introduction

The "Mailing history" is a tool allowing you to keep track of the mailings sent to clients of the database.


The use of this tool allows you to:

  • Document who received what and when;
  • View and consult the mailing history per client from a client file;
  • Quickly find the list of people who did not respond to a first invitation; to send them a reminder, second mailing, third mailing, etc.;
  • Discover people's trends (the type of invitation people are interested in);
  • Target and plan mailings according to the individual's preferences.


Specifically, this tool allows you to find out that a person always donates; for instance, in gastronomic activities, but never in golf tournaments; or that you have to send three notifications to get a response.


Moreover, this function allows you to assess the profitability of your actions by comparing the number of positive responses versus negative ones for all the mailings.

Configuration of Default Responses for the Mailing History

To be able to fully use the "Mailing history", you first need to configure the default responses to be entered in different situations. This configuration is mainly applied to mailing histories in relation to mail solicitation.


CAUTION: Usually, only the user "Supervisor" can access the "System preferences".

From the software home page, click on the "Configuration" menu, then select "Preferences". The "Preferences" window opens, go to the "System preferences" tab, then select the "Mailings" tab.

Mailing History 001.png

NOTE: The drop-down lists of the A to F fields are dynamic, which means that it is possible to add new options to the list at all times. If an option is added in a list, it will automatically be added in the five others. Furthermore, the check boxes in H are exactly the same options as the ones of  the dynamic drop-down lists. To know how the dynamic drop-down lists work, consult this procedure.

For more information concerning the "Response" field that will be used in the upcoming examples, see letter A on the section "Consulting mailing histories from "Analysis and history"".

A: The comment "Pending" will automatically be entered in the "Response" field in the creation of the mailing history.

B: The comment "Gift received" will automatically be entered in the "Response" field as soon as the transaction linked to the mailing is transferred.

C: The comment "Gift received (third)" will automatically be entered in the "Response" field if the transferred transaction linked to the mailing is third. For more information concerning transactions third, click here.

D: The comment "Responded to subsequent solicitation" is entered in the "Response" field when several solicitations have been made to the same client for the same activity of a donation occasion. For instance, at the third solicitation, the client decides to make a donation; the comment "Responded to subsequent solicitation" will be displayed in the "Response" field in the histories of the first and second mailing; then a mention of payment will be entered for the third mailing.

E: The comment "Pending payment" will automatically be entered in the "Response" field if the transaction linked to the mailing is "To be received" or "To be paid". For more information concerning the transaction types, click here.

F: The comment "Pending payment (third)" will automatically be entered in the "Response" field if the transaction linked to the mailing is third and if it is a transaction "To be recieved" or "To be paid".

G: If this option is checked, the donation occasion and the activity selected in the last mailing documented in the client folder will automatically be entered during the entry of a new transaction.

H: These options are available only if the option in G is checked and allow you to search a mailing by "Response". For instance, you want that when you enter your next transaction, the donation occasion and the activity of the last mailing having the reponse "Pending payment" are both entered automatically.


Creating Mailing Histories

A mailing history can be created in three different ways:


Creating Individual Mailing Histories

The mailing history can be used on an individual basis.

To individually add, remove or modify a mailing, open the client file, then go to the "Mailings" tab that is at the bottom of the file.

Mailing History 002.png

A: The Button Search.png button allows you to activate the search bar.

B: The Button add plus.png button allows you to create a new mailing history.

C: The Button Edit.png button allows you to modify a mailing history.

D: The Button Minus remove delete.png button allows you to remove a mailing from the list of mailing histories of the client.


After clicking on the Button add plus.png button, this window opens.

Mailing History 003.png

A: The current date is entered automatically, but it is possible to modify it.

B: Allows you to specify the donation occasion for which the mailing is done.

C: Allows you to specify the activity for which the mailing is done. In order for the response to be automatically modified later, you must configure the mailing histories. Moreover, the occasion and activity of the transaction have to be exactly the same as the history's. If no activity was entered in the mailing history, it will be updated regardless of the specified activity in the transaction.

D: Allows you to indicate the canvasser. In the entry of a transaction related to a mailing history, if the canvasser is not the same one in the transaction as in the mailing history, there is a warning issued. It will then be possible for you to modify either the canvasser of the transaction or the one of the mailing history; so that the same canvasser appears in the transaction and in the mailing history.

E: This field indicates the response.

F: This line contains the name of the last person who modified the mailing status and the response date. This date is automatically updated when the response is modified. The date is modifiable nonetheless.

G: Allows you to indicate the amount that was suggested in the mailing. If the amount of the transaction differs from the suggested amount, the response will still be updated.

H: This box is available only in the use of the individual mailing history. It is useful to specify in the "Supplier-client" file that the mailing has been done through this external company. When the box is checked, a second box appears right next to the check box intended for entering the number of people to whom the mailing was sent. When this option is used, it is not possible to document the clients' responses one by one.

I: Allows you to enter a description for the mailing.



Creating Mailing Histories from Mass Mailing

Each time a "Mass mailing" is done, it is possible to keep a history of it. To do so, you need to fill out the "Mailings" tab of the "Mass mailing" window. For more information concerning "Mass mailing", consult this procedure.


Mailing History 004.png

It is important to specify the elements to be entered in the "Mailing history" of the "Mailings" tab when configuring the "Mass mailing".


When the "Mailing history" is created, as soon as a transaction corresponding to the specified donation occasion is created, the response is updated according to the configuration of the mailing history.


When the "Mailing history" of the "Mass mailing" is created, this result appears in the "Mailings" tab of the client file included in the "Mass mailing".

Mailing History 005.png

A: The response is "Pending" and there is nothing entered below the fields "Responded on" and "Responded to" since no transaction related to the "Mailing history" was entered, these three fields will automatically be updated.


Here is an example of result when a transaction related to the "Mailing history" is entered.

Mailing History 006.png

B: The comment "Gift received" is entered under the "Response" field since a transaction has been transferred, the date of the transaction transfer is entered under the "Responded on" field and the person's name who transferred the transaction is under the "Responded to" field.


Mailing Assignment to an Active List

It is also possible to create a "Mailing history" for several clients at a time, but without generating "Mass mailing".


To do so, go to the "Client management", then search, using the search bar or a filter, the clients to whom this "mailing history" should be assigned. When the active list is ready, click on the "Special functions" menu, then select "Add mailings".

Mailing History 007.png


After clicking on "Add mailings", this window opens.

Mailing History 008.png

A: See letter A of the "Creating Individual Mailing Histories" section.

B: See letter B of the "Creating Individual Mailing Histories" section.

C: See letter C of the "Creating Individual Mailing Histories" section.

D: See letter D of the "Creating Individual Mailing Histories" section. If the box is checked, the database will enter, in the mailing of each client, the canvasser assigned to him or her in the client file.

E: See letter E of the "Creating Individual Mailing Histories" section.

F: This field indicates the response date. This date is automatically updated when the response is modified. The date is modifiable nonetheless.

G: See letter G of the "Creating Individual Mailing Histories" section.

H: See letter I of the "Creating Individual Mailing Histories" section.


Consulting Mailing Histories

It is possible to view the mailing histories in two ways:



Consulting the Mailing Histories from a Client File

The individual management of the mailing histories can be done in the client files.

To view the elements of the "Mailing history" of a client in particular, open his or her file; then go to the "Mailings" tab that is at the bottom of the client file.

Mailing History 007.png

B: It is the date when the "Mailing history" was modified, either because a transaction has been transferred, or because a "To be received" or "To be paid" transaction has been entered or simply because the "Mailing history" has been modified manually. The current date is automatically entered, but it is possible to modify it. For more information concerning the modification of mailing histories, click here.

C: It is the person who modified the "Mailing history", either because he or she has transferred a transaction, or because a "To be received" or "To be paid" transaction has been entered or simply because he or she has modified the "Mailing history" manually. This field is not modifiable, the software automatically enters the name of the user who performed the modifications. For more information concerning the modification of the mailing histories, click here.


Consulting the Mailing Histories from "Analysis and History"

"Analysis and history" allows you to view precise mailings (for example, the mailings of a donation occasion).

To view the "Mailing history" of all the clients of the database or of a selection of clients in particular, go to "Analysis and history"; then to the "Mailings" tab.

Mailing History 009.png

A: The "Response" field indicates the status of the mailing. These responses can be modified either individually, massively, or in certain cases, automatically in the entry of a transaction.


Modification of Mailing Histories

It is possible to modify the mailing histories from two different locations in the software:


Individual Modification of Mailing Histories

To individually modify a mailing history, follow the "Creating Individual Mailing Histories" procedure by using the Button Edit.png button.


Massive Modification of Mailing Histories

It is also possible to massively modify or delete mailing histories. This option is particularly useful if the mailing is not linked to transactions.

To do so, you need to go to "Analysis and history". Then search, using the search bar or a filter, the mailing histories that must be modified or deleted. When the active list is ready, click on the "Special functions" menu, then select "Assign new values".

CAUTION: It is strongly recommended to save your data before a "Massive assignment".

Mailing History 010.png


After clicking on "Assign new values", this window opens.

Mailing History 011.png

A: These options allow you to choose whether it is a mailing removal or modification. 

B: These boxes are shaded when it is a removal. When it is a mailing modification, you must check the box corresponding to the field to be modified.


Creating a Recall List

It is also possible to create a customized list to find the clients meeting certain mailing criteria. For instance, to find all the clients who have not responded to the invitation for the Golf Tournament 2011, so that you can send them a second invitation. To know how to create a customized list on mailing criteria, click here.

Mailing Analyses

There are some reports related to the mailings:

  • The "Response rate summary" report allows you to easily view the response rate to a particular mailing.
    To use this report: From "Analysis and history", then go to the "Mailings" tab and click on the Button Print Report.png button that is at the top of the window.
  • The "Revenue vs mailing history" report allows you to compare the revenues relevant to a mailing.
    To use this report: From the software home page, click on the "Analysis" menu, then select "Reports".
  • The "Return on investment" report, allows you to check whether a mailing was financially profitable or not.
    To use this report: From the software home page, click on the "Analysis" menu, then select "Reports".
  • The "Client with detailed history" report allows you to include the mailings.
    To use this report: From the "Client management" click on the Button Print Report.png button, that is at the top of the window.


Moreover, all the mailings are in the "Mailings" tab of "Analysis and history" and from there, it is possible to export the entire mailings to Excel or to create an active list of the mailings to export.




Document name: ProDon:Mailing History
Version : 4.6.5.9