Last modified by Rayaan Ahmed on 2024/12/30 03:27
From version 20.1
edited by Rayaan Ahmed
on 2024/12/30 03:27
Change comment: There is no comment for this version
To version 10.1
edited by melanie@one-count_com
on 2016/12/14 13:10
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -List Wizard - Run Queries and Generate Lists
1 +List Wizard - Run Queries and Generate Lists (v12.x)
Parent
... ... @@ -1,1 +1,0 @@
1 -Lists and Reports
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.rayaan
1 +XWiki.melanie@one-count_com
Content
... ... @@ -1,54 +1,49 @@
1 1  {{layout}}
2 2  {{layout-section ac:type="two_right_sidebar"}}
3 3  {{layout-cell}}
4 +
5 +
4 4  {{id name="Start ScreenSteps Content"/}}
5 -With the List Wizard you can run from simple to the most complex counts and user lists, matching user demographic data with e-mail or web site response. You can view, export, and save demographic and product reports based upon the the counts/lists generated in the List Wizard.
7 + With the List Wizard you can run from simple to the most complex counts and user lists, matching user demographic data with e-mail or web site response. You can view, export, and save demographic and product reports based upon the the counts/lists generated in the List Wizard.
6 6  
7 7  The following lesson will provide instruction on using the List Wizard to generate counts and export lists.
8 8  
9 9  === OPEN THE LIST WIZARD MAIN WINDOW ===
10 10  
11 -**Select DATA MANAGEMENT from the main menu.**
13 +**Select LISTS AND REPORTS from the main menu.**
12 12  
15 +[[image:attach:media_1433865702013.png||align="center"]]
13 13  
14 -[[image:attach:Screen Shot 2021-10-09 at 4.33.36 PM (2) copy.png||thumbnail="true" height="250"]]
17 +
15 15  
16 16  **Select List Wizard from the sub-menu.**
17 17  
18 -[[image:attach:Screen Shot 2021-10-09 at 4.33.36 PM (2).png||thumbnail="true" height="250"]]
21 +[[image:attach:media_1433865752359.png||align="center"]]
19 19  
20 20  This will bring you to the List Wizard main window. (See below.)
21 21  
22 - [[image:attach:Screenshot.png||border="true" height="400" width="800"]]
25 +[[image:attach:media_1433865800325.png||align="center"]]
23 23  
24 24  === DEFINITIONS ===
25 25  
26 26  Definitions are in order that they appear in the List Wizard window. (See screenshot above.)
27 27  
28 -**View Saved Filters** - Queries may be saved for later/repeated use. The Saved Query button brings you to a list of all saved queries. (See screenshot below.)
31 +**Saved Query** - Queries may be saved for later/repeated use. The Saved Query button brings you to a list of all saved queries. (See screenshot below.)
29 29  
30 -**Users** - This is a running count of the number of users in a list at any time. This metric excludes any users who have been deleted in your ONEcount database.
33 +**Users** - This is a running count of the number of users in a list, so you can see how many users are in a list at any given point while applying filters.
31 31  
32 -**Known** - This is a running count of known users in the system.
33 -
34 34  **Applied Filters -** Filters that have been applied to generate a count/list will appear under the "Applied Filter" heading. In the screenshot above, no filters have been applied. Clicking on the "x" beside an applied filter allows you to clear or edit that individual filter. Clicking on "clear" will clear ALL filter selections.
35 35  
36 36  **Available Filters** - Filters are used to generate counts/lists based on selected criteria. Available Filters are:
37 37  
38 -**Package Selection**
39 -**Include in List-** Allows you to select users/subscribers based upon what packages they are subscribed to, have renewed, and/or unsubscribed from during a specific date range. These users will be included in the count/list. The selected date range will query on Request Date (Not Transaction Date). 
40 -**Exclude from List -** Further, allows you to filter out those users who subscribed, renewed, or unsubscribed from the same set of packages as selected in **Include in List** in a different date range. These users will not be included in the count/list.
41 -
42 -**Exclude Packages** - Allows you to filter out users/subscribers to a different set of packages than those selected in Package Selection during a specified date range. These users will not be included in the count/list. The selected date range will query on Request Date (Not Transaction Date).
43 -
44 -**Package Expiration** - Allows you to filter users/subscribers by expiration date for a specified package(s).
45 -
46 46  **Product Selection**
47 -**Include in List-** Allows you to select users/subscribers based upon what products they are subscribed to, and/or unsubscribed from during a specific date range. These users will be included in the count/list. The selected date range will query on Request Date (Not Transaction Date). 
40 + **Include in List-** Allows you to select users/subscribers based upon what products they are subscribed to, have renewed, and/or unsubscribed from during a specific date range. These users will be included in the count/list.
48 48  **Exclude from List -** Further, allows you to filter out those users who subscribed, renewed, or unsubscribed from the same set of products as selected in **Include in List** in a different date range. These users will not be included in the count/list.
49 49  
50 -**Exclude Products** - Allows you to filter out users/subscribers to a different set of products than those selected in Product Selection during a specified date range. These users will not be included in the count/list. The selected date range will query on Request Date (Not Transaction Date).
43 +**Exclude Products** - Allows you to filter out users/subscribers to a different set of products than those selected in Product Selection during a specified date range. These users will not be included in thecount/list.
51 51  
45 +**Product Expiration** - Allows you to filter users/subscribers by expiration date for a specified product(s).
46 +
52 52  **Demographics** - Allows you to filter users/subscribers by selecting certain demographic criteria. All of your database fields/questions are available for selection.
53 53  
54 54  **Source Codes** - Allows you to filter users/subscribers by Source Code. A Source Code is used to track the source of the name/transaction. When assigned to a form it's used to track the form a user/subscriber completed. On import, it can be used to track what list a user came from, or to show which e-mail campaign a user came from. (Further information about Source Codes can be found in Form Manager documentation.)
... ... @@ -57,26 +57,26 @@
57 57  
58 58  **Newsletter Activity** - Allows you to filter users/subscribers based on their newsletter activity. For example, you can filter users who have (or who have not) opened and/or clicked on a newsletter(s) campaign during a specified date range.
59 59  
60 -**Web Activity** - Allows you to filter users/subscribers based on web activity. For example, you can filter users who have viewed a specified web page or section of a site during a specified date range.
55 +**Web Acvity** - Allows you to filter users/subscribers based on web activity. For example, you can filter users who have viewed a specified web page or section of a site during a specified date range.
61 61  
62 62  **Ad Activity** - Allows you to filter users/subscribers based on banner views by advertiser. For example, you can filter users who have viewed an ad during a specified date range. Specific ads can be selected by advertiser.
63 63  
64 -**Saved Filters**
59 +==== Saved Query ====
65 65  
66 -[[image:attach:media_1433867081722.png||style="vertical-align:center"]]
61 +[[image:attach:media_1433867081722.png||align="center"]]
67 67  
68 -(% style="text-decoration:underline" %)**To run a saved query**(%%)**:**
63 +(% style="text-decoration: underline;" %)**To run a saved query**(%%)**:**
69 69  
70 70  * Expand the details by clicking on the "expand/hide" icon to the right of the saved query name. When you do so, the "Run Report" icon will appear, as shown above.
71 71  * **Be sure to change the dates to fit your desired date range. Start:** date defaults to one month prior to the current date and **End:** date defualts to the current date. ~*~*
72 72  * Click on the "Run Report" icon.
73 73  
74 -(% style="text-decoration:underline" %)**To delete a saved query**(%%)**:**
75 -Click on the "Delete" icon. You'll get a confirmation pop-up asking if you're sure you want to delete the query. Click "OK" to delete and "Cancel" to cancel deletion.
69 +(% style="text-decoration: underline;" %)**To delete a saved query**(%%)**:**
70 + Click on the "Delete" icon. You'll get a confirmation pop-up asking if you're sure you want to delete the query. Click "OK" to delete and "Cancel" to cancel deletion.
76 76  
77 77  === ESSENTIALS ===
78 78  
79 -**Each filter – Package Selection, Exclude Packages, Product Selection, Exclude Products, Demographics, Source Codes, E-Deliverability, Newsletter Activity, Web Activity, Ad Activity – can be applied independently of or in conjunction with the others.**
74 +**Each filter – Product Selection, Exclude Products, Demographics, Source Codes, E-Deliverability, Newsletter Activity, Web Activity, Ad Activity – can be applied independently of or in conjunction with the others.**
80 80  
81 81  If you change options in a filter, apply the filter then change the options without moving into another filter, it's considered an update to that filter and the user count will change based on that update.
82 82  
... ... @@ -92,27 +92,23 @@
92 92  
93 93  Details of each applied filter can be displayed by clicking on the button, i.e. clicking on "Product Selection" will display details of products selected.
94 94  
95 -**Filters may be used independently or in conjunction with other filters. Applying multiple filters will drill the list down based on the filters applied.**
90 +**Filters may be used independenty of or in conjunction with other filters. Applying multiple filters will drill the list down based on the filters applied.**
96 96  
97 97  === LIST ACTIONS ===
98 98  
99 -[[image:attach:media_1433866712415.png||style="vertical-align:center"]]
94 +[[image:attach:media_1433866712415.png||align="center"]]
100 100  
101 101  The list actions shown above are found at the top of the List Wizard window, directly below the list count .
102 102  
103 103  ~*~***Apply Filter** - Applies filters as they're selected/defined. **Must be selected each time a filter is defined,** e.g a product or demographic is selected. If you don't click on Apply Filter, the count won't change. You must click "Apply Filter" each time you define a new filter.
104 104  
105 -**Save** - Saves a list in the ONEcount system for later use. Saved lists are accessed and used to generate reports for audit or other purposes. Simply give the list a name, description, and select the fields you want to save in the list. If you are saving a list for a 3B audit report, you may want to include the number of Adds and Drops to be added to the 3B report when generated.
100 +**Save** - Saves a list in the ONEcount system for later use. Saved lists are accessed and used to generate reports for audit or other purposes. Simply give the list a name, description, and select the fields you want to save in the list. If you are saving a list for a 3B audit report, you may want to include the number of Adds and Drops to be added to the 3B report when generated.
106 106  Adds = the number of additions to the list in the audit period (Obtain the number by running a list of new subscribers for the audit period date range.)
107 -Drops = the number of drops from the list in the audit period (Obtain the number by running a list of unsubscribes for the audit period date range.)
108 -(See Audit Report documentation for more information on saving lists and generating audit reports.)
102 + Drops = the number of drops from the list in the audit period (Obtain the number by running a list of unsubscribes for the audit period date range.)
103 + (See Audit Report documentation for more information on saving lists and generating audit reports.)
109 109  
110 -**Download** - Allows you to download a list in Excel .csv format. You select the fields you wish to appear in the report (e.g. product status, source code, request date, transaction date, and demographic information – first name, last name, email, title, etc.). OCID (ONEcount User ID #) is automatically appended to downloaded lists. If a list doesn't include a product selection (e.g. a Web Activity or demographic selection only list) Product Status, Source Code, Request Date, Transaction Date aren't options in fields to download.  Whhen you click Download, a box pops up allowing you to select the fields that you would like put in your download file. Click the big box to add fields to the filter; remember that the order in which they appear in this box is the order the fields will be output in your file. All files are exported with the OCID of the user in the first column. This will help you if you later need to import the data back into ONEcount.
105 +**Download** - Allows you to download a list in Excel .csv format. You select the fields you wish to appear in the report (e.g. product status, source code, request date, transaction date, and demographic information – first name, last name, email, title, etc.). OCID (ONEcount User ID #) is automatically appended to downloaded lists. If a list doesn't include a product selection (e.g. a Web Activity or demographic selection only list) Product Status, Source Code, Request Date, Transaction Date aren't options in fields to download.
111 111  
112 -[[image:attach:lw-demo-field-select.png||thumbnail="true" width="300"]][[image:attach:lw-demo-template-select.png||thumbnail="true" width="300"]]
113 -
114 -//On the left, selecting the fields you would like in your download file. On the right, choosing a download template from a saved list.//
115 -
116 116  **View** - Allows you to create breakout reports by row or by row and column demographic and export them in Excel format. To generate the report, simply select the demographic you want for rows, and if you'd like a row and column breakout, select the column demographic as well. The report will generate in an expandable window where you can view and/or export to Excel format.
117 117  
118 118  **Bulk Operations** - Allows you to perform batch product changes, status changes, unsubscribes, subscribes, deletes, and merges on a list of records. (See User Operations > Bulk Operations documentation for further details)
... ... @@ -124,7 +124,7 @@
124 124  ==== Product Selection ====
125 125  
126 126  AND/OR Logic: When selecting products or demographics you can use AND logic or OR logic, or a combination of both through the "Joining Logic" drop-down. For example, you can generate a list of users who are subscribed to Product A //AND// Product B or who are subscribed to Product A //OR// Product B. Further, you can select users who are subscribed to Product A //AND// Product B //OR// Product C or a list of users who are subscribed to Product A //OR// Product B //AND// Product C. The AND/OR logic provides great flexibility in product selection for counts/lists.
127 -When generating a product list, the system looks at the user/subscriber's most recent subscription status (new, renew, or unsubscribed) for a product.
118 + When generating a product list, the system looks at the user/subscriber's most recent subscription status (new, renew, or unsubscribed) for a product.
128 128  
129 129  When generating a product count/list, if you don't specify the subscription status for the list (new, renew, unsubscribed) the system will pull users with any of the subscription statuses for the selected product(s) and date range. The subscription status is selected via the "Requested action" pulldown
130 130  
... ... @@ -134,37 +134,37 @@
134 134  
135 135  To generate a count/list of users who unsubscribed from a product(s) within a specified date range, select the product(s), set the start and end date of the date range, then "Unsubscribed". The generated count/list will include all users who are currently unsubscribed from the selected product(s). If their subscription status "Unsubscribed" as of the end date of the date range , they will be on the list. When selecting multiple products and using OR logic, the list will include users who have unsubscribed from ANY of the products (because they unsubscribed from Product A //OR// Product B //OR// Product C, etc,). If using AND logic, the list will include only users who are unsubscribed to ALL of the selected products as of the end date of the time range (because they unsubscribed from Product A //AND// Product B //AND// Product C, etc.). (Not all selected products are shown on the list, as it is a list of //users//, not products.)
136 136  
137 -(% style="color:#000000" %)In the screenshot below, the system will generate a count/list that will include those users/records subscribed to either the Bi-weekly Aviation Brief Newsletter OR the Aviator's Guide Qualified Print with a subscription status of "New" or "Renew" and a product status of "Current Sub" or "Qualified Non Paid", respectively, between 05/09/2012 and 06/09/2014.
128 +(% style="color: rgb(0,0,0);" %)In the screenshot below, the system will generate a count/list that will include those users/records subscribed to either the Bi-weekly Aviation Brief Newsletter OR the Aviator's Guide Qualified Print with a subscription status of "New" or "Renew" and a product status of "Current Sub" or "Qualified Non Paid", respectively, between 05/09/2012 and 06/09/2014.
138 138  
139 -(% style="color:#000000" %)Products may be moved between the AND logic and OR logic boxes by dragging and dropping.
130 +(% style="color: rgb(0,0,0);" %)Products may be moved between the AND logic and OR logic boxes by dragging and dropping.
140 140  
141 141  (% style="margin-left: 30.0px;" %)
142 142  ==== Include in List ====
143 143  
144 144  (% style="margin-left: 30.0px;" %)
145 -[[image:attach:media_1433874473732.png||style="vertical-align:center"]]
136 +[[image:attach:media_1433874473732.png||align="center"]]
146 146  
147 147  (% style="margin-left: 30.0px;" %)
148 -(% style="color:#000000" %)1) Select products by clicking on "Select from list..." to the right of "Please select product(s)/term(s):" This will generate a drop-down list of products/terms to choose from. Once product(s)/term(s) are selected, click on "And" or "Or" button. (%%)Selecting multiple products and clicking on AND will place them all in the AND Logic box. Selecting multiple products and clicking on OR will place them all in the OR box. If you select only one product, place it in the AND box. (% style="color:#000000" %)The left-hand selection box is for AND logic: If there are two products in this box, Product A and Product B, and New and Renew is selected for each, the system will search for new and renewal subscribers to Product A AND Product B. If selecting only one product, it should be placed in this box.
139 +(% style="color: rgb(0,0,0);" %)1) Select products by clicking on "Select from list..." to the right of "Please select product(s)/term(s):" This will generate a drop-down list of products/terms to choose from. Once product(s)/term(s) are selected, click on "And" or "Or" button. (%%)Selecting multiple products and clicking on AND will place them all in the AND Logic box. Selecting multiple products and clicking on OR will place them all in the OR box. If you select only one product, place it in the AND box. (% style="color: rgb(0,0,0);" %)The left-hand selection box is for AND logic: If there are two products in this box, Product A and Product B, and New and Renew is selected for each, the system will search for new and renewal subscribers to Product A AND Product B. If selecting only one product, it should be placed in this box.
149 149  
150 150  (% style="margin-left: 30.0px;" %)
151 151  2) Select the Subscription Status and Product Status for each product, as indicated in the screenshot above.
152 152  
153 153  (% style="margin-left: 30.0px;" %)
154 -(% style="color:#000000" %)3) Set joining logic to AND/OR (if using).(%%)
155 -(% style="color:#000000" %)The "AND" box and the "OR" box can be joined by using the drop-down between the two boxes. So, if the "AND" Box (top right) has Product A and Product B and the "OR" Box (bottom right) has Product C, and the drop-down menu is set to OR, the system will search for users subscribed to Product A AND Product B OR to Product C. (Be sure to set the joining logic in the drop-down menu between boxes to AND/OR.)
145 +(% style="color: rgb(0,0,0);" %)3) Set joining logic to AND/OR (if using).(%%)
146 + (% style="color: rgb(0,0,0);" %)The "AND" box and the "OR" box can be joined by using the drop-down between the two boxes. So, if the "AND" Box (top right) has Product A and Product B and the "OR" Box (bottom right) has Product C, and the drop-down menu is set to OR, the system will search for users subscribed to Product A AND Product B OR to Product C. (Be sure to set the joining logic in the drop-down menu between boxes to AND/OR.)
156 156  
157 157  (% style="margin-left: 30.0px;" %)
158 -(% style="color:#000000" %)4) Select the date range.
149 +(% style="color: rgb(0,0,0);" %)4) Select the date range.
159 159  
160 160  (% style="margin-left: 30.0px;" %)
161 -(% style="color:#000000" %)5) Apply Filter
152 +(% style="color: rgb(0,0,0);" %)5) Apply Filter
162 162  
163 163  (% style="margin-left: 30.0px;" %)
164 -(% style="color:#000000" %)When the filter is applied, the user count will change and the Product Selection filter will move under Applied Filters. (See count and applied filters highlighted in green. The Product Selection filter has been expanded in the screenshot. Clicking on the X will unapply the filter.)
155 +(% style="color: rgb(0,0,0);" %)When the filter is applied, the user count will change and the Product Selection filter will move under Applied Filters. (See count and applied filters highlighted in green. The Product Selection filter has been expanded in the screenshot. Clicking on the X will unapply the filter.)
165 165  
166 166  (% style="margin-left: 30.0px;" %)
167 -(% style="color:#000000" %)Note that when "**Include in List**" is expanded, **"Exclude from List**" is hidden and vice versa.
158 +(% style="color: rgb(0,0,0);" %)Note that when "**Include in List**" is expanded, **"Exclude from List**" is hidden and vice versa.
168 168  
169 169  (% style="margin-left: 30.0px;" %)
170 170  ==== Exclude from List ====
... ... @@ -179,19 +179,19 @@
179 179  While the interface looks slightly different, **Exclude from List** AND/OR logic functions in the same way as **Include in List**. Products can be moved into AND or OR boxes either by checking the checkbox and clicking "AND>>" or 'OR>>" or by dragging and dropping).
180 180  
181 181  (% style="margin-left: 30.0px;" %)
182 -[[image:attach:media_1433874807428.png||style="vertical-align:center"]]
173 +[[image:attach:media_1433874807428.png||align="center"]]
183 183  
184 184  (% style="margin-left: 30.0px;" %)
185 185  The screenshot below shows the process for setting the criteria to **Exclude from List** all users who unsubscribed from either product between 06/10/2014 and 06/09/2015.
186 186  
187 187  (% style="margin-left: 30.0px;" %)
188 -[[image:attach:media_1433875899581.png||style="vertical-align:center"]]
179 +[[image:attach:media_1433875899581.png||align="center"]]
189 189  
190 190  (% style="margin-left: 30.0px;" %)
191 191  1) Set different date range
192 -2) Select product(s) by moving into AND or OR boxes (either by checking the checkbox or dragging and dropping).
193 -3) Select subscription status and product status for each product. (Note that in the example above, the Print Subscription subscription status is set to "Unsubscribe" rather than "New, Renew".)
194 -4) Set joining logic.
183 + 2) Select product(s) by moving into AND or OR boxes (either by checking the checkbox or dragging and dropping).
184 + 3) Select subscription status and product status for each product. (Note that in the example above, the Print Subscription subscription status is set to "Unsubscribe" rather than "New, Renew".)
185 + 4) Set joining logic.
195 195  
196 196  ----
197 197  
... ... @@ -201,26 +201,28 @@
201 201  
202 202  ----
203 203  
195 +
204 204  
205 -==== Package Expire ====
197 +==== Product Expire ====
206 206  
207 -This filter allows you to select a package and date range that subscriptions expired/will expire within, i.e. you can select the package and date range and the system will include in the list all users subscribed to that package whose subscription will expire within that date range. You can also select to run a query of those users who are NOT subscribed to a package that will expire within a specified range.
199 +This filter allows you to select a product and date range that subscriptions expired/will expire within, i.e. you can select the product and date range and the system will include in the list all users subscribed to that product whose subscription will expire within that date range. You can also select to run a query of those users who are NOT subscribed to a product that will expire within a specified range.
208 208  
209 -To use the **Package Expire** filter:
210 -1) Select the package(s) from the drop-down list. (Image #1)
211 -2) Click the "Apply" button. (Image #1)
212 -This will move the package into the active package(s) box, as shown in Image #2.
201 +To use the **Product Expire** filter:
202 +1) Select the product(s) from the drop-down list. (Image #1)
203 + 2) Click the "Apply" button. (Image #1)
204 + This will move the product into the active product(s) box, as shown in Image #2.
213 213  
214 214  3) Select the expiration date range. (Image #2)
215 -4) Select "IN" or "NOT IN". (IN will pull in all users who ARE subscribed to the package and whose subscription will expire within the date range; NOT IN will pull in all users who are subscribed to the package but whose subscription will not expire within the date range.) (Image #2)
216 -5) Apply Filter. (Image #2)
207 + 4) Select "IN" or "NOT IN". (IN will pull in all users who ARE subscribed to the product and whose subscription will expire within the date range; NOT IN will pull in all users who are subscribed to the product but whose subscription will not expire within the date range.) (Image #2)
208 + 5) Apply Filter. (Image #2)
217 217  
218 -[[image:attach:media_1433881091602.png||style="vertical-align:center"]]
210 +[[image:attach:media_1433881091602.png||align="center"]]
219 219  
220 -[[image:attach:media_1433882546908.png||style="vertical-align:center"]]
212 +[[image:attach:media_1433882546908.png||align="center"]]
221 221  
222 222  ----
223 223  
216 +
224 224  
225 225  ==== Demographics ====
226 226  
... ... @@ -231,56 +231,46 @@
231 231  If you generate a count/list using only the Demographics filter (or it in combination with other filters that don't include a product selection) the Request Date and Product Status fields cannot be selected for inclusion in a download of the list . For example, you may wish to generate a count/list of all subscribers/users who are Certified Nurses and who live in the United States, without filtering them by what product they may or may not be subscribed to. In such a list, the Request Date and Product Status fields won't be available to include in the .csv download, as they relate directly to product subscribes/unsubscribes.
232 232  
233 233  In the screenshot below, the demographic filter will pull only those users who have a title of Avionics Tech or Maint. Specialists or Chief Mechanic or Maint. Manager or General Manager **OR** whose involvement in decisions to purchase products/services contains Purchase or Specify or Recommend or Approve. ~*~*
234 -**(If multiple responses are selected for one demographic question, e.g. in the example above (CONTAINS Avionics Tech, Maint. Specialists, Chief Mechanic, etc.) the responses themselves use OR logic, even if placed in the AND Logic box.**
227 + **(If multiple responses are selected for one demographic question, e.g. in the example above (CONTAINS Avionics Tech, Maint. Specialists, Chief Mechanic, etc.) the responses themselves use OR logic, even if placed in the AND Logic box.**
235 235  
236 -[[image:attach:media_1433883310734.png||style="vertical-align:center"]]
229 +[[image:attach:media_1433883310734.png||align="center"]]
237 237  
238 238  AND/OR Logic works the same way as it does in Product Selection.
239 -1) Select demographic question using the drop-down menu.
240 -2) Select operator/variable (CONTAINS, DOES NOT CONTAIN, IS, IS NOT, BEGINS WITH, ENDS WITH, IN, CONTAINS IN) using the drop-down menu.
241 -2) If a radio button-type, select-type, or checkbox-type question, select response(s) from the drop-down menu. (Clicking in the response field will bring up the list of possible response values.) Type in the response for text-type questions. Selecting multiple responses and clicking on AND will place them all in the AND Logic box. Selecting multiple responses and clicking on OR will place them all in the OR box. If selecting only one demographic, place it in the AND box. **Note that if multiple responses are selected for one demographic question, e.g. in the example above (CONTAINS Avionics Tech, Maint. Specialists, Chief Mechanic, etc.) the responses themselves use OR logic, even if placed in the AND Logic box.**
242 -
243 -* "**CONTAINS**" will do wild card search only the single value entered in the text box for "text-type questions". For radio button-type, select-type, or checkbox-type question, select the values from the drop down list.
244 -* (% style="letter-spacing:0.0px" %)**"DOES NOT CONTAIN" **(%%)will return all the records which doesn't contain the entered text or selected responses.
245 -* **"IS" **will search for the exact value entered in the text box and return those records.
246 -* "**IS NOT**" will return all the values in the system which are not matching the entered value.
247 -* "**BEGINS WITH**" will return all the records whose value begins with the entered text.
248 -* "**ENDS WITH**" will return all the records whose value ends with the entered text.
249 -* "**IN**" is for text-type questions and accept the values in comma separated format. It is search for the exact values entered and returns the matched records.
250 -* "**CONTAINS IN**" is for text-type questions and accept the values in comma separated format. It will do wild card search for each value entered in the database and returns the matched results.
251 -
232 + 1) Select demographic question using the drop-down menu.
233 + 2) Select operator/variable (CONTAINS, DOES NOT CONTAIN, IS, IS NOT) using the drop-down menu.
234 + 2) If a radio button-type, select-type, or checkbox-type question, select response(s) from the drop-down menu. (Clicking in the response field will bring up the list of possible response values.) Type in the response for text-type questions. Selecting multiple responses and clicking on AND will place them all in the AND Logic box. Selecting multiple responses and clicking on OR will place them all in the OR box. If selecting only one demographic, place it in the AND box. **Note that if multiple responses are selected for one demographic question, e.g. in the example above (CONTAINS Avionics Tech, Maint. Specialists, Chief Mechanic, etc.) the responses themselves use OR logic, even if placed in the AND Logic box.**
252 252  3) Set JOINING logic to AND/OR.
253 -4) Apply Filter.
236 + 4) Apply Filter.
254 254  
255 -(% style="color:#000000" %)When the filter is applied, the user count will change and the Demographics filter will move under Applied Filters. (See count and applied filters highlighted in green. Note that both filters have been expanded in the screenshot above. To hide, simply click on the title of the filter, e.g. "Product Selection" or "Demographics". (Clicking on the X will unapply the filter.)
238 +(% style="color: rgb(0,0,0);" %)When the filter is applied, the user count will change and the Demographics filter will move under Applied Filters. (See count and applied filters highlighted in green. Note that both filters have been expanded in the screenshot above. To hide, simply click on the title of the filter, e.g. "Product Selection" or "Demographics". (Clicking on the X will unapply the filter.)
256 256  
257 -(% style="text-decoration:underline" %)**Note regarding queries on blank fields**(%%):
258 -(% style="color:#000000" %)To get a count of all users who have NO information (a blank) in a designated demographic field:(%%)
259 -(% style="color:#000000" %)1) Select the demographic field using the drop-down menu.(%%)
260 -(% style="color:#000000" %)2) Select CONTAINS or IS from the operator drop-down menu. (%%)
261 -(% style="color:#000000" %)3) Leave the response blank, i.e. don't select a response.
240 +(% style="text-decoration: underline;" %)**Note regarding queries on blank fields**(%%):
241 + (% style="color: rgb(0,0,0);" %)To get a count of all users who have NO information (a blank) in a designated demographic field:(%%)
242 + (% style="color: rgb(0,0,0);" %)1) Select the demographic field using the drop-down menu.(%%)
243 + (% style="color: rgb(0,0,0);" %)2) Select CONTAINS or IS from the operator drop-down menu. (%%)
244 +(% style="color: rgb(0,0,0);" %)3) Leave the response blank, i.e. don't select a response.
262 262  
263 -(% style="color:#000000" %)To get a count of all users who have ANY response in a designated demographic field:(%%)
264 -(% style="color:#000000" %)1) Select the demographic field using the drop-down menu.(%%)
265 -(% style="color:#000000" %)2) Select IS NOT from the operator drop-down menu(%%)
266 -(% style="color:#000000" %)3) Leave the response blank, i.e. don't select a response.
246 +(% style="color: rgb(0,0,0);" %)To get a count of all users who have ANY response in a designated demographic field:(%%)
247 + (% style="color: rgb(0,0,0);" %)1) Select the demographic field using the drop-down menu.(%%)
248 + (% style="color: rgb(0,0,0);" %)2) Select IS NOT from the operator drop-down menu(%%)
249 + (% style="color: rgb(0,0,0);" %)3) Leave the response blank, i.e. don't select a response.
267 267  
268 268  ----
269 269  
270 -(% style="color:#000000" %)
253 +(% style="color: rgb(0,0,0);" %)
271 271  
272 272  ==== Source Codes ====
273 273  
274 -[[image:attach:media_1433963600153.png||style="vertical-align:center"]]
257 +[[image:attach:media_1433963600153.png||align="center"]]
275 275  
276 276  This filter allows you to include or exclude users based on source code(s). A source code is associated with a record when the code is assigned to an online form that the user/subscriber submits, assigned to an imported list, appended to a URL link, or appended to a smartlink in an email blast. (More detail on Source Codes can be found in the Form Manager section.) You can select to run a count/query based on users who have a specified source code(s) associated with their record or based on users who don't have a specified source code(s) associated with their record. Source Codes are selected the same way that products are selected (see above).
277 277  
278 278  To generate a count/query:
279 -1) Select Source Codes filter.
280 -2) Select the source code(s) fro mthe drop-down list. Clicking in the "Select from list..." field will bring up a drop-down menu of source codes.
281 -3) Click "Apply".
282 -4) Select "IN" or "NOT IN" from the drop-down. IN will generate a count/list of users who have a specified source code(s) associated with their record and NOT IN will generate a count/list of users who DO NOT have a specified source code associated with their record.
283 -5) Apply filter.
262 + 1) Select Source Codes filter.
263 + 2) Select the source code(s) fro mthe drop-down list. Clicking in the "Select from list..." field will bring up a drop-down menu of source codes.
264 + 3) Click "Apply".
265 + 4) Select "IN" or "NOT IN" from the drop-down. IN will generate a count/list of users who have a specified source code(s) associated with their record and NOT IN will generate a count/list of users who DO NOT have a specified source code associated with their record.
266 + 5) Apply filter.
284 284  
285 285  If you generate a count/list using only the Source Codes filter (or it in combination with other filters that don't include a product selection) the Request Date and Product Status fields cannot be selected for inclusion in a download of the list. For example, you may wish to generate a count/list of all subscribers/users who have a certain source code(s) associated with their record, without filtering them by what product they may or may not be subscribed to. In such a list, the Request Date and Product Status fields won't be available to include in the .csv download, as they relate directly to product subscribes/unsubscribes.
286 286  
... ... @@ -288,10 +288,11 @@
288 288  
289 289  ----
290 290  
274 +
291 291  
292 292  ==== E-Deliverability ====
293 293  
294 -[[image:attach:media_1433963855972.png||style="vertical-align:center"]]
278 +[[image:attach:media_1433963855972.png||align="center"]]
295 295  
296 296  This filter allows you to include or exclude users based on e-deliverability status: Get Unconfirmed, Get Blacklisted, Exclude Unconfirmed and Blacklisted.
297 297  
... ... @@ -299,30 +299,31 @@
299 299  
300 300  ----
301 301  
286 +
302 302  
303 303  ==== Newsletter Activity ====
304 304  
305 305  The Newsletter Activity filter allows you to filter counts/lists based on user views and/or opens of specified newsletter campaigns. You can select one or multiple newsletter lists and one or multiple campaigns during a specified date range and get a count of users who opened the campaign(s) and/or clicked on a link. (More specific information on exactly what links were clicked on can be obtained using the Newsletter Analytics in the **Analytics** module. )
306 306  
307 -[[image:attach:media_1433963906337.png||style="vertical-align:center"]]
292 +[[image:attach:media_1433963906337.png||align="center"]]
308 308  
309 -(% style="color:#000000" %)1) Select the date range.(%%)
310 -(% style="color:#000000" %)2) Use the drop-down menu of e-newsletters to select a newsletter(s) – click where it says "Choose Lists" to bring up the drop-down menu – then click "Get campaigns" button. This will load a list of all newsletter campaigns sent during the specified date range.(%%)
311 -(% style="color:#000000" %)3) Select the OpenOptions (Opened or Not Opened) (%%)
312 -(% style="color:#000000" %)4) Select the joining logic AND or OR. (%%)
313 -(% style="color:#000000" %)5) Select Click Options (Clicked, Not Clicked, or neither).(%%)
314 -6) Select the newsletter campaigns you wish to filter by.
315 -6) Click Apply Filter.
294 +(% style="color: rgb(0,0,0);" %)1) Select the date range.(%%)
295 + (% style="color: rgb(0,0,0);" %)2) Use the drop-down menu of e-newsletters to select a newsletter(s) – click where it says "Choose Lists" to bring up the drop-down menu – then click "Get campaigns" button. This will load a list of all newsletter campaigns sent during the specified date range.(%%)
296 + (% style="color: rgb(0,0,0);" %)3) Select the OpenOptions (Opened or Not Opened) (%%)
297 +(% style="color: rgb(0,0,0);" %)4) Select the joining logic AND or OR. (%%)
298 +(% style="color: rgb(0,0,0);" %)5) Select Click Options (Clicked, Not Clicked, or neither).(%%)
299 + 6) Select the newsletter campaigns you wish to filter by.
300 + 6) Click Apply Filter.
316 316  
317 -(% style="color:#000000" %)When the filter is applied, the user count will change and the Newsletter Activity filter will move under Applied Filters. (See count and applied filters highlighted in green. Clicking on the X beside the filter name, e.g. Newsletter Activity, will unapply the filter.)
302 +(% style="color: rgb(0,0,0);" %)When the filter is applied, the user count will change and the Newsletter Activity filter will move under Applied Filters. (See count and applied filters highlighted in green. Clicking on the X beside the filter name, e.g. Newsletter Activity, will unapply the filter.)
318 318  
319 -(% style="color:#000000" %)The screenshot below shows the count for users who have Opened AND Clicked on Campaigns #2810, #2707, #2611, or #2279 in Daily Aviation News or Daily Aviation Brief newsletters during the date range of 02/01/2015 - 02/14/2015.
304 +(% style="color: rgb(0,0,0);" %)The screenshot below shows the count for users who have Opened AND Clicked on Campaigns #2810, #2707, #2611, or #2279 in Daily Aviation News or Daily Aviation Brief newsletters during the date range of 02/01/2015 - 02/14/2015.
320 320  
321 -[[image:attach:media_1433964371712.png||style="vertical-align:center"]]
306 +[[image:attach:media_1433964371712.png||align="center"]]
322 322  
323 323  ----
324 324  
325 -NOTE: The campaign list appear only on the selected date. Which is identified by campaign sent date when Get campaign button is clicked.
310 +
326 326  
327 327  ==== Web Activity ====
328 328  
... ... @@ -330,22 +330,22 @@
330 330  
331 331  In the screenshot below, the system has filtered all users who visited "... .com/md-iq-quizzes.html OR "... .com/md-iq-quizzes.html. These are the pages with the MD-IQ Quizzes on the respective website. (Note that "... .com/md-iq-quizzes.html" is in the "Section:" box, indicating that it hasn't yet been selected by clicking on either "And" or "Or".)
332 332  
333 -[[image:attach:media_1433965068319.png||style="vertical-align:center"]]
318 +[[image:attach:media_1433965068319.png||align="center"]]
334 334  
335 335  1) Select the date range.
336 -2) Enter the path of the section of the site and click on "And" or "Or". Clicking on "And" will place the path in the AND Logic box. Entering the path to additional section(s) and clicking on "Or" will place them in the OR box. If selecting only one section, click on "And" to place in the AND box.
337 -3) Set JOINING logic to AND/OR.
338 -4) Apply Filter.
321 + 2) Enter the path of the section of the site and click on "And" or "Or". Clicking on "And" will place the path in the AND Logic box. Entering the path to additional section(s) and clicking on "Or" will place them in the OR box. If selecting only one section, click on "And" to place in the AND box.
322 + 3) Set JOINING logic to AND/OR.
323 + 4) Apply Filter.
339 339  
340 340  For a protected section, you only need to enter the part of the URL that every page in that section has in common. For example, if you enter /views in the "Section:" field, the system will generate statistics for every page that has "/views" as part of its URL.
341 341  
342 342  Note: entering a period (.) in the "Section:" text box will pull data for ALL resources, including ALL protected web pages.
343 343  
344 -(% style="color:#000000" %)When the filter is applied, the user count will change and the Web Activity filter will move under Applied Filters. (See count and applied filters highlighted in green. Note that the Web Activity filter hasn't been expanded in the screenshot above. To expand, simply click on the filter button. Clicking on the X will unapply the filter.)
329 +(% style="color: rgb(0,0,0);" %)When the filter is applied, the user count will change and the Web Activity filter will move under Applied Filters. (See count and applied filters highlighted in green. Note that the Web Activity filter hasn't been expanded in the screenshot above. To expand, simply click on the filter button. Clicking on the X will unapply the filter.)
345 345  
346 346  ----
347 347  
348 -(% style="color:#000000" %)
333 +(% style="color: rgb(0,0,0);" %)
349 349  
350 350  ==== Ad Activity ====
351 351  
... ... @@ -353,35 +353,27 @@
353 353  
354 354  In the screenshot below, the count is showing the number of users own, operate, or lease specified types of aircraft and who have viewed banner ads #1000000000 and #10000000002 from Cirrus Design Corp and Cessna, respectively.
355 355  
356 -[[image:attach:media_1434036518846.png||style="vertical-align:center"]]
341 +[[image:attach:media_1434036518846.png||align="center"]]
357 357  
358 358  1) Set the date range.
359 -2) Select the Advertiser(s) from the drop-down menu – (% style="color:#000000" %)click where it says "Choose Advertiser(s)" to bring up the drop-down menu – (%%)then click "Get Banners". This will generate a list of banner ads run by that advertiser in the specified date range.
360 -3) Select the banner ads you wish to filter by.
361 -4) Apply Filter.
344 + 2) Select the Advertiser(s) from the drop-down menu – (% style="color: rgb(0,0,0);" %)click where it says "Choose Advertiser(s)" to bring up the drop-down menu – (%%)then click "Get Banners". This will generate a list of banner ads run by that advertiser in the specified date range.
345 + 3) Select the banner ads you wish to filter by.
346 + 4) Apply Filter.
362 362  
363 -(% style="color:#000000" %)When the filter is applied, the user count will change and the Ad Activity filter will move under Applied Filters. (See count and applied filters highlighted in green. Note that the applied Web Activity filter has been expanded in the screenshot above, showing the advertiser and selected banner ads. Clicking on the X will unapply the filter.)
348 +(% style="color: rgb(0,0,0);" %)When the filter is applied, the user count will change and the Ad Activity filter will move under Applied Filters. (See count and applied filters highlighted in green. Note that the applied Web Activity filter has been expanded in the screenshot above, showing the advertiser and selected banner ads. Clicking on the X will unapply the filter.)
364 364  
350 +(% style="color: rgb(200,0,0);" %)//**IMPORTANT NOTE 1:**//
365 365  
366 -(% style="color:#000000" %)**AND/OR Logic between Filters:**
367 -
368 -(% style="color:#000000" %)In between the filters, AND/OR logic can be applied. The default is AND which does a AND operation between the applied filters. For OR operation, toggle button has to be clicked.
369 -
370 - [[image:attach:Screen Shot 2020-05-11 at 12.57.36 PM.png||height="400"]]
371 -
372 -
373 -(% style="color:#c80000" %)//**IMPORTANT NOTE 1:**//
374 -
375 375  _**In order to identify users and track activity, widgets must be embedded on every page of your web site .** _
376 -//**These widgets, specific to your site(s), and directions for placement are provided in the Widget Builder**//_**.** _
353 + //**These widgets, specific to your site(s), and directions for placement are provided in the Widget Builder**//_**.** _
377 377  
378 378  //**See Widget Implementation** ~_~_**documentation for more detail on widgets.**//
379 -//**See Smartlinks and Other Form Linkouts**//_ **documentation for more detail on Smartlinks.**_
356 + //**See Smartlinks and Other Form Linkouts**//_ **documentation for more detail on Smartlinks.**_
380 380  
381 -(% style="color:#c80000" %)//**IMPORTANT NOTE 2:**//
358 +(% style="color: rgb(200,0,0);" %)//**IMPORTANT NOTE 2:**//
382 382  
383 383  _**If using the ONEcount Email Engine, deleting a user subscribed to an email/newsletter list(s) deletes the user in the ONEcount database and removes the user from the list in the Email Engine.** _
384 -//**Historical statistics for deleted users (e.g. opens, clicks) are retained in the database, so when running newsletter statistics those historical actions will remain in the counts. If users have been deleted, those users who have been deleted are no longer known to the system, so although their past actions (clicks, opens) will be included in analytics counts, the user won't be included in the List Wizard known user count.**//
361 + //**Historical statistics for deleted users (e.g. opens, clicks) are retained in the database, so when running newsletter statistics those historical actions will remain in the counts. If users have been deleted, those users who have been deleted are no longer known to the system, so although their past actions (clicks, opens) will be included in analytics counts, the user won't be included in the List Wizard known user count.**//
385 385  
386 386  //**If using MagnetMail , ExactTarget, Silverpop, connected to ONEcount via API, deleting a user subscribed to an email/newsltter list(s) will delete the user in ONEcount and automatically move the user to a suppression list in your ESP.**//
387 387  
... ... @@ -392,28 +392,33 @@
392 392  
393 393  {{layout-cell}}
394 394  {{panel title="Search All Documentation:"}}
372 +
373 +
395 395  {{livesearch/}}
396 396  {{/panel}}
397 397  
398 398  {{panel title="Search LISTS AND REPORTS Documentation"}}
378 +
379 +
399 399  {{pagetreesearch rootPage="Lists and Reports"/}}
400 400  {{/panel}}
401 401  
402 402  {{panel title="On this page:"}}
384 +
385 +
403 403  {{toc/}}
404 404  {{/panel}}
405 405  
406 406  {{panel title="More LISTS AND REPORTS"}}
407 -{{expand title="Click here to expand..."}}
390 +{{expand}}
408 408  (% style="margin-left: 30.0px;" %)
409 -
410 410  
411 411  
412 412  (% style="margin-left: 30.0px;" %)
413 -[[doc:Saved Lists]]
395 +[[Saved Lists>>doc:Saved Lists (v12\.x)]]
414 414  
415 415  (% style="margin-left: 30.0px;" %)
416 -[[Transaction Summary Report>>doc:Run a Transaction Summary Report]]
398 +[[Transaction Summary Report>>doc:Run a Transaction Summary Report (v12\.x)]]
417 417  
418 418  (% style="margin-left: 30.0px;" %)
419 419  Audit Reports
... ... @@ -422,6 +422,7 @@
422 422  {{/expand}}
423 423  {{/panel}}
424 424  
407 +
425 425  
426 426  
427 427  {{/layout-cell}}
Screen Shot 2020-05-11 at 12.00.04 PM.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -104.7 KB
Content
Screen Shot 2020-05-11 at 12.57.36 PM.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -218.5 KB
Content
Screen Shot 2021-10-09 at 4.33.36 PM (2) copy.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -15.2 KB
Content
Screen Shot 2021-10-09 at 4.33.36 PM (2).png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -16.0 KB
Content
Screenshot.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -467.2 KB
Content
lw-demo-field-select.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -97.5 KB
Content
lw-demo-template-select.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -66.9 KB
Content
media_1433865702013.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -26.4 KB
Content
media_1433865752359.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -27.7 KB
Content
media_1433865800325.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -56.1 KB
Content
media_1433866712415.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -6.0 KB
Content
media_1433867081722.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -91.5 KB
Content
media_1433874473732.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -110.4 KB
Content
media_1433874807428.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -52.8 KB
Content
media_1433875899581.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -52.4 KB
Content
media_1433881091602.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -70.5 KB
Content
media_1433882546908.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -67.1 KB
Content
media_1433883310734.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -109.5 KB
Content
media_1433963600153.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -48.6 KB
Content
media_1433963855972.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -42.8 KB
Content
media_1433963906337.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -70.7 KB
Content
media_1433964371712.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -120.5 KB
Content
media_1433965068319.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -65.0 KB
Content
media_1434036518846.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -73.2 KB
Content
Confluence.Code.ConfluencePageClass[0]
id
... ... @@ -1,1 +1,1 @@
1 -67044
1 +67509
url
... ... @@ -1,1 +1,1 @@
1 -https://info.onecount.net//wiki/spaces/OD/pages/67044/List Wizard - Run Queries and Generate Lists
1 +https://info.onecount.net//wiki/spaces/OD/pages/67509/List Wizard - Run Queries and Generate Lists (v12.x)