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 13.1
edited by Admin
on 2020/05/08 16:35
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".
... ... @@ -270,64 +270,10 @@
270 270  
271 271  {{id name="End ScreenSteps Content"/}}
272 272  
273 -=== MAPPING ENGAGEMENT DATA ===
267 +\\
274 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.
269 +**HOW DExTr MAPS DATA**
276 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 331  The following information is being provided to help you understand how DExTr will map/transform your data on import.
332 332  
333 333  (% class="diff-block-target" %)
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 +45940746
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/45940746/Utilities - DExTr