Difference between revisions of "ProDon:Mailing History"

From Logilys
Jump to: navigation, search
 
(76 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{{Header_ProDon | | 4.6.5.10 | Nadia Carrier | | 2011/08/29 }}  
+
{{Header_TOC}}<br>
  
 
== Introduction  ==
 
== Introduction  ==
Line 13: Line 13:
 
*Quickly find the list of people who did not respond to a first invitation; to send them a reminder, second mailing, third mailing, etc.;  
 
*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);  
 
*Discover people's trends (the type of invitation people are interested in);  
*Target and plan mailings according to an individual's preferences.
+
*Target and plan mailings according to the individual's preferences.
  
 
<br>  
 
<br>  
Line 21: Line 21:
 
<br>  
 
<br>  
  
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.
+
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  ==
 
== Configuration of Default Responses for the Mailing History  ==
Line 29: Line 29:
 
<br>  
 
<br>  
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" style="width: 582px; height: 1291px;" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
Line 37: Line 37:
  
 
|-
 
|-
| colspan="2" | [[Image:Mailing History 001.png]]
+
| colspan="2" | [[Image:Mailing History 001.png]]<br>
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
'''NOTE: '''The drop-down lists for the fields from <span style="color: rgb(255, 0, 0);">'''A '''</span>to '''<span style="color: rgb(255, 0, 0);">F </span>'''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 <span style="color: rgb(255, 0, 0);">'''H '''</span>are exactly the same options as for the dynamic drop-down lists. To know how the dynamic drop-down lists work, consult this procedure.  
+
'''NOTE: '''The drop-down lists of the <span style="color: rgb(255, 0, 0);">'''A '''</span>to '''<span style="color: rgb(255, 0, 0);">F </span>'''fields'''<span style="color: rgb(255, 0, 0);"> </span>'''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 <span style="color: rgb(255, 0, 0);">'''H '''</span>are exactly the same options as the ones of&nbsp; the dynamic drop-down lists. To know how the dynamic drop-down lists work, consult [[Common functions:Dynamic Drop-down Lists|this procedure]].  
  
For more information concerning the "Response" field that will be used in the upcoming examples, see letter <span style="color: rgb(255, 0, 0);">'''A'''</span> on the "Consulting mailing histories from "Analysis and history" section.  
+
For more information concerning the "Response" field that will be used in the upcoming examples, see letter <span style="color: rgb(255, 0, 0);">'''A'''</span> on the section [[ProDon:Mailing History#Consulting_the_Mailing_Histories_from_.22Analysis_and_History.22|"Consulting mailing histories from "Analysis and history""]].  
  
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
'''<span style="color: rgb(255, 0, 0);">A: </span>'''The mention "Pending" will automatically be entered in the "Response" field in the creation of the mailing history.  
+
'''<span style="color: rgb(255, 0, 0);">A: </span>'''The comment "Pending" will automatically be entered in the "Response" field in the creation of the mailing history.  
  
 
| width="50%" |  
 
| width="50%" |  
'''<span style="color: rgb(255, 0, 0);">B:&nbsp;</span>'''The mention "Gift received" will automatically be entered in the "Response" field as soon as the transaction linked to the mailing is transferred.  
+
'''<span style="color: rgb(255, 0, 0);">B:&nbsp;</span>'''The comment "Gift received" will automatically be entered in the "Response" field as soon as the transaction linked to the mailing is transferred.  
  
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
'''<span style="color: rgb(255, 0, 0);">C: </span>'''The mention "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.  
+
'''<span style="color: rgb(255, 0, 0);">C: </span>'''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, [[ProDon:Different Clients of a Transaction|click here]].  
  
 
| width="50%" |  
 
| width="50%" |  
'''<span style="color: rgb(255, 0, 0);">D:&nbsp;</span>'''The mention "Responded to subsequent solicitation" is entered in the "Response" filed 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 mention "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.  
+
'''<span style="color: rgb(255, 0, 0);">D:&nbsp;</span>'''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.  
  
 
|-
 
|-
 
| 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|click here]].
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">F: </span>'''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".
 +
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">G: </span>'''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.
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">H: </span>'''These options are available only if the option in <span style="color: rgb(255, 0, 0);">'''G'''</span> 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.
 +
 
|}
 
|}
  
<br>
+
<br>  
  
== Creating Mailing History ==
+
== Creating Mailing Histories ==
  
=== Creating Individual Mailing History  ===
+
A mailing history can be created in three different ways:
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
*From the "Mailings" tab of a client file (for the [[ProDon:Mailing History#Creating_Individual_Mailing_Histories|creation of an individual mailing history]]);
 +
*During the configuration of a "Mass Mailing" (for the [[ProDon:Mailing History#Creating_Mailing_Histories_from_Mass_Mailing|creation of a massive mailing history]]);
 +
*From the "Client management" (for an [[ProDon:Mailing History#Mailing_Assignment_to_an_Active_List|assignment of mailings to an active list]]).
 +
 
 +
<br>
 +
 
 +
=== Creating Individual Mailing Histories  ===
 +
 
 +
The mailing history can be used on an individual basis.
 +
 
 +
{| cellspacing="1" cellpadding="1" border="1" style="width: 649px; height: 441px;" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
 +
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.
 +
 
|-
 
|-
| colspan="2" |  
+
| colspan="2" | [[Image:Mailing History 002.png]]
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">A: </span>'''The [[Image:Button Search.png]] button allows you to activate the [[Common functions:Search Bar|search bar]].
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">B: </span>'''The [[Image:Button add plus.png]] button allows you to create a new mailing history.
 +
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
<span style="color: rgb(255, 0, 0);">'''C: '''</span>The [[Image:Button Edit.png]] button allows you to modify a mailing history.
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">D: </span>'''The [[Image:Button Minus remove delete.png]] button allows you to remove a mailing from the list of mailing histories of the client.
 +
 
|}
 
|}
  
 
<br>  
 
<br>  
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" style="width: 528px; height: 988px;" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
 +
After clicking on the [[Image:Button add plus.png]] button, this window opens.
 +
 
|-
 
|-
| colspan="2" |  
+
| colspan="2" | [[Image:Mailing History 003.png]]
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">{{Anchor||mailinghistoryA}}A: </span>'''The current date is entered automatically, but it is possible to modify it.
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">{{Anchor||mailinghistoryB}}B:&nbsp;</span>'''Allows you to specify the donation occasion for which the mailing is done.
 +
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">{{Anchor||mailinghistoryC}}C: </span>'''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.
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">{{Anchor||mailinghistoryD}}D:&nbsp;</span>'''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.
 +
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">{{Anchor||mailinghistoryE}}E: </span>'''This field indicates the response.
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">F: </span>'''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.
 +
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">{{Anchor||mailinghistoryG}}G: </span>'''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.
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">H:&nbsp;</span>'''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.
 +
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">{{Anchor||mailinghistoryI}}I: </span>'''Allows you to enter a description for the mailing.
 +
 
| width="50%" |  
 
| width="50%" |  
 
|}
 
|}
Line 113: Line 161:
 
<br>  
 
<br>  
  
=== Creating Mailing History from Mass 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 [[ProDon:Mass Mailing|this procedure]].
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
<br>
 +
 
 +
{| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 448px; height: 564px;"
 
|-
 
|-
|  
+
| [[Image:Mailing History 004.png]]
 
|-
 
|-
 
|  
 
|  
 +
It is important to specify the elements to be entered in the "Mailing history" of the [[ProDon:Mass Mailing#.22Mailings.22_Tab|"Mailings"]] tab when configuring the "Mass mailing".
 +
 +
<br>
 +
 +
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 [[ProDon:Mailing History#Configuration_of_Default_Responses_for_the_Mailing_History|configuration of the mailing history]].
 +
 
|}
 
|}
  
 
<br>  
 
<br>  
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
{| width="656" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 
|-
 
|-
 
|  
 
|  
 +
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".
 +
 
|-
 
|-
|  
+
| [[Image:Mailing History 005.png]]
 
|-
 
|-
 
|  
 
|  
 +
'''<span style="color: rgb(255, 0, 0);">A: </span>'''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.
 +
 
|}
 
|}
  
 
<br>  
 
<br>  
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
{| width="654" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 
|-
 
|-
 
|  
 
|  
 +
Here is an example of result when a transaction related to the "Mailing history" is entered.
 +
 
|-
 
|-
|  
+
| [[Image:Mailing History 006.png]]
 
|-
 
|-
 
|  
 
|  
 +
'''<span style="color: rgb(255, 0, 0);">B: </span>'''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.
 +
 
|}
 
|}
  
Line 148: Line 214:
 
=== Mailing Assignment to an Active List  ===
 
=== Mailing Assignment to an Active List  ===
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
It is also possible to create a "Mailing history" for several clients at a time, but without generating "Mass mailing".
 +
 
 +
<br>
 +
 
 +
{| width="486" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 
|-
 
|-
 
|  
 
|  
 +
To do so, go to the "Client management", then search, using the [[Common functions:Search Bar|search bar]] or a [[Common functions:Filter Data (Queries)|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".
 +
 
|-
 
|-
|  
+
| style="text-align: center;" | [[Image:Mailing History 007.png]]<br>
 
|}
 
|}
  
 
<br>  
 
<br>  
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
{| width="519" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
 +
After clicking on "Add mailings", this window opens.<br>
 +
 
|-
 
|-
| colspan="2" |  
+
| style="text-align: center;" colspan="2" | [[Image:Mailing History 008.png]]<br>
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">A: </span>'''See letter <span style="color: rgb(255, 0, 0);">'''A '''</span>of the "[[#mailinghistoryA|Creating Individual Mailing Histories]]" section.
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">B: </span>'''See letter <span style="color: rgb(255, 0, 0);">'''B'''</span> of the [[#mailinghistoryB|"Creating Individual Mailing Histories"]] section.
 +
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">C: </span>'''See letter '''<span style="color: rgb(255, 0, 0);">C</span>''' of the [[#mailinghistoryC|"Creating Individual Mailing Histories"]] section.
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">D: </span>'''See letter '''<span style="color: rgb(255, 0, 0);">D</span>''' of the [[#mailinghistoryD|"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.
 +
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">E: </span>'''See letter <span style="color: rgb(255, 0, 0);">'''E'''</span> of the [[#mailinghistoryE|"Creating Individual Mailing Histories"]] section.
 +
 
| width="50%" |  
 
| width="50%" |  
 +
<span style="color: rgb(255, 0, 0);">'''F: '''</span>This field indicates the response date. This date is automatically updated when the response is modified. The date is modifiable nonetheless.
 +
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">G: </span>'''See letter <span style="color: rgb(255, 0, 0);">'''G '''</span>of the [[#mailinghistoryG|"Creating Individual Mailing Histories"]] section.
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">H:&nbsp;</span>'''See letter <span style="color: rgb(255, 0, 0);">'''I '''</span>of the [[#mailinghistoryI|"Creating Individual Mailing Histories"]] section.
 +
 
|}
 
|}
  
 
<br>  
 
<br>  
  
== Consulting Mailing History ==
+
== Consulting Mailing Histories ==
  
=== Consulting the Mailing History from a Client File  ===
+
It is possible to view the mailing histories in two ways:
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
<br>
 +
 
 +
*From a client file (for an [[ProDon:Mailing History#Consulting_the_Mailing_Histories_from_a_Client_File|individual consultation]]);
 +
*From "Analysis and history" (for the [[ProDon:Mailing History#Consulting_the_Mailing_Histories_from_.22Analysis_and_History.22|massive consultation of mailing histories]]).
 +
 
 +
<br>
 +
 
 +
=== Consulting the Mailing Histories from a Client File  ===
 +
 
 +
The individual management of the mailing histories can be done in the client files.<br>
 +
 
 +
{| cellspacing="1" cellpadding="1" border="1" style="width: 450px; height: 466px;" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
 +
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.
 +
 
|-
 
|-
| colspan="2" |  
+
| colspan="2" | [[Image:Mailing History 007.png]]
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">B: </span>'''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, [[ProDon:Mailing History#Modification_of_Mailing_Histories|click here]].
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">C: </span>'''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, [[ProDon:Mailing History#Modification_of_Mailing_Histories|click here]].
 +
 
|}
 
|}
  
 
<br>  
 
<br>  
  
=== Consulting the Mailing History from "Analysis and History"  ===
+
=== Consulting the Mailing Histories from "Analysis and History"  ===
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
"Analysis and history" allows you to view precise mailings (for example, the mailings of a donation occasion).
 +
 
 +
{| width="50%" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 
|-
 
|-
 
|  
 
|  
 +
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.
 +
 
|-
 
|-
|  
+
| [[Image:Mailing History 009.png]]
 
|-
 
|-
 
|  
 
|  
 +
'''<span style="color: rgb(255, 0, 0);">A: </span>'''The "Response" field indicates the status of the mailing. These responses can be modified either [[ProDon:Mailing History#Individual_Modification_of_Mailing_Histories|individually]], [[ProDon:Mailing History#Massive_Modification_of_Mailing_Histories|massively]], or in certain cases, [[ProDon:Mailing History#Configuration_of_Default_Responses_for_the_Mailing_History|automatically]] in the entry of a transaction.
 +
 
|}
 
|}
  
 
<br>  
 
<br>  
  
== Modification of Mailing History ==
+
== Modification of Mailing Histories ==
 +
 
 +
It is possible to modify the mailing histories from two different locations in the software:
 +
 
 +
*From a client file (for the [[ProDon:Mailing History#Individual_Modification_of_Mailing_Histories|individual modification of mailing histories]]);
 +
*From "Analysis and history" (for the [[ProDon:Mailing History#Massive_Modification_of_Mailing_Histories|massive or individual modification of mailing histories]]).
  
=== Individual Modification of Mailing History  ===
+
<br>
  
=== Massive Modification of Mailing History ===
+
=== Individual Modification of Mailing Histories ===
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
To individually modify a mailing history, follow the [[ProDon:Mailing History#Creating_Individual_Mailing_Histories|"Creating Individual Mailing Histories"]] procedure by using the [[Image:Button Edit.png]] button.
 +
 
 +
<br>
 +
 
 +
=== 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.
 +
 
 +
{| cellspacing="1" cellpadding="1" border="1" style="width: 602px; height: 356px;" class="wikitable"
 
|-
 
|-
 
|  
 
|  
 +
To do so, you need to go to "Analysis and history". Then search, using the [[Common functions:Search Bar|search bar]] or a [[Common functions:Filter Data (Queries)|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".
 +
 
|-
 
|-
|  
+
| [[Image:Mailing History 010.png]]
 
|}
 
|}
  
 
<br>  
 
<br>  
  
{| cellspacing="1" cellpadding="1" border="1" width="50%" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" style="width: 520px; height: 602px;" class="wikitable"
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
 +
After clicking on "Assign new values", this window opens.
 +
 
|-
 
|-
| colspan="2" |  
+
| colspan="2" | [[Image:Mailing History 011.png]]
 
|-
 
|-
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">A: </span>'''These options allow you to choose whether it is a mailing removal or modification.&nbsp;
 +
 
| width="50%" |  
 
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">B: </span>'''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.
 +
 
|}
 
|}
  
 
<br>  
 
<br>  
  
== Creating a Calling 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]].
 +
 
 +
== 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.<br>To use this report: From "Analysis and history", then go to the "Mailings" tab and click on the&nbsp;[[Image: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.<br>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.<br>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.<br>To use this report: From the "Client management" click on the [[Image:Button Print Report.png]] button, that is at the top of the window.
 +
 
 +
<br>
 +
 
 +
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.
 +
 
 +
<br>
  
== Mailing Analysis  ==
+
<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