Wiki source code of DExTr Import Files

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