Changes for page Bulk Operation - How to Perform a Bulk Merge of Duplicate Users
Last modified by caterina on 2022/02/04 14:56
Summary
-
Page properties (4 modified, 0 added, 0 removed)
-
Attachments (0 modified, 12 added, 0 removed)
- Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 3.png
- Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 7.png
- media_1430151147663.png
- media_1430151210830.png
- media_1430151456843.png
- media_1430151885313.png
- media_1430163531217.png
- media_1430163612501.png
- media_1430163644824.png
- media_1430163695483.png
- media_1438020148654.png
- media_1438020317487.png
-
Objects (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Title
-
... ... @@ -1,1 +1,1 @@ 1 -Bulk Operation - How to Perform a Bulk Merge of Duplicate Users (v12.x)1 +Bulk Operation - How to Perform a Bulk Merge of Duplicate Users - Parent
-
... ... @@ -1,0 +1,1 @@ 1 +User Operations - Managing Your Data - Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. melanie@one-count_com1 +XWiki.caterina - Content
-
... ... @@ -4,7 +4,7 @@ 4 4 5 5 6 6 {{id name="Start ScreenSteps Content"/}} 7 - 7 +This lesson describes how to use the Bulk Operation tool in the USER OPERATIONS module to merge duplicate user records. Performing a batch merge will merge duplicate records into one selected record. 8 8 9 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 10 ... ... @@ -11,7 +11,7 @@ 11 11 === IMPORTANT NOTE – FIRST GENERATE A FILE OF DUPLICATES TO BE MERGED === 12 12 13 13 (% style="color: rgb(164,10,10);" %)**Note that prior to performing a merge, you must generate a csv file of duplicate ocids. ~*~***(%%) 14 - 14 +(% style="color: rgb(164,10,10);" %)**The first column of the file should have the ocid of the user you wish to keep (i.e. the ocid of the user you wish to merge duplicate users into). **(%%) 15 15 (% style="color: rgb(164,10,10);" %)**The second column should have a list of duplicate ocids (i.e. ocids of duplicate users that you wish to merge into the one user in the first column). **(%%) 16 16 (% style="color: rgb(164,10,10);" %)**Be sure that the file doesn't have any duplicates within itself.** 17 17 ... ... @@ -27,12 +27,11 @@ 27 27 28 28 ocids 40754 and 45770 will be merged into ocid 30290, ocids 39314 and 46162 will be merged into ocid 20834, ocid 38146 will be merged into ocid 28138, ocid 41994 will be merged into ocid 19385. 29 29 30 -=== IMPORTANT NOTE – STATISTICS, NEWSLETTER LISTS, AND MERGED RECORDS === 30 +=== IMPORTANT NOTES – STATISTICS, NEWSLETTER LISTS, AND MERGED RECORDS === 31 31 32 -All transaction data and product subscriptions from a removed/merged user will be moved to the kept user's record. 32 +1. All transaction data and product subscriptions from a removed/merged user will be moved to the kept user's record. 33 +1. Each piece of demographic data has a timestamp attached to it. When users are merged, whichever has the latest timestamp on a per question basis becomes the latest info for that user. Each demographic field with the latest timestamp will be included in the "kept" users record. **NOTE**: Usernames and passwords qualify as demographic information that will be updated to the latest timestamp as well. 33 33 34 -Whatever is the latest demographic data will be included in the "kept" user's record. Each piece of demographic data has a timestamp attached to it; and when users are merged, whichever has the latest timestamp on a per question basis becomes the latest info for that user. 35 - 36 36 When merging records/users, email stats stay the same. For example, 37 37 38 38 * four records are merged into one, and ... ... @@ -39,23 +39,27 @@ 39 39 * all are subscribed to the same newsletter, and 40 40 * there are four unique opens for those users (one unique open per user) for that newsletter, and 41 41 * the unique opens count will stay at four. 42 - 41 +If you drill into the List Wizard to generate a list of the users, only the record that was kept (the ones other ocids were merged into) will be included on the list. 43 43 44 44 Users will be processed differently depending on the email engine. 45 -If using the ONEcount email engine, those users who have been removed (merged into another ocid) and who were subscribed to the same newsletter list(s) as the kept user will be deleted in the ONEcount email engine. If a removed user is subscribed to an email list that the kept user is not subscribed to, the kept user will be added to the newsletter list. 44 +\\If using the ONEcount email engine, those users who have been removed (merged into another ocid) and who were subscribed to the same newsletter list(s) as the kept user will be deleted in the ONEcount email engine. If a removed user is subscribed to an email list that the kept user is not subscribed to, the kept user will be added to the newsletter list. 46 46 47 47 MagnetMail doesn't allow for deleting/ merging users, so all users that were merged into another ocid will remain in MagnetMail but will be unsubscribed from respective email list(s) in MagnetMail. If a removed user is subscribed to an email list that the kept user is not subscribed to, the kept user will be added to the newsletter list. 48 48 49 49 === OPEN THE BULK OPERATION WINDOW === 50 50 51 -=== Select USER OPERATIONSfrom the Main Menu. ===50 +=== Select DATA MANAGEMENT from the Main Menu. === 52 52 53 - [[image:attach:media_1430151147663.png||align="center"]]52 +\\ 54 54 55 - ===Select"BULKOPERATION"fromthe USER OPERATIONS sub-menu.===54 +[[image:attach:Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 3.png||thumbnail="true" height="250"]] 56 56 57 - [[image:attach:media_1430151210830.png||align="center"]]56 +=== Select "BULK OPERATIONS" from the DATA MANAGEMENT sub-menu. === 58 58 58 +[[image:attach:Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 7.png||thumbnail="true" height="250"]] 59 + 60 +\\ 61 + 59 59 This will open the Bulk Operation main window, as shown below. 60 60 61 61 === BULK OPERATION Main Window === ... ... @@ -110,31 +110,35 @@ 110 110 111 111 You will receive email notification at the email address you provided when the merge is completed. 112 112 116 +\\ 113 113 118 +**IMPORTANT NOTE:** 114 114 120 +Performing merge operations on user accounts will not be reflected in the clients external ESP analytics, however those merged accounts will be reflected in ONEcount's analytics. This may lead to a small difference in metrics between each database, however the results in ONEcount would be reflective of the more accurate real-time information. 121 + 122 +\\ 123 + 124 + 125 + 115 115 {{id name="End ScreenSteps Content"/}} 116 116 {{/layout-cell}} 117 117 118 118 {{layout-cell}} 119 - **Searchall Documentation:**130 +{{panel title="Search All Documentation:"}} 120 120 121 121 122 - 123 123 {{livesearch/}} 134 +{{/panel}} 124 124 125 - 136 +{{panel title="Search USER OPERATIONS Documentation:"}} 126 126 127 -**Search USER OPERATIONS Documentation:** 128 128 129 - 130 - 131 131 {{pagetreesearch rootPage="User Operations - Managing Your Data"/}} 140 +{{/panel}} 132 132 133 - 134 - 135 -{{expand title="More USER OPERATIONS Documentation"}} 136 -(% style="margin-left: 30.0px;" %) 137 -**Add Users 142 +{{panel title="More USER OPERATIONS Documentation"}} 143 +{{expand}} 144 + **Add Users 138 138 ** 139 139 140 140 (% style="margin-left: 60.0px;" %) ... ... @@ -141,40 +141,40 @@ 141 141 142 142 143 143 (% style="margin-left: 60.0px;" %) 144 -[[Preparing for Data Import>>doc:Getting Started - Preparing for Data Import (v12\.x)]]151 +[[Preparing for Data Import>>doc:Getting Started - Preparing for Data Import]] 145 145 146 146 (% style="margin-left: 60.0px;" %) 147 -[[ Pre-Import Checklist>>doc:Pre-Import Checklist(v12\.x)]]154 +[[doc:Pre-Import Checklist]] 148 148 149 149 (% style="margin-left: 60.0px;" %) 150 -[[How to Import a File>>doc:Import - How to Import a File (v12\.x)]] 151 151 158 + 152 152 (% style="margin-left: 60.0px;" %) 153 -[[How to Create an Import Mapping Template>>doc:Import - How to Create an Import Mapping Template (v12\.x)]]160 +[[How to Create an Import Mapping Template>>doc:Import - How to Create an Import Mapping Template]] 154 154 155 155 (% style="margin-left: 60.0px;" %) 156 -[[How to Use an Import Mapping Template>>doc:Import - How to Use an Import Mapping Template (v12\.x)]]163 +[[How to Use an Import Mapping Template>>doc:Import - How to Use an Import Mapping Template]] 157 157 158 158 (% style="margin-left: 60.0px;" %) 159 -[[ Add Audience>>doc:Add Audience(v12\.x)]]166 +[[doc:Add Audience]] 160 160 161 161 (% style="margin-left: 30.0px;" %) 162 162 **Batch Operations** 163 163 164 164 (% style="margin-left: 60.0px;" %) 165 -[[ Bulk Operation - How to Perform a Batch Delete>>doc:Bulk Operation - How to Perform a Batch Delete(v12\.x)]]172 +[[doc:Bulk Operation - How to Perform a Batch Delete]] 166 166 167 167 (% style="margin-left: 60.0px;" %) 168 -[[ Bulk Operation - How to Perform a Batch Product Change>>doc:Bulk Operation - How to Perform a Batch Product Change(v12\.x)]]175 +[[doc:Bulk Operation - How to Perform a Batch Product Change]] 169 169 170 170 (% style="margin-left: 60.0px;" %) 171 -[[ Bulk Operation - How to Perform a Batch Status Change>>doc:Bulk Operation - How to Perform a Batch Status Change(v12\.x)]]178 +[[doc:Bulk Operation - How to Perform a Batch Status Change]] 172 172 173 173 (% style="margin-left: 60.0px;" %) 174 -[[Bulk Operation - How to Perform a Batch Suscribe>>doc:Bulk Operation - How to Perform a Batch Subscribe (v12\.x)]]181 +[[Bulk Operation - How to Perform a Batch Suscribe>>doc:Bulk Operation - How to Perform a Batch Subscribe]] 175 175 176 176 (% style="margin-left: 60.0px;" %) 177 -[[Bulk Operation - How to Perform a Batch Unsubscribe>>doc:Bulk Operation - How to Perform a Batch UnsubscribeKill (v12\.x)]]184 +[[Bulk Operation - How to Perform a Batch Unsubscribe>>doc:Bulk Operation - How to Perform a Batch UnsubscribeKill]] 178 178 179 179 (% style="margin-left: 60.0px;" %) 180 180 ... ... @@ -183,13 +183,26 @@ 183 183 **Target Audience Segments** 184 184 185 185 (% style="margin-left: 60.0px;" %) 186 -(% style="color: rgb(0,51,102);" %) [[ Target Engine >>doc: Utilities - TargetEngine(v12\.x)]]__193 +(% style="color: rgb(0,51,102);" %) [[ Target Engine >>doc:Segment Manager]]__ 187 187 __ 188 188 189 - 196 +\\ 190 190 191 - 198 +\\ 192 192 {{/expand}} 200 +{{/panel}} 201 + 202 +\\ 203 + 204 +\\ 205 + 206 +\\ 207 + 208 +\\ 209 + 210 +\\ 211 + 212 +\\ 193 193 {{/layout-cell}} 194 194 {{/layout-section}} 195 195 {{/layout}}
- Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 3.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +15.2 KB - Content
- Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 7.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +17.1 KB - Content
- media_1430151147663.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +17.8 KB - Content
- media_1430151210830.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +17.9 KB - Content
- media_1430151456843.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +43.1 KB - Content
- media_1430151885313.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +79.0 KB - Content
- media_1430163531217.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +210.3 KB - Content
- media_1430163612501.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +65.1 KB - Content
- media_1430163644824.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +25.7 KB - Content
- media_1430163695483.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +18.3 KB - Content
- media_1438020148654.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +71.8 KB - Content
- media_1438020317487.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.XWikiGuest - Size
-
... ... @@ -1,0 +1,1 @@ 1 +61.5 KB - Content
- Confluence.Code.ConfluencePageClass[0]
-
- id
-
... ... @@ -1,1 +1,1 @@ 1 -6 75511 +66658 - url
-
... ... @@ -1,1 +1,1 @@ 1 -https://info.onecount.net//wiki/spaces/OD/pages/6 7551/Bulk Operation - How to Perform a Bulk Merge of Duplicate Users(v12.x)1 +https://info.onecount.net//wiki/spaces/OD/pages/66658/Bulk Operation - How to Perform a Bulk Merge of Duplicate Users