Difference between revisions of "ProDon:Customized Lists"
(163 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | {{ | + | {{Header_TOC}}<br> |
+ | |||
+ | '''<u>CAUTION</u>''' : This document is for '''VERSION''' '''5''' of '''''Prodon'''''. To go to the document for version 4, [[ProDon:Customized_Lists (Version 4)|click here]]. | ||
+ | |||
+ | <br><span style="color: rgb(255, 0, 0);">'''WARNING : This document is currently being edited/revised, it is possible that some parts are missing or obsolete.'''</span> | ||
+ | |||
+ | |||
== Introduction == | == Introduction == | ||
− | The customized list tool allows you to create | + | The customized list tool allows you to create client lists. Once created, these clients lists are saved and can be viewed again at will. They can also be combined with one another and can be modified or deleted if desired. Although it is possible to create lists somewhere else than in the "Client management", they still are client lists. |
<br> | <br> | ||
Line 21: | Line 27: | ||
<br> | <br> | ||
− | Static lists remain the same and always contain the same clients (e.g. a list people | + | Static lists remain the same and always contain the same clients (e.g. a list of people who received a particular letter), whereas a dynamic list is automatically modified by '''''ProDon''''' each time a client meets the requested criteria (e.g. all the clients who gave $1,000 or more in a lifetime). To be noted that dynamic lists are only available in the "Client management". |
<br> | <br> | ||
+ | |||
+ | Customized lists can be based on precise clients (e.g. all clients, potential duplicates, etc.) AND on different criteria as well. Therefore, a list is created with certain clients (or all clients) who meet certain criteria. | ||
<br> | <br> | ||
− | |||
− | |||
== Preparing the Active List == | == Preparing the Active List == | ||
− | As stated in the introduction, customized lists can be created from different '''''ProDon''''' managements. Although each grid contains different elements (Client management = clients, Analysis and history = transactions, etc.), the | + | As stated in the introduction, customized lists can be created from different '''''ProDon''''' managements. Although each management grid contains different elements (Client management = clients, Analysis and history = transactions, etc.), the outcome of a list will always be a client list. |
+ | It is possible to create a customized list from all the elements of a management grid or from a created list using a [[Common functions:Search Bar|search]] or a [[Common functions:Filter Data (Queries)|filter]] in order to isolate certain clients or a precise transaction batch, etc.<br> | ||
− | + | {| width="653" cellspacing="1" cellpadding="1" border="1" class="wikitable" | |
− | {| width=" | ||
|- | |- | ||
| | | | ||
− | Example of an active list containing all the clients of the "Client management", no search | + | Example of an active list containing all the clients of the "Client management", no search nor filter was applied. |
|- | |- | ||
− | | [[Image: | + | | style="text-align: center;" | [[Image:Customized Lists 001.png]] |
|- | |- | ||
| | | | ||
− | + | In the following example, after searching for the clients living in Toronto, the number of items onscreen has decreased; but it still is the active list on which the customized list will be based. | |
|- | |- | ||
− | | [[Image: | + | | [[Image:Customized Lists 002.png]] |
|} | |} | ||
+ | |||
+ | <br> | ||
== Creating Customized Lists == | == Creating Customized Lists == | ||
− | After configuring the active list in the chosen management, click on the [[Image: | + | After configuring the [[ProDon:Customized Lists#Preparing_the_Active_List|active list]] in the chosen management, click on the [[Image:Button Personnalised lists.png]] button that is at the top of the window, in order to edit the criteria of the customized list. |
− | In the "Client management", two options are available: "Static lists" and "Dynamic lists". In all other managements, only the option "Static lists" is available, so no choices are offered | + | In the "Client management", two options are available: "Static lists" and "Dynamic lists". In all other managements, only the option "Static lists" is available, so no other choices are offered. |
− | |||
− | |||
+ | With the customized lists tool, it is possible to create, modify and remove lists. However, to be able to view them onscreen again or to combine lists together, see the [[ProDon:Customized Lists#Viewing_.2F_Filtering_Customized_Lists|"Viewing / Filtering Customized Lists"]] section. | ||
+ | <br> | ||
=== Static List (main window) === | === Static List (main window) === | ||
− | Static | + | Static lists remain the same and always contain the same clients. It is sometimes necessary that a list remains the same, for instance, people who received a particular letter for a specific occasion. This list has to be fixed and must not change.<br> |
− | + | {| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 517px; height: 684px;" | |
− | |||
− | {| cellspacing="1" cellpadding="1" border="1" style="width: 517px; height: 684px; | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
− | After clicking on the [[Image:Button Personnalised lists.png]] button and | + | After clicking on the [[Image:Button Personnalised lists.png]] button and selecting the "Static lists" option, this window opens. |
|- | |- | ||
Line 75: | Line 81: | ||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
− | '''<span style="color: rgb(255, 0, 0);">A: </span>'''These are the choices of clients who could be assigned to a static | + | '''<span style="color: rgb(255, 0, 0);">{{Anchor||staticA}}A: </span>'''These are the choices of clients who could be assigned to a customized static list. For more details, see [[ProDon:Customized Lists#Customized_Static_List_Criteria|this section]]. |
| width="50%" | | | width="50%" | | ||
− | '''<span style="color: rgb(255, 0, 0);">B: </span>'''By checking this box, the clients excluded from | + | '''<span style="color: rgb(255, 0, 0);">{{Anchor||staticB}}B: </span>'''By checking this box, the clients excluded from mass mailing who meet the selected criteria will be added to the list. |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
− | '''<span style="color: rgb(255, 0, 0);">C: </span>'''The buttons [[Image:Button add plus.png]], [[Image:Button Edit.png]] and [[Image:Button Minus remove delete.png]] allow you to add a new list, to modify the name of a list or to remove a customized list. | + | '''<span style="color: rgb(255, 0, 0);">{{Anchor||staticC}}C: </span>'''The buttons [[Image:Button add plus.png]], [[Image:Button Edit.png]] and [[Image:Button Minus remove delete.png]] allow you to [[ProDon:Customized Lists#Static_List_.2F_Adding_a_New_List|add a new list]], to [[ProDon:Customized Lists#Static_List_.2F_Renaming_a_List|modify the name of a list]] or to [[ProDon:Customized Lists#Static_List_.2F_Removing_a_List|remove a customized list]]. |
| width="50%" | | | width="50%" | | ||
− | '''<span style="color: rgb(255, 0, 0);">D: </span>'''These are | + | '''<span style="color: rgb(255, 0, 0);">D: </span>'''These are the lists that have already been created. By clicking on the drop-down menu, all existing customized lists are available. To modify an existing list, select it, then follow the instructions of the [[ProDon:Customized Lists#Static_List_.2F_Modifying_an_Existing_List_.28Add_or_remove_clients.29|"Static list/Modifying an existing list (Add or remove clients)"]] section. |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
− | '''<span style="color: rgb(255, 0, 0);">E: </span>'''Allows you to edit the criteria for the customized list. The criteria to be edited will change based on the chosen criterion of static | + | '''<span style="color: rgb(255, 0, 0);">{{Anchor||staticE}}E: </span>'''Allows you to edit the criteria for the customized list. The criteria to be edited will change based on the chosen [[ProDon:Customized Lists#Customized_Static_List_Criteria|criterion of the customized static list]]. |
| width="50%" | | | width="50%" | | ||
− | '''<span style="color: rgb(255, 0, 0);">F: </span>'''Depending on the choice selected | + | '''<span style="color: rgb(255, 0, 0);">F: </span>'''Depending on the choice selected at '''<span style="color: rgb(255, 0, 0);">A</span>''', this button will be visible or not. If it is visible, by clicking on it, the number of clients, in accordance with the chosen criteria, will be indicated. |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
− | '''<span style="color: rgb(255, 0, 0);">G: </span>'''Always considering the criteria selected | + | '''<span style="color: rgb(255, 0, 0);">G: </span>'''Always considering the criteria selected at <span style="color: rgb(255, 0, 0);">'''A'''</span>, this button allows you to add to an existing list the [[ProDon:Customized Lists#Preparing_the_Active_List|clients of the active list shown onscreen]], '''OR''' allows you to add to an existing list the clients of the active list meeting the criteria edited in <span style="color: rgb(255, 0, 0);">'''E'''</span>, '''OR''' allows you to [[ProDon:Customized Lists#Static_List_.2F_Adding_a_New_List|add to a new list]] the clients from the active list meeting the selected criteria. |
| width="50%" | | | width="50%" | | ||
− | '''<span style="color: rgb(255, 0, 0);">H: </span>'''Always considering the | + | '''<span style="color: rgb(255, 0, 0);">H: </span>'''Always considering the criteria selected at <span style="color: rgb(255, 0, 0);">'''A'''</span>, this button allows you to remove from an existing list the [[ProDon:Customized Lists#Preparing_the_Active_List|clients of the active list shown onscreen]], '''OR''' allows you to remove from an existing list the clients of the active list meeting the criteria edited in <span style="color: rgb(255, 0, 0);">'''E'''</span>. |
|- | |- | ||
Line 105: | Line 111: | ||
'''<span style="color: rgb(255, 0, 0);">I: </span>'''Allows you to empty the chosen existing list before adding the client(s) with the selected criteria. | '''<span style="color: rgb(255, 0, 0);">I: </span>'''Allows you to empty the chosen existing list before adding the client(s) with the selected criteria. | ||
− | '''CAUTION:''' By clicking on <span style="color: rgb(255, 0, 0);">'''G'''</span>, this feature will erase the clients previously contained in this list and will modify it with the new corresponding client(s). | + | '''CAUTION:''' By clicking on <span style="color: rgb(255, 0, 0);">'''G'''</span>, this feature will erase the clients previously contained in this list and will modify it with the new corresponding client(s). |
| width="50%" | | | width="50%" | | ||
− | '''<span style="color: rgb(255, 0, 0);">J: </span>'''Automatically displays onscreen the result of the modified list. | + | '''<span style="color: rgb(255, 0, 0);">J: </span>'''Automatically displays onscreen the result of the modified list. |
− | '''NOTE:''' It is strongly recommended to leave this checkbox unchecked at all times not to lose the previous active list onscreen. To learn how to view or revise the customized lists onscreen, see this section. | + | '''NOTE:''' It is strongly recommended to leave this checkbox unchecked at all times not to lose the previous active list onscreen. To learn how to view or revise the customized lists onscreen, see [[ProDon:Customized Lists#Viewing_.2F_Filtering_Customized_Lists|this section]]. |
|} | |} | ||
Line 118: | Line 124: | ||
==== Customized Static List Criteria ==== | ==== Customized Static List Criteria ==== | ||
− | There are seven types of static | + | There are seven types of customized static lists and each type contains different criteria. Here they are: |
+ | |||
+ | *[[ProDon:Customized Lists#All_clients_in_the_active_list|All clients in the active list]] | ||
+ | *[[ProDon:Customized Lists#All_third-party_clients_of_the_active_list|All third-party clients of the active list]] | ||
+ | *[[ProDon:Customized Lists#All_clients_in_the_active_list_that_meet_certain_donation_criteria|All clients in the active list that meet certain donation criteria]] | ||
+ | *[[ProDon:Customized Lists#All_clients_in_the_active_list_that_meet_certain_mailing_criteria|All clients in the active list that meet certain mailing criteria]] | ||
+ | *[[ProDon:Customized Lists#All_potential_duplicate_clients_in_the_active_list|All potential duplicate clients in the active list]] | ||
+ | *[[ProDon:Customized Lists#All_clients_linked_to_a_client_in_the_active_list_that_meet_certain_link_criteria|All clients linked to a client in the active list that meet certain link criteria]] | ||
+ | *[[ProDon:Customized Lists#Only_the_selected_client.C2.A0|Only the selected client]] | ||
+ | |||
+ | <br> | ||
+ | |||
+ | ===== All clients in the active list ===== | ||
+ | |||
+ | Allows you to include all the clients who are currently in the active list. | ||
+ | |||
+ | This type of customized list is useful if all the clients to be added or removed from a list are already isolated in the active list. | ||
− | + | After choosing "All clients in the active list" [[#staticA|at <span style="color: rgb(255, 0, 0);">'''A'''</span>]], determine what must be done by following the instructions in the main window [[ProDon:Customized Lists#Static_List_.28main_window.29|"Static list (main window)"]]. | |
− | |||
− | |||
− | + | <br> | |
===== All third-party clients of the active list ===== | ===== All third-party clients of the active list ===== | ||
− | ===== All clients | + | Only available in some tabs of "Analysis and history", it allows you to extract all third-party clients registered in the transactions of the active list. |
+ | |||
+ | After choosing "All clients in the active list" [[#staticA|at <span style="color: rgb(255, 0, 0);">'''A'''</span>]], determine what must be done by following the instructions of the main window [[ProDon:Customized Lists#Static_List_.28main_window.29|"Static list (main window)"]]. | ||
+ | |||
+ | <br> | ||
+ | |||
+ | ===== All clients in the active list that meet certain donation criteria ===== | ||
+ | |||
+ | Allows you to include the clients of the [[ProDon:Customized Lists#Preparing_the_Active_List|active list]] who meet certain donation criteria. | ||
− | {| width=" | + | {| width="630" cellspacing="1" cellpadding="1" border="1" class="wikitable" |
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | This window appears after selecting "All clients in the active list that meet certain donation criteria" [[#staticA|at <span style="color: rgb(255, 0, 0);">'''A'''</span>]] determine what must be done [[#staticC|at <span style="color: rgb(255, 0, 0);">'''C'''</span>]], then click on the "Edit criteria" button [[#staticE|at <span style="color: rgb(255, 0, 0);">'''E'''</span>]]. | ||
+ | |||
+ | In this window, you must select the desired options in order to target clients in relation with a transaction history. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 004.png]] |
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | '''CAUTION: '''Only the clients who are part of the active list created [[ProDon:Customized Lists#Preparing_the_Active_List|earlier]] '''and''' who meet '''all''' the criteria entered in this window will be found. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Allows you to base your search on a received amount of money. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''Allows you to base your search on an amount in relation with the receipts issued to the clients. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''This option is not available in the first criterion. It allows you to target a variation in relation to the previous criterion. For instance, if $50 were entered, the clients who gave $50 more or less in a donation occasion in comparison to another donation occasion or in a year in comparison to another year would have been found. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">D: </span>'''Allows you to specify the number of instalments in order to reach the amount targeted at <span style="color: rgb(255, 0, 0);">'''A'''</span> or at '''<span style="color: rgb(255, 0, 0);">B</span>'''. For instance, if the amounts indicated at <span style="color: rgb(255, 0, 0);">'''A '''</span>had been $500 to $1,000 and that a minimum of 1 transaction and a maximum of 2 transactions would have been defined, a client who made 3 transactions of $200 could not be found. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">E: </span>'''Allows you to base your search on the highest transactions in order to reach the amount targeted at <span style="color: rgb(255, 0, 0);">'''A'''</span> or at <span style="color: rgb(255, 0, 0);">'''B'''</span>. For instance, if the amounts indicated at<span style="color: rgb(255, 0, 0);">''' A'''</span> had been $500 to $1,000 and that only the 2 highest transactions of the clients would be considered, a client for whom the 2 highest transactions were $500 and $600 would not be found. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">F: </span>'''Allows you to define the date interval (according to the [[ProDon:Period Management|periods]] created in '''''ProDon''''') in which the transactions must have been made. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">G: </span>'''Depending on the period selected in <span style="color: rgb(255, 0, 0);">'''F'''</span>, the dates will be modified automatically. It is also possible to define the dates manually, in that event, the <span style="color: rgb(255, 0, 0);">'''F'''</span> field becomes empty and '''''ProDon''''' will refer to the dates entered here. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">H: </span>'''Allows you to choose for which organization the transactions have been made. | ||
+ | |||
+ | '''NOTE: '''This option is available only if the [[ProDon:Multi-organization Module|Multi-organization Module]] is active. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">I: </span>'''Allows you to select the type of transaction among three choices "Client", "Third-party client" or "Client and third-party client". | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">J: </span>'''Allows you to decide whether the search should be based on all the transactions or if it should be based on particular donation occasions, campaigns or activities. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">K: </span>'''Allows you to include or not the commitments. | ||
+ | |||
+ | '''NOTE: '''This option is only available when the [[ProDon:Prospecting and Commitments Module|Prospecting and Commitments Module]] is activated. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">L: </span>'''Allows you to base the search on [[ProDon:Origin Code Management|origin codes]]. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">M: </span>'''Depending on the type of selection chosen at <span style="color: rgb(255, 0, 0);">'''J'''</span>, the [[Image:Button funky check mark.png]] and [[Image:Button funky x.png]] buttons and the boxes on the left will be available or not. The [[Image:Button funky check mark.png]] button allows you to check all the boxes to the left of the buttons and the [[Image:Button funky x.png]] allows you to uncheck them all. It is also possible to select one by one the donation occasions, activities or campaigns that should be considered in the search. In the example above, all the clients who gave at least $1 in either donation occasions will be found. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">N: </span>'''These 4 checkboxes allow you to choose the type of transactions to include in the search. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">O: </span>'''The buttons "[[Image:Button add plus.png]] Add criterion" and "[[Image:Button Minus remove delete.png]] Delete criterion" allow you to add or delete a criterion. In this example, there are two criteria. The number of criteria is visible from the tabs in the upper-left of the window. When adding a criterion, you must go in the tab to configure criterion 2, 3, etc. To delete a criterion, select the tab of the criterion, then click on the "[[Image:Button Minus remove delete.png]] Delete criterion" button. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">P: </span>'''When all the criteria are selected, click on "[[Image:Button Check mark Confirm.png]] OK". | ||
+ | |||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | '''NOTE: '''For points <span style="color: rgb(255, 0, 0);">'''D'''</span> and <span style="color: rgb(255, 0, 0);">'''E'''</span>, the "0" indicates that the box should not be considered. Therefore, if "0" is entered at <span style="color: rgb(255, 0, 0);">'''D'''</span>, this field will not be considered. At <span style="color: rgb(255, 0, 0);">'''E'''</span>, for instance, if the minimum is "2", but there is no maximum, you must enter "0" as maximum and if the maximum is "10" but there is no minimum, you must enter "0" as minimum. | ||
+ | |||
|} | |} | ||
+ | |||
+ | After clicking on "[[Image:Button Check mark Confirm.png]] OK", '''''ProDon''''' will go back to the main menu screen. To pursue with the customized list, see points <span style="color: rgb(255, 0, 0);">'''F'''</span>, '''<span style="color: rgb(255, 0, 0);">G</span>''', '''<span style="color: rgb(255, 0, 0);">H</span>''', '''<span style="color: rgb(255, 0, 0);">I</span>''' and '''<span style="color: rgb(255, 0, 0);">J</span>''' of the [[ProDon:Customized Lists#Static_List_.28main_window.29|"Static List (main window)"]] section.<br> | ||
<br> | <br> | ||
− | ===== All clients | + | ===== All clients in the active list that meet certain mailing criteria ===== |
− | {| width=" | + | Allows you to include the clients of the [[ProDon:Customized Lists#Preparing_the_Active_List|active list]] who meet certain mailing criteria. |
+ | |||
+ | A list by mailing criterion mainly allows you to find all the clients who have not responded following a mailing, in order to solicit them again. This type of list is also useful to find the clients who responded positively, or to find the clients who have not received a mailing. | ||
+ | |||
+ | To use the customized list of the clients meeting certain mailing criteria, it is important that mailing histories have been adequately documented in the database. To learn how to use the mailing history, see [[ProDon:Mailing History|this document]].<br> | ||
+ | |||
+ | {| width="527" cellspacing="1" cellpadding="1" border="1" class="wikitable" | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | This window opens after selecting "All clients in the active list that meet certain mailing criteria" [[#staticA|at <span style="color: rgb(255, 0, 0);">'''A'''</span>]], determine what must be done [[#staticC|at <span style="color: rgb(255, 0, 0);">'''C'''</span>]], then click on the "Edit criteria" button [[#staticE|at <span style="color: rgb(255, 0, 0);">'''E'''</span>]]. | ||
+ | |||
+ | In this window, you must select the desired options in order to target clients by mailing history report. | ||
+ | |||
+ | |- | ||
+ | | colspan="2" | [[Image:Customized Lists 005.png]] | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | '''CAUTION:''' Only the clients who are part of the active list created [[ProDon:Customized Lists#Preparing_the_Active_List|earlier]] and meeting the criteria entered in this window will be found. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Enter the date when the mailing was done. If no date is to be considered for the search, simply leave this space blank. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''Select the organization for which the mailing was done. | ||
+ | |||
+ | '''NOTE:''' This option is available only if the [[ProDon:Multi-organization Module|Multi-organization Module]] is active in the database. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''Select the donation occasion for which the maling was done. If no donation occasion is to be considered, simply leave this box empty. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">D: </span>'''Select the activity for which the mailing was done. If no activity is to be considered for the search, simply leave this box empty. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">E: </span>'''Enter the canvasser of the mailing, if desired. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">F:</span>''' Select the "response value" of the mailing history to be considered for the search according to the [[ProDon:Mailing History#Configuration_of_Default_Responses_for_the_Mailing_History|configuration of default responses]]. In this example, "No answer" means that I want to search the clients to whom I have sent a solicitation, but from whom I did not get any response; all this with the purpose of sending a second mailing. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">G: </span>'''Enter the description of the mailing that was sent, if desired. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">H: </span>'''Allows you to search the mailings for which no activity has been specified. | ||
+ | |||
+ | '''NOTE:''' If <span style="color: rgb(255, 0, 0);">'''D'''</span> is blank and that this box is not checked, the mailings for which no activity had been specified and the mailings for which any activity had been specified will be found. If <span style="color: rgb(255, 0, 0);">'''D'''</span> is blank and that this box is checked, only the mailings with no activity specified will be found. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">I: </span>'''The reversed search allows you to find all the clients who '''do not meet''' '''all''' the entered criteria. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">J: </span>'''This option allows you to include, in addition to the clients who meet the edited criteria, all the clients with no mailings documented. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">K: </span>'''The buttons "[[Image:Button add plus.png]] Add criterion" and "[[Image:Button Minus remove delete.png]] Delete criterion" allow you to add or remove a criterion. In this example, there is only one criterion. The number of criteria is visible from the tabs at the upper-left of the window. When adding a criterion, you must go in the tab to configure criterion 2, 3, etc. To delete a criterion, select the tab of the criterion, then click on the "[[Image:Button Minus remove delete.png]] Delete criterion" button. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
− | + | '''<span style="color: rgb(255, 0, 0);">L: </span>'''When all the criteria are selected, click on "[[Image:Button Check mark Confirm.png]] OK". | |
− | + | ||
− | |||
|} | |} | ||
<br> | <br> | ||
− | ===== | + | After clicking on "[[Image:Button Check mark Confirm.png]] OK", '''''ProDon''''' will go back to the main menu screen. To pursue with the customized list, see points <span style="color: rgb(255, 0, 0);">'''F'''</span>, <span style="color: rgb(255, 0, 0);">'''G'''</span>, <span style="color: rgb(255, 0, 0);">'''H'''</span>,<span style="color: rgb(255, 0, 0);"> '''I '''</span>and <span style="color: rgb(255, 0, 0);">'''J'''</span> of the [[ProDon:Customized Lists#Static_List_.28main_window.29|"Static List (main window)"]] section. |
+ | |||
+ | <br> | ||
− | ===== All clients | + | ===== All potential duplicate clients in the active list ===== |
− | + | Allows you to find the clients who potentially appear more than once in the database of an active list. | |
+ | |||
+ | There is a duplicate when there is more than one client file for the same client. | ||
+ | |||
+ | To learn how to use this type of customized list, see the [[ProDon:Searching and Eliminating Duplicates|"Searching and Eliminating Duplicates"]] procedure. | ||
+ | |||
+ | <br> | ||
+ | |||
+ | ===== All clients linked to a client in the active list that meet certain link criteria ===== | ||
+ | |||
+ | Allows you to include the clients of the [[ProDon:Customized Lists#Preparing_the_Active_List|active list]] corresponding to certain types of links/relations between client files. | ||
+ | |||
+ | A list by link/relation criteria is used to find all the clients linked to one of the clients of the active list. For example, if the active list consists of five client files of schools in which exist links to students, it would be possible to find all students from any of the five schools. Or, if the active list consists of all the students' client files of one school, in which exist the links to their parents, it would be possible to find all the students' parents of the school. | ||
+ | |||
+ | To use the type of customized list by link criterion, all the links/relations must have been documented in the database. To learn how to add contacts linked to client files, see the [[ProDon:Contacts and Links|"Contacts and Links"]] document.<br> | ||
+ | |||
+ | {| cellspacing="1" cellpadding="1" border="1" style="width: 485px; height: 378px;" class="wikitable" | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | This window opens after selecting "All clients in the active list that meet certain link criteria" [[#staticA|at <span style="color: rgb(255, 0, 0);">'''A'''</span>]], determine what must be done [[#staticC|at <span style="color: rgb(255, 0, 0);">'''C'''</span>]], then click on the "Edit criteria" button [[#staticE|at <span style="color: rgb(255, 0, 0);">'''E'''</span>]]. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 006.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Allows you to indicate the type of link to search. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''Allows you to use the link in both directions. In this example, the employees or employers linked to client files of the active list would be found. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''Allows you to add to the customized list, the clients of the active list, in addition to the clients meeting the entered criteria. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">D: </span>'''Allows you to use the reverse link. In this example, the employees linked to the client files of the active list would be found rather than their employers. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">E: </span>'''Indicates the result of the search of the link that will be found. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">F: </span>'''When all criteria are selected, click on "[[Image:Button Check mark Confirm.png]] OK". | ||
+ | |||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | '''NOTE:''' The statement at <span style="color: rgb(255, 0, 0);">'''E'''</span> changes, if the options at <span style="color: rgb(255, 0, 0);">'''B'''</span> or '''<span style="color: rgb(255, 0, 0);">D</span>''' are checked. | ||
+ | |||
|} | |} | ||
<br> | <br> | ||
− | ===== | + | After clicking on "[[Image:Button Check mark Confirm.png]] OK", '''''ProDon''''' will go back to the main screen. To continue the customized list, see points <span style="color: rgb(255, 0, 0);">'''F'''</span>, '''<span style="color: rgb(255, 0, 0);">G</span>''', '''<span style="color: rgb(255, 0, 0);">H</span>''', '''<span style="color: rgb(255, 0, 0);">I</span>''' and '''<span style="color: rgb(255, 0, 0);">J</span>''' of the [[ProDon:Customized Lists#Static_List_.28main_window.29|"Static List (main window)"]] section. |
+ | |||
+ | <br> | ||
+ | |||
+ | ===== Only the selected client ===== | ||
+ | |||
+ | Allows you to only include the client of the [[ProDon:Customized Lists#Preparing_the_Active_List|active list]] who is selected. | ||
+ | |||
+ | This type of customized list is useful if only one client has to be [[ProDon:Customized Lists#Static_List_.2F_Modifying_an_Existing_List_.28Add_or_remove_clients.29|added or removed from an existing customized list]], or if a new list to which it will be necessary to add clients one by one has to be created. | ||
+ | |||
+ | However, to add or remove clients individually, it is preferable to proceed directly from the client file. | ||
+ | |||
+ | To learn how to add or remove a client in a customized list from the client file, see [[ProDon:Customized Lists#Adding_or_Removing_a_Client_from_an_Existing_List_.28static_or_dynamic.29_from_a_Client_File|this section]]. | ||
+ | |||
+ | <br> | ||
==== Static List / Adding a New List ==== | ==== Static List / Adding a New List ==== | ||
− | + | To create a new customized static list, go to the management proper to the type of list to be created (client management, analysis and history, etc.), then prepare the active list of the clients who must be in the new customized static list. Once the [[ProDon:Customized Lists#Preparing_the_Active_List|active list]] is created, click on the [[Image:Bouton Listes personnalisees.png]] button, which is at the top of the window, then select "Static list".<br> | |
+ | |||
+ | {| cellspacing="1" cellpadding="1" border="1" style="width: 517px; height: 837px;" class="wikitable" | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on "Static list", this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 007.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Select the desired option. For more details, see [[#staticA|point <span style="color: rgb(255, 0, 0);">'''A'''</span>]] of the [[ProDon:Customized Lists#Static_List_.28main_window.29|"Static List (main window)"]] section. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''Choose to check the box or not. For more details, see [[#staticB|point <span style="color: rgb(255, 0, 0);">'''B'''</span>]] of the [[ProDon:Customized Lists#Static_List_.28main_window.29|"Static List (main window)"]] section. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''Click on the [[Image:Button add plus.png]] button. | ||
+ | |||
+ | '''NOTE:''' A window opens, to learn how to fill it in, [[#chart|click here]]. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">D: </span>'''After clicking on the "[[Image:Button Check mark Confirm.png]] Confirm addition" of [[#chart|this window]], the name of the new list is entered in that field. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">E: </span>'''Click on this button to edit the criteria of the new customized list. For more details, see [[#staticE|point <span style="color: rgb(255, 0, 0);">'''E'''</span>]] of the [[ProDon:Customized Lists#Static_List_.28main_window.29|"Static List (main window)"]] section. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">F: </span>'''Depending on the choice selected at <span style="color: rgb(255, 0, 0);">'''A'''</span>, this button will be visible or not. If it is visible, by clicking on it, the number of clients to be added to the list will be indicated. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">G: </span>'''Once steps <span style="color: rgb(255, 0, 0);">'''A'''</span>, <span style="color: rgb(255, 0, 0);">'''B'''</span>, '''<span style="color: rgb(255, 0, 0);">C</span>''', <span style="color: rgb(255, 0, 0);">'''D'''</span> and '''<span style="color: rgb(255, 0, 0);">E</span>''' are completed, click on "[[Image:Button add plus.png]] Add to clients list" to add the clients meeting the edited criteria. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''NOTE:''' To see the new customized list onscreen, see the [[ProDon:Customized Lists#Viewing_.2F_Filtering_Customized_Lists|"Viewing/Filtering Customized Lists"]] section. | ||
+ | |||
|} | |} | ||
<br> | <br> | ||
− | {| | + | {| cellspacing="1" cellpadding="1" border="1" style="width: 455px; height: 382px;" class="wikitable" |
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | {{Anchor||chart}}After clicking on the [[Image:Button add plus.png]] button in order to create a new customized static list of clients, this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 008.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Name the new customized list. | ||
+ | |||
+ | '''NOTE:''' The name given here must be meaningful since this list will be saved for future consultation. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''It is not possible to modify the list type from this window. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''Click on "[[Image:Button Check mark Confirm.png]] Confirm addition" to add the customized list. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">D: </span>'''Click on "[[Image:Bouton annuler.png]] Cancel new record" to cancel the addition to the current customized list. | ||
+ | |||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on "[[Image:Button Check mark Confirm.png]] Confirm addition" or on "[[Image:Bouton annuler.png]] Cancel record", '''''ProDon''''' goes back to [[ProDon:Customized Lists#Static_List_.2F_Adding_a_New_List|this screen]]. Carry on with the instructions from point <span style="color: rgb(255, 0, 0);">'''D'''</span>. | ||
+ | |||
|} | |} | ||
Line 267: | Line 464: | ||
==== Static List / Modifying an Existing List (Add or remove clients) ==== | ==== Static List / Modifying an Existing List (Add or remove clients) ==== | ||
− | + | To modify an existing customized static list, go to the proper management (client management, analysis and history, etc.) in order to find the list to be modified, then prepare the [[ProDon:Customized Lists#Preparing_the_Active_List|active list]] of clients who have to be added or removed from the existing list. Once the active list is created, click on the [[Image:Bouton Listes personnalisees.png]] button, that is at the top of the window, then select "Static list". | |
+ | |||
+ | {| cellspacing="1" cellpadding="1" border="1" style="width: 516px; height: 819px;" class="wikitable" | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on "Static list", this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 009.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Select the desired option. For more details, see [[#staticA|point <span style="color: rgb(255, 0, 0);">'''A'''</span>]] of the [[ProDon:Customized Lists#Static_List_.28main_window.29|"Static list (main window)"]] section. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''Choose to check the box or not. For more details, see [[#staticB|point<span style="color: rgb(255, 0, 0);">''' B'''</span>]] of the [[ProDon:Customized Lists#Static_List_.28main_window.29|"Static list (main window)"]] section. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''Using the drop-down list, select the customized list in which the clients should be added or removed. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">D: </span>'''Click on this button to edit the criteria of the customized list chosen at <span style="color: rgb(255, 0, 0);">'''C'''</span>. For more details, see [[#staticE|point <span style="color: rgb(255, 0, 0);">'''E'''</span>]] of the [[ProDon:Customized Lists#Static_List_.28main_window.29|"Static list (main window)"]] section. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">E: </span>'''Depending on the selected option at <span style="color: rgb(255, 0, 0);">'''A'''</span>, this button will be visible or not. If it is visible, by clicking on it, the number of clients who will be added or removed from the list will be indicated. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">F: </span>'''To modify the customized list by adding clients, once steps <span style="color: rgb(255, 0, 0);">'''A'''</span>, '''<span style="color: rgb(255, 0, 0);">B</span>''', '''<span style="color: rgb(255, 0, 0);">C</span>''' and '''<span style="color: rgb(255, 0, 0);">D</span>''' are completed, click on "[[Image:Button add plus.png]] Add to the client list" to add the clients with the selected criteria in the list chosen at <span style="color: rgb(255, 0, 0);">'''C'''</span>. | ||
+ | |||
+ | '''CAUTION: '''The list will henceforth comprise the clients who were already part of the list '''AND''' the clients meeting the edited criteria. | ||
+ | |||
+ | <br> | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">G: </span>'''To modify the customized list by removing clients, once steps <span style="color: rgb(255, 0, 0);">'''A'''</span>, '''<span style="color: rgb(255, 0, 0);">B</span>''', '''<span style="color: rgb(255, 0, 0);">C</span>''' and <span style="color: rgb(255, 0, 0);">'''D'''</span> are completed, click on "[[Image:Button Minus remove delete.png]] Remove from the client list" to remove clients with the selected criteria of the list chosen at <span style="color: rgb(255, 0, 0);">'''C'''</span>. | ||
+ | |||
+ | '''CAUTION: '''The list will henceforth comprise the clients who were part of the list '''MINUS''' the clients meeting the edited criteria. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">H: </span>'''Allows you to empty the existing list chosen prior to adding the client(s) with the selected criteria, or being in the active list. | ||
+ | |||
+ | '''CAUTION: '''By clicking on <span style="color: rgb(255, 0, 0);">'''F'''</span>, this feature will erase the clients previously contained in this list and will modify it with the new corresponding client(s). | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">I: </span>'''Automatically displays onscreen the result of the modified list. | ||
+ | |||
+ | '''NOTE: '''It is strongly recommended to leave this box unchecked at all times not to lose the previous active list onscreen. To learn how to consult or see the customized lists onscreen again, see [[ProDon:Customized Lists#Viewing_.2F_Filtering_Customized_Lists|this section]]. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''NOTE: '''To learn how to consult or see the customized lists onscreen again, see the [[ProDon:Customized Lists#Viewing_.2F_Filtering_Customized_Lists|"Viewing/Filtering Customized Lists"]]. | ||
+ | |||
|} | |} | ||
Line 293: | Line 524: | ||
==== Static List / Renaming a List ==== | ==== Static List / Renaming a List ==== | ||
− | {| | + | To rename a customized static list, go to the proper management (client management, analysis and history, etc.) in order to find the list to be renamed, then click on the [[Image:Bouton Listes personnalisees.png]] button that is at the top of the window.<br> |
+ | |||
+ | {| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 518px; height: 582px;" | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on the [[Image:Bouton Listes personnalisees.png]] button, this window opens.<br> | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 010.png]]<br> |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Using the drop-down list, select the customized list to be renamed. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''After selecting the customized static list to be renamed, click on the [[Image:Button Edit.png]] button. | ||
+ | |||
|} | |} | ||
<br> | <br> | ||
− | {| | + | {| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 458px; height: 343px;" |
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on the [[Image:Button Edit.png]] button, this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 011.png]]<br> |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Enter the new name in the "Name" field. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''Click on the "[[Image:Button Check mark Confirm.png]] Confirm edit" button, then click on the "[[Image:Bouton annuler.png]] Close" in the next window. | ||
+ | |||
|} | |} | ||
<br> | <br> | ||
− | + | ==== Static List / Removing a List ==== | |
− | + | To delete a customized static list for good, go to the proper management (client management, analysis and history, etc.) in order to find the list to be removed, then click on the [[Image:Bouton Listes personnalisees.png]] button that is at the top of the window. | |
− | {| | + | {| cellspacing="1" cellpadding="1" border="1" style="width: 520px; height: 544px;" class="wikitable" |
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on the [[Image:Bouton Listes personnalisees.png]] button, this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 012.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Using the drop-down list, select the customized list to be deleted. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''After selecting the customized static list to be deleted, click on the [[Image:Button Minus remove delete.png]] button. | ||
+ | |||
|} | |} | ||
<br> | <br> | ||
− | {| | + | {| cellspacing="1" cellpadding="1" border="1" style="width: 456px; height: 343px;" class="wikitable" |
|- | |- | ||
| | | | ||
+ | After clicking on the [[Image:Button Minus remove delete.png]] button, this window opens. | ||
+ | |||
|- | |- | ||
− | | | + | | [[Image:Customized Lists 013.png]] |
|- | |- | ||
| | | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''To delete the list that is found in the "Name" field for good, click on the "[[Image:Button Check mark Confirm.png]] Confirm deletion", then click on the "[[Image:Bouton annuler.png]] Close" button of the next window. | ||
+ | |||
|} | |} | ||
− | <br> | + | <br> |
=== Dynamic List (main window) === | === Dynamic List (main window) === | ||
− | {| | + | A dynamic list, as opposed to a static list, keeps itself updated. Upon each viewing, all the clients it contains correspond exactly to the criteria specified in the creation of the list. Moreover, only the mailing or the gift criteria can be used for the dynamic lists. |
+ | |||
+ | '''NOTE: '''The dynamic lists are only available in the "Client management". | ||
+ | |||
+ | '''CAUTION: '''Contrary to static lists, dynamic lists '''are not''' based on the [[ProDon:Customized Lists#Preparing_the_Active_List|active list]] onscreen. The clients found during the configuration of a dynamic list are '''all the clients in the database''' meeting the edited criteria. | ||
+ | |||
+ | {| cellspacing="1" cellpadding="1" border="1" style="width: 567px; height: 418px;" class="wikitable" | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on the [[Image:Bouton Listes personnalisees.png]] button at the top of the "Client management" and selecting the option "Dynamic list", this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 014.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''These are all the existing dynamic lists in the database. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''The [[Image:Button add plus.png]], [[Image:Button Edit.png]] and [[Image:Button Minus remove delete.png]] buttons allow you to add, modify or remove a customized dynamic list. | ||
+ | |||
|} | |} | ||
Line 360: | Line 627: | ||
==== Dynamic List / Adding a New List ==== | ==== Dynamic List / Adding a New List ==== | ||
− | {| | + | To create a new customized dynamic list , go to the "Client management", click on the [[Image:Bouton Listes personnalisees.png]] button, that is at the top of the window, then select the "Dynamic list" option. |
+ | |||
+ | {| cellspacing="1" cellpadding="1" border="1" style="width: 565px; height: 396px;" class="wikitable" | ||
|- | |- | ||
| | | | ||
+ | After clicking on "Dynamic list", this window opens. | ||
+ | |||
|- | |- | ||
− | | | + | | [[Image:Customized Lists 015.png]] |
|- | |- | ||
| | | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''To create a new list, click on the [[Image:Button add plus.png]] button. | ||
+ | |||
|} | |} | ||
<br> | <br> | ||
− | {| | + | {| cellspacing="1" cellpadding="1" border="1" style="width: 502px; height: 401px;" class="wikitable" |
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on the [[Image:Button add plus.png]] button of the previous window, this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 016.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Name the new customized list. | ||
+ | |||
+ | '''NOTE: '''The name given here must be meaningful since this list will be saved for future consultation. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''It is not possible to modify the type of list from this window. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''By checking this box, the clients excluded from mass mailing and who meet the criteria will be added to the list. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">{{Anchor||dynamicD}}D: </span>'''Allows you to select the sub-type of customized list. | ||
+ | |||
+ | '''NOTE: '''There are only two choices with regards to dynamic lists: [[ProDon:Customized Lists#Gift_criteria|"Gift criteria"]] and [[ProDon:Customized Lists#Mailing_criteria|"Mailing criteria"]]. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">{{Anchor||dynamicE}}E: </span>'''Allows you to edit the criteria of the customized dynamic list. The criteria to be edited will change based on the chosen sub-type of customized dynamic list. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">F: </span>'''By clicking on the "[[Image:Button Check mark Confirm.png]] Confirm addition", clients meeting the criteria edited at <span style="color: rgb(255, 0, 0);">'''E'''</span> will be added to the list. | ||
+ | |||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | '''NOTE: '''To see the list onscreen, see the [[ProDon:Customized Lists#Viewing_.2F_Filtering_Customized_Lists|"Viewing/Filtering Customized Lists"]] section. | ||
+ | |||
|} | |} | ||
Line 393: | Line 686: | ||
==== Types of Customized Dynamic Lists ==== | ==== Types of Customized Dynamic Lists ==== | ||
− | + | There are two types of customized dynamic lists and each contains different criteria.<br> | |
− | {| width=" | + | Here are the two types:<br> |
+ | |||
+ | *[[ProDon:Customized Lists#Gift_criteria|Gift criteria]]<br> | ||
+ | *[[ProDon:Customized Lists#Mailing_criteria|Mailing criteria]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | ===== Gift criteria ===== | ||
+ | |||
+ | Allow you to include all the clients of the database who meet certain gift criteria.<br> | ||
+ | |||
+ | '''NOTE: '''Contrary to the static lists, in dynamic lists, the criteria are not based on the [[ProDon:Customized Lists#Preparing_the_Active_List|active list]], but rather on all clients in the database.<br> | ||
+ | |||
+ | {| width="651" cellspacing="1" cellpadding="1" border="1" class="wikitable" | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | This window opens after choosing the "Gift criteria" [[#dynamicD|at<span style="color: rgb(255, 0, 0);">''' D'''</span>]], then click on the "Edit criteria" [[#dynamicE|at '''<span style="color: rgb(255, 0, 0);">E</span>''']]. | ||
+ | |||
+ | In this window, you must select the desired options in order to target the clients based on their transaction history.<br> | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 017.png]]<br> |
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | '''CAUTION: '''All clients of the database meeting the criteria entered in this window will be found.<br> | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Allows you to base a search on a received amount of money.<br> | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''Allows you to base the search on an amount in relation to the receipts issued to clients. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''This option is not available in the first criterion. It allows you to target a variation in relation to the previous criterion. For instance, if $50 were entered, the clients who gave $50 more or less in a donation occasion in comparison with another donation occasion or in a year compared to another year will be found. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">D: </span>'''Allows you to define the number of instalments to reach the amount targeted at <span style="color: rgb(255, 0, 0);">'''A'''</span> and '''<span style="color: rgb(255, 0, 0);">B</span>'''. For instance, if the amounts indicated at <span style="color: rgb(255, 0, 0);">'''A'''</span> were $500 to $1,000 and a minimum of two transactions had been defined, a client who made three transactions of $200 would not be found. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">E: </span>'''Allows you to base a search on the higest transactions to reach the amount targeted at <span style="color: rgb(255, 0, 0);">'''A'''</span> or <span style="color: rgb(255, 0, 0);">'''B'''</span>. For instance, if the amounts indicated at <span style="color: rgb(255, 0, 0);">'''A'''</span> had been $500 to $1,000 and that only the two highest transactions of clients would have been considered, a client for whom the two highest transactions are $500 and $600 would not be found. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">F: </span>'''Allows you to define the date interval (according to [[ProDon:Period Management|periods]] created in '''''ProDon''''') in which the transactions must have been made. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">G: </span>'''Depending on the period selected at <span style="color: rgb(255, 0, 0);">'''F'''</span>, the dates will automatically be modified. It is also possible to define the dates manually, in this case, the <span style="color: rgb(255, 0, 0);">'''F'''</span> field becomes empty and '''''ProDon''''' will only consider the dates entered here. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">H: </span>'''Allows you to decide for which organization the transactions must be made. | ||
+ | |||
+ | '''NOTE: '''This option is available only if the [[ProDon:Multi-organization Module|Multi-organization Module]] is active. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">I: </span>'''Allows you to select the type of transaction between "Client", "Third-party client" or "Client and third-party client". | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">J: </span>'''Allows you to decide if the search should be based on all the transactions or if it needs to be based on particular donation occasions, campaigns or activities. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">K: </span>'''Allows you to include the commitments or not. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">L: </span>'''Allows you to base a search on [[ProDon:Origin Code Management|origin code(s)]]. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">M: </span>'''Depending on of the type of selection chosen at <span style="color: rgb(255, 0, 0);">'''J'''</span>, the buttons [[Image:Button funky check mark.png]] and [[Image:Button funky x.png]] and the boxes to the left of the buttons will be available or not. The [[Image:Button funky check mark.png]] button allows you to check all the boxes to the left of the buttons and the [[Image:Button funky x.png]] button allows you to uncheck them all. It is also possible to select one by one the donation occasions, activities or campaigns that must be considered in the search. In the example above, all the clients who gave at least $1 in one of these donation occasions will be found. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">N: </span>'''These four checkboxes allow you to choose the type of transactions to be included in the search. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">O: </span>'''The buttons "[[Image:Button add plus.png]] Add criterion" and "[[Image:Button Minus remove delete.png]] Delete criterion" allow you to add or remove a criterion. In this example, there are 2 criterias. The number of criteria is visible from the tabs at the upper-left of the window. When adding a criterion, you must go in the tab to configure criterion 2, 3, etc. To delete a criterion, select the tab of the criterion, then click on the "[[Image:Button Minus remove delete.png]] Delete criterion" button. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">P: </span>'''When all the criteria are selected, click on "[[Image:Button Check mark Confirm.png]] OK". | ||
+ | |||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | '''NOTE: '''For points <span style="color: rgb(255, 0, 0);">'''D '''</span>and <span style="color: rgb(255, 0, 0);">'''E'''</span>, the "0" indicates that the box must be ignored. Therefore, if "0" is entered at <span style="color: rgb(255, 0, 0);">'''D'''</span>, this field will not be considered. At <span style="color: rgb(255, 0, 0);">'''E'''</span>, for example, if the minimum is "2", but there is no maximum, you have to enter a maximum of "0" and if the maximum is "10", but there is no minimum, you have to enter a minimum of "0". | ||
+ | |||
|} | |} | ||
+ | |||
+ | <br> | ||
+ | |||
+ | After clicking on "[[Image:Button Check mark Confirm.png]] OK", '''''ProDon''''' will go back to the [[ProDon:Customized Lists#Dynamic_List_.28main_window.29|Customized list management]] screen. | ||
+ | |||
+ | To see the dynamic list onscreen, see the [[ProDon:Customized Lists#Viewing_.2F_Filtering_Customized_Lists|"Viewing/Filtering Customized Lists"]] section. | ||
<br> | <br> | ||
Line 434: | Line 788: | ||
===== Mailing criteria ===== | ===== Mailing criteria ===== | ||
− | {| | + | Allow you to include all the clients of the database who meet certain mailing criteria. |
+ | |||
+ | A list by mailing criteria mainly allows you to find the clients who have not responded following a mailing, in order to solicit them again. This type of list is also useful to find the clients who have responded positively, or to find the clients who have not received the mailing. | ||
+ | |||
+ | To use the customized list of the clients meeting certain mailing criteria, it is important that the mailing histories have been documented adequately in the database. To learn how to use the mailing history, see [[ProDon:Mailing History|this document]]. | ||
+ | |||
+ | '''NOTE: '''Contrary to the static lists, as far as the dynamic lists are concerned, the criteria are not based on the [[ProDon:Customized Lists#Preparing_the_Active_List|active list]], but rather on all the clients of the database.<br> | ||
+ | |||
+ | {| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 574px; height: 514px;" | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | This window appears after selecting "Mailing criteria" [[#dynamicD|at <span style="color: rgb(255, 0, 0);">'''D'''</span>]], then click on the "Edit criteria" button [[#dynamicE|at <span style="color: rgb(255, 0, 0);">'''E'''</span>]]. In this window, you must select the desired options in order to target the clients based on their mailing history. | ||
+ | |||
+ | |- | ||
+ | | colspan="2" | [[Image:Customized Lists 018.png]]<br> | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | '''CAUTION: '''All the clients of the database meeting the criteria entered in this window will be found. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Enter the date when the mailing was sent. If no date is to be considered for the search, simply leave this box empty. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''Select the organization for which the mailing has been sent. | ||
+ | |||
+ | '''NOTE: '''This option is available only if the [[ProDon:Multi-organization Module|Multi-organization Module]] is active in the database. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''Select the donation occasion for which the mailing has been sent. If no donation occasion is to be considered for the search, simply leave this box empty. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">D: </span>'''Select the activity for which the mailing has been sent. If no activity is to be considered for the search, simply leave this box empty. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">E: </span>'''Enter the canvasser for the mailing, if desired. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">F: </span>'''Choose the "response value" of the mailing history to be considered for the search in accordance with the [[ProDon:Mailing History#Configuration_of_Default_Responses_for_the_Mailing_History|configuration of the default responses]]. In this example, "No answer" means that I want to search the clients to whom I have sent a solicitation, but from whom I did not receive any response, so that I can send them another solicitation. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">G: </span>'''Enter the description of the mailing that has been sent, if desired. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">H: </span>'''Allows you to search the mailings for which no activity was specified. | ||
+ | |||
+ | '''NOTE: '''If <span style="color: rgb(255, 0, 0);">'''D'''</span> is empty and that this box is not checked, the mailings for which no activity had been specified and the mailings for which any activity had been specified will be found. If <span style="color: rgb(255, 0, 0);">'''D'''</span> is empty and that this box is checked, only the mailings with no activity specified will be found. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">I: </span>'''The reversed search allows you to find all the clients who '''do not meet''' '''all''' the entered criteria. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">J: </span>'''This option allows you to include, in addition to the clients meeting the edited criteria, all the clients with no mailings documented. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">K: </span>'''The buttons "[[Image:Button add plus.png]] Add criterion" and "[[Image:Button Minus remove delete.png]] Delete criterion" allow you to add or remove a criterion. In this example, there is only one criterion. The number of criteria is visible from the tabs in the upper-left of the window. By adding a criterion, you must go in the tab to configure criterion 2, 3, etc. To delete a criterion, select the criterion tab, then click on the "[[Image:Button Minus remove delete.png]] Delete criterion". | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">L: </span>'''When all the criteria are selected, click on "[[Image:Button Check mark Confirm.png]] OK". | ||
+ | |||
|} | |} | ||
+ | |||
+ | <br> | ||
+ | |||
+ | After clicking on "[[Image:Button Check mark Confirm.png]] OK", '''''ProDon''''' will go back to the [[ProDon:Customized Lists#Dynamic_List_.28main_window.29|Customized list management]] screen. | ||
+ | |||
+ | To see the list onscreen, see the [[ProDon:Customized Lists#Viewing_.2F_Filtering_Customized_Lists|"Viewing/Filtering Customized Lists"]] section. | ||
<br> | <br> | ||
Line 463: | Line 865: | ||
==== Dynamic List / Modifying Criteria from an Existing List ==== | ==== Dynamic List / Modifying Criteria from an Existing List ==== | ||
− | {| | + | To modify an existing customized dynamic list, go to the "Client management", click on the [[Image:Bouton Listes personnalisees.png]] at the top of the window, then select the "Dynamic list" option. |
+ | |||
+ | {| cellspacing="1" cellpadding="1" border="1" style="width: 564px; height: 417px;" class="wikitable" | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on "Dynamic lists", this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 019.png]]<br> |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Select the customized list to be modified. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''After selecting the customized dynamic list to be modified, click on the [[Image:Button Edit.png]] button. | ||
+ | |||
|} | |} | ||
<br> | <br> | ||
− | {| | + | {| cellspacing="1" cellpadding="1" border="1" style="width: 480px; height: 382px;" class="wikitable" |
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on the [[Image:Button Edit.png]] button, this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 020.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Click on the "Edit criteria" button to modify the [[ProDon:Customized Lists#Gift_criteria|gift criteria]] or the [[ProDon:Customized Lists#Mailing_criteria|mailing criteria]]. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''It is possible to check or uncheck the "Include clients excluded from mass mailing" box. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''It is possible to modify the sub-type of the customized dynamic list, and the criteria at <span style="color: rgb(255, 0, 0);">'''A'''</span>. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">D: </span>'''To save the new edited criteria, click on the "[[Image:Button Check mark Confirm.png]] Confirm edit" button. | ||
+ | |||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | '''NOTE: '''To see the modified list onscreen, see the [[ProDon:Customized Lists#Viewing_.2F_Filtering_Customized_Lists|"Viewing/Filtering Customized Lists"]] section. | ||
+ | |||
|} | |} | ||
Line 494: | Line 916: | ||
==== Dynamic List / Renaming a List ==== | ==== Dynamic List / Renaming a List ==== | ||
− | {| | + | To rename an existing customized dynamic list, go to "Client management", click on the [[Image:Bouton Listes personnalisees.png]] button at the top of the window, then click the "Dynamic lists" option. |
+ | |||
+ | {| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 566px; height: 417px;" | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on "Dynamic lists", this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 019.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Select the customized list to be renamed. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''After selecting the customized dynamic list to be renamed, click on the [[Image:Button Edit.png]] button. | ||
+ | |||
|} | |} | ||
<br> | <br> | ||
− | {| | + | {| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 468px; height: 362px;" |
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on the [[Image:Button Edit.png]] button, this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 022.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Enter the new name in the "Name" field. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''Click on the "[[Image:Button Check mark Confirm.png]] Confirm edit" button. | ||
+ | |||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | '''NOTE: '''To see the renamed list onscreen, see the [[ProDon:Customized Lists#Viewing_.2F_Filtering_Customized_Lists|"Viewing/Filtering Customized Lists"]] section. | ||
+ | |||
|} | |} | ||
Line 522: | Line 960: | ||
==== Dynamic List / Removing a List ==== | ==== Dynamic List / Removing a List ==== | ||
− | {| | + | To delete a customized dynamic list for good, go to the "Client management", click on the [[Image:Bouton Listes personnalisees.png]] button at the top of the window, then select the "Dynamic lists" option. |
+ | |||
+ | {| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 563px; height: 417px;" | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on "Dynamic lists", this window opens. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 021.png]]<br> |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Select the customized list to be deleted. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''After selecting the customized dynamic list to be deleted, click on the [[Image:Button Minus remove delete.png]] button. | ||
+ | |||
|} | |} | ||
<br> | <br> | ||
− | {| | + | {| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 466px; height: 343px;" |
|- | |- | ||
| | | | ||
+ | After clicking on the [[Image:Button Minus remove delete.png]] button, this window opens. | ||
+ | |||
|- | |- | ||
− | | | + | | [[Image:Customized Lists 024.png]] |
|- | |- | ||
| | | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''To delete the list that is in the "Name" field for good, click on the "[[Image:Button Check mark Confirm.png]] Confirm deletion" button. | ||
+ | |||
|} | |} | ||
− | + | <br> | |
+ | == Adding or Removing a Client from an Existing List (static or dynamic) from a Client File == | ||
+ | To add clients to the customized lists on a case by case basis, it is preferable and faster to do it from their client files. | ||
− | {| | + | {| cellspacing="1" cellpadding="1" border="1" style="width: 584px; height: 519px;" class="wikitable" |
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | Search the client to be added or removed from a list in the "Client management", then open his or her file. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 025.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''In the client file, go to the "7- Lists" tab, at the right of the window. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | <span style="color: rgb(255, 0, 0);">'''B:'''</span>'''<span style="color: rgb(255, 0, 0);"> </span>'''To see the static lists, select the "Static" tab, to view the dynamic lists, select the "Dynamic" tab. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''These are all the existing static and dynamic lists, depending on the selected tab. To add the client to a static list, simply check the name of the list in which he or she must be part. To remove him or her from a (static or dynamic) list, simply uncheck the box. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''NOTE: '''With regards to the dynamic lists, it is only possible to view the lists in which the client is registered. It is therefore not possible to add or remove the client from a dynamic list from here. | ||
+ | |||
|} | |} | ||
+ | <br> | ||
+ | == Viewing / Filtering Customized Lists == | ||
− | + | To view a customized list, you must apply a filter. | |
+ | First go to the proper management (client management, analysis and history, etc.) to find the list to be viewed.<br> | ||
− | + | {| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 611px; height: 385px;" | |
− | {| | ||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 026.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''First make sure that no search and no filter are currently applied. | ||
+ | |||
+ | '''NOTE: '''If the [[Image:Bouton efface.png]] buttons are shaded, it is because there is no search nor filter applied. If a search or a filter is ongoing, erase it by clicking on the [[Image:Bouton efface.png]] button. | ||
+ | |||
+ | <br> | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''After making sure that no search nor filter is applied, click on the [[Image:Button Filter.png]] button. | ||
+ | |||
|} | |} | ||
+ | <br> | ||
− | + | {| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 638px; height: 594px;" | |
− | {| | ||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | After clicking on the [[Image:Button Filter.png]] button, then select the "Temporary filter" option, this window opens. Go to the "Special" tab. | ||
+ | |||
|- | |- | ||
− | | colspan="2" | | + | | colspan="2" | [[Image:Customized Lists 027.png]] |
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">A: </span>'''Select either "Dynamic lists" or "Stactic lists", in accordance with the list to be generated. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">B: </span>'''Choose the static list to be generated by checking the box. | ||
+ | |||
|- | |- | ||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">C: </span>'''Click on the "[[Image:Button Check mark Confirm.png]] Add condition" button. | ||
+ | |||
| width="50%" | | | width="50%" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">D: </span>'''Click on the "[[Image:Button Check mark Confirm.png]] Apply" button. | ||
+ | |||
|- | |- | ||
| colspan="2" | | | colspan="2" | | ||
+ | '''<span style="color: rgb(255, 0, 0);">E: </span>'''It is possible to select many lists at <span style="color: rgb(255, 0, 0);">'''B'''</span> and to use the functions "Intersection (AND)", "Union (OR)" and/or "Reversed search" to combine the lists. To learn how to use these three functions, see the [[Common functions:Filter Data (Queries)#Intersection_.28AND.29_or_Union_.28OR.29|"Intersection (AND) / Union (OR)"]] section of the [[Common functions:Filter Data (Queries)|"Filter Data (Queries)"]] document. | ||
+ | |||
|} | |} | ||
+ | <br> | ||
+ | '''CAUTION: '''When a customized list is generated in "Analysis and history", all the "transactions" of the clients that are included in this list are found. For instance, if you isolate the transactions of "Golf Tournament 2012" by using the "Donation occasion" column, you could find 150 transactions, but for 125 clients. When all the clients of the active list are added to the customized list, 125 clients will be added and not 150 transactions. When viewing this list in "Analysis and history", the result would not be of 150 transactions, but rather all the transactions of the 125 clients of the list. If the same list is viewed in the "Client management", 125 clients would be found. | ||
+ | <br> | ||
− | + | {{Footer_ProDon_Version|4.6.6.5}}<br> | |
− | {{ |
Latest revision as of 13:28, 17 May 2019
Customized Lists |
Contents
- 1 Introduction
- 2 Preparing the Active List
- 3 Creating Customized Lists
- 3.1 Static List (main window)
- 3.1.1 Customized Static List Criteria
- 3.1.1.1 All clients in the active list
- 3.1.1.2 All third-party clients of the active list
- 3.1.1.3 All clients in the active list that meet certain donation criteria
- 3.1.1.4 All clients in the active list that meet certain mailing criteria
- 3.1.1.5 All potential duplicate clients in the active list
- 3.1.1.6 All clients linked to a client in the active list that meet certain link criteria
- 3.1.1.7 Only the selected client
- 3.1.2 Static List / Adding a New List
- 3.1.3 Static List / Modifying an Existing List (Add or remove clients)
- 3.1.4 Static List / Renaming a List
- 3.1.5 Static List / Removing a List
- 3.1.1 Customized Static List Criteria
- 3.2 Dynamic List (main window)
- 3.1 Static List (main window)
- 4 Adding or Removing a Client from an Existing List (static or dynamic) from a Client File
- 5 Viewing / Filtering Customized Lists
CAUTION : This document is for VERSION 5 of Prodon. To go to the document for version 4, click here.
WARNING : This document is currently being edited/revised, it is possible that some parts are missing or obsolete.
Introduction
The customized list tool allows you to create client lists. Once created, these clients lists are saved and can be viewed again at will. They can also be combined with one another and can be modified or deleted if desired. Although it is possible to create lists somewhere else than in the "Client management", they still are client lists.
The button allows you to create a customized list and can be found in the following ProDon managements:
- Client management
- Task and history management
- Analysis and history
- Receipts to be issued
- Documents to be issued
There are two types of customized lists: static lists and dynamic lists.
Static lists remain the same and always contain the same clients (e.g. a list of people who received a particular letter), whereas a dynamic list is automatically modified by ProDon each time a client meets the requested criteria (e.g. all the clients who gave $1,000 or more in a lifetime). To be noted that dynamic lists are only available in the "Client management".
Customized lists can be based on precise clients (e.g. all clients, potential duplicates, etc.) AND on different criteria as well. Therefore, a list is created with certain clients (or all clients) who meet certain criteria.
Preparing the Active List
As stated in the introduction, customized lists can be created from different ProDon managements. Although each management grid contains different elements (Client management = clients, Analysis and history = transactions, etc.), the outcome of a list will always be a client list.
It is possible to create a customized list from all the elements of a management grid or from a created list using a search or a filter in order to isolate certain clients or a precise transaction batch, etc.
Creating Customized Lists
After configuring the active list in the chosen management, click on the button that is at the top of the window, in order to edit the criteria of the customized list.
In the "Client management", two options are available: "Static lists" and "Dynamic lists". In all other managements, only the option "Static lists" is available, so no other choices are offered.
With the customized lists tool, it is possible to create, modify and remove lists. However, to be able to view them onscreen again or to combine lists together, see the "Viewing / Filtering Customized Lists" section.
Static List (main window)
Static lists remain the same and always contain the same clients. It is sometimes necessary that a list remains the same, for instance, people who received a particular letter for a specific occasion. This list has to be fixed and must not change.
After clicking on the button and selecting the "Static lists" option, this window opens. | |
A: These are the choices of clients who could be assigned to a customized static list. For more details, see this section. |
B: By checking this box, the clients excluded from mass mailing who meet the selected criteria will be added to the list. |
C: The buttons , and allow you to add a new list, to modify the name of a list or to remove a customized list. |
D: These are the lists that have already been created. By clicking on the drop-down menu, all existing customized lists are available. To modify an existing list, select it, then follow the instructions of the "Static list/Modifying an existing list (Add or remove clients)" section. |
E: Allows you to edit the criteria for the customized list. The criteria to be edited will change based on the chosen criterion of the customized static list. |
F: Depending on the choice selected at A, this button will be visible or not. If it is visible, by clicking on it, the number of clients, in accordance with the chosen criteria, will be indicated. |
G: Always considering the criteria selected at A, this button allows you to add to an existing list the clients of the active list shown onscreen, OR allows you to add to an existing list the clients of the active list meeting the criteria edited in E, OR allows you to add to a new list the clients from the active list meeting the selected criteria. |
H: Always considering the criteria selected at A, this button allows you to remove from an existing list the clients of the active list shown onscreen, OR allows you to remove from an existing list the clients of the active list meeting the criteria edited in E. |
I: Allows you to empty the chosen existing list before adding the client(s) with the selected criteria. CAUTION: By clicking on G, this feature will erase the clients previously contained in this list and will modify it with the new corresponding client(s). |
J: Automatically displays onscreen the result of the modified list. NOTE: It is strongly recommended to leave this checkbox unchecked at all times not to lose the previous active list onscreen. To learn how to view or revise the customized lists onscreen, see this section. |
Customized Static List Criteria
There are seven types of customized static lists and each type contains different criteria. Here they are:
- All clients in the active list
- All third-party clients of the active list
- All clients in the active list that meet certain donation criteria
- All clients in the active list that meet certain mailing criteria
- All potential duplicate clients in the active list
- All clients linked to a client in the active list that meet certain link criteria
- Only the selected client
All clients in the active list
Allows you to include all the clients who are currently in the active list.
This type of customized list is useful if all the clients to be added or removed from a list are already isolated in the active list.
After choosing "All clients in the active list" at A, determine what must be done by following the instructions in the main window "Static list (main window)".
All third-party clients of the active list
Only available in some tabs of "Analysis and history", it allows you to extract all third-party clients registered in the transactions of the active list.
After choosing "All clients in the active list" at A, determine what must be done by following the instructions of the main window "Static list (main window)".
All clients in the active list that meet certain donation criteria
Allows you to include the clients of the active list who meet certain donation criteria.
This window appears after selecting "All clients in the active list that meet certain donation criteria" at A determine what must be done at C, then click on the "Edit criteria" button at E. In this window, you must select the desired options in order to target clients in relation with a transaction history. | |
CAUTION: Only the clients who are part of the active list created earlier and who meet all the criteria entered in this window will be found. | |
A: Allows you to base your search on a received amount of money. |
B: Allows you to base your search on an amount in relation with the receipts issued to the clients. |
C: This option is not available in the first criterion. It allows you to target a variation in relation to the previous criterion. For instance, if $50 were entered, the clients who gave $50 more or less in a donation occasion in comparison to another donation occasion or in a year in comparison to another year would have been found. |
D: Allows you to specify the number of instalments in order to reach the amount targeted at A or at B. For instance, if the amounts indicated at A had been $500 to $1,000 and that a minimum of 1 transaction and a maximum of 2 transactions would have been defined, a client who made 3 transactions of $200 could not be found. |
E: Allows you to base your search on the highest transactions in order to reach the amount targeted at A or at B. For instance, if the amounts indicated at A had been $500 to $1,000 and that only the 2 highest transactions of the clients would be considered, a client for whom the 2 highest transactions were $500 and $600 would not be found. |
F: Allows you to define the date interval (according to the periods created in ProDon) in which the transactions must have been made. |
G: Depending on the period selected in F, the dates will be modified automatically. It is also possible to define the dates manually, in that event, the F field becomes empty and ProDon will refer to the dates entered here. |
H: Allows you to choose for which organization the transactions have been made. NOTE: This option is available only if the Multi-organization Module is active. |
I: Allows you to select the type of transaction among three choices "Client", "Third-party client" or "Client and third-party client". |
J: Allows you to decide whether the search should be based on all the transactions or if it should be based on particular donation occasions, campaigns or activities. |
K: Allows you to include or not the commitments. NOTE: This option is only available when the Prospecting and Commitments Module is activated. |
L: Allows you to base the search on origin codes. |
M: Depending on the type of selection chosen at J, the and buttons and the boxes on the left will be available or not. The button allows you to check all the boxes to the left of the buttons and the allows you to uncheck them all. It is also possible to select one by one the donation occasions, activities or campaigns that should be considered in the search. In the example above, all the clients who gave at least $1 in either donation occasions will be found. |
N: These 4 checkboxes allow you to choose the type of transactions to include in the search. |
O: The buttons " Add criterion" and " Delete criterion" allow you to add or delete a criterion. In this example, there are two criteria. The number of criteria is visible from the tabs in the upper-left of the window. When adding a criterion, you must go in the tab to configure criterion 2, 3, etc. To delete a criterion, select the tab of the criterion, then click on the " Delete criterion" button. |
|
NOTE: For points D and E, the "0" indicates that the box should not be considered. Therefore, if "0" is entered at D, this field will not be considered. At E, for instance, if the minimum is "2", but there is no maximum, you must enter "0" as maximum and if the maximum is "10" but there is no minimum, you must enter "0" as minimum. |
After clicking on " OK", ProDon will go back to the main menu screen. To pursue with the customized list, see points F, G, H, I and J of the "Static List (main window)" section.
All clients in the active list that meet certain mailing criteria
Allows you to include the clients of the active list who meet certain mailing criteria.
A list by mailing criterion mainly allows you to find all the clients who have not responded following a mailing, in order to solicit them again. This type of list is also useful to find the clients who responded positively, or to find the clients who have not received a mailing.
To use the customized list of the clients meeting certain mailing criteria, it is important that mailing histories have been adequately documented in the database. To learn how to use the mailing history, see this document.
This window opens after selecting "All clients in the active list that meet certain mailing criteria" at A, determine what must be done at C, then click on the "Edit criteria" button at E. In this window, you must select the desired options in order to target clients by mailing history report. | |
CAUTION: Only the clients who are part of the active list created earlier and meeting the criteria entered in this window will be found. | |
A: Enter the date when the mailing was done. If no date is to be considered for the search, simply leave this space blank. |
B: Select the organization for which the mailing was done. NOTE: This option is available only if the Multi-organization Module is active in the database. |
C: Select the donation occasion for which the maling was done. If no donation occasion is to be considered, simply leave this box empty. |
D: Select the activity for which the mailing was done. If no activity is to be considered for the search, simply leave this box empty. |
E: Enter the canvasser of the mailing, if desired. |
F: Select the "response value" of the mailing history to be considered for the search according to the configuration of default responses. In this example, "No answer" means that I want to search the clients to whom I have sent a solicitation, but from whom I did not get any response; all this with the purpose of sending a second mailing. |
G: Enter the description of the mailing that was sent, if desired. |
H: Allows you to search the mailings for which no activity has been specified. NOTE: If D is blank and that this box is not checked, the mailings for which no activity had been specified and the mailings for which any activity had been specified will be found. If D is blank and that this box is checked, only the mailings with no activity specified will be found. |
I: The reversed search allows you to find all the clients who do not meet all the entered criteria. |
J: This option allows you to include, in addition to the clients who meet the edited criteria, all the clients with no mailings documented. |
K: The buttons " Add criterion" and " Delete criterion" allow you to add or remove a criterion. In this example, there is only one criterion. The number of criteria is visible from the tabs at the upper-left of the window. When adding a criterion, you must go in the tab to configure criterion 2, 3, etc. To delete a criterion, select the tab of the criterion, then click on the " Delete criterion" button. |
After clicking on " OK", ProDon will go back to the main menu screen. To pursue with the customized list, see points F, G, H, I and J of the "Static List (main window)" section.
All potential duplicate clients in the active list
Allows you to find the clients who potentially appear more than once in the database of an active list.
There is a duplicate when there is more than one client file for the same client.
To learn how to use this type of customized list, see the "Searching and Eliminating Duplicates" procedure.
All clients linked to a client in the active list that meet certain link criteria
Allows you to include the clients of the active list corresponding to certain types of links/relations between client files.
A list by link/relation criteria is used to find all the clients linked to one of the clients of the active list. For example, if the active list consists of five client files of schools in which exist links to students, it would be possible to find all students from any of the five schools. Or, if the active list consists of all the students' client files of one school, in which exist the links to their parents, it would be possible to find all the students' parents of the school.
To use the type of customized list by link criterion, all the links/relations must have been documented in the database. To learn how to add contacts linked to client files, see the "Contacts and Links" document.
This window opens after selecting "All clients in the active list that meet certain link criteria" at A, determine what must be done at C, then click on the "Edit criteria" button at E. | |
A: Allows you to indicate the type of link to search. |
B: Allows you to use the link in both directions. In this example, the employees or employers linked to client files of the active list would be found. |
C: Allows you to add to the customized list, the clients of the active list, in addition to the clients meeting the entered criteria. |
D: Allows you to use the reverse link. In this example, the employees linked to the client files of the active list would be found rather than their employers. |
E: Indicates the result of the search of the link that will be found. |
|
NOTE: The statement at E changes, if the options at B or D are checked. |
After clicking on " OK", ProDon will go back to the main screen. To continue the customized list, see points F, G, H, I and J of the "Static List (main window)" section.
Only the selected client
Allows you to only include the client of the active list who is selected.
This type of customized list is useful if only one client has to be added or removed from an existing customized list, or if a new list to which it will be necessary to add clients one by one has to be created.
However, to add or remove clients individually, it is preferable to proceed directly from the client file.
To learn how to add or remove a client in a customized list from the client file, see this section.
Static List / Adding a New List
To create a new customized static list, go to the management proper to the type of list to be created (client management, analysis and history, etc.), then prepare the active list of the clients who must be in the new customized static list. Once the active list is created, click on the button, which is at the top of the window, then select "Static list".
After clicking on "Static list", this window opens. | |
A: Select the desired option. For more details, see point A of the "Static List (main window)" section. |
B: Choose to check the box or not. For more details, see point B of the "Static List (main window)" section. |
NOTE: A window opens, to learn how to fill it in, click here. |
D: After clicking on the " Confirm addition" of this window, the name of the new list is entered in that field. |
E: Click on this button to edit the criteria of the new customized list. For more details, see point E of the "Static List (main window)" section. |
F: Depending on the choice selected at A, this button will be visible or not. If it is visible, by clicking on it, the number of clients to be added to the list will be indicated. |
G: Once steps A, B, C, D and E are completed, click on " Add to clients list" to add the clients meeting the edited criteria. |
NOTE: To see the new customized list onscreen, see the "Viewing/Filtering Customized Lists" section. |
After clicking on the button in order to create a new customized static list of clients, this window opens. | |
A: Name the new customized list. NOTE: The name given here must be meaningful since this list will be saved for future consultation. |
B: It is not possible to modify the list type from this window. |
D: Click on " Cancel new record" to cancel the addition to the current customized list. | |
After clicking on " Confirm addition" or on " Cancel record", ProDon goes back to this screen. Carry on with the instructions from point D. |
Static List / Modifying an Existing List (Add or remove clients)
To modify an existing customized static list, go to the proper management (client management, analysis and history, etc.) in order to find the list to be modified, then prepare the active list of clients who have to be added or removed from the existing list. Once the active list is created, click on the button, that is at the top of the window, then select "Static list".
After clicking on "Static list", this window opens. | |
A: Select the desired option. For more details, see point A of the "Static list (main window)" section. |
B: Choose to check the box or not. For more details, see point B of the "Static list (main window)" section. |
C: Using the drop-down list, select the customized list in which the clients should be added or removed. |
D: Click on this button to edit the criteria of the customized list chosen at C. For more details, see point E of the "Static list (main window)" section. |
E: Depending on the selected option at A, this button will be visible or not. If it is visible, by clicking on it, the number of clients who will be added or removed from the list will be indicated. |
F: To modify the customized list by adding clients, once steps A, B, C and D are completed, click on " Add to the client list" to add the clients with the selected criteria in the list chosen at C. CAUTION: The list will henceforth comprise the clients who were already part of the list AND the clients meeting the edited criteria.
|
G: To modify the customized list by removing clients, once steps A, B, C and D are completed, click on " Remove from the client list" to remove clients with the selected criteria of the list chosen at C. CAUTION: The list will henceforth comprise the clients who were part of the list MINUS the clients meeting the edited criteria. |
H: Allows you to empty the existing list chosen prior to adding the client(s) with the selected criteria, or being in the active list. CAUTION: By clicking on F, this feature will erase the clients previously contained in this list and will modify it with the new corresponding client(s). |
I: Automatically displays onscreen the result of the modified list. NOTE: It is strongly recommended to leave this box unchecked at all times not to lose the previous active list onscreen. To learn how to consult or see the customized lists onscreen again, see this section. |
NOTE: To learn how to consult or see the customized lists onscreen again, see the "Viewing/Filtering Customized Lists". |
Static List / Renaming a List
To rename a customized static list, go to the proper management (client management, analysis and history, etc.) in order to find the list to be renamed, then click on the button that is at the top of the window.
| |
A: Using the drop-down list, select the customized list to be renamed. |
B: After selecting the customized static list to be renamed, click on the button. |
| |
A: Enter the new name in the "Name" field. |
B: Click on the " Confirm edit" button, then click on the " Close" in the next window. |
Static List / Removing a List
To delete a customized static list for good, go to the proper management (client management, analysis and history, etc.) in order to find the list to be removed, then click on the button that is at the top of the window.
A: Using the drop-down list, select the customized list to be deleted. |
B: After selecting the customized static list to be deleted, click on the button. |
A: To delete the list that is found in the "Name" field for good, click on the " Confirm deletion", then click on the " Close" button of the next window. |
Dynamic List (main window)
A dynamic list, as opposed to a static list, keeps itself updated. Upon each viewing, all the clients it contains correspond exactly to the criteria specified in the creation of the list. Moreover, only the mailing or the gift criteria can be used for the dynamic lists.
NOTE: The dynamic lists are only available in the "Client management".
CAUTION: Contrary to static lists, dynamic lists are not based on the active list onscreen. The clients found during the configuration of a dynamic list are all the clients in the database meeting the edited criteria.
Dynamic List / Adding a New List
To create a new customized dynamic list , go to the "Client management", click on the button, that is at the top of the window, then select the "Dynamic list" option.
After clicking on "Dynamic list", this window opens. |
After clicking on the button of the previous window, this window opens. | |
A: Name the new customized list. NOTE: The name given here must be meaningful since this list will be saved for future consultation. |
B: It is not possible to modify the type of list from this window. |
C: By checking this box, the clients excluded from mass mailing and who meet the criteria will be added to the list. |
D: Allows you to select the sub-type of customized list. NOTE: There are only two choices with regards to dynamic lists: "Gift criteria" and "Mailing criteria". |
E: Allows you to edit the criteria of the customized dynamic list. The criteria to be edited will change based on the chosen sub-type of customized dynamic list. |
F: By clicking on the " Confirm addition", clients meeting the criteria edited at E will be added to the list. |
NOTE: To see the list onscreen, see the "Viewing/Filtering Customized Lists" section. |
Types of Customized Dynamic Lists
There are two types of customized dynamic lists and each contains different criteria.
Here are the two types:
Gift criteria
Allow you to include all the clients of the database who meet certain gift criteria.
NOTE: Contrary to the static lists, in dynamic lists, the criteria are not based on the active list, but rather on all clients in the database.
This window opens after choosing the "Gift criteria" at D, then click on the "Edit criteria" at E. In this window, you must select the desired options in order to target the clients based on their transaction history. | |
| |
CAUTION: All clients of the database meeting the criteria entered in this window will be found. | |
A: Allows you to base a search on a received amount of money. |
B: Allows you to base the search on an amount in relation to the receipts issued to clients. |
C: This option is not available in the first criterion. It allows you to target a variation in relation to the previous criterion. For instance, if $50 were entered, the clients who gave $50 more or less in a donation occasion in comparison with another donation occasion or in a year compared to another year will be found. |
D: Allows you to define the number of instalments to reach the amount targeted at A and B. For instance, if the amounts indicated at A were $500 to $1,000 and a minimum of two transactions had been defined, a client who made three transactions of $200 would not be found. |
E: Allows you to base a search on the higest transactions to reach the amount targeted at A or B. For instance, if the amounts indicated at A had been $500 to $1,000 and that only the two highest transactions of clients would have been considered, a client for whom the two highest transactions are $500 and $600 would not be found. |
F: Allows you to define the date interval (according to periods created in ProDon) in which the transactions must have been made. |
G: Depending on the period selected at F, the dates will automatically be modified. It is also possible to define the dates manually, in this case, the F field becomes empty and ProDon will only consider the dates entered here. |
H: Allows you to decide for which organization the transactions must be made. NOTE: This option is available only if the Multi-organization Module is active. |
I: Allows you to select the type of transaction between "Client", "Third-party client" or "Client and third-party client". |
J: Allows you to decide if the search should be based on all the transactions or if it needs to be based on particular donation occasions, campaigns or activities. |
K: Allows you to include the commitments or not. |
L: Allows you to base a search on origin code(s). |
M: Depending on of the type of selection chosen at J, the buttons and and the boxes to the left of the buttons will be available or not. The button allows you to check all the boxes to the left of the buttons and the button allows you to uncheck them all. It is also possible to select one by one the donation occasions, activities or campaigns that must be considered in the search. In the example above, all the clients who gave at least $1 in one of these donation occasions will be found. |
N: These four checkboxes allow you to choose the type of transactions to be included in the search. |
O: The buttons " Add criterion" and " Delete criterion" allow you to add or remove a criterion. In this example, there are 2 criterias. The number of criteria is visible from the tabs at the upper-left of the window. When adding a criterion, you must go in the tab to configure criterion 2, 3, etc. To delete a criterion, select the tab of the criterion, then click on the " Delete criterion" button. |
|
NOTE: For points D and E, the "0" indicates that the box must be ignored. Therefore, if "0" is entered at D, this field will not be considered. At E, for example, if the minimum is "2", but there is no maximum, you have to enter a maximum of "0" and if the maximum is "10", but there is no minimum, you have to enter a minimum of "0". |
After clicking on " OK", ProDon will go back to the Customized list management screen.
To see the dynamic list onscreen, see the "Viewing/Filtering Customized Lists" section.
Mailing criteria
Allow you to include all the clients of the database who meet certain mailing criteria.
A list by mailing criteria mainly allows you to find the clients who have not responded following a mailing, in order to solicit them again. This type of list is also useful to find the clients who have responded positively, or to find the clients who have not received the mailing.
To use the customized list of the clients meeting certain mailing criteria, it is important that the mailing histories have been documented adequately in the database. To learn how to use the mailing history, see this document.
NOTE: Contrary to the static lists, as far as the dynamic lists are concerned, the criteria are not based on the active list, but rather on all the clients of the database.
This window appears after selecting "Mailing criteria" at D, then click on the "Edit criteria" button at E. In this window, you must select the desired options in order to target the clients based on their mailing history. | |
| |
CAUTION: All the clients of the database meeting the criteria entered in this window will be found. | |
A: Enter the date when the mailing was sent. If no date is to be considered for the search, simply leave this box empty. |
B: Select the organization for which the mailing has been sent. NOTE: This option is available only if the Multi-organization Module is active in the database. |
C: Select the donation occasion for which the mailing has been sent. If no donation occasion is to be considered for the search, simply leave this box empty. |
D: Select the activity for which the mailing has been sent. If no activity is to be considered for the search, simply leave this box empty. |
E: Enter the canvasser for the mailing, if desired. |
F: Choose the "response value" of the mailing history to be considered for the search in accordance with the configuration of the default responses. In this example, "No answer" means that I want to search the clients to whom I have sent a solicitation, but from whom I did not receive any response, so that I can send them another solicitation. |
G: Enter the description of the mailing that has been sent, if desired. |
H: Allows you to search the mailings for which no activity was specified. NOTE: If D is empty and that this box is not checked, the mailings for which no activity had been specified and the mailings for which any activity had been specified will be found. If D is empty and that this box is checked, only the mailings with no activity specified will be found. |
I: The reversed search allows you to find all the clients who do not meet all the entered criteria. |
J: This option allows you to include, in addition to the clients meeting the edited criteria, all the clients with no mailings documented. |
K: The buttons " Add criterion" and " Delete criterion" allow you to add or remove a criterion. In this example, there is only one criterion. The number of criteria is visible from the tabs in the upper-left of the window. By adding a criterion, you must go in the tab to configure criterion 2, 3, etc. To delete a criterion, select the criterion tab, then click on the " Delete criterion". |
After clicking on " OK", ProDon will go back to the Customized list management screen.
To see the list onscreen, see the "Viewing/Filtering Customized Lists" section.
Dynamic List / Modifying Criteria from an Existing List
To modify an existing customized dynamic list, go to the "Client management", click on the at the top of the window, then select the "Dynamic list" option.
After clicking on "Dynamic lists", this window opens. | |
| |
A: Select the customized list to be modified. |
B: After selecting the customized dynamic list to be modified, click on the button. |
A: Click on the "Edit criteria" button to modify the gift criteria or the mailing criteria. |
B: It is possible to check or uncheck the "Include clients excluded from mass mailing" box. |
C: It is possible to modify the sub-type of the customized dynamic list, and the criteria at A. |
D: To save the new edited criteria, click on the " Confirm edit" button. |
NOTE: To see the modified list onscreen, see the "Viewing/Filtering Customized Lists" section. |
Dynamic List / Renaming a List
To rename an existing customized dynamic list, go to "Client management", click on the button at the top of the window, then click the "Dynamic lists" option.
After clicking on "Dynamic lists", this window opens. | |
A: Select the customized list to be renamed. |
B: After selecting the customized dynamic list to be renamed, click on the button. |
A: Enter the new name in the "Name" field. |
|
NOTE: To see the renamed list onscreen, see the "Viewing/Filtering Customized Lists" section. |
Dynamic List / Removing a List
To delete a customized dynamic list for good, go to the "Client management", click on the button at the top of the window, then select the "Dynamic lists" option.
After clicking on "Dynamic lists", this window opens. | |
| |
A: Select the customized list to be deleted. |
B: After selecting the customized dynamic list to be deleted, click on the button. |
A: To delete the list that is in the "Name" field for good, click on the " Confirm deletion" button. |
Adding or Removing a Client from an Existing List (static or dynamic) from a Client File
To add clients to the customized lists on a case by case basis, it is preferable and faster to do it from their client files.
Viewing / Filtering Customized Lists
To view a customized list, you must apply a filter.
First go to the proper management (client management, analysis and history, etc.) to find the list to be viewed.
After clicking on the button, then select the "Temporary filter" option, this window opens. Go to the "Special" tab. | |
A: Select either "Dynamic lists" or "Stactic lists", in accordance with the list to be generated. |
B: Choose the static list to be generated by checking the box. |
E: It is possible to select many lists at B and to use the functions "Intersection (AND)", "Union (OR)" and/or "Reversed search" to combine the lists. To learn how to use these three functions, see the "Intersection (AND) / Union (OR)" section of the "Filter Data (Queries)" document. |
CAUTION: When a customized list is generated in "Analysis and history", all the "transactions" of the clients that are included in this list are found. For instance, if you isolate the transactions of "Golf Tournament 2012" by using the "Donation occasion" column, you could find 150 transactions, but for 125 clients. When all the clients of the active list are added to the customized list, 125 clients will be added and not 150 transactions. When viewing this list in "Analysis and history", the result would not be of 150 transactions, but rather all the transactions of the 125 clients of the list. If the same list is viewed in the "Client management", 125 clients would be found.
Document name: ProDon:Customized Lists
Version : 4.6.6.5