Wiki source code of DExTr Import Files

Version 4.1 by Admin on 2022/09/19 12:40
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 \\
1139
1140 === LiveIntent Data Sample: ===
1141
1142 |(((
1143 **Liveintentuserid**
1144 )))|(((
1145 **Advertiserid**
1146 )))|(((
1147 **Campaignid**
1148 )))|(((
1149 **Creativeid**
1150 )))|(((
1151 **Devtype**
1152 )))|(((
1153 **Emailasmdfive**
1154 )))|(((
1155 **Eventtype**
1156 )))|(((
1157 **Lineitemid**
1158 )))|(((
1159 **Liveintentdecisionid**
1160 )))|(((
1161 **Publisherid**
1162 )))|(((
1163 **Sectionid**
1164 )))|(((
1165 **Templateid**
1166 )))|(((
1167 **Timestamp**
1168 )))
1169 |(((
1170 **28427698**
1171 )))|(((
1172 39771
1173 )))|(((
1174 246944
1175 )))|(((
1176 787604
1177 )))|(((
1178 PC
1179 )))|(((
1180 d57dccaadbba6c4ad8f143de8c571771
1181 )))|(((
1182 impression
1183 )))|(((
1184 10001043
1185 )))|(((
1186 66233848-4580-3d7f-92b2-beb4741e8f7
1187 )))|(((
1188 36479
1189 )))|(((
1190 253729
1191 )))|(((
1192 19263
1193 )))|(((
1194 2021-03-10
1195 )))
1196 |(((
1197 **28422453**
1198 )))|(((
1199 39771
1200 )))|(((
1201 246944
1202 )))|(((
1203 787604
1204 )))|(((
1205 PC
1206 )))|(((
1207 2dece7448530fdf799254a875ebe0a77
1208 )))|(((
1209 impression
1210 )))|(((
1211 10001043
1212 )))|(((
1213 b8c41396-b896-333d-9945-522c21174e2
1214 )))|(((
1215 36479
1216 )))|(((
1217 277132
1218 )))|(((
1219 19263
1220 )))|(((
1221 2021-03-10
1222 )))
1223 |(((
1224 **28421392**
1225 )))|(((
1226 39771
1227 )))|(((
1228 246944
1229 )))|(((
1230 787604
1231 )))|(((
1232 PC
1233 )))|(((
1234 a4c0388d679348e467d27391b3fd456c
1235 )))|(((
1236 impression
1237 )))|(((
1238 10001043
1239 )))|(((
1240 844ebc51-0a02-3783-99c8-8ac96a29bc3
1241 )))|(((
1242 36479
1243 )))|(((
1244 277132
1245 )))|(((
1246 19263
1247 )))|(((
1248 2021-03-10
1249 )))
1250 |(((
1251 **28499279**
1252 )))|(((
1253 39771
1254 )))|(((
1255 246944
1256 )))|(((
1257 787604
1258 )))|(((
1259 PC
1260 )))|(((
1261 96032eb8da86e394b23c2a9647477d66
1262 )))|(((
1263 impression
1264 )))|(((
1265 10001043
1266 )))|(((
1267 69a0d6fd-7cb3-301d-b24a-04144d9ec74
1268 )))|(((
1269 36479
1270 )))|(((
1271 253729
1272 )))|(((
1273 19263
1274 )))|(((
1275 2021-03-10
1276 )))
1277 |(((
1278 **28421344**
1279 )))|(((
1280 39771
1281 )))|(((
1282 246944
1283 )))|(((
1284 787604
1285 )))|(((
1286 PC
1287 )))|(((
1288 fd2d53dbe2e7aa2198c19afce5a35cc6
1289 )))|(((
1290 impression
1291 )))|(((
1292 10001043
1293 )))|(((
1294 75c72eca-6cf1-3144-b00c-04ca49471363
1295 )))|(((
1296 36479
1297 )))|(((
1298 253729
1299 )))|(((
1300 19263
1301 )))|(((
1302 2021-03-10
1303 )))
1304
1305 \\
1306
1307 ==== **BrightCove Data Sample:** ====
1308
1309 (% class="wrapped" %)
1310 |(((
1311 **Contactid**
1312 )))|(((
1313 **Country**
1314 )))|(((
1315 **Createdat**
1316 )))|(((
1317 **Device**
1318 )))|(((
1319 **Id**
1320 )))|(((
1321 **Metriccode**
1322 )))|(((
1323 **Pageurl**
1324 )))|(((
1325 **Playerid**
1326 )))|(((
1327 **Timewatched**
1328 )))|(((
1329 **Updatedat**
1330 )))|(((
1331 **Utmcampaign**
1332 )))|(((
1333 **Utmmedium**
1334 )))|(((
1335 **Utmsource**
1336 )))|(((
1337 **Videoid**
1338 )))|(((
1339 **Videoname**
1340 )))|(((
1341 **Watched**
1342 )))
1343 |(((
1344 **3B07C282-170D-46C4-B8CC-AAADFD**
1345 )))|(((
1346 United States
1347 )))|(((
1348 2021-02-11
1349 )))|(((
1350 desktop
1351 )))|(((
1352 309529
1353 )))|(((
1354 V1
1355 )))|(((
1356 __https:~/~/preview.CUSTOMER.com/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video__
1357 )))|(((
1358 Sy80k7Mtg
1359 )))|(((
1360 0
1361 )))|(((
1362 2021-02-11
1363 )))|(((
1364 \\
1365 )))|(((
1366 \\
1367 )))|(((
1368 \\
1369 )))|(((
1370 5982181673007
1371 )))|(((
1372 What is symptomatic neurogenic orthostatic hypotension?
1373 )))|(((
1374 0
1375 )))
1376 |(((
1377 **228DA837-9358-43AB-A6E6-DFSF**
1378 )))|(((
1379 United States
1380 )))|(((
1381 2021-01-25
1382 )))|(((
1383 desktop
1384 )))|(((
1385 306311
1386 )))|(((
1387 V1
1388 )))|(((
1389 __https:~/~/www.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1390 )))|(((
1391 Sy80k7Mtg
1392 )))|(((
1393 1
1394 )))|(((
1395 2021-01-25
1396 )))|(((
1397 \\
1398 )))|(((
1399 \\
1400 )))|(((
1401 \\
1402 )))|(((
1403 6171615690004
1404 )))|(((
1405 TED Risk Factors & Symptoms
1406 )))|(((
1407 1
1408 )))
1409 |(((
1410 **1EFC18BF-E9A4-44D9-849F-FDSFS**
1411 )))|(((
1412 United States
1413 )))|(((
1414 2021-01-29
1415 )))|(((
1416 desktop
1417 )))|(((
1418 307009
1419 )))|(((
1420 V1
1421 )))|(((
1422 __https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1423 )))|(((
1424 Sy80k7Mtg
1425 )))|(((
1426 1
1427 )))|(((
1428 2021-01-29
1429 )))|(((
1430 \\
1431 )))|(((
1432 \\
1433 )))|(((
1434 \\
1435 )))|(((
1436 6171615690003
1437 )))|(((
1438 TED Risk Factors & Symptoms
1439 )))|(((
1440 1
1441 )))
1442 |(((
1443 **228DA837-9358-43AB-A6E6-DFASFDASF**
1444 )))|(((
1445 United States
1446 )))|(((
1447 2021-02-12
1448 )))|(((
1449 desktop
1450 )))|(((
1451 309633
1452 )))|(((
1453 V1
1454 )))|(((
1455 __https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi__
1456 )))|(((
1457 Sy80k7Mtg
1458 )))|(((
1459 0
1460 )))|(((
1461 2021-02-12
1462 )))|(((
1463 \\
1464 )))|(((
1465 \\
1466 )))|(((
1467 \\
1468 )))|(((
1469 6171632240005
1470 )))|(((
1471 TED Pathophysiology
1472 )))|(((
1473 0
1474 )))
1475 |(((
1476 **5835554F-9B8A-4BA2-BB31-FDSAF**
1477 )))|(((
1478 United States
1479 )))|(((
1480 2021-02-09
1481 )))|(((
1482 desktop
1483 )))|(((
1484 309052
1485 )))|(((
1486 V1
1487 )))|(((
1488 __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__ educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605
1489 )))|(((
1490 Sy80k7Mtg
1491 )))|(((
1492 40
1493 )))|(((
1494 2021-02-09
1495 )))|(((
1496 cardiology educationlab
1497 )))|(((
1498 email
1499 )))|(((
1500 selligent
1501 )))|(((
1502 6185538439007
1503 )))|(((
1504 Chapter 5 — NORTHERA Safety Results
1505 )))|(((
1506 19
1507 )))
1508 |(((
1509 **5835554F-9B8A-4BA2-BB31-68C51F5632F7**
1510 )))|(((
1511 United States
1512 )))|(((
1513 2021-02-09
1514 )))|(((
1515 desktop
1516 )))|(((
1517 309058
1518 )))|(((
1519 V1
1520 )))|(((
1521 __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__ educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605
1522 )))|(((
1523 Sy80k7Mtg
1524 )))|(((
1525 10
1526 )))|(((
1527 2021-02-09
1528 )))|(((
1529 cardiology educationlab
1530 )))|(((
1531 email
1532 )))|(((
1533 selligent
1534 )))|(((
1535 6185538439004
1536 )))|(((
1537 Chapter 5 — NORTHERA Safety Results
1538 )))|(((
1539 5
1540 )))
1541 |(((
1542 **5835554F-9B8A-4BA2-BB31-68C51F5632F7**
1543 )))|(((
1544 United States
1545 )))|(((
1546 2021-02-09
1547 )))|(((
1548 desktop
1549 )))|(((
1550 309064
1551 )))|(((
1552 V1
1553 )))|(((
1554 __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__ educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605
1555 )))|(((
1556 Sy80k7Mtg
1557 )))|(((
1558 30
1559 )))|(((
1560 2021-02-09
1561 )))|(((
1562 cardiology educationlab
1563 )))|(((
1564 email
1565 )))|(((
1566 selligent
1567 )))|(((
1568 6185538439008
1569 )))|(((
1570 Chapter 5 — NORTHERA Safety Results
1571 )))|(((
1572 14
1573 )))
1574
1575 **ContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1576
1577 \\
1578
1579 ==== **Raw Web Impressions** ====
1580
1581 (% class="wrapped" %)
1582 |(((
1583 **VisitContactId**
1584 )))|(((
1585 **EventTime**
1586 )))|(((
1587 **PlatformViewed**
1588 )))|(((
1589 **RefererID**
1590 )))|(((
1591 **SessionId**
1592 )))|(((
1593 **SiteName**
1594 )))|(((
1595 **Url**
1596 )))
1597 |(((
1598 **59DA834C-803E-4C14-9C49-FDSA**
1599 )))|(((
1600 2021-03-09 01:35:12
1601 )))|(((
1602 mobile
1603 )))|(((
1604 \\
1605 )))|(((
1606 2407411196308715909161529690620210309
1607 )))|(((
1608 __www.CUSTOMER.com__
1609 )))|(((
1610 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1611 )))
1612 |(((
1613 **D0717BB2-CCDB-4DBE-ADD6-REWQREQW**
1614 )))|(((
1615 2021-03-06 01:43:53
1616 )))|(((
1617 tablet
1618 )))|(((
1619 \\
1620 )))|(((
1621 2419995085411609985161503823320210306
1622 )))|(((
1623 __www.CUSTOMER.com__
1624 )))|(((
1625 __http:~/~/www.hCUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1626 )))
1627 |(((
1628 **1AFE97E9-9931-4427-9C4E-VZCXVZ**
1629 )))|(((
1630 2021-02-22 11:04:20
1631 )))|(((
1632 tablet
1633 )))|(((
1634 \\
1635 )))|(((
1636 3663669472315156695161403488520210222
1637 )))|(((
1638 __www.CUSTOMER.com__
1639 )))|(((
1640 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1641 )))
1642 |(((
1643 **59DA834C-803E-4C14-9C49-YHDGT**
1644 )))|(((
1645 2021-03-09 01:35:14
1646 )))|(((
1647 mobile
1648 )))|(((
1649 \\
1650 )))|(((
1651 2407411196308715909161529690620210309
1652 )))|(((
1653 __wwwCUSTOMER.com__
1654 )))|(((
1655 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1656 )))
1657 |(((
1658 **31C5F8C6-3EFF-4DE7-A899-JGVMHGY**
1659 )))|(((
1660 2021-02-25 05:11:38
1661 )))|(((
1662 mobile
1663 )))|(((
1664 \\
1665 )))|(((
1666 8233752448896666794161427278020210225
1667 )))|(((
1668 __www.CUSTOMER.com__
1669 )))|(((
1670 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d__
1671 )))
1672 |(((
1673 **68E8551F-AD4E-4AAF-B4E6-RTSDFSAFA**
1674 )))|(((
1675 2021-03-15 09:57:00
1676 )))|(((
1677 desktop
1678 )))|(((
1679 \\
1680 )))|(((
1681 \\
1682 )))|(((
1683 __www.CUSTOMER.com__
1684 )))|(((
1685 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~~contactid~~__
1686 )))
1687
1688 **VisitContactID is a GUID assigned by the Customer's Internal Data Warehouse**