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 14.1
edited by Admin
on 2021/03/11 15:37
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,10 +264,64 @@
264 264  
265 265  {{id name="End ScreenSteps Content"/}}
266 266  
267 -\\
267 +=== MAPPING ENGAGEMENT DATA ===
268 268  
269 -**HOW DExTr MAPS DATA**
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.
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 +
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" %)
Confluence.Code.ConfluencePageClass[0]
id
... ... @@ -1,1 +1,1 @@
1 -45940746
1 +62521418
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/62521418/Utilities - DExTr