Changes for page Utilities - DExTr

Last modified by rayaan@one-count_com on 2023/11/09 10:38
From version 13.1
edited by Admin
on 2020/05/08 15:35
Change comment: There is no comment for this version
To version 15.1
edited by rayaan@one-count_com
on 2023/11/09 10:38
Change comment: There is no comment for this version

Summary

Details

Page properties
Parent
... ... @@ -1,0 +1,1 @@
1 +System Utilities
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.Admin
1 +XWiki.rayaan@one-count_com
Content
... ... @@ -37,9 +37,9 @@
37 37  
38 38  **OPEN THE MAPPING WINDOW**
39 39  
40 -Select UTILITIES from the main menu and the DExTr from the sub-menu.
40 +Select DATA MANAGEMENT from the main menu and the DExTr from the sub-menu.
41 41  
42 -[[image:attach:DExTr Nav.png||width="707"]]
42 +[[image:attach:Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 8.png||thumbnail="true" height="250"]]
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,10 +243,16 @@
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/2016 and yy/mm/dd will export as 16/07/05.
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 +
247 247  **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.
248 248  
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.
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 +
250 250  **Date Column Field:** This identifies the column header for the date column in the import file.
251 251  
252 252  When done with mapping, click "Next".
... ... @@ -264,10 +264,64 @@
264 264  
265 265  {{id name="End ScreenSteps Content"/}}
266 266  
267 -\\
273 +=== MAPPING ENGAGEMENT DATA ===
268 268  
269 -**HOW DExTr MAPS DATA**
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.
270 270  
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 +
271 271  The following information is being provided to help you understand how DExTr will map/transform your data on import.
272 272  
273 273  (% class="diff-block-target" %)
DExTr Demo Tab.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +196.0 KB
Content
DExTr Listing Page.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +144.2 KB
Content
DExTr Nav.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +51.4 KB
Content
DExTr Value Mapping Pop-Up.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +119.3 KB
Content
New-DExTr-Mapping.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +89.9 KB
Content
Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 8.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +17.7 KB
Content
media_1467388147151.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +30.4 KB
Content
media_1467391080266.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +56.2 KB
Content
media_1467391237758.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +63.3 KB
Content
media_1467391409099.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +160.0 KB
Content
media_1467396172019.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +80.4 KB
Content
media_1467397686498.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +29.5 KB
Content
media_1467398257338.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +37.2 KB
Content
media_1467398286154.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +18.0 KB
Content
media_1467398730892.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +112.7 KB
Content
media_1467398948360.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +8.8 KB
Content
media_1467399198566.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +51.5 KB
Content
media_1467651841763.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +170.2 KB
Content
media_1468251499518.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +28.5 KB
Content
media_1468251557794.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +26.0 KB
Content
media_1468252151743.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +122.0 KB
Content
media_1468252886176.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +92.5 KB
Content
media_1468256607407.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +90.4 KB
Content
Confluence.Code.ConfluencePageClass[0]
id
... ... @@ -1,1 +1,1 @@
1 -45940746
1 +67230
url
... ... @@ -1,1 +1,1 @@
1 -https://info.onecount.net//wiki/spaces/OD/pages/45940746/Utilities - DExTr
1 +https://info.onecount.net//wiki/spaces/OD/pages/67230/Utilities - DExTr