Wiki source code of Bulk Operation - How to Perform a Batch Delete
Last modified by caterina on 2022/02/04 14:55
Show last authors
author | version | line-number | content |
---|---|---|---|
1 | {{layout}} | ||
2 | {{layout-section ac:type="two_right_sidebar"}} | ||
3 | {{layout-cell}} | ||
4 | |||
5 | |||
6 | {{id name="Start ScreenSteps Content"/}} | ||
7 | This lesson describes how to use the Bulk Operation tool in the USER OPERATIONS module to apply a batch delete of user records. Performing a batch delete will remove the records from the ONEcount database. | ||
8 | |||
9 | Please refer to the Quick Start Guide - User Operations for important information about basic concepts and rules relating to imports and bulk operations. | ||
10 | |||
11 | === IMPORTANT NOTE RE: STATISTICS, NEWSLETTER LISTS, AND DELETED USERS === | ||
12 | |||
13 | When users are deleted from the database, their historical web, banner, and newsletter statistics are retained; however, because the user is no longer "Known" (as they're no longer in the database), their statistics will be counted as "Unknown" when running web and banner analytics. | ||
14 | |||
15 | If using the ONEcount Email Engine, deleting a user subscribed to an email/newsletter list(s) will delete the user in the ONEcount database and remove the user from the list in the Email Engine. | ||
16 | |||
17 | If using MagnetMail or Silverpop, connected to ONEcount via API, deleting a user subscribed to an email/newsltter list(s) will delete the user in ONEcount and move the user to a suppression list in MagnetMail or Silverpop. | ||
18 | |||
19 | Historical newsletter statistics for deleted users (e.g. opens, clicks) will be retained in the database, so when running newsletter statistics those historical actions will remain in the counts. It's important to note, however, that if you click on, e.g. the open count for a particular campaign in newsletter statistics, you will be brought to the List Wizard where the list of users can be saved, downloaded, or filtered further. The total number of users will be displayed in the List Wizard, and this number may be lower than the number displayed in the open count in the Newsletter Analytics detail because in the List Wizard the system only displays counts for Known users. Those users who have been deleted are no longer known to the system, so they won't be included in the List Wizard count. | ||
20 | |||
21 | === OPENING THE BULK OPERATION WINDOW === | ||
22 | |||
23 | === Select DATA MANAGEMENT from the Main Menu. === | ||
24 | |||
25 | [[image:attach:Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 3.png||thumbnail="true" height="250"]] | ||
26 | |||
27 | === Select "BULK OPERATIONS" from the DATA MANAGEMENT sub-menu. === | ||
28 | |||
29 | [[image:attach:Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 6.png||thumbnail="true" height="250"]] | ||
30 | |||
31 | This will open the Bulk Operation main window, as shown below. | ||
32 | |||
33 | === Bulk Operation Main Window === | ||
34 | |||
35 | [[image:attach:media_1443645187323.png||align="center"]] | ||
36 | |||
37 | (% style="color: rgb(0,0,0);" %)**1** - (%%)Copy and paste a delimiter separated list of ONEcount IDs. | ||
38 | |||
39 | (% style="color: rgb(0,0,0);" %)**2 **-(%%) Select the bulk operation: Status Change will change the status of ocids entered in Box 1, Product Change will change the product all ocids entered in Box 1 are assigned to, Unsubscribe/Kills will unsubscribe all ocids entered in Box 1 from a designated product, Subscribe will subscribe all ocids entered in Box 1 to a designated product, Delete will delete all ocids entered in Box 1, and Merge will merge ocids enterd in Box 1. | ||
40 | |||
41 | (% style="color: rgb(0,0,0);" %)**3** - (%%)Select the delimiter used in the list of ONEcount IDs (Box 1). | ||
42 | |||
43 | (% style="color: rgb(0,0,0);" %)**4** - (%%)Select the status to apply to the Status Change, Product Change, Unsubscribe/Kill, or Subscribe. | ||
44 | |||
45 | (% style="color: rgb(0,0,0);" %)**5 **-(%%) Select the Product(Term) that the Status Change, Product Change, Unsubscribe/kill, or Subscribe applies to. If Product Change is selected, "Select the product(Term)" will change to "Select the Product(Term)[FROM} and another box "Select the Product (Term)[[TO>>doc:TO]] will be added. See details on Product Change below. | ||
46 | |||
47 | === PERFORMING A BATCH DELETE === | ||
48 | |||
49 | === 1. Copy and paste the ONEcount IDs of users you wish to delete from the database. === | ||
50 | |||
51 | [[image:attach:1.__Copy_and_paste_the_ONEcount_IDs_of_users_you_wish_t_1.png||align="center"]] | ||
52 | |||
53 | ONEcount IDs may be selected by running a list as described in List Wizard lessons. | ||
54 | |||
55 | You will need to select the delimiter used in this list in Step 5. | ||
56 | |||
57 | If no ONEcount IDs are entered, when you complete the steps below and select "Process" a pop-up will appear prompting you to enter IDs. (see below) | ||
58 | |||
59 | [[image:attach:media_1358447970415.png||align="center"]] | ||
60 | |||
61 | === 2. Select Delete. === | ||
62 | |||
63 | [[image:attach:media_1443644768337.png||align="center"]] | ||
64 | |||
65 | Status Change is selected as the default. | ||
66 | |||
67 | === 3. Select the delimiter used in list of ONEcount IDs that were entered. === | ||
68 | |||
69 | [[image:attach:media_1358448390363.png||align="center"]] | ||
70 | |||
71 | In the example in Step 1, the delimiter is a comma. Other choices include Tab, New Line (each ID on a new line), or Other (e.g. semicolon, colon). | ||
72 | |||
73 | If you do not select a delimeter, when you complete the steps below and select "Process" a pop-up will appear prompting you to select a delimiter. (see below) | ||
74 | |||
75 | [[image:attach:media_1358448434044.png||align="center"]] | ||
76 | |||
77 | === 6. Scroll to the bottom of the screen and click "Process". === | ||
78 | |||
79 | [[image:attach:media_1443644993371.png||align="center"]] | ||
80 | |||
81 | You will receive a message asking for confrmation of the deletion, as shown below. | ||
82 | |||
83 | [[image:attach:7.png||align="center"]] | ||
84 | |||
85 | Clicking "Delete Confirm" will confirm that you wish to proceed with the deletion, and the system will delete the records from the database. You will receive a message confirming that the records have been deleted. | ||
86 | |||
87 | Clicking "Cancel" will cancel the deletion process. | ||
88 | |||
89 | |||
90 | |||
91 | {{id name="End ScreenSteps Content"/}} | ||
92 | {{/layout-cell}} | ||
93 | |||
94 | {{layout-cell}} | ||
95 | {{panel title="Search All Documentation:"}} | ||
96 | |||
97 | |||
98 | {{livesearch/}} | ||
99 | {{/panel}} | ||
100 | |||
101 | {{panel title="Search USER OPERATIONS Documentation:"}} | ||
102 | |||
103 | |||
104 | {{pagetreesearch rootPage="User Operations - Managing Your Data"/}} | ||
105 | {{/panel}} | ||
106 | |||
107 | {{panel title="More USER OPERATIONS Documentation"}} | ||
108 | {{expand}} | ||
109 | **Add Users | ||
110 | ** | ||
111 | |||
112 | (% style="margin-left: 60.0px;" %) | ||
113 | |||
114 | |||
115 | (% style="margin-left: 60.0px;" %) | ||
116 | [[Preparing for Data Import>>doc:Getting Started - Preparing for Data Import]] | ||
117 | |||
118 | (% style="margin-left: 60.0px;" %) | ||
119 | [[doc:Pre-Import Checklist]] | ||
120 | |||
121 | (% style="margin-left: 60.0px;" %) | ||
122 | |||
123 | |||
124 | (% style="margin-left: 60.0px;" %) | ||
125 | [[How to Create an Import Mapping Template>>doc:Import - How to Create an Import Mapping Template]] | ||
126 | |||
127 | (% style="margin-left: 60.0px;" %) | ||
128 | [[How to Use an Import Mapping Template>>doc:Import - How to Use an Import Mapping Template]] | ||
129 | |||
130 | (% style="margin-left: 60.0px;" %) | ||
131 | [[doc:Add Audience]] | ||
132 | |||
133 | (% style="margin-left: 30.0px;" %) | ||
134 | **Batch Operations** | ||
135 | |||
136 | (% style="margin-left: 60.0px;" %) | ||
137 | |||
138 | |||
139 | (% style="margin-left: 60.0px;" %) | ||
140 | [[doc:Bulk Operation - How to Perform a Batch Product Change]] | ||
141 | |||
142 | (% style="margin-left: 60.0px;" %) | ||
143 | [[doc:Bulk Operation - How to Perform a Batch Status Change]] | ||
144 | |||
145 | (% style="margin-left: 60.0px;" %) | ||
146 | [[Bulk Operation - How to Perform a Batch Suscribe>>doc:Bulk Operation - How to Perform a Batch Subscribe]] | ||
147 | |||
148 | (% style="margin-left: 60.0px;" %) | ||
149 | [[Bulk Operation - How to Perform a Batch Unsubscribe>>doc:Bulk Operation - How to Perform a Batch UnsubscribeKill]] | ||
150 | |||
151 | (% style="margin-left: 60.0px;" %) | ||
152 | [[Bulk Operation - How to Perform a Merge of Duplicate Users>>doc:Bulk Operation - How to Perform a Bulk Merge of Duplicate Users]] | ||
153 | |||
154 | (% style="margin-left: 30.0px;" %) | ||
155 | **Target Audience Segments** | ||
156 | |||
157 | (% style="margin-left: 60.0px;" %) | ||
158 | (% style="color: rgb(0,51,102);" %) [[ Target Engine >>doc:Segment Manager]]__ | ||
159 | __ | ||
160 | |||
161 | \\ | ||
162 | |||
163 | \\ | ||
164 | {{/expand}} | ||
165 | {{/panel}} | ||
166 | |||
167 | \\ | ||
168 | |||
169 | \\ | ||
170 | |||
171 | \\ | ||
172 | |||
173 | \\ | ||
174 | |||
175 | \\ | ||
176 | |||
177 | \\ | ||
178 | {{/layout-cell}} | ||
179 | {{/layout-section}} | ||
180 | {{/layout}} |