Changes for page Utilities - DExTr

Last modified by rayaan@one-count_com on 2023/11/09 10:38
From version 14.1
edited by Admin
on 2021/03/11 16:37
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
Content
... ... @@ -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  
... ... @@ -264,64 +264,10 @@
264 264  
265 265  {{id name="End ScreenSteps Content"/}}
266 266  
267 -=== MAPPING ENGAGEMENT DATA ===
267 +\\
268 268  
269 -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**
270 270  
271 -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.
272 -
273 -Generic Engagement Fields
274 -
275 -* Activity Date: Date of the Activity
276 -* Activity Time: Time of the Activity, Mandatory for Import.
277 -* Channel Codes: Codes for Email, Banner and Web page views, CMI needed it in export.
278 -* End Date: End date of export, mainly used in aggregate export.
279 -* Unique External ID: Unique ID for each transaction.
280 -* Month: Month of the Activity.
281 -* OCID:
282 -* OCID Hash: Unique hash of the user. This is the cookie set on user’s browser.
283 -* Platform Viewed: Platform of the user in which Impression or Page view happened.
284 -* 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.
285 -* Start Date: Start date of export, mainly used in aggregate export.
286 -
287 -Metric Engagement Fields
288 -
289 -* 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.
290 -* 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.
291 -* Activity Metric count: Mainly used for export. It has counts for each activity.
292 -* 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.
293 -* 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.
294 -* Aggregate Metric count: Mainly used for export. It has counts for each activity.
295 -
296 -Banner Engagement
297 -
298 -* Ad Server Name: Name of the Ad Server, i.e., DFP
299 -* Advertiser ID: ID of the Advertiser
300 -* Advertiser Name: Name of the Advertiser
301 -* Banner ID: ID of the Banner
302 -* Banner Name: Name of the Banner
303 -* Campaign ID: ID of the Campaign
304 -* Campaign Name: Name of the Campaign
305 -* Viewable Impression: If Impression is viewed or not, Boolean (0, 1 accepted)
306 -
307 -Newsletter Engagement Fields
308 -
309 -* Click URL: URL of the Clicked link. Mandatory for Importing Email clicks.
310 -* List ID: ID of the newsletter List of Group
311 -* List Name: Name of the newsletter list or group
312 -* Message ID: Campaign ID of the newsletter
313 -* Message Name: Campaign name of the newsletter
314 -* Recipient ID: Unique User Id in the Email service provider
315 -* Message Subject: Subject of the Campaign
316 -
317 -Web Engagement Fields
318 -
319 -* Referrer: Referrer for the page view
320 -* Site name: Website URL
321 -* Page URL: URL of the Page.
322 -
323 -=== **HOW DExTr MAPS DATA** ===
324 -
325 325  The following information is being provided to help you understand how DExTr will map/transform your data on import.
326 326  
327 327  (% class="diff-block-target" %)
Confluence.Code.ConfluencePageClass[0]
id
... ... @@ -1,1 +1,1 @@
1 -62521418
1 +45940746
url
... ... @@ -1,1 +1,1 @@
1 -https://info.onecount.net//wiki/spaces/OD/pages/62521418/Utilities - DExTr
1 +https://info.onecount.net//wiki/spaces/OD/pages/45940746/Utilities - DExTr