Wiki source code of DExTr Import Files

Version 5.1 by Admin on 2022/09/19 14:01
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 (See FULFILLEMENT SAMPLE below), 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 === Transaction Data Sample: ===
755
756 (% class="wrapped" %)
757 |(((
758 **SubscriberID**
759 )))|(((
760 **ProductID/code**
761 )))|(((
762 **RequestDate**
763 )))|(((
764 **ExpirationDate**
765 )))|(((
766 **TransactionType**
767 )))|(((
768 **Quantity**
769 )))|(((
770 **Price**
771 )))|(((
772 **SourceCode**
773 )))|(((
774 **StatusCode**
775 )))
776 |(((
777 **14010114326**
778 )))|(((
779 3345
780 )))|(((
781 2015-02-05
782 )))|(((
783 2016-02-05
784 )))|(((
785 N
786 )))|(((
787 1
788 )))|(((
789 15
790 )))|(((
791 \\
792 )))|(((
793 \\
794 )))
795 |(((
796 **14010114326**
797 )))|(((
798 243
799 )))|(((
800 2015-02-04
801 )))|(((
802 2016-02-04
803 )))|(((
804 R
805 )))|(((
806 1
807 )))|(((
808 24.95
809 )))|(((
810 \\
811 )))|(((
812 \\
813 )))
814 |(((
815 **14010114326**
816 )))|(((
817 107
818 )))|(((
819 2015-02-04
820 )))|(((
821 2016-02-04
822 )))|(((
823 R
824 )))|(((
825 1
826 )))|(((
827 13
828 )))|(((
829 \\
830 )))|(((
831 \\
832 )))
833 |(((
834 **14010116098**
835 )))|(((
836 4215
837 )))|(((
838 2015-02-08
839 )))|(((
840 2015-02-08
841 )))|(((
842 U
843 )))|(((
844 1
845 )))|(((
846 \\
847 )))|(((
848 \\
849 )))|(((
850 \\
851 )))
852
853 Transaction type must be one of the following values:
854
855 N - New (includes product purchases)
856
857 R - Renew
858
859 U - Unsubscribe
860
861 Source Code: Source Codes will map to ONEcount Source Codes
862
863 Status Code: This for subscriber status changes (Current Subscriber, Expired, Pended Add, etc.)
864
865 === Fulfillment Sample: Advantage/Omeda/PCS/CDS ===
866
867 |(((
868 **PUBCDE**
869 )))|(((
870 **CUSTNUMB**
871 )))|(% colspan="1" %)(% colspan="1" %)
872 (((
873 OCID
874 )))|(((
875 **CRCSTS**
876 )))|(((
877 **FIRST**
878 )))|(((
879 **LAST**
880 )))|(((
881 **COMPANY**
882 )))|(((
883 **ADD1**
884 )))|(((
885 **ADD2**
886 )))|(((
887 **CITY**
888 )))|(((
889 **ZIPCDE**
890 )))|(((
891 **STATE**
892 )))|(((
893 **ADRCDE**
894 )))|(((
895 **KEYCDE**
896 )))|(((
897 **QUALSRC**
898 )))|(((
899 **EMAIL**
900 )))|(((
901 **CTMDTE**
902 )))|(((
903 **FINDTE**
904 )))|(((
905 **PHONE**
906 )))|(((
907 **LISTIND**
908 )))|(((
909 **County**
910 )))|(((
911 **COUNTRY**
912 )))
913 |(((
914 **AAI**
915 )))|(((
916 404304
917 )))|(% colspan="1" %)(% colspan="1" %)
918 (((
919 33675
920 )))|(((
921 E
922 )))|(((
923 FRED
924 )))|(((
925 SMITH
926 )))|(((
927 \\
928 )))|(((
929 57 CHURCH ST
930 )))|(((
931 \\
932 )))|(((
933 ROXBURY
934 )))|(((
935 67831704
936 )))|(((
937 CT
938 )))|(((
939 M
940 )))|(((
941 TREN68B
942 )))|(((
943 5F
944 )))|(((
945 \\
946 )))|(((
947 20161205
948 )))|(((
949 20190101
950 )))|(((
951 8005551234
952 )))|(((
953 NONACTIVE
954 )))|(((
955 LITCHFIELD
956 )))|(((
957 USA
958 )))
959 |(((
960 **AIB**
961 )))|(((
962 445771
963 )))|(% colspan="1" %)(% colspan="1" %)
964 (((
965 \\
966 )))|(((
967 Q
968 )))|(((
969 JOSEPH
970 )))|(((
971 JONES
972 )))|(((
973 JONES & CO
974 )))|(((
975 7632 WILDCAT PIKE
976 )))|(((
977 \\
978 )))|(((
979 NEW BLOOMINGTON
980 )))|(((
981 433419532
982 )))|(((
983 OH
984 )))|(((
985 M
986 )))|(((
987 E3CC1220
988 )))|(((
989 5F
990 )))|(((
991 [[__JMBUCKOHIO@AOL.COM__>>mailto:JMBUCKOHIO@AOL.COM||shape="rect"]]
992 )))|(((
993 20201201
994 )))|(((
995 20231201
996 )))|(((
997 9546783214
998 )))|(((
999 QUAL
1000 )))|(((
1001 MARION
1002 )))|(((
1003 USA
1004 )))
1005 |(((
1006 **AXW**
1007 )))|(((
1008 \\
1009 )))|(% colspan="1" %)(% colspan="1" %)
1010 (((
1011 3324
1012 )))|(((
1013 G
1014 )))|(((
1015 MARK
1016 )))|(((
1017 ROBERTS
1018 )))|(((
1019 TRF Inc.
1020 )))|(((
1021 5201 WOODWARD AVE
1022 )))|(((
1023 \\
1024 )))|(((
1025 DETROIT
1026 )))|(((
1027 482024093
1028 )))|(((
1029 MI
1030 )))|(((
1031 M
1032 )))|(((
1033 RRT6GT
1034 )))|(((
1035 1A
1036 )))|(((
1037 \\
1038 )))|(((
1039 20201207
1040 )))|(((
1041 20210401
1042 )))|(((
1043 \\
1044 )))|(((
1045 PAID
1046 )))|(((
1047 WAYNE
1048 )))|(((
1049 USA
1050 )))
1051
1052 **PUBCODE maps to Package TERM**
1053
1054 \\
1055
1056 === Engagement Data ===
1057
1058 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.
1059
1060 Here are a couple of examples:
1061
1062 ==== **E-Mail Engagement (combined, from Eloqua)** ====
1063
1064 (% class="wrapped" %)
1065 |(((
1066 **ActivityDate**
1067 )))|(((
1068 **ActivityType**
1069 )))|(((
1070 **AssetId**
1071 )))|(((
1072 **AssetName**
1073 )))|(((
1074 **CampaignId**
1075 )))|(((
1076 **ContactId**
1077 )))|(((
1078 **EmailAddress**
1079 )))|(((
1080 **EmailClickedThruLink**
1081 )))|(((
1082 **EmailRecipientId**
1083 )))|(((
1084 **ExternalId**
1085 )))|(((
1086 **SmtpErrorCode**
1087 )))|(((
1088 **SmtpMessage**
1089 )))|(((
1090 **SmtpStatusCode**
1091 )))|(((
1092 **VisitorId**
1093 )))
1094 |(((
1095 \\
1096 )))|(((
1097 \\
1098 )))|(((
1099 \\
1100 )))|(((
1101 \\
1102 )))|(((
1103 \\
1104 )))|(((
1105 \\
1106 )))|(((
1107 \\
1108 )))|(((
1109 \\
1110 )))|(((
1111 \\
1112 )))|(((
1113 \\
1114 )))|(((
1115 \\
1116 )))|(((
1117 \\
1118 )))|(((
1119 \\
1120 )))|(((
1121 \\
1122 )))
1123 |(((
1124 **
1125 **
1126 )))|(((
1127 \\
1128 )))|(((
1129 \\
1130 )))|(((
1131 \\
1132 )))|(((
1133 \\
1134 )))|(((
1135 \\
1136 )))|(((
1137 \\
1138 )))|(((
1139 \\
1140 )))|(((
1141 \\
1142 )))|(((
1143 \\
1144 )))|(((
1145 \\
1146 )))|(((
1147 \\
1148 )))|(((
1149 \\
1150 )))|(((
1151 \\
1152 )))
1153 |(((
1154 **
1155 **
1156 )))|(((
1157 \\
1158 )))|(((
1159 \\
1160 )))|(((
1161 \\
1162 )))|(((
1163 \\
1164 )))|(((
1165 \\
1166 )))|(((
1167 \\
1168 )))|(((
1169 \\
1170 )))|(((
1171 \\
1172 )))|(((
1173 \\
1174 )))|(((
1175 \\
1176 )))|(((
1177 \\
1178 )))|(((
1179 \\
1180 )))|(((
1181 \\
1182 )))
1183
1184 **ContactID is an Eloqua-specific ID **
1185
1186 **VisitorID is a custom field in the e-mail system containing the user's GUID from the customer's internal data lake
1187 **
1188
1189 ==== **E-mail Engagement (Split Files)** ====
1190
1191 **email-clicks.csv:**
1192
1193 (% class="wrapped" %)
1194 |(((
1195 **ActivityDate**
1196 )))|(((
1197 **ActivityType**
1198 )))|(((
1199 **MessageID**
1200 )))|(((
1201 **MessageName**
1202 )))|(((
1203 **MessageSubject**
1204 )))|(((
1205 **ListID**
1206 )))|(((
1207 **ListName**
1208 )))|(((
1209 **OCID**
1210 )))|(((
1211 **LinkURL**
1212 )))|(((
1213 **LinkID**
1214 )))|(((
1215 **Firstclick**
1216 )))|(((
1217 **Latestclick**
1218 )))|(((
1219 **clicked**
1220 )))
1221 |(((
1222 \\
1223 )))|(((
1224 \\
1225 )))|(((
1226 \\
1227 )))|(((
1228 \\
1229 )))|(((
1230 \\
1231 )))|(((
1232 \\
1233 )))|(((
1234 \\
1235 )))|(((
1236 \\
1237 )))|(((
1238 \\
1239 )))|(((
1240 \\
1241 )))|(((
1242 \\
1243 )))|(((
1244 \\
1245 )))|(((
1246 \\
1247 )))
1248
1249 **email-opens.csv**
1250
1251 (% class="wrapped" %)
1252 |(((
1253 **ActivityDate**
1254 )))|(((
1255 **ActivityType**
1256 )))|(((
1257 **MessageID**
1258 )))|(((
1259 **MessageName**
1260 )))|(((
1261 **MessageSubject**
1262 )))|(((
1263 **ListID**
1264 )))|(((
1265 **ListName**
1266 )))|(((
1267 **OCID**
1268 )))
1269 |(((
1270 \\
1271 )))|(((
1272 \\
1273 )))|(((
1274 \\
1275 )))|(((
1276 \\
1277 )))|(((
1278 \\
1279 )))|(((
1280 \\
1281 )))|(((
1282 \\
1283 )))|(((
1284 \\
1285 )))
1286
1287 **email-sends.csv**
1288
1289 (% class="wrapped" %)
1290 |(((
1291 **ActivityDate**
1292 )))|(((
1293 **ActivityType**
1294 )))|(((
1295 **MessageID**
1296 )))|(((
1297 **MessageName**
1298 )))|(((
1299 **MessageSubject**
1300 )))|(((
1301 **ListID**
1302 )))|(((
1303 **ListName**
1304 )))|(((
1305 **OCID**
1306 )))
1307 |(((
1308 \\
1309 )))|(((
1310 \\
1311 )))|(((
1312 \\
1313 )))|(((
1314 \\
1315 )))|(((
1316 \\
1317 )))|(((
1318 \\
1319 )))|(((
1320 \\
1321 )))|(((
1322 \\
1323 )))
1324
1325 \\
1326
1327 ==== LiveIntent Data Sample: ====
1328
1329 (% class="wrapped" %)
1330 |(((
1331 **Liveintentuserid**
1332 )))|(((
1333 **Advertiserid**
1334 )))|(((
1335 **Campaignid**
1336 )))|(((
1337 **Creativeid**
1338 )))|(((
1339 **Devtype**
1340 )))|(((
1341 **Emailasmdfive**
1342 )))|(((
1343 **Eventtype**
1344 )))|(((
1345 **Lineitemid**
1346 )))|(((
1347 **Liveintentdecisionid**
1348 )))|(((
1349 **Publisherid**
1350 )))|(((
1351 **Sectionid**
1352 )))|(((
1353 **Templateid**
1354 )))|(((
1355 **Timestamp**
1356 )))
1357 |(((
1358 **28427698**
1359 )))|(((
1360 39771
1361 )))|(((
1362 246944
1363 )))|(((
1364 787604
1365 )))|(((
1366 PC
1367 )))|(((
1368 d57dccaadbba6c4ad8f143de8c571771
1369 )))|(((
1370 impression
1371 )))|(((
1372 10001043
1373 )))|(((
1374 66233848-4580-3d7f-92b2-beb4741e8f7
1375 )))|(((
1376 36479
1377 )))|(((
1378 253729
1379 )))|(((
1380 19263
1381 )))|(((
1382 2021-03-10
1383 )))
1384 |(((
1385 **28422453**
1386 )))|(((
1387 39771
1388 )))|(((
1389 246944
1390 )))|(((
1391 787604
1392 )))|(((
1393 PC
1394 )))|(((
1395 2dece7448530fdf799254a875ebe0a77
1396 )))|(((
1397 impression
1398 )))|(((
1399 10001043
1400 )))|(((
1401 b8c41396-b896-333d-9945-522c21174e2
1402 )))|(((
1403 36479
1404 )))|(((
1405 277132
1406 )))|(((
1407 19263
1408 )))|(((
1409 2021-03-10
1410 )))
1411 |(((
1412 **28421392**
1413 )))|(((
1414 39771
1415 )))|(((
1416 246944
1417 )))|(((
1418 787604
1419 )))|(((
1420 PC
1421 )))|(((
1422 a4c0388d679348e467d27391b3fd456c
1423 )))|(((
1424 impression
1425 )))|(((
1426 10001043
1427 )))|(((
1428 844ebc51-0a02-3783-99c8-8ac96a29bc3
1429 )))|(((
1430 36479
1431 )))|(((
1432 277132
1433 )))|(((
1434 19263
1435 )))|(((
1436 2021-03-10
1437 )))
1438 |(((
1439 **28499279**
1440 )))|(((
1441 39771
1442 )))|(((
1443 246944
1444 )))|(((
1445 787604
1446 )))|(((
1447 PC
1448 )))|(((
1449 96032eb8da86e394b23c2a9647477d66
1450 )))|(((
1451 impression
1452 )))|(((
1453 10001043
1454 )))|(((
1455 69a0d6fd-7cb3-301d-b24a-04144d9ec74
1456 )))|(((
1457 36479
1458 )))|(((
1459 253729
1460 )))|(((
1461 19263
1462 )))|(((
1463 2021-03-10
1464 )))
1465 |(((
1466 **28421344**
1467 )))|(((
1468 39771
1469 )))|(((
1470 246944
1471 )))|(((
1472 787604
1473 )))|(((
1474 PC
1475 )))|(((
1476 fd2d53dbe2e7aa2198c19afce5a35cc6
1477 )))|(((
1478 impression
1479 )))|(((
1480 10001043
1481 )))|(((
1482 75c72eca-6cf1-3144-b00c-04ca49471363
1483 )))|(((
1484 36479
1485 )))|(((
1486 253729
1487 )))|(((
1488 19263
1489 )))|(((
1490 2021-03-10
1491 )))
1492
1493 \\
1494
1495 ==== **BrightCove Data Sample:** ====
1496
1497 (% class="wrapped" %)
1498 |(((
1499 **Contactid**
1500 )))|(((
1501 **Country**
1502 )))|(((
1503 **Createdat**
1504 )))|(((
1505 **Device**
1506 )))|(((
1507 **Id**
1508 )))|(((
1509 **Metriccode**
1510 )))|(((
1511 **Pageurl**
1512 )))|(((
1513 **Playerid**
1514 )))|(((
1515 **Timewatched**
1516 )))|(((
1517 **Updatedat**
1518 )))|(((
1519 **Utmcampaign**
1520 )))|(((
1521 **Utmmedium**
1522 )))|(((
1523 **Utmsource**
1524 )))|(((
1525 **Videoid**
1526 )))|(((
1527 **Videoname**
1528 )))|(((
1529 **Watched**
1530 )))
1531 |(((
1532 **3B07C282-170D-46C4-B8CC-AAADFD**
1533 )))|(((
1534 United States
1535 )))|(((
1536 2021-02-11
1537 )))|(((
1538 desktop
1539 )))|(((
1540 309529
1541 )))|(((
1542 V1
1543 )))|(((
1544 __https:~/~/preview.CUSTOMER.com/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video__
1545 )))|(((
1546 Sy80k7Mtg
1547 )))|(((
1548 0
1549 )))|(((
1550 2021-02-11
1551 )))|(((
1552 \\
1553 )))|(((
1554 \\
1555 )))|(((
1556 \\
1557 )))|(((
1558 5982181673007
1559 )))|(((
1560 What is symptomatic neurogenic orthostatic hypotension?
1561 )))|(((
1562 0
1563 )))
1564 |(((
1565 **228DA837-9358-43AB-A6E6-DFSF**
1566 )))|(((
1567 United States
1568 )))|(((
1569 2021-01-25
1570 )))|(((
1571 desktop
1572 )))|(((
1573 306311
1574 )))|(((
1575 V1
1576 )))|(((
1577 __https:~/~/www.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1578 )))|(((
1579 Sy80k7Mtg
1580 )))|(((
1581 1
1582 )))|(((
1583 2021-01-25
1584 )))|(((
1585 \\
1586 )))|(((
1587 \\
1588 )))|(((
1589 \\
1590 )))|(((
1591 6171615690004
1592 )))|(((
1593 TED Risk Factors & Symptoms
1594 )))|(((
1595 1
1596 )))
1597 |(((
1598 **1EFC18BF-E9A4-44D9-849F-FDSFS**
1599 )))|(((
1600 United States
1601 )))|(((
1602 2021-01-29
1603 )))|(((
1604 desktop
1605 )))|(((
1606 307009
1607 )))|(((
1608 V1
1609 )))|(((
1610 __https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1611 )))|(((
1612 Sy80k7Mtg
1613 )))|(((
1614 1
1615 )))|(((
1616 2021-01-29
1617 )))|(((
1618 \\
1619 )))|(((
1620 \\
1621 )))|(((
1622 \\
1623 )))|(((
1624 6171615690003
1625 )))|(((
1626 TED Risk Factors & Symptoms
1627 )))|(((
1628 1
1629 )))
1630 |(((
1631 **228DA837-9358-43AB-A6E6-DFASFDASF**
1632 )))|(((
1633 United States
1634 )))|(((
1635 2021-02-12
1636 )))|(((
1637 desktop
1638 )))|(((
1639 309633
1640 )))|(((
1641 V1
1642 )))|(((
1643 __https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi__
1644 )))|(((
1645 Sy80k7Mtg
1646 )))|(((
1647 0
1648 )))|(((
1649 2021-02-12
1650 )))|(((
1651 \\
1652 )))|(((
1653 \\
1654 )))|(((
1655 \\
1656 )))|(((
1657 6171632240005
1658 )))|(((
1659 TED Pathophysiology
1660 )))|(((
1661 0
1662 )))
1663 |(((
1664 **5835554F-9B8A-4BA2-BB31-FDSAF**
1665 )))|(((
1666 United States
1667 )))|(((
1668 2021-02-09
1669 )))|(((
1670 desktop
1671 )))|(((
1672 309052
1673 )))|(((
1674 V1
1675 )))|(((
1676 __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
1677 )))|(((
1678 Sy80k7Mtg
1679 )))|(((
1680 40
1681 )))|(((
1682 2021-02-09
1683 )))|(((
1684 cardiology educationlab
1685 )))|(((
1686 email
1687 )))|(((
1688 selligent
1689 )))|(((
1690 6185538439007
1691 )))|(((
1692 Chapter 5 — NORTHERA Safety Results
1693 )))|(((
1694 19
1695 )))
1696 |(((
1697 **5835554F-9B8A-4BA2-BB31-68C51F5632F7**
1698 )))|(((
1699 United States
1700 )))|(((
1701 2021-02-09
1702 )))|(((
1703 desktop
1704 )))|(((
1705 309058
1706 )))|(((
1707 V1
1708 )))|(((
1709 __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
1710 )))|(((
1711 Sy80k7Mtg
1712 )))|(((
1713 10
1714 )))|(((
1715 2021-02-09
1716 )))|(((
1717 cardiology educationlab
1718 )))|(((
1719 email
1720 )))|(((
1721 selligent
1722 )))|(((
1723 6185538439004
1724 )))|(((
1725 Chapter 5 — NORTHERA Safety Results
1726 )))|(((
1727 5
1728 )))
1729 |(((
1730 **5835554F-9B8A-4BA2-BB31-68C51F5632F7**
1731 )))|(((
1732 United States
1733 )))|(((
1734 2021-02-09
1735 )))|(((
1736 desktop
1737 )))|(((
1738 309064
1739 )))|(((
1740 V1
1741 )))|(((
1742 __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
1743 )))|(((
1744 Sy80k7Mtg
1745 )))|(((
1746 30
1747 )))|(((
1748 2021-02-09
1749 )))|(((
1750 cardiology educationlab
1751 )))|(((
1752 email
1753 )))|(((
1754 selligent
1755 )))|(((
1756 6185538439008
1757 )))|(((
1758 Chapter 5 — NORTHERA Safety Results
1759 )))|(((
1760 14
1761 )))
1762
1763 **ContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1764
1765 \\
1766
1767 ==== **Raw Web Impressions** ====
1768
1769 (% class="wrapped" %)
1770 |(((
1771 **VisitContactId**
1772 )))|(((
1773 **EventTime**
1774 )))|(((
1775 **PlatformViewed**
1776 )))|(((
1777 **RefererID**
1778 )))|(((
1779 **SessionId**
1780 )))|(((
1781 **SiteName**
1782 )))|(((
1783 **Url**
1784 )))
1785 |(((
1786 **59DA834C-803E-4C14-9C49-FDSA**
1787 )))|(((
1788 2021-03-09 01:35:12
1789 )))|(((
1790 mobile
1791 )))|(((
1792 \\
1793 )))|(((
1794 2407411196308715909161529690620210309
1795 )))|(((
1796 __www.CUSTOMER.com__
1797 )))|(((
1798 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1799 )))
1800 |(((
1801 **D0717BB2-CCDB-4DBE-ADD6-REWQREQW**
1802 )))|(((
1803 2021-03-06 01:43:53
1804 )))|(((
1805 tablet
1806 )))|(((
1807 \\
1808 )))|(((
1809 2419995085411609985161503823320210306
1810 )))|(((
1811 __www.CUSTOMER.com__
1812 )))|(((
1813 __http:~/~/www.hCUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1814 )))
1815 |(((
1816 **1AFE97E9-9931-4427-9C4E-VZCXVZ**
1817 )))|(((
1818 2021-02-22 11:04:20
1819 )))|(((
1820 tablet
1821 )))|(((
1822 \\
1823 )))|(((
1824 3663669472315156695161403488520210222
1825 )))|(((
1826 __www.CUSTOMER.com__
1827 )))|(((
1828 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1829 )))
1830 |(((
1831 **59DA834C-803E-4C14-9C49-YHDGT**
1832 )))|(((
1833 2021-03-09 01:35:14
1834 )))|(((
1835 mobile
1836 )))|(((
1837 \\
1838 )))|(((
1839 2407411196308715909161529690620210309
1840 )))|(((
1841 __wwwCUSTOMER.com__
1842 )))|(((
1843 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1844 )))
1845 |(((
1846 **31C5F8C6-3EFF-4DE7-A899-JGVMHGY**
1847 )))|(((
1848 2021-02-25 05:11:38
1849 )))|(((
1850 mobile
1851 )))|(((
1852 \\
1853 )))|(((
1854 8233752448896666794161427278020210225
1855 )))|(((
1856 __www.CUSTOMER.com__
1857 )))|(((
1858 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d__
1859 )))
1860 |(((
1861 **68E8551F-AD4E-4AAF-B4E6-RTSDFSAFA**
1862 )))|(((
1863 2021-03-15 09:57:00
1864 )))|(((
1865 desktop
1866 )))|(((
1867 \\
1868 )))|(((
1869 \\
1870 )))|(((
1871 __www.CUSTOMER.com__
1872 )))|(((
1873 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~~contactid~~__
1874 )))
1875
1876 **VisitContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1877
1878 \\
1879
1880 ==== **Swapcard (Webinar/Virtual Event Platform)** ====
1881
1882 |(((
1883 **Title**
1884 )))|(((
1885 **Start date**
1886 )))|(((
1887 **Format**
1888 )))|(((
1889 **Topics**
1890 )))|(((
1891 **Group**
1892 )))|(((
1893 **Email**
1894 )))|(((
1895 **First**
1896 )))|(((
1897 **Last**
1898 )))|(((
1899 **Title**
1900 )))|(((
1901 **Company**
1902 )))
1903 |(((
1904 **Is COVID-19 FOR REAL?
1905 **
1906 )))|(((
1907 2-11-21 12:55 PM
1908 )))|(((
1909 PRE_RECORDED
1910 )))|(((
1911 Other, Human Health, Policy, Business
1912 )))|(((
1913 Premium Members
1914 )))|(((
1915 [[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com||shape="rect"]]
1916 )))|(((
1917 Ryan
1918 )))|(((
1919 Brown
1920 )))|(((
1921 \\
1922 )))|(((
1923 2XXX Group
1924 )))
1925 |(((
1926 **BREAKING NEWS SESSION: Extreme 
1927 **
1928 )))|(((
1929 2-17-21 1:15 PM
1930 )))|(((
1931 PRE_RECORDED
1932 )))|(((
1933 \\
1934 )))|(((
1935 Premium Members
1936 )))|(((
1937 [[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com||shape="rect"]]
1938 )))|(((
1939 Ryan
1940 )))|(((
1941 Brown
1942 )))|(((
1943 \\
1944 )))|(((
1945 2XXX Group
1946 )))
1947
1948 \\
1949
1950 ==== **Trade Show Registration Data** ====
1951
1952 |(((
1953 **Event Series**
1954 )))|(((
1955 **Event Edition**
1956 )))|(((
1957 **Source System**
1958 )))|(((
1959 **Reg Number**
1960 )))|(((
1961 **First Name**
1962 )))|(((
1963 **Last Name**
1964 )))|(((
1965 **Title**
1966 )))|(((
1967 **Company 1**
1968 )))|(((
1969 **Address 1**
1970 )))|(((
1971 **Address 2**
1972 )))|(((
1973 **City**
1974 )))|(((
1975 **State**
1976 )))|(((
1977 **Zip Code**
1978 )))|(((
1979 **Country**
1980 )))|(((
1981 **Phone Number**
1982 )))|(((
1983 **Fax Number**
1984 )))|(((
1985 **Email Address**
1986 )))|(((
1987 **Internet Address 2**
1988 )))|(((
1989 **Phone Area Code**
1990 )))|(((
1991 **Phone Number Only**
1992 )))|(((
1993 **Reg Code**
1994 )))|(((
1995 **Membership Flag**
1996 )))|(((
1997 **Member ID**
1998 )))|(((
1999 **Reg Code 3**
2000 )))|(((
2001 **Text 1**
2002 )))|(((
2003 **Credential**
2004 )))|(((
2005 **Amount Paid**
2006 )))|(((
2007 **Amount Refunded**
2008 )))|(((
2009 **Reg Code 2**
2010 )))|(((
2011 **Source Code**
2012 )))|(((
2013 **Link Reg ID**
2014 )))|(((
2015 **Business type:  Check all that apply.**
2016 )))|(((
2017 **Age range**
2018 )))|(((
2019 **Primary business**
2020 )))|(((
2021 **Is this your first time to attend the Expo?**
2022 )))|(((
2023 **Please keep me up-to-date with the latest events and services
2024 **
2025 )))|(((
2026 **I would like to hear from  directly about products and services**
2027 )))|(((
2028 **What is your gender?**
2029 )))|(((
2030 **Buying decisions**
2031 )))|(((
2032 **Job function**
2033 )))|(((
2034 **Primary Market**
2035 )))|(((
2036 **What is your job title/function?**
2037 )))|(((
2038 **What is your company's primary media type?**
2039 )))|(((
2040 **Products/services**
2041 )))|(((
2042 **Do you want to receive a free subscription to PVV Magazine?**
2043 )))|(((
2044 **Do you want to receive a free subscription to RXY Magazine?**
2045 )))|(((
2046 **Sales Volume**
2047 )))|(((
2048 **Do you want to receive a free subscription to our e-newsletter?**
2049 )))|(((
2050 **What services does your company provide?**
2051 )))
2052 |(((
2053 **Annual Trade Show
2054 **
2055 )))|(((
2056 EXPO 2022
2057 )))|(((
2058 CSI
2059 )))|(((
2060 1100339
2061 )))|(((
2062 Fred
2063 )))|(((
2064 Jones
2065 )))|(((
2066 Owner
2067 )))|(((
2068 Jones Construction Ent.
2069 )))|(((
2070 690 E Highway 90
2071 )))|(((
2072 690 e HWY 90
2073 )))|(((
2074 Tampa
2075 )))|(((
2076 FL
2077 )))|(((
2078 32425
2079 )))|(((
2080 \\
2081 )))|(((
2082 1  8505551001
2083 )))|(((
2084 \\
2085 )))|(((
2086 __fred@myaddress.com__
2087 )))|(((
2088 __officemgr@notmyaddress.com__
2089 )))|(((
2090 850
2091 )))|(((
2092 5471001
2093 )))|(((
2094 Conference Attendee
2095 )))|(((
2096 Y
2097 )))|(((
2098 412351
2099 )))|(((
2100 \\
2101 )))|(((
2102 \\
2103 )))|(((
2104 \\
2105 )))|(((
2106 396
2107 )))|(((
2108 \\
2109 )))|(((
2110 Super Pass
2111 )))|(((
2112 \\
2113 )))|(((
2114 1100002
2115 )))|(((
2116 Contractor
2117 )))|(((
2118 51-60
2119 )))|(((
2120 Contractor
2121 )))|(((
2122 No
2123 )))|(((
2124 Yes
2125 )))|(((
2126 \\
2127 )))|(((
2128 Male
2129 )))|(((
2130 Yes
2131 )))|(((
2132 Owner/CEO/President/Executive
2133 )))|(((
2134 Both
2135 )))|(((
2136 \\
2137 )))|(((
2138 \\
2139 )))|(((
2140 This, That, A little of the other, Something Else
2141 )))|(((
2142 Yes
2143 )))|(((
2144 Yes
2145 )))|(((
2146 $1,000,000-$4,999,999
2147 )))|(((
2148 Yes
2149 )))|(((
2150 Roofing, Pool Repair, Driveway Sealing, Electrical Contracting
2151 )))
2152 |(((
2153 \\
2154 )))|(((
2155 \\
2156 )))|(((
2157 \\
2158 )))|(((
2159 \\
2160 )))|(((
2161 \\
2162 )))|(((
2163 \\
2164 )))|(((
2165 \\
2166 )))|(((
2167 \\
2168 )))|(((
2169 \\
2170 )))|(((
2171 \\
2172 )))|(((
2173 \\
2174 )))|(((
2175 \\
2176 )))|(((
2177 \\
2178 )))|(((
2179 \\
2180 )))|(((
2181 \\
2182 )))|(((
2183 \\
2184 )))|(((
2185 \\
2186 )))|(((
2187 \\
2188 )))|(((
2189 \\
2190 )))|(((
2191 \\
2192 )))|(((
2193 \\
2194 )))|(((
2195 \\
2196 )))|(((
2197 \\
2198 )))|(((
2199 \\
2200 )))|(((
2201 \\
2202 )))|(((
2203 \\
2204 )))|(((
2205 \\
2206 )))|(((
2207 \\
2208 )))|(((
2209 \\
2210 )))|(((
2211 \\
2212 )))|(((
2213 \\
2214 )))|(((
2215 \\
2216 )))|(((
2217 \\
2218 )))|(((
2219 \\
2220 )))|(((
2221 \\
2222 )))|(((
2223 \\
2224 )))|(((
2225 \\
2226 )))|(((
2227 \\
2228 )))|(((
2229 \\
2230 )))|(((
2231 \\
2232 )))|(((
2233 \\
2234 )))|(((
2235 \\
2236 )))|(((
2237 \\
2238 )))|(((
2239 \\
2240 )))|(((
2241 \\
2242 )))|(((
2243 \\
2244 )))|(((
2245 \\
2246 )))|(((
2247 \\
2248 )))|(((
2249 \\
2250 )))
2251 |(((
2252 **Annual Trade Show
2253 **
2254 )))|(((
2255 EXPO 2022
2256 )))|(((
2257 CSI
2258 )))|(((
2259 1100005
2260 )))|(((
2261 Jim
2262 )))|(((
2263 Nordstrom
2264 )))|(((
2265 Spouse
2266 )))|(((
2267 Nordstrom Chain, LLC
2268 )))|(((
2269 690 E Highway 90
2270 )))|(((
2271 \\
2272 )))|(((
2273 Miami
2274 )))|(((
2275 FL
2276 )))|(((
2277 33736
2278 )))|(((
2279 \\
2280 )))|(((
2281 1  8502588247
2282 )))|(((
2283 \\
2284 )))|(((
2285 __jimnordstrom@something.com__
2286 )))|(((
2287 \\
2288 )))|(((
2289 850
2290 )))|(((
2291 3998247
2292 )))|(((
2293 Attendee Expo Only
2294 )))|(((
2295 N
2296 )))|(((
2297 \\
2298 )))|(((
2299 \\
2300 )))|(((
2301 \\
2302 )))|(((
2303 \\
2304 )))|(((
2305 66
2306 )))|(((
2307 \\
2308 )))|(((
2309 Expo Only
2310 )))|(((
2311 \\
2312 )))|(((
2313 1100002
2314 )))|(((
2315 No Response
2316 )))|(((
2317 41-50
2318 )))|(((
2319 Spouse/Guest
2320 )))|(((
2321 Yes
2322 )))|(((
2323 Yes
2324 )))|(((
2325 \\
2326 )))|(((
2327 Male
2328 )))|(((
2329 No Response
2330 )))|(((
2331 Spouse/Guest
2332 )))|(((
2333 \\
2334 )))|(((
2335 \\
2336 )))|(((
2337 \\
2338 )))|(((
2339 Rope, Twine, Chain
2340 )))|(((
2341 No
2342 )))|(((
2343 No
2344 )))|(((
2345 No Response
2346 )))|(((
2347 No
2348 )))|(((
2349 No Response [DB ONLY]
2350 )))