Wiki source code of DExTr Import Files

Version 3.1 by Admin on 2022/09/19 11:57
Show last authors
1 DExTr is a data mapping tool that can be used to transform data coming into or out of ONEcount. DExTr mappings are capable of mapping almost every type of data ONEcount uses. For all of the data types discussed below, ONEcount can both ingest this data from outside sources, and export files like this to be consumed by outside sources.
2
3 Below are some sample formats for data coming into ONEcount via DExTr. These samples are meant as examples only. DExTr is capable of manipulating data in multiple formats, and variations in these formats are usually acceptable.
4
5 All files should be in CSV format, with fields enclosed in quotes. If you have quotes within the data of a field and do not enclose the fields in quotes, you will have problems importing your data.
6
7 There are three main types of data that you can exchange with ONEcount: User Demographic Data, Transactional Data, and Engagement Data.
8
9 === User Demographic Data ===
10
11 Typically data about the person, including NAME, ADDRESS, CITY, STATE, ZIP, JOB TITLE, E-MAIL, HAIR COLOR, ETC. If the system you are bringing the data in from contains a unique identifier, such as a user or customer ID, it is important to bring that data in so that it can be used for matching and de-duping records later. ONEcount can use ANY field to de-dupe, records, not just e-mail. Typically, records are de-duplicated across different fields depending on the source system (ie., records from your CRM system are de-duped based on the CRM ID, records from your e-mail system may be de-duped on the email system ID).
12
13 \\
14
15 (% class="wrapped" %)
16 |(((
17 (% style="color: rgb(0,51,102);" %)**ACCOUNT NUMBER**
18 )))|(((
19 (% style="color: rgb(0,51,102);" %)**FIRST NAME**
20 )))|(((
21 (% style="color: rgb(0,51,102);" %)**LAST NAME**
22 )))|(((
23 (% style="color: rgb(0,51,102);" %)**MIDDLE NAME**
24 )))|(((
25 (% style="color: rgb(0,51,102);" %)**TITLE**
26 )))|(((
27 (% style="color: rgb(0,51,102);" %)**SUFFIX**
28 )))|(((
29 (% style="color: rgb(0,51,102);" %)**COMPANY**
30 )))|(((
31 (% style="color: rgb(0,51,102);" %)**JOB TITLE**
32 )))|(((
33 (% style="color: rgb(0,51,102);" %)**ADDRESS1**
34 )))|(((
35 (% style="color: rgb(0,51,102);" %)**ADDRESS2**
36 )))|(((
37 (% style="color: rgb(0,51,102);" %)**CITY**
38 )))|(((
39 (% style="color: rgb(0,51,102);" %)**STATE**
40 )))|(((
41 (% style="color: rgb(0,51,102);" %)**ZIP**
42 )))|(((
43 (% style="color: rgb(0,51,102);" %)**ZIP4**
44 )))|(((
45 (% style="color: rgb(0,51,102);" %)**COUNTRY**
46 )))|(((
47 (% style="color: rgb(0,51,102);" %)**TELEPHONE NUMBER**
48 )))|(((
49 (% style="color: rgb(0,51,102);" %)**FAX NUMBER**
50 )))|(((
51 (% style="color: rgb(0,51,102);" %)**E-MAIL ADDRESS**
52 )))|(((
53 (% style="color: rgb(0,51,102);" %)**E-MAIL CONTACT**
54 )))|(((
55 (% style="color: rgb(0,51,102);" %)**CUSTOM1**
56 )))|(((
57 (% style="color: rgb(0,51,102);" %)**CUSTOM2**
58 )))|(((
59 (% style="color: rgb(0,51,102);" %)**CUSTOM3**
60 )))|(((
61 (% style="color: rgb(0,51,102);" %)**LAST UPDATED**
62 )))|(((
63 (% style="color: rgb(0,51,102);" %)**OCID**
64 )))
65 |(((
66 (% style="color: rgb(0,51,102);" %)**14010000431**
67 )))|(((
68 (% style="color: rgb(0,51,102);" %)Graham
69 )))|(((
70 (% style="color: rgb(0,51,102);" %)O'Gorman
71 )))|(((
72 \\
73 )))|(((
74 \\
75 )))|(((
76 \\
77 )))|(((
78 (% style="color: rgb(0,51,102);" %)Graham O'Gorman Landscape
79 )))|(((
80 \\
81 )))|(((
82 (% style="color: rgb(0,51,102);" %)192 Olmstead Hill Rd
83 )))|(((
84 \\
85 )))|(((
86 (% style="color: rgb(0,51,102);" %)Wilton
87 )))|(((
88 (% style="color: rgb(0,51,102);" %)CT
89 )))|(((
90 (% style="color: rgb(0,51,102);" %)6897
91 )))|(((
92 (% style="color: rgb(0,51,102);" %)1816
93 )))|(((
94 (% style="color: rgb(0,51,102);" %)United States
95 )))|(((
96 \\
97 )))|(((
98 \\
99 )))|(((
100 \\
101 )))|(((
102 (% style="color: rgb(0,51,102);" %)N
103 )))|(((
104 \\
105 )))|(((
106 \\
107 )))|(((
108 \\
109 )))|(((
110 (% style="color: rgb(0,51,102);" %)20141113211102
111 )))|(((
112 \\
113 )))
114 |(((
115 (% style="color: rgb(0,51,102);" %)**14010000449**
116 )))|(((
117 (% style="color: rgb(0,51,102);" %)Dale S
118 )))|(((
119 (% style="color: rgb(0,51,102);" %)Galbo
120 )))|(((
121 \\
122 )))|(((
123 \\
124 )))|(((
125 \\
126 )))|(((
127 (% style="color: rgb(0,51,102);" %)Law Offices
128 )))|(((
129 (% style="color: rgb(0,51,102);" %)Owner
130 )))|(((
131 (% style="color: rgb(0,51,102);" %)15 W Hill Rd
132 )))|(((
133 \\
134 )))|(((
135 (% style="color: rgb(0,51,102);" %)Bloomfield
136 )))|(((
137 (% style="color: rgb(0,51,102);" %)CT
138 )))|(((
139 (% style="color: rgb(0,51,102);" %)6002
140 )))|(((
141 (% style="color: rgb(0,51,102);" %)5016
142 )))|(((
143 (% style="color: rgb(0,51,102);" %)United States
144 )))|(((
145 (% style="color: rgb(0,51,102);" %)2032709821
146 )))|(((
147 \\
148 )))|(((
149 \\
150 )))|(((
151 (% style="color: rgb(0,51,102);" %)N
152 )))|(((
153 \\
154 )))|(((
155 \\
156 )))|(((
157 \\
158 )))|(((
159 (% style="color: rgb(0,51,102);" %)20141113211111
160 )))|(((
161 \\
162 )))
163 |(((
164 (% style="color: rgb(0,51,102);" %)**14010000648**
165 )))|(((
166 (% style="color: rgb(0,51,102);" %)Patricia
167 )))|(((
168 (% style="color: rgb(0,51,102);" %)Cannon
169 )))|(((
170 \\
171 )))|(((
172 \\
173 )))|(((
174 \\
175 )))|(((
176 (% style="color: rgb(0,51,102);" %)Employee Assistance Program
177 )))|(((
178 (% style="color: rgb(0,51,102);" %)Director
179 )))|(((
180 (% style="color: rgb(0,51,102);" %)887 Bridgeport Ave Ste C
181 )))|(((
182 \\
183 )))|(((
184 (% style="color: rgb(0,51,102);" %)Shelton
185 )))|(((
186 (% style="color: rgb(0,51,102);" %)CT
187 )))|(((
188 (% style="color: rgb(0,51,102);" %)6484
189 )))|(((
190 (% style="color: rgb(0,51,102);" %)7602
191 )))|(((
192 (% style="color: rgb(0,51,102);" %)United States
193 )))|(((
194 (% style="color: rgb(0,51,102);" %)2039290681
195 )))|(((
196 \\
197 )))|(((
198 \\
199 )))|(((
200 (% style="color: rgb(0,51,102);" %)N
201 )))|(((
202 \\
203 )))|(((
204 \\
205 )))|(((
206 \\
207 )))|(((
208 (% style="color: rgb(0,51,102);" %)20141121163017
209 )))|(((
210 \\
211 )))
212 |(((
213 (% style="color: rgb(0,51,102);" %)**14010001843**
214 )))|(((
215 (% style="color: rgb(0,51,102);" %)Susan
216 )))|(((
217 (% style="color: rgb(0,51,102);" %)Kent
218 )))|(((
219 \\
220 )))|(((
221 \\
222 )))|(((
223 \\
224 )))|(((
225 \\
226 )))|(((
227 \\
228 )))|(((
229 (% style="color: rgb(0,51,102);" %)38110 5th St E Apt 1
230 )))|(((
231 \\
232 )))|(((
233 (% style="color: rgb(0,51,102);" %)Los Angeles
234 )))|(((
235 (% style="color: rgb(0,51,102);" %)CA
236 )))|(((
237 (% style="color: rgb(0,51,102);" %)93550
238 )))|(((
239 (% style="color: rgb(0,51,102);" %)2317
240 )))|(((
241 (% style="color: rgb(0,51,102);" %)United States
242 )))|(((
243 \\
244 )))|(((
245 \\
246 )))|(((
247 \\
248 )))|(((
249 (% style="color: rgb(0,51,102);" %)N
250 )))|(((
251 \\
252 )))|(((
253 \\
254 )))|(((
255 \\
256 )))|(((
257 (% style="color: rgb(0,51,102);" %)20141212210537
258 )))|(((
259 \\
260 )))
261 |(((
262 (% style="color: rgb(0,51,102);" %)**14010001858**
263 )))|(((
264 (% style="color: rgb(0,51,102);" %)Brendan
265 )))|(((
266 (% style="color: rgb(0,51,102);" %)Eppley
267 )))|(((
268 \\
269 )))|(((
270 \\
271 )))|(((
272 \\
273 )))|(((
274 \\
275 )))|(((
276 \\
277 )))|(((
278 (% style="color: rgb(0,51,102);" %)20 Driftway Ln
279 )))|(((
280 \\
281 )))|(((
282 (% style="color: rgb(0,51,102);" %)Darien
283 )))|(((
284 (% style="color: rgb(0,51,102);" %)CT
285 )))|(((
286 (% style="color: rgb(0,51,102);" %)6820
287 )))|(((
288 (% style="color: rgb(0,51,102);" %)6130
289 )))|(((
290 (% style="color: rgb(0,51,102);" %)United States
291 )))|(((
292 \\
293 )))|(((
294 \\
295 )))|(((
296 \\
297 )))|(((
298 (% style="color: rgb(0,51,102);" %)N
299 )))|(((
300 \\
301 )))|(((
302 \\
303 )))|(((
304 \\
305 )))|(((
306 (% style="color: rgb(0,51,102);" %)20141211230144
307 )))|(((
308 \\
309 )))
310 |(((
311 (% style="color: rgb(0,51,102);" %)**14010001862**
312 )))|(((
313 \\
314 )))|(((
315 \\
316 )))|(((
317 \\
318 )))|(((
319 \\
320 )))|(((
321 \\
322 )))|(((
323 (% style="color: rgb(0,51,102);" %)Orchard Tree Care Llc
324 )))|(((
325 \\
326 )))|(((
327 (% style="color: rgb(0,51,102);" %)184 Ave
328 )))|(((
329 \\
330 )))|(((
331 (% style="color: rgb(0,51,102);" %)Darien
332 )))|(((
333 (% style="color: rgb(0,51,102);" %)CT
334 )))|(((
335 (% style="color: rgb(0,51,102);" %)6820
336 )))|(((
337 \\
338 )))|(((
339 (% style="color: rgb(0,51,102);" %)United States
340 )))|(((
341 (% style="color: rgb(0,51,102);" %)2036550618
342 )))|(((
343 \\
344 )))|(((
345 \\
346 )))|(((
347 (% style="color: rgb(0,51,102);" %)N
348 )))|(((
349 \\
350 )))|(((
351 \\
352 )))|(((
353 \\
354 )))|(((
355 (% style="color: rgb(0,51,102);" %)20150211133156
356 )))|(((
357 \\
358 )))
359 |(((
360 (% style="color: rgb(0,51,102);" %)**14010001870**
361 )))|(((
362 (% style="color: rgb(0,51,102);" %)Avis Z
363 )))|(((
364 (% style="color: rgb(0,51,102);" %)Gray
365 )))|(((
366 \\
367 )))|(((
368 \\
369 )))|(((
370 \\
371 )))|(((
372 (% style="color: rgb(0,51,102);" %)Designers 5 Incorporated
373 )))|(((
374 (% style="color: rgb(0,51,102);" %)President
375 )))|(((
376 (% style="color: rgb(0,51,102);" %)96 5 Mile River Rd
377 )))|(((
378 \\
379 )))|(((
380 (% style="color: rgb(0,51,102);" %)Darien
381 )))|(((
382 (% style="color: rgb(0,51,102);" %)CT
383 )))|(((
384 (% style="color: rgb(0,51,102);" %)6820
385 )))|(((
386 (% style="color: rgb(0,51,102);" %)6234
387 )))|(((
388 (% style="color: rgb(0,51,102);" %)United States
389 )))|(((
390 (% style="color: rgb(0,51,102);" %)2036552033
391 )))|(((
392 \\
393 )))|(((
394 \\
395 )))|(((
396 (% style="color: rgb(0,51,102);" %)N
397 )))|(((
398 \\
399 )))|(((
400 \\
401 )))|(((
402 \\
403 )))|(((
404 (% style="color: rgb(0,51,102);" %)20150212210227
405 )))|(((
406 \\
407 )))
408 |(((
409 (% style="color: rgb(0,51,102);" %)**14010001889**
410 )))|(((
411 (% style="color: rgb(0,51,102);" %)John
412 )))|(((
413 (% style="color: rgb(0,51,102);" %)Hertz
414 )))|(((
415 \\
416 )))|(((
417 \\
418 )))|(((
419 \\
420 )))|(((
421 (% style="color: rgb(0,51,102);" %)Hertz Construction Co
422 )))|(((
423 (% style="color: rgb(0,51,102);" %)Partner
424 )))|(((
425 (% style="color: rgb(0,51,102);" %)12 Hillside Ave
426 )))|(((
427 \\
428 )))|(((
429 (% style="color: rgb(0,51,102);" %)Darien
430 )))|(((
431 (% style="color: rgb(0,51,102);" %)CT
432 )))|(((
433 (% style="color: rgb(0,51,102);" %)6820
434 )))|(((
435 (% style="color: rgb(0,51,102);" %)5010
436 )))|(((
437 (% style="color: rgb(0,51,102);" %)United States
438 )))|(((
439 (% style="color: rgb(0,51,102);" %)2036564900
440 )))|(((
441 \\
442 )))|(((
443 \\
444 )))|(((
445 (% style="color: rgb(0,51,102);" %)N
446 )))|(((
447 \\
448 )))|(((
449 \\
450 )))|(((
451 \\
452 )))|(((
453 (% style="color: rgb(0,51,102);" %)20141121163018
454 )))|(((
455 \\
456 )))
457 |(((
458 (% style="color: rgb(0,51,102);" %)**14010001891**
459 )))|(((
460 \\
461 )))|(((
462 \\
463 )))|(((
464 \\
465 )))|(((
466 \\
467 )))|(((
468 \\
469 )))|(((
470 (% style="color: rgb(0,51,102);" %)Niche Home Furnishings Ll
471 )))|(((
472 \\
473 )))|(((
474 (% style="color: rgb(0,51,102);" %)25 Old Kings Hwy N Ste 17
475 )))|(((
476 \\
477 )))|(((
478 (% style="color: rgb(0,51,102);" %)Darien
479 )))|(((
480 (% style="color: rgb(0,51,102);" %)CT
481 )))|(((
482 (% style="color: rgb(0,51,102);" %)6820
483 )))|(((
484 (% style="color: rgb(0,51,102);" %)4608
485 )))|(((
486 (% style="color: rgb(0,51,102);" %)United States
487 )))|(((
488 (% style="color: rgb(0,51,102);" %)2036566674
489 )))|(((
490 \\
491 )))|(((
492 \\
493 )))|(((
494 (% style="color: rgb(0,51,102);" %)N
495 )))|(((
496 \\
497 )))|(((
498 \\
499 )))|(((
500 \\
501 )))|(((
502 (% style="color: rgb(0,51,102);" %)20141121163018
503 )))|(((
504 \\
505 )))
506 |(((
507 (% style="color: rgb(0,51,102);" %)**14010001901**
508 )))|(((
509 (% style="color: rgb(0,51,102);" %)Wendy
510 )))|(((
511 (% style="color: rgb(0,51,102);" %)Cole
512 )))|(((
513 \\
514 )))|(((
515 (% style="color: rgb(0,51,102);" %)Ms.
516 )))|(((
517 \\
518 )))|(((
519 (% style="color: rgb(0,51,102);" %)Wendy C Cole Interiors
520 )))|(((
521 (% style="color: rgb(0,51,102);" %)Principal
522 )))|(((
523 (% style="color: rgb(0,51,102);" %)3 Outlook Dr
524 )))|(((
525 \\
526 )))|(((
527 (% style="color: rgb(0,51,102);" %)Darien
528 )))|(((
529 (% style="color: rgb(0,51,102);" %)CT
530 )))|(((
531 (% style="color: rgb(0,51,102);" %)6820
532 )))|(((
533 (% style="color: rgb(0,51,102);" %)5616
534 )))|(((
535 (% style="color: rgb(0,51,102);" %)United States
536 )))|(((
537 (% style="color: rgb(0,51,102);" %)2036552954
538 )))|(((
539 \\
540 )))|(((
541 \\
542 )))|(((
543 (% style="color: rgb(0,51,102);" %)N
544 )))|(((
545 \\
546 )))|(((
547 \\
548 )))|(((
549 \\
550 )))|(((
551 (% style="color: rgb(0,51,102);" %)20150212210227
552 )))|(((
553 \\
554 )))
555 |(((
556 (% style="color: rgb(0,51,102);" %)**14010001917**
557 )))|(((
558 (% style="color: rgb(0,51,102);" %)Frank
559 )))|(((
560 (% style="color: rgb(0,51,102);" %)Stone
561 )))|(((
562 \\
563 )))|(((
564 \\
565 )))|(((
566 \\
567 )))|(((
568 (% style="color: rgb(0,51,102);" %)Stones Landscape
569 )))|(((
570 (% style="color: rgb(0,51,102);" %)Owner
571 )))|(((
572 (% style="color: rgb(0,51,102);" %)258 West Ave
573 )))|(((
574 \\
575 )))|(((
576 (% style="color: rgb(0,51,102);" %)Darien
577 )))|(((
578 (% style="color: rgb(0,51,102);" %)CT
579 )))|(((
580 (% style="color: rgb(0,51,102);" %)6820
581 )))|(((
582 (% style="color: rgb(0,51,102);" %)4111
583 )))|(((
584 (% style="color: rgb(0,51,102);" %)United States
585 )))|(((
586 (% style="color: rgb(0,51,102);" %)2036569674
587 )))|(((
588 \\
589 )))|(((
590 \\
591 )))|(((
592 (% style="color: rgb(0,51,102);" %)N
593 )))|(((
594 \\
595 )))|(((
596 \\
597 )))|(((
598 \\
599 )))|(((
600 (% style="color: rgb(0,51,102);" %)20150212210227
601 )))|(((
602 \\
603 )))
604 |(((
605 (% style="color: rgb(0,51,102);" %)**14010002429**
606 )))|(((
607 (% style="color: rgb(0,51,102);" %)Bruce
608 )))|(((
609 (% style="color: rgb(0,51,102);" %)Pomerance
610 )))|(((
611 \\
612 )))|(((
613 (% style="color: rgb(0,51,102);" %)Mr.
614 )))|(((
615 \\
616 )))|(((
617 (% style="color: rgb(0,51,102);" %)P L V Inc
618 )))|(((
619 (% style="color: rgb(0,51,102);" %)President
620 )))|(((
621 (% style="color: rgb(0,51,102);" %)1076 Post Rd
622 )))|(((
623 \\
624 )))|(((
625 (% style="color: rgb(0,51,102);" %)Darien
626 )))|(((
627 (% style="color: rgb(0,51,102);" %)CT
628 )))|(((
629 (% style="color: rgb(0,51,102);" %)6820
630 )))|(((
631 (% style="color: rgb(0,51,102);" %)5414
632 )))|(((
633 (% style="color: rgb(0,51,102);" %)United States
634 )))|(((
635 (% style="color: rgb(0,51,102);" %)2036554668
636 )))|(((
637 \\
638 )))|(((
639 \\
640 )))|(((
641 (% style="color: rgb(0,51,102);" %)N
642 )))|(((
643 \\
644 )))|(((
645 \\
646 )))|(((
647 \\
648 )))|(((
649 (% style="color: rgb(0,51,102);" %)20150212210227
650 )))|(((
651 \\
652 )))
653 |(((
654 (% style="color: rgb(0,51,102);" %)**14010002438**
655 )))|(((
656 (% style="color: rgb(0,51,102);" %)Joanne
657 )))|(((
658 (% style="color: rgb(0,51,102);" %)Salvatore
659 )))|(((
660 \\
661 )))|(((
662 \\
663 )))|(((
664 \\
665 )))|(((
666 (% style="color: rgb(0,51,102);" %)Nassau Interests Llc
667 )))|(((
668 (% style="color: rgb(0,51,102);" %)Member
669 )))|(((
670 (% style="color: rgb(0,51,102);" %)42 N Meadows Ln
671 )))|(((
672 \\
673 )))|(((
674 (% style="color: rgb(0,51,102);" %)Stamford
675 )))|(((
676 (% style="color: rgb(0,51,102);" %)CT
677 )))|(((
678 (% style="color: rgb(0,51,102);" %)6903
679 )))|(((
680 (% style="color: rgb(0,51,102);" %)5151
681 )))|(((
682 (% style="color: rgb(0,51,102);" %)United States
683 )))|(((
684 (% style="color: rgb(0,51,102);" %)2036550303
685 )))|(((
686 \\
687 )))|(((
688 (% style="color: rgb(0,51,102);" %)[[(% style="color: rgb(0,51,102);" %)__joannesal@aol.com__>>mailto:joannesal@aol.com||style="color: rgb(0,51,102);" shape="rect"]]
689 )))|(((
690 (% style="color: rgb(0,51,102);" %)Y
691 )))|(((
692 \\
693 )))|(((
694 \\
695 )))|(((
696 \\
697 )))|(((
698 (% style="color: rgb(0,51,102);" %)20141212210537
699 )))|(((
700 \\
701 )))
702
703 NOTE: Dates need to be in YYYY-mm-dd format
704
705 Sample File:
706
707 [[demo->>attach:demo-sample.csv]][[sample.csv>>attach:demo-sample.csv]]
708
709 === Transactional Data ===
710
711 Transaction data includes subscriptions, opt-in actions, product purchases, etc. In the case of magazine subscriptions, there is a difference between a Request Date (the date the user subscribed) and the Transaction Date (the date the transaction was entered into the system). In cases where only one date is provided, it will be used as both the Request Date and the Transaction Date.
712
713 There are two main types of transactions, Product Transactions and Package Transactions.  A product is an item, like a coffee cup, a gated content area on a web site, a newsletter subscription, etc. A package is a collection of one or more products and one or more Terms. A Term is a time-period and a price, for example 1 year for $50, 2 years for $75, etc. You can read more about these in other parts of this documentation. The main difference for imports and exports is that Products are imported directly, while Packages are imported by their "Term." Each Package must have at least one term, but Packages can have multiple Terms. Term ID #s are unique across the system, so we use them for importing Package transactions.
714
715 Again, when you import Transaction Data, it is important to import whatever customer or account ID your remote system has for the user so transactions can be mapped appropriately.
716
717 When syncing ONEcount with a remote system like a fulfillment database or e-commerce system on a regular basis, say every day or every week, it is best to import and export both the remote system ID, and the ONEcount ID, or OCID. This will ensure new customers added by either system are handled appropriately.
718
719 This will create the following work-flow:
720
721 (% class="wrapped" %)
722 |=(((
723 Subscriber ID
724 )))|=(((
725 OCID
726 )))|=(((
727 ACTION
728 )))
729 |(((
730 YES
731 )))|(((
732 NO
733 )))|(((
734 User was created by the fulfillment system and is new to ONEcount, create a new record in ONEcount
735 )))
736 |(((
737 NO
738 )))|(((
739 YES
740 )))|(((
741 User was created in ONEcount and is new to the fulfillment system user, create a new record in the fulfillment system
742 )))
743 |(% colspan="1" %)(% colspan="1" %)
744 (((
745 YES
746 )))|(% colspan="1" %)(% colspan="1" %)
747 (((
748 YES
749 )))|(% colspan="1" %)(% colspan="1" %)
750 (((
751 User exists in both systems, update record with incoming data
752 )))
753
754 \\
755
756 === Transaction Data Sample: ===
757
758 (% class="wrapped" %)
759 |(((
760 **SubscriberID**
761 )))|(((
762 **ProductID/code**
763 )))|(((
764 **RequestDate**
765 )))|(((
766 **ExpirationDate**
767 )))|(((
768 **TransactionType**
769 )))|(((
770 **Quantity**
771 )))|(((
772 **Price**
773 )))|(((
774 **SourceCode**
775 )))|(((
776 **StatusCode**
777 )))
778 |(((
779 **14010114326**
780 )))|(((
781 3345
782 )))|(((
783 2015-02-05
784 )))|(((
785 2016-02-05
786 )))|(((
787 N
788 )))|(((
789 1
790 )))|(((
791 15
792 )))|(((
793 \\
794 )))|(((
795 \\
796 )))
797 |(((
798 **14010114326**
799 )))|(((
800 243
801 )))|(((
802 2015-02-04
803 )))|(((
804 2016-02-04
805 )))|(((
806 R
807 )))|(((
808 1
809 )))|(((
810 24.95
811 )))|(((
812 \\
813 )))|(((
814 \\
815 )))
816 |(((
817 **14010114326**
818 )))|(((
819 107
820 )))|(((
821 2015-02-04
822 )))|(((
823 2016-02-04
824 )))|(((
825 R
826 )))|(((
827 1
828 )))|(((
829 13
830 )))|(((
831 \\
832 )))|(((
833 \\
834 )))
835 |(((
836 **14010116098**
837 )))|(((
838 4215
839 )))|(((
840 2015-02-08
841 )))|(((
842 2015-02-08
843 )))|(((
844 U
845 )))|(((
846 1
847 )))|(((
848 \\
849 )))|(((
850 \\
851 )))|(((
852 \\
853 )))
854
855 Transaction type must be one of the following values:
856
857 N - New (includes product purchases)
858
859 R - Renew
860
861 U - Unsubscribe
862
863 Source Code: Source Codes will map to ONEcount Source Codes
864
865 Status Code: This for subscriber status changes (Current Subscriber, Expired, Pended Add, etc.)
866
867 \\
868
869 === Engagement Data ===
870
871 Engagement Data covers a broad range of activities, including banner views and clicks, e-mail opens and clicks, webinar attendance, video plays, etc. The key metric for ALL of these engagement data types is: the user who did it, the date/time of the engagement, and the engagement activity itself (open, click, view, etc.) Other data can be added to these records as well, including the name of the advertiser or banner campaign, the subject of the e-mail campaign, etc.  This data is important to each engagement and can be imported into ONEcount using DExTR.
872
873 Here are a couple of examples:
874
875 ==== **E-Mail Engagement (combined, from Eloqua)** ====
876
877 (% class="wrapped" %)
878 |(((
879 **ActivityDate**
880 )))|(((
881 **ActivityType**
882 )))|(((
883 **AssetId**
884 )))|(((
885 **AssetName**
886 )))|(((
887 **CampaignId**
888 )))|(((
889 **ContactId**
890 )))|(((
891 **EmailAddress**
892 )))|(((
893 **EmailClickedThruLink**
894 )))|(((
895 **EmailRecipientId**
896 )))|(((
897 **ExternalId**
898 )))|(((
899 **SmtpErrorCode**
900 )))|(((
901 **SmtpMessage**
902 )))|(((
903 **SmtpStatusCode**
904 )))|(((
905 **VisitorId**
906 )))
907 |(((
908 \\
909 )))|(((
910 \\
911 )))|(((
912 \\
913 )))|(((
914 \\
915 )))|(((
916 \\
917 )))|(((
918 \\
919 )))|(((
920 \\
921 )))|(((
922 \\
923 )))|(((
924 \\
925 )))|(((
926 \\
927 )))|(((
928 \\
929 )))|(((
930 \\
931 )))|(((
932 \\
933 )))|(((
934 \\
935 )))
936 |(((
937 **
938 **
939 )))|(((
940 \\
941 )))|(((
942 \\
943 )))|(((
944 \\
945 )))|(((
946 \\
947 )))|(((
948 \\
949 )))|(((
950 \\
951 )))|(((
952 \\
953 )))|(((
954 \\
955 )))|(((
956 \\
957 )))|(((
958 \\
959 )))|(((
960 \\
961 )))|(((
962 \\
963 )))|(((
964 \\
965 )))
966 |(((
967 **
968 **
969 )))|(((
970 \\
971 )))|(((
972 \\
973 )))|(((
974 \\
975 )))|(((
976 \\
977 )))|(((
978 \\
979 )))|(((
980 \\
981 )))|(((
982 \\
983 )))|(((
984 \\
985 )))|(((
986 \\
987 )))|(((
988 \\
989 )))|(((
990 \\
991 )))|(((
992 \\
993 )))|(((
994 \\
995 )))
996
997 **ContactID is an Eloqua-specific ID **
998
999 **VisitorID is a custom field in the e-mail system containing the user's GUID from the customer's internal data lake
1000 **
1001
1002 ==== **E-mail Engagement (Split Files)** ====
1003
1004 **email-clicks.csv:**
1005
1006 (% class="wrapped" %)
1007 |(((
1008 **ActivityDate**
1009 )))|(((
1010 **ActivityType**
1011 )))|(((
1012 **MessageID**
1013 )))|(((
1014 **MessageName**
1015 )))|(((
1016 **MessageSubject**
1017 )))|(((
1018 **ListID**
1019 )))|(((
1020 **ListName**
1021 )))|(((
1022 **OCID**
1023 )))|(((
1024 **LinkURL**
1025 )))|(((
1026 **LinkID**
1027 )))|(((
1028 **Firstclick**
1029 )))|(((
1030 **Latestclick**
1031 )))|(((
1032 **clicked**
1033 )))
1034 |(((
1035 \\
1036 )))|(((
1037 \\
1038 )))|(((
1039 \\
1040 )))|(((
1041 \\
1042 )))|(((
1043 \\
1044 )))|(((
1045 \\
1046 )))|(((
1047 \\
1048 )))|(((
1049 \\
1050 )))|(((
1051 \\
1052 )))|(((
1053 \\
1054 )))|(((
1055 \\
1056 )))|(((
1057 \\
1058 )))|(((
1059 \\
1060 )))
1061
1062 **email-opens.csv**
1063
1064 (% class="wrapped" %)
1065 |(((
1066 **ActivityDate**
1067 )))|(((
1068 **ActivityType**
1069 )))|(((
1070 **MessageID**
1071 )))|(((
1072 **MessageName**
1073 )))|(((
1074 **MessageSubject**
1075 )))|(((
1076 **ListID**
1077 )))|(((
1078 **ListName**
1079 )))|(((
1080 **OCID**
1081 )))
1082 |(((
1083 \\
1084 )))|(((
1085 \\
1086 )))|(((
1087 \\
1088 )))|(((
1089 \\
1090 )))|(((
1091 \\
1092 )))|(((
1093 \\
1094 )))|(((
1095 \\
1096 )))|(((
1097 \\
1098 )))
1099
1100 **email-sends.csv**
1101
1102 (% class="wrapped" %)
1103 |(((
1104 **ActivityDate**
1105 )))|(((
1106 **ActivityType**
1107 )))|(((
1108 **MessageID**
1109 )))|(((
1110 **MessageName**
1111 )))|(((
1112 **MessageSubject**
1113 )))|(((
1114 **ListID**
1115 )))|(((
1116 **ListName**
1117 )))|(((
1118 **OCID**
1119 )))
1120 |(((
1121 \\
1122 )))|(((
1123 \\
1124 )))|(((
1125 \\
1126 )))|(((
1127 \\
1128 )))|(((
1129 \\
1130 )))|(((
1131 \\
1132 )))|(((
1133 \\
1134 )))|(((
1135 \\
1136 )))
1137
1138 ==== **BrightCove Data Sample:** ====
1139
1140 (% class="wrapped" %)
1141 |(((
1142 **Contactid**
1143 )))|(((
1144 **Country**
1145 )))|(((
1146 **Createdat**
1147 )))|(((
1148 **Device**
1149 )))|(((
1150 **Id**
1151 )))|(((
1152 **Metriccode**
1153 )))|(((
1154 **Pageurl**
1155 )))|(((
1156 **Playerid**
1157 )))|(((
1158 **Timewatched**
1159 )))|(((
1160 **Updatedat**
1161 )))|(((
1162 **Utmcampaign**
1163 )))|(((
1164 **Utmmedium**
1165 )))|(((
1166 **Utmsource**
1167 )))|(((
1168 **Videoid**
1169 )))|(((
1170 **Videoname**
1171 )))|(((
1172 **Watched**
1173 )))
1174 |(((
1175 **3B07C282-170D-46C4-B8CC-AAADFD**
1176 )))|(((
1177 United States
1178 )))|(((
1179 2021-02-11
1180 )))|(((
1181 desktop
1182 )))|(((
1183 309529
1184 )))|(((
1185 V1
1186 )))|(((
1187 [[__https:~~/~~/preview.CUSTOMER.com/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video__>>url:https://preview.healio.com/cardiology/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video||shape="rect"]]
1188 )))|(((
1189 Sy80k7Mtg
1190 )))|(((
1191 0
1192 )))|(((
1193 2021-02-11
1194 )))|(((
1195 \\
1196 )))|(((
1197 \\
1198 )))|(((
1199 \\
1200 )))|(((
1201 5982181673007
1202 )))|(((
1203 What is symptomatic neurogenic orthostatic hypotension?
1204 )))|(((
1205 0
1206 )))
1207 |(((
1208 **228DA837-9358-43AB-A6E6-DFSF**
1209 )))|(((
1210 United States
1211 )))|(((
1212 2021-01-25
1213 )))|(((
1214 desktop
1215 )))|(((
1216 306311
1217 )))|(((
1218 V1
1219 )))|(((
1220 [[__https:~~/~~/www.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__>>url:https://www.healio.com/endocrinology/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video||shape="rect"]]
1221 )))|(((
1222 Sy80k7Mtg
1223 )))|(((
1224 1
1225 )))|(((
1226 2021-01-25
1227 )))|(((
1228 \\
1229 )))|(((
1230 \\
1231 )))|(((
1232 \\
1233 )))|(((
1234 6171615690004
1235 )))|(((
1236 TED Risk Factors & Symptoms
1237 )))|(((
1238 1
1239 )))
1240 |(((
1241 **1EFC18BF-E9A4-44D9-849F-FDSFS**
1242 )))|(((
1243 United States
1244 )))|(((
1245 2021-01-29
1246 )))|(((
1247 desktop
1248 )))|(((
1249 307009
1250 )))|(((
1251 V1
1252 )))|(((
1253 [[__https:~~/~~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__>>url:https://preview.healio.com/endocrinology/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video||shape="rect"]]
1254 )))|(((
1255 Sy80k7Mtg
1256 )))|(((
1257 1
1258 )))|(((
1259 2021-01-29
1260 )))|(((
1261 \\
1262 )))|(((
1263 \\
1264 )))|(((
1265 \\
1266 )))|(((
1267 6171615690003
1268 )))|(((
1269 TED Risk Factors & Symptoms
1270 )))|(((
1271 1
1272 )))
1273 |(((
1274 **228DA837-9358-43AB-A6E6-DFASFDASF**
1275 )))|(((
1276 United States
1277 )))|(((
1278 2021-02-12
1279 )))|(((
1280 desktop
1281 )))|(((
1282 309633
1283 )))|(((
1284 V1
1285 )))|(((
1286 [[__https:~~/~~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi__>>url:https://preview.healio.com/endocrinology/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi||shape="rect"]]
1287 )))|(((
1288 Sy80k7Mtg
1289 )))|(((
1290 0
1291 )))|(((
1292 2021-02-12
1293 )))|(((
1294 \\
1295 )))|(((
1296 \\
1297 )))|(((
1298 \\
1299 )))|(((
1300 6171632240005
1301 )))|(((
1302 TED Pathophysiology
1303 )))|(((
1304 0
1305 )))
1306 |(((
1307 **5835554F-9B8A-4BA2-BB31-FDSAF**
1308 )))|(((
1309 United States
1310 )))|(((
1311 2021-02-09
1312 )))|(((
1313 desktop
1314 )))|(((
1315 309052
1316 )))|(((
1317 V1
1318 )))|(((
1319 [[__https:~~/~~/www.CUSTOMER.com/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology__>>url:https://www.healio.com/cardiology/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology||shape="rect"]] educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605
1320 )))|(((
1321 Sy80k7Mtg
1322 )))|(((
1323 40
1324 )))|(((
1325 2021-02-09
1326 )))|(((
1327 cardiology educationlab
1328 )))|(((
1329 email
1330 )))|(((
1331 selligent
1332 )))|(((
1333 6185538439007
1334 )))|(((
1335 Chapter 5 — NORTHERA Safety Results
1336 )))|(((
1337 19
1338 )))
1339 |(((
1340 **5835554F-9B8A-4BA2-BB31-68C51F5632F7**
1341 )))|(((
1342 United States
1343 )))|(((
1344 2021-02-09
1345 )))|(((
1346 desktop
1347 )))|(((
1348 309058
1349 )))|(((
1350 V1
1351 )))|(((
1352 [[__https:~~/~~/www.CUSTOMER.com/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology__>>url:https://www.healio.com/cardiology/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology||shape="rect"]] educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605
1353 )))|(((
1354 Sy80k7Mtg
1355 )))|(((
1356 10
1357 )))|(((
1358 2021-02-09
1359 )))|(((
1360 cardiology educationlab
1361 )))|(((
1362 email
1363 )))|(((
1364 selligent
1365 )))|(((
1366 6185538439004
1367 )))|(((
1368 Chapter 5 — NORTHERA Safety Results
1369 )))|(((
1370 5
1371 )))
1372 |(((
1373 **5835554F-9B8A-4BA2-BB31-68C51F5632F7**
1374 )))|(((
1375 United States
1376 )))|(((
1377 2021-02-09
1378 )))|(((
1379 desktop
1380 )))|(((
1381 309064
1382 )))|(((
1383 V1
1384 )))|(((
1385 [[__https:~~/~~/www.CUSTOMER.com/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology__>>url:https://www.healio.com/cardiology/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology||shape="rect"]] educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605
1386 )))|(((
1387 Sy80k7Mtg
1388 )))|(((
1389 30
1390 )))|(((
1391 2021-02-09
1392 )))|(((
1393 cardiology educationlab
1394 )))|(((
1395 email
1396 )))|(((
1397 selligent
1398 )))|(((
1399 6185538439008
1400 )))|(((
1401 Chapter 5 — NORTHERA Safety Results
1402 )))|(((
1403 14
1404 )))
1405
1406 **ContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1407
1408 \\
1409
1410 ==== **Web Impressions** ====
1411
1412 (% class="wrapped" %)
1413 |(((
1414 **VisitContactId**
1415 )))|(((
1416 **EventTime**
1417 )))|(((
1418 **PlatformViewed**
1419 )))|(((
1420 **RefererID**
1421 )))|(((
1422 **SessionId**
1423 )))|(((
1424 **SiteName**
1425 )))|(((
1426 **Url**
1427 )))
1428 |(((
1429 **59DA834C-803E-4C14-9C49-FDSA**
1430 )))|(((
1431 2021-03-09 01:35:12
1432 )))|(((
1433 mobile
1434 )))|(((
1435 \\
1436 )))|(((
1437 2407411196308715909161529690620210309
1438 )))|(((
1439 [[__www.CUSTOMER.com__>>url:http://www.healio.com||shape="rect"]]
1440 )))|(((
1441 [[__http:~~/~~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression||shape="rect"]]
1442 )))
1443 |(((
1444 **D0717BB2-CCDB-4DBE-ADD6-REWQREQW**
1445 )))|(((
1446 2021-03-06 01:43:53
1447 )))|(((
1448 tablet
1449 )))|(((
1450 \\
1451 )))|(((
1452 2419995085411609985161503823320210306
1453 )))|(((
1454 [[__www.CUSTOMER.com__>>url:http://www.healio.com||shape="rect"]]
1455 )))|(((
1456 [[__http:~~/~~/www.hCUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis||shape="rect"]]
1457 )))
1458 |(((
1459 **1AFE97E9-9931-4427-9C4E-VZCXVZ**
1460 )))|(((
1461 2021-02-22 11:04:20
1462 )))|(((
1463 tablet
1464 )))|(((
1465 \\
1466 )))|(((
1467 3663669472315156695161403488520210222
1468 )))|(((
1469 [[__www.CUSTOMER.com__>>url:http://www.healio.com||shape="rect"]]
1470 )))|(((
1471 [[__http:~~/~~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis||shape="rect"]]
1472 )))
1473 |(((
1474 **59DA834C-803E-4C14-9C49-YHDGT**
1475 )))|(((
1476 2021-03-09 01:35:14
1477 )))|(((
1478 mobile
1479 )))|(((
1480 \\
1481 )))|(((
1482 2407411196308715909161529690620210309
1483 )))|(((
1484 [[__wwwCUSTOMER.com__>>url:http://www.healio.com||shape="rect"]]
1485 )))|(((
1486 [[__http:~~/~~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression||shape="rect"]]
1487 )))
1488 |(((
1489 **31C5F8C6-3EFF-4DE7-A899-JGVMHGY**
1490 )))|(((
1491 2021-02-25 05:11:38
1492 )))|(((
1493 mobile
1494 )))|(((
1495 \\
1496 )))|(((
1497 8233752448896666794161427278020210225
1498 )))|(((
1499 [[__www.CUSTOMER.com__>>url:http://www.healio.com||shape="rect"]]
1500 )))|(((
1501 [[__http:~~/~~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d||shape="rect"]]
1502 )))
1503 |(((
1504 **68E8551F-AD4E-4AAF-B4E6-RTSDFSAFA**
1505 )))|(((
1506 2021-03-15 09:57:00
1507 )))|(((
1508 desktop
1509 )))|(((
1510 \\
1511 )))|(((
1512 \\
1513 )))|(((
1514 [[__www.CUSTOMER.com__>>url:http://www.healio.com||shape="rect"]]
1515 )))|(((
1516 [[__http:~~/~~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~~~~contactid~~~~__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~~contactid~~||shape="rect"]]
1517 )))
1518
1519 **VisitContactID is a GUID assigned by the Customer's Internal Data Warehouse**