Changes for page Utilities - DExTr

Last modified by rayaan@one-count_com on 2023/11/09 10:38
From version 16.1
edited by rayaan@one-count_com
on 2023/11/09 11:38
Change comment: There is no comment for this version
To version 12.1
edited by Admin
on 2019/12/28 19:29
Change comment: There is no comment for this version

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,0 @@
1 -System Utilities
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.rayaan@one-count_com
1 +XWiki.Admin
Content
... ... @@ -37,9 +37,9 @@
37 37  
38 38  **OPEN THE MAPPING WINDOW**
39 39  
40 -Select DATA MANAGEMENT from the main menu and the DExTr from the sub-menu.
40 +Select UTILITIES from the main menu and the DExTr from the sub-menu.
41 41  
42 -[[image:attach:Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 8.png||thumbnail="true" height="250"]]
42 +[[image:attach:DExTr Nav.png||width="707"]]
43 43  
44 44  This will open the Main DExTr Listing Page, as shown below.
45 45  
... ... @@ -61,7 +61,7 @@
61 61  (% style="margin-left: 30.0px;" %)
62 62  \\
63 63  
64 -=== Creating a Data Mapping ===
64 +Creating a Data Mapping
65 65  
66 66  **[[image:attach:New-DExTr-Mapping.png||height="250"]]**
67 67  
... ... @@ -243,16 +243,10 @@
243 243  )))
244 244  
245 245  (% style="text-decoration: underline;" %)**Date Mapping Area**(%%)
246 -**For automated data feed reports,** enter the format you would like dates to be exported as. For example MM/dd/yyyy will export as 07/05/2023 and yy/MM/dd will export as 23/07/05. If you want to import time along with date add hh:mm:ss:a along with date. For example MM/dd/yyyy hh:mm:ss:a will be exported as 07/23/2023 11:45:32:AM
247 -
248 -(% style="color: rgb(51,51,51);" %)MM : months, dd: days, yyyy: years, hh: hours (12 hour format), HH: hours (24 hour format), mm: minutes, ss: seconds, a:AM/PM(%%)\\
249 -
246 +**For automated data feed reports,** enter the format you would like dates to be exported as. For example mm/dd/yyyy will export as 07/05/2016 and yy/mm/dd will export as 16/07/05.
250 250  **Date Column Field:** This identifies what to output as the header for the date field. Enter the heading that's required for the report output.
251 251  
252 -**For Imports,** enter the format of dates in the import file. For example, if a date is 07/05/2016, enter the format MM/dd/yyyy. If you want to import time along with date add hh:mm:ss along with date. For example MM/dd/yyyy hh:mm:ss:a will be exported as 07/23/2023 11:45:32:AM
253 -
254 -(% style="color: rgb(51,51,51);" %)MM : months, dd: days, yyyy: years, hh: hours (12 hour format), HH: hours (24 hour format), mm: minutes, ss: seconds, a:AM/PM
255 -
249 +**For Imports,** enter the format of dates in the import file. For example, if a date is 07/05/2016, enter the format mm/dd/yyyy.
256 256  **Date Column Field:** This identifies the column header for the date column in the import file.
257 257  
258 258  When done with mapping, click "Next".
... ... @@ -269,90 +269,6 @@
269 269  
270 270  
271 271  {{id name="End ScreenSteps Content"/}}
272 -
273 -=== MAPPING ENGAGEMENT DATA ===
274 -
275 -This section outlines the types of engagement data that DExTr can import/export. Please note that Generic and Engagement data fields can be used for both web, banner and newsletter engagement data.
276 -
277 -If you need data points imported or exported that are not on this list, check with the ONEcount team to see if those fields can be accommodated.
278 -
279 -Generic Engagement Fields
280 -
281 -* Activity Date: Date of the Activity
282 -* Activity Time: Time of the Activity, Mandatory for Import.
283 -* Channel Codes: Codes for Email, Banner and Web page views, CMI needed it in export.
284 -* End Date: End date of export, mainly used in aggregate export.
285 -* Unique External ID: Unique ID for each transaction.
286 -* Month: Month of the Activity.
287 -* OCID:
288 -* OCID Hash: Unique hash of the user. This is the cookie set on user’s browser.
289 -* Platform Viewed: Platform of the user in which Impression or Page view happened.
290 -* Resource Details: This is used for export. It has Page title for Web activity, Banner name for Banner Activity and Message title for Email data.
291 -* Start Date: Start date of export, mainly used in aggregate export.
292 -
293 -Metric Engagement Fields
294 -
295 -* Activity Metric code: Metric codes for Activity data. It has codes for Email sent, delivered, opened, clicked, banner impression, banner clicked and page view. It is mandatory for Import and export.
296 -* Activity Metric Name: Metric Names for Activity data (CMI report needs Metric code and Name). It has codes for Email sent, delivered, opened, clicked, banner impression, banner clicked and page view.
297 -* Activity Metric count: Mainly used for export. It has counts for each activity.
298 -* Aggregate Metric code: Metric codes for Aggregate data. It has codes for Email sent, delivered, opened, clicked, banner impression, banner clicked and page view. Mandatory for aggregate export.
299 -* Aggregate Metric Name: Metric Names for Aggregate data (CMI report needs Metric code and Name). It has codes for Email sent, delivered, opened, clicked, banner impression, banner clicked and page view.
300 -* Aggregate Metric count: Mainly used for export. It has counts for each activity.
301 -
302 -Banner Engagement
303 -
304 -* Ad Server Name: Name of the Ad Server, i.e., DFP
305 -* Advertiser ID: ID of the Advertiser
306 -* Advertiser Name: Name of the Advertiser
307 -* Banner ID: ID of the Banner
308 -* Banner Name: Name of the Banner
309 -* Campaign ID: ID of the Campaign
310 -* Campaign Name: Name of the Campaign
311 -* Viewable Impression: If Impression is viewed or not, Boolean (0, 1 accepted)
312 -
313 -Newsletter Engagement Fields
314 -
315 -* Click URL: URL of the Clicked link. Mandatory for Importing Email clicks.
316 -* List ID: ID of the newsletter List of Group
317 -* List Name: Name of the newsletter list or group
318 -* Message ID: Campaign ID of the newsletter
319 -* Message Name: Campaign name of the newsletter
320 -* Recipient ID: Unique User Id in the Email service provider
321 -* Message Subject: Subject of the Campaign
322 -
323 -Web Engagement Fields
324 -
325 -* Referrer: Referrer for the page view
326 -* Site name: Website URL
327 -* Page URL: URL of the Page.
328 -
329 -=== **HOW DExTr MAPS DATA** ===
330 -
331 -The following information is being provided to help you understand how DExTr will map/transform your data on import.
332 -
333 -(% class="diff-block-target" %)
334 -1. On import, ONEcount will always check if fields in the DExTr mapping are present in the file or not; if any field is not present in the file, then we fail the job. This is to ensure that we won’t miss mandatory data or dedupe fields and possibly corrupt the data. If you are importing data and the file does not have all of the fields in the DExTr mapping you are using, you can create a blank column with that field name in it–//as long as that field is not a de-dupe field for the import.//
335 -1. If there are multiple dedupe fields in mapping then we dedupe the data based on order that the fields appear in the mapping. For Example if mapping has dedupe fields as “Email” (1^^st^^ field in order) and “AccountID” (2^^nd^^ field in order) then DExTr will first query the datase for a match on “Email,” if match is not found then it will query on “AccountID”. It always an OR match. You //can not match// on Email AND AccountID
336 -1. If OCID is present as a dedupe field, then it always takes precedence irrespective of order. If you import a file with OCID as a dedupe field, and a record does not have an OCID, then a new user will be created in ONEcount and a unique OCID will be generated.
337 -1. There are a variety of validations which can be added to DExTr mapping like, “Numeric”, “Required” etc.. If any record/row doesn’t satisfy these validations, then that record won’t be imported into ONEcount. It will be saved into a failed record file and mailed to the email address supplied with the import job.
338 -1. If there are any passwords that are being imported, they should be imported as plain text. ONEcount will encrypt the field based on encrypt function for your installation.
339 -1. For Package transactions: Term ID, Package status, source code and transaction type are mandatory.
340 -11. If Term ID is not mapped, then the transaction won’t be imported.
341 -11. IF Package status is not mapped then default Package status from term will be added.
342 -11. If source code is not mapped. Then default source code from import job will be selected.
343 -11. If transaction type is not added, then default type from Import job will be selected.
344 -1. For Product transaction: Product ID, source code and transaction type are mandatory.
345 -11. If Product ID is not mapped, then the transaction won’t be imported.
346 -11. If source code is not mapped. Then default source code from import job will be selected.
347 -11. If transaction type is not added, then default type from Import job will be selected.
348 -1. If Transaction Date is not mapped or not formatted correctly, then current date will be used as request date.
349 -1. If Expiration date is not mapped or not formatted correctly, then expiration date will be calculated based on the duration of the term and the request date.
350 -1. For Engagement imports, Activity type is mandatory.
351 -1. If Engagement date is not formatted, then current date will be used as activity date.
352 -1. If Data and campaign ID, name, List ID and name then they will be imported as well.
353 -1. If dedupe is not added/matched for an engagement import then new users will be created in the system just like Users and transaction import.
354 -
355 -\\
356 356  {{/layout-cell}}
357 357  
358 358  {{layout-cell}}
DExTr Demo Tab.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -196.0 KB
Content
DExTr Listing Page.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -144.2 KB
Content
DExTr Nav.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -51.4 KB
Content
DExTr Value Mapping Pop-Up.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -119.3 KB
Content
New-DExTr-Mapping.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -89.9 KB
Content
Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 8.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -17.7 KB
Content
media_1467388147151.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -30.4 KB
Content
media_1467391080266.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -56.2 KB
Content
media_1467391237758.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -63.3 KB
Content
media_1467391409099.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -160.0 KB
Content
media_1467396172019.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -80.4 KB
Content
media_1467397686498.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -29.5 KB
Content
media_1467398257338.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -37.2 KB
Content
media_1467398286154.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -18.0 KB
Content
media_1467398730892.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -112.7 KB
Content
media_1467398948360.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -8.8 KB
Content
media_1467399198566.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -51.5 KB
Content
media_1467651841763.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -170.2 KB
Content
media_1468251499518.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -28.5 KB
Content
media_1468251557794.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -26.0 KB
Content
media_1468252151743.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -122.0 KB
Content
media_1468252886176.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -92.5 KB
Content
media_1468256607407.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -90.4 KB
Content
Confluence.Code.ConfluencePageClass[0]
id
... ... @@ -1,1 +1,1 @@
1 -67230
1 +23331872
url
... ... @@ -1,1 +1,1 @@
1 -https://info.onecount.net//wiki/spaces/OD/pages/67230/Utilities - DExTr
1 +https://info.onecount.net//wiki/spaces/OD/pages/23331872/Utilities - DExTr