Wiki source code of DExTr Import Files

Version 5.2 by Rayaan Ahmed on 2024/12/27 03:28
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 (% class="wrapped" %)
15 |(((
16 (% style="color:#003366" %)**ACCOUNT NUMBER**
17 )))|(((
18 (% style="color:#003366" %)**FIRST NAME**
19 )))|(((
20 (% style="color:#003366" %)**LAST NAME**
21 )))|(((
22 (% style="color:#003366" %)**MIDDLE NAME**
23 )))|(((
24 (% style="color:#003366" %)**TITLE**
25 )))|(((
26 (% style="color:#003366" %)**SUFFIX**
27 )))|(((
28 (% style="color:#003366" %)**COMPANY**
29 )))|(((
30 (% style="color:#003366" %)**JOB TITLE**
31 )))|(((
32 (% style="color:#003366" %)**ADDRESS1**
33 )))|(((
34 (% style="color:#003366" %)**ADDRESS2**
35 )))|(((
36 (% style="color:#003366" %)**CITY**
37 )))|(((
38 (% style="color:#003366" %)**STATE**
39 )))|(((
40 (% style="color:#003366" %)**ZIP**
41 )))|(((
42 (% style="color:#003366" %)**ZIP4**
43 )))|(((
44 (% style="color:#003366" %)**COUNTRY**
45 )))|(((
46 (% style="color:#003366" %)**TELEPHONE NUMBER**
47 )))|(((
48 (% style="color:#003366" %)**FAX NUMBER**
49 )))|(((
50 (% style="color:#003366" %)**E-MAIL ADDRESS**
51 )))|(((
52 (% style="color:#003366" %)**E-MAIL CONTACT**
53 )))|(((
54 (% style="color:#003366" %)**CUSTOM1**
55 )))|(((
56 (% style="color:#003366" %)**CUSTOM2**
57 )))|(((
58 (% style="color:#003366" %)**CUSTOM3**
59 )))|(((
60 (% style="color:#003366" %)**LAST UPDATED**
61 )))|(((
62 (% style="color:#003366" %)**OCID**
63 )))
64 |(((
65 (% style="color:#003366" %)**14010000431**
66 )))|(((
67 (% style="color:#003366" %)Graham
68 )))|(((
69 (% style="color:#003366" %)O'Gorman
70 )))|(((
71
72 )))|(((
73
74 )))|(((
75
76 )))|(((
77 (% style="color:#003366" %)Graham O'Gorman Landscape
78 )))|(((
79
80 )))|(((
81 (% style="color:#003366" %)192 Olmstead Hill Rd
82 )))|(((
83
84 )))|(((
85 (% style="color:#003366" %)Wilton
86 )))|(((
87 (% style="color:#003366" %)CT
88 )))|(((
89 (% style="color:#003366" %)6897
90 )))|(((
91 (% style="color:#003366" %)1816
92 )))|(((
93 (% style="color:#003366" %)United States
94 )))|(((
95
96 )))|(((
97
98 )))|(((
99
100 )))|(((
101 (% style="color:#003366" %)N
102 )))|(((
103
104 )))|(((
105
106 )))|(((
107
108 )))|(((
109 (% style="color:#003366" %)20141113211102
110 )))|(((
111
112 )))
113 |(((
114 (% style="color:#003366" %)**14010000449**
115 )))|(((
116 (% style="color:#003366" %)Dale S
117 )))|(((
118 (% style="color:#003366" %)Galbo
119 )))|(((
120
121 )))|(((
122
123 )))|(((
124
125 )))|(((
126 (% style="color:#003366" %)Law Offices
127 )))|(((
128 (% style="color:#003366" %)Owner
129 )))|(((
130 (% style="color:#003366" %)15 W Hill Rd
131 )))|(((
132
133 )))|(((
134 (% style="color:#003366" %)Bloomfield
135 )))|(((
136 (% style="color:#003366" %)CT
137 )))|(((
138 (% style="color:#003366" %)6002
139 )))|(((
140 (% style="color:#003366" %)5016
141 )))|(((
142 (% style="color:#003366" %)United States
143 )))|(((
144 (% style="color:#003366" %)2032709821
145 )))|(((
146
147 )))|(((
148
149 )))|(((
150 (% style="color:#003366" %)N
151 )))|(((
152
153 )))|(((
154
155 )))|(((
156
157 )))|(((
158 (% style="color:#003366" %)20141113211111
159 )))|(((
160
161 )))
162 |(((
163 (% style="color:#003366" %)**14010000648**
164 )))|(((
165 (% style="color:#003366" %)Patricia
166 )))|(((
167 (% style="color:#003366" %)Cannon
168 )))|(((
169
170 )))|(((
171
172 )))|(((
173
174 )))|(((
175 (% style="color:#003366" %)Employee Assistance Program
176 )))|(((
177 (% style="color:#003366" %)Director
178 )))|(((
179 (% style="color:#003366" %)887 Bridgeport Ave Ste C
180 )))|(((
181
182 )))|(((
183 (% style="color:#003366" %)Shelton
184 )))|(((
185 (% style="color:#003366" %)CT
186 )))|(((
187 (% style="color:#003366" %)6484
188 )))|(((
189 (% style="color:#003366" %)7602
190 )))|(((
191 (% style="color:#003366" %)United States
192 )))|(((
193 (% style="color:#003366" %)2039290681
194 )))|(((
195
196 )))|(((
197
198 )))|(((
199 (% style="color:#003366" %)N
200 )))|(((
201
202 )))|(((
203
204 )))|(((
205
206 )))|(((
207 (% style="color:#003366" %)20141121163017
208 )))|(((
209
210 )))
211 |(((
212 (% style="color:#003366" %)**14010001843**
213 )))|(((
214 (% style="color:#003366" %)Susan
215 )))|(((
216 (% style="color:#003366" %)Kent
217 )))|(((
218
219 )))|(((
220
221 )))|(((
222
223 )))|(((
224
225 )))|(((
226
227 )))|(((
228 (% style="color:#003366" %)38110 5th St E Apt 1
229 )))|(((
230
231 )))|(((
232 (% style="color:#003366" %)Los Angeles
233 )))|(((
234 (% style="color:#003366" %)CA
235 )))|(((
236 (% style="color:#003366" %)93550
237 )))|(((
238 (% style="color:#003366" %)2317
239 )))|(((
240 (% style="color:#003366" %)United States
241 )))|(((
242
243 )))|(((
244
245 )))|(((
246
247 )))|(((
248 (% style="color:#003366" %)N
249 )))|(((
250
251 )))|(((
252
253 )))|(((
254
255 )))|(((
256 (% style="color:#003366" %)20141212210537
257 )))|(((
258
259 )))
260 |(((
261 (% style="color:#003366" %)**14010001858**
262 )))|(((
263 (% style="color:#003366" %)Brendan
264 )))|(((
265 (% style="color:#003366" %)Eppley
266 )))|(((
267
268 )))|(((
269
270 )))|(((
271
272 )))|(((
273
274 )))|(((
275
276 )))|(((
277 (% style="color:#003366" %)20 Driftway Ln
278 )))|(((
279
280 )))|(((
281 (% style="color:#003366" %)Darien
282 )))|(((
283 (% style="color:#003366" %)CT
284 )))|(((
285 (% style="color:#003366" %)6820
286 )))|(((
287 (% style="color:#003366" %)6130
288 )))|(((
289 (% style="color:#003366" %)United States
290 )))|(((
291
292 )))|(((
293
294 )))|(((
295
296 )))|(((
297 (% style="color:#003366" %)N
298 )))|(((
299
300 )))|(((
301
302 )))|(((
303
304 )))|(((
305 (% style="color:#003366" %)20141211230144
306 )))|(((
307
308 )))
309 |(((
310 (% style="color:#003366" %)**14010001862**
311 )))|(((
312
313 )))|(((
314
315 )))|(((
316
317 )))|(((
318
319 )))|(((
320
321 )))|(((
322 (% style="color:#003366" %)Orchard Tree Care Llc
323 )))|(((
324
325 )))|(((
326 (% style="color:#003366" %)184 Ave
327 )))|(((
328
329 )))|(((
330 (% style="color:#003366" %)Darien
331 )))|(((
332 (% style="color:#003366" %)CT
333 )))|(((
334 (% style="color:#003366" %)6820
335 )))|(((
336
337 )))|(((
338 (% style="color:#003366" %)United States
339 )))|(((
340 (% style="color:#003366" %)2036550618
341 )))|(((
342
343 )))|(((
344
345 )))|(((
346 (% style="color:#003366" %)N
347 )))|(((
348
349 )))|(((
350
351 )))|(((
352
353 )))|(((
354 (% style="color:#003366" %)20150211133156
355 )))|(((
356
357 )))
358 |(((
359 (% style="color:#003366" %)**14010001870**
360 )))|(((
361 (% style="color:#003366" %)Avis Z
362 )))|(((
363 (% style="color:#003366" %)Gray
364 )))|(((
365
366 )))|(((
367
368 )))|(((
369
370 )))|(((
371 (% style="color:#003366" %)Designers 5 Incorporated
372 )))|(((
373 (% style="color:#003366" %)President
374 )))|(((
375 (% style="color:#003366" %)96 5 Mile River Rd
376 )))|(((
377
378 )))|(((
379 (% style="color:#003366" %)Darien
380 )))|(((
381 (% style="color:#003366" %)CT
382 )))|(((
383 (% style="color:#003366" %)6820
384 )))|(((
385 (% style="color:#003366" %)6234
386 )))|(((
387 (% style="color:#003366" %)United States
388 )))|(((
389 (% style="color:#003366" %)2036552033
390 )))|(((
391
392 )))|(((
393
394 )))|(((
395 (% style="color:#003366" %)N
396 )))|(((
397
398 )))|(((
399
400 )))|(((
401
402 )))|(((
403 (% style="color:#003366" %)20150212210227
404 )))|(((
405
406 )))
407 |(((
408 (% style="color:#003366" %)**14010001889**
409 )))|(((
410 (% style="color:#003366" %)John
411 )))|(((
412 (% style="color:#003366" %)Hertz
413 )))|(((
414
415 )))|(((
416
417 )))|(((
418
419 )))|(((
420 (% style="color:#003366" %)Hertz Construction Co
421 )))|(((
422 (% style="color:#003366" %)Partner
423 )))|(((
424 (% style="color:#003366" %)12 Hillside Ave
425 )))|(((
426
427 )))|(((
428 (% style="color:#003366" %)Darien
429 )))|(((
430 (% style="color:#003366" %)CT
431 )))|(((
432 (% style="color:#003366" %)6820
433 )))|(((
434 (% style="color:#003366" %)5010
435 )))|(((
436 (% style="color:#003366" %)United States
437 )))|(((
438 (% style="color:#003366" %)2036564900
439 )))|(((
440
441 )))|(((
442
443 )))|(((
444 (% style="color:#003366" %)N
445 )))|(((
446
447 )))|(((
448
449 )))|(((
450
451 )))|(((
452 (% style="color:#003366" %)20141121163018
453 )))|(((
454
455 )))
456 |(((
457 (% style="color:#003366" %)**14010001891**
458 )))|(((
459
460 )))|(((
461
462 )))|(((
463
464 )))|(((
465
466 )))|(((
467
468 )))|(((
469 (% style="color:#003366" %)Niche Home Furnishings Ll
470 )))|(((
471
472 )))|(((
473 (% style="color:#003366" %)25 Old Kings Hwy N Ste 17
474 )))|(((
475
476 )))|(((
477 (% style="color:#003366" %)Darien
478 )))|(((
479 (% style="color:#003366" %)CT
480 )))|(((
481 (% style="color:#003366" %)6820
482 )))|(((
483 (% style="color:#003366" %)4608
484 )))|(((
485 (% style="color:#003366" %)United States
486 )))|(((
487 (% style="color:#003366" %)2036566674
488 )))|(((
489
490 )))|(((
491
492 )))|(((
493 (% style="color:#003366" %)N
494 )))|(((
495
496 )))|(((
497
498 )))|(((
499
500 )))|(((
501 (% style="color:#003366" %)20141121163018
502 )))|(((
503
504 )))
505 |(((
506 (% style="color:#003366" %)**14010001901**
507 )))|(((
508 (% style="color:#003366" %)Wendy
509 )))|(((
510 (% style="color:#003366" %)Cole
511 )))|(((
512
513 )))|(((
514 (% style="color:#003366" %)Ms.
515 )))|(((
516
517 )))|(((
518 (% style="color:#003366" %)Wendy C Cole Interiors
519 )))|(((
520 (% style="color:#003366" %)Principal
521 )))|(((
522 (% style="color:#003366" %)3 Outlook Dr
523 )))|(((
524
525 )))|(((
526 (% style="color:#003366" %)Darien
527 )))|(((
528 (% style="color:#003366" %)CT
529 )))|(((
530 (% style="color:#003366" %)6820
531 )))|(((
532 (% style="color:#003366" %)5616
533 )))|(((
534 (% style="color:#003366" %)United States
535 )))|(((
536 (% style="color:#003366" %)2036552954
537 )))|(((
538
539 )))|(((
540
541 )))|(((
542 (% style="color:#003366" %)N
543 )))|(((
544
545 )))|(((
546
547 )))|(((
548
549 )))|(((
550 (% style="color:#003366" %)20150212210227
551 )))|(((
552
553 )))
554 |(((
555 (% style="color:#003366" %)**14010001917**
556 )))|(((
557 (% style="color:#003366" %)Frank
558 )))|(((
559 (% style="color:#003366" %)Stone
560 )))|(((
561
562 )))|(((
563
564 )))|(((
565
566 )))|(((
567 (% style="color:#003366" %)Stones Landscape
568 )))|(((
569 (% style="color:#003366" %)Owner
570 )))|(((
571 (% style="color:#003366" %)258 West Ave
572 )))|(((
573
574 )))|(((
575 (% style="color:#003366" %)Darien
576 )))|(((
577 (% style="color:#003366" %)CT
578 )))|(((
579 (% style="color:#003366" %)6820
580 )))|(((
581 (% style="color:#003366" %)4111
582 )))|(((
583 (% style="color:#003366" %)United States
584 )))|(((
585 (% style="color:#003366" %)2036569674
586 )))|(((
587
588 )))|(((
589
590 )))|(((
591 (% style="color:#003366" %)N
592 )))|(((
593
594 )))|(((
595
596 )))|(((
597
598 )))|(((
599 (% style="color:#003366" %)20150212210227
600 )))|(((
601
602 )))
603 |(((
604 (% style="color:#003366" %)**14010002429**
605 )))|(((
606 (% style="color:#003366" %)Bruce
607 )))|(((
608 (% style="color:#003366" %)Pomerance
609 )))|(((
610
611 )))|(((
612 (% style="color:#003366" %)Mr.
613 )))|(((
614
615 )))|(((
616 (% style="color:#003366" %)P L V Inc
617 )))|(((
618 (% style="color:#003366" %)President
619 )))|(((
620 (% style="color:#003366" %)1076 Post Rd
621 )))|(((
622
623 )))|(((
624 (% style="color:#003366" %)Darien
625 )))|(((
626 (% style="color:#003366" %)CT
627 )))|(((
628 (% style="color:#003366" %)6820
629 )))|(((
630 (% style="color:#003366" %)5414
631 )))|(((
632 (% style="color:#003366" %)United States
633 )))|(((
634 (% style="color:#003366" %)2036554668
635 )))|(((
636
637 )))|(((
638
639 )))|(((
640 (% style="color:#003366" %)N
641 )))|(((
642
643 )))|(((
644
645 )))|(((
646
647 )))|(((
648 (% style="color:#003366" %)20150212210227
649 )))|(((
650
651 )))
652 |(((
653 (% style="color:#003366" %)**14010002438**
654 )))|(((
655 (% style="color:#003366" %)Joanne
656 )))|(((
657 (% style="color:#003366" %)Salvatore
658 )))|(((
659
660 )))|(((
661
662 )))|(((
663
664 )))|(((
665 (% style="color:#003366" %)Nassau Interests Llc
666 )))|(((
667 (% style="color:#003366" %)Member
668 )))|(((
669 (% style="color:#003366" %)42 N Meadows Ln
670 )))|(((
671
672 )))|(((
673 (% style="color:#003366" %)Stamford
674 )))|(((
675 (% style="color:#003366" %)CT
676 )))|(((
677 (% style="color:#003366" %)6903
678 )))|(((
679 (% style="color:#003366" %)5151
680 )))|(((
681 (% style="color:#003366" %)United States
682 )))|(((
683 (% style="color:#003366" %)2036550303
684 )))|(((
685
686 )))|(((
687 (% style="color:#003366" %)[[(% style="color: rgb(0, 51, 102); color: rgb(0, 51, 102)" %)__joannesal@aol.com__>>mailto:joannesal@aol.com||shape="rect" style="color: rgb(0,51,102);"]]
688 )))|(((
689 (% style="color:#003366" %)Y
690 )))|(((
691
692 )))|(((
693
694 )))|(((
695
696 )))|(((
697 (% style="color:#003366" %)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 (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.
717
718 This will create the following work-flow:
719
720 (% class="wrapped" %)
721 |=(((
722 Subscriber ID
723 )))|=(((
724 OCID
725 )))|=(((
726 ACTION
727 )))
728 |(((
729 YES
730 )))|(((
731 NO
732 )))|(((
733 User was created by the fulfillment system and is new to ONEcount, create a new record in ONEcount
734 )))
735 |(((
736 NO
737 )))|(((
738 YES
739 )))|(((
740 User was created in ONEcount and is new to the fulfillment system user, create a new record in the fulfillment system
741 )))
742 |(% colspan="1" %)(% colspan="1" %)
743 (((
744 YES
745 )))|(% colspan="1" %)(% colspan="1" %)
746 (((
747 YES
748 )))|(% colspan="1" %)(% colspan="1" %)
749 (((
750 User exists in both systems, update record with incoming data
751 )))
752
753 === Transaction Data Sample: ===
754
755 (% class="wrapped" %)
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 === Fulfillment Sample: Advantage/Omeda/PCS/CDS ===
865
866 |(((
867 **PUBCDE**
868 )))|(((
869 **CUSTNUMB**
870 )))|(% colspan="1" %)(% colspan="1" %)
871 (((
872 OCID
873 )))|(((
874 **CRCSTS**
875 )))|(((
876 **FIRST**
877 )))|(((
878 **LAST**
879 )))|(((
880 **COMPANY**
881 )))|(((
882 **ADD1**
883 )))|(((
884 **ADD2**
885 )))|(((
886 **CITY**
887 )))|(((
888 **ZIPCDE**
889 )))|(((
890 **STATE**
891 )))|(((
892 **ADRCDE**
893 )))|(((
894 **KEYCDE**
895 )))|(((
896 **QUALSRC**
897 )))|(((
898 **EMAIL**
899 )))|(((
900 **CTMDTE**
901 )))|(((
902 **FINDTE**
903 )))|(((
904 **PHONE**
905 )))|(((
906 **LISTIND**
907 )))|(((
908 **County**
909 )))|(((
910 **COUNTRY**
911 )))
912 |(((
913 **AAI**
914 )))|(((
915 404304
916 )))|(% colspan="1" %)(% colspan="1" %)
917 (((
918 33675
919 )))|(((
920 E
921 )))|(((
922 FRED
923 )))|(((
924 SMITH
925 )))|(((
926
927 )))|(((
928 57 CHURCH ST
929 )))|(((
930
931 )))|(((
932 ROXBURY
933 )))|(((
934 67831704
935 )))|(((
936 CT
937 )))|(((
938 M
939 )))|(((
940 TREN68B
941 )))|(((
942 5F
943 )))|(((
944
945 )))|(((
946 20161205
947 )))|(((
948 20190101
949 )))|(((
950 8005551234
951 )))|(((
952 NONACTIVE
953 )))|(((
954 LITCHFIELD
955 )))|(((
956 USA
957 )))
958 |(((
959 **AIB**
960 )))|(((
961 445771
962 )))|(% colspan="1" %)(% colspan="1" %)
963 (((
964
965 )))|(((
966 Q
967 )))|(((
968 JOSEPH
969 )))|(((
970 JONES
971 )))|(((
972 JONES & CO
973 )))|(((
974 7632 WILDCAT PIKE
975 )))|(((
976
977 )))|(((
978 NEW BLOOMINGTON
979 )))|(((
980 433419532
981 )))|(((
982 OH
983 )))|(((
984 M
985 )))|(((
986 E3CC1220
987 )))|(((
988 5F
989 )))|(((
990 [[__JMBUCKOHIO@AOL.COM__>>mailto:JMBUCKOHIO@AOL.COM||shape="rect"]]
991 )))|(((
992 20201201
993 )))|(((
994 20231201
995 )))|(((
996 9546783214
997 )))|(((
998 QUAL
999 )))|(((
1000 MARION
1001 )))|(((
1002 USA
1003 )))
1004 |(((
1005 **AXW**
1006 )))|(((
1007
1008 )))|(% colspan="1" %)(% colspan="1" %)
1009 (((
1010 3324
1011 )))|(((
1012 G
1013 )))|(((
1014 MARK
1015 )))|(((
1016 ROBERTS
1017 )))|(((
1018 TRF Inc.
1019 )))|(((
1020 5201 WOODWARD AVE
1021 )))|(((
1022
1023 )))|(((
1024 DETROIT
1025 )))|(((
1026 482024093
1027 )))|(((
1028 MI
1029 )))|(((
1030 M
1031 )))|(((
1032 RRT6GT
1033 )))|(((
1034 1A
1035 )))|(((
1036
1037 )))|(((
1038 20201207
1039 )))|(((
1040 20210401
1041 )))|(((
1042
1043 )))|(((
1044 PAID
1045 )))|(((
1046 WAYNE
1047 )))|(((
1048 USA
1049 )))
1050
1051 **PUBCODE maps to Package TERM**
1052
1053
1054 === Engagement Data ===
1055
1056 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.
1057
1058
1059 **NOTE**: For e-mail engagement activity date, message id, recipient id, activity type, email click url 
1060
1061
1062 Here are a couple of examples:
1063
1064 ==== **E-Mail Engagement (combined, from Eloqua)** ====
1065
1066 (% class="wrapped" %)
1067 |(((
1068 **ActivityDate**
1069 )))|(((
1070 **ActivityType**
1071 )))|(((
1072 **AssetId**
1073 )))|(((
1074 **AssetName**
1075 )))|(((
1076 **CampaignId**
1077 )))|(((
1078 **ContactId**
1079 )))|(((
1080 **EmailAddress**
1081 )))|(((
1082 **EmailClickedThruLink**
1083 )))|(((
1084 **EmailRecipientId**
1085 )))|(((
1086 **ExternalId**
1087 )))|(((
1088 **SmtpErrorCode**
1089 )))|(((
1090 **SmtpMessage**
1091 )))|(((
1092 **SmtpStatusCode**
1093 )))|(((
1094 **VisitorId**
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 ==== **E-mail Engagement (Split Files)** ====
1189
1190 **email-clicks.csv:**
1191
1192 (% class="wrapped" %)
1193 |(((
1194 **ActivityDate**
1195 )))|(((
1196 **ActivityType**
1197 )))|(((
1198 **MessageID**
1199 )))|(((
1200 **MessageName**
1201 )))|(((
1202 **MessageSubject**
1203 )))|(((
1204 **ListID**
1205 )))|(((
1206 **ListName**
1207 )))|(((
1208 **OCID**
1209 )))|(((
1210 **LinkURL**
1211 )))|(((
1212 **LinkID**
1213 )))|(((
1214 **Firstclick**
1215 )))|(((
1216 **Latestclick**
1217 )))|(((
1218 **clicked**
1219 )))
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 **email-opens.csv**
1249
1250 (% class="wrapped" %)
1251 |(((
1252 **ActivityDate**
1253 )))|(((
1254 **ActivityType**
1255 )))|(((
1256 **MessageID**
1257 )))|(((
1258 **MessageName**
1259 )))|(((
1260 **MessageSubject**
1261 )))|(((
1262 **ListID**
1263 )))|(((
1264 **ListName**
1265 )))|(((
1266 **OCID**
1267 )))
1268 |(((
1269
1270 )))|(((
1271
1272 )))|(((
1273
1274 )))|(((
1275
1276 )))|(((
1277
1278 )))|(((
1279
1280 )))|(((
1281
1282 )))|(((
1283
1284 )))
1285
1286 **email-sends.csv**
1287
1288 (% class="wrapped" %)
1289 |(((
1290 **ActivityDate**
1291 )))|(((
1292 **ActivityType**
1293 )))|(((
1294 **MessageID**
1295 )))|(((
1296 **MessageName**
1297 )))|(((
1298 **MessageSubject**
1299 )))|(((
1300 **ListID**
1301 )))|(((
1302 **ListName**
1303 )))|(((
1304 **OCID**
1305 )))
1306 |(((
1307
1308 )))|(((
1309
1310 )))|(((
1311
1312 )))|(((
1313
1314 )))|(((
1315
1316 )))|(((
1317
1318 )))|(((
1319
1320 )))|(((
1321
1322 )))
1323
1324
1325 ==== LiveIntent Data Sample: ====
1326
1327 (% class="wrapped" %)
1328 |(((
1329 **Liveintentuserid**
1330 )))|(((
1331 **Advertiserid**
1332 )))|(((
1333 **Campaignid**
1334 )))|(((
1335 **Creativeid**
1336 )))|(((
1337 **Devtype**
1338 )))|(((
1339 **Emailasmdfive**
1340 )))|(((
1341 **Eventtype**
1342 )))|(((
1343 **Lineitemid**
1344 )))|(((
1345 **Liveintentdecisionid**
1346 )))|(((
1347 **Publisherid**
1348 )))|(((
1349 **Sectionid**
1350 )))|(((
1351 **Templateid**
1352 )))|(((
1353 **Timestamp**
1354 )))
1355 |(((
1356 **28427698**
1357 )))|(((
1358 39771
1359 )))|(((
1360 246944
1361 )))|(((
1362 787604
1363 )))|(((
1364 PC
1365 )))|(((
1366 d57dccaadbba6c4ad8f143de8c571771
1367 )))|(((
1368 impression
1369 )))|(((
1370 10001043
1371 )))|(((
1372 66233848-4580-3d7f-92b2-beb4741e8f7
1373 )))|(((
1374 36479
1375 )))|(((
1376 253729
1377 )))|(((
1378 19263
1379 )))|(((
1380 2021-03-10
1381 )))
1382 |(((
1383 **28422453**
1384 )))|(((
1385 39771
1386 )))|(((
1387 246944
1388 )))|(((
1389 787604
1390 )))|(((
1391 PC
1392 )))|(((
1393 2dece7448530fdf799254a875ebe0a77
1394 )))|(((
1395 impression
1396 )))|(((
1397 10001043
1398 )))|(((
1399 b8c41396-b896-333d-9945-522c21174e2
1400 )))|(((
1401 36479
1402 )))|(((
1403 277132
1404 )))|(((
1405 19263
1406 )))|(((
1407 2021-03-10
1408 )))
1409 |(((
1410 **28421392**
1411 )))|(((
1412 39771
1413 )))|(((
1414 246944
1415 )))|(((
1416 787604
1417 )))|(((
1418 PC
1419 )))|(((
1420 a4c0388d679348e467d27391b3fd456c
1421 )))|(((
1422 impression
1423 )))|(((
1424 10001043
1425 )))|(((
1426 844ebc51-0a02-3783-99c8-8ac96a29bc3
1427 )))|(((
1428 36479
1429 )))|(((
1430 277132
1431 )))|(((
1432 19263
1433 )))|(((
1434 2021-03-10
1435 )))
1436 |(((
1437 **28499279**
1438 )))|(((
1439 39771
1440 )))|(((
1441 246944
1442 )))|(((
1443 787604
1444 )))|(((
1445 PC
1446 )))|(((
1447 96032eb8da86e394b23c2a9647477d66
1448 )))|(((
1449 impression
1450 )))|(((
1451 10001043
1452 )))|(((
1453 69a0d6fd-7cb3-301d-b24a-04144d9ec74
1454 )))|(((
1455 36479
1456 )))|(((
1457 253729
1458 )))|(((
1459 19263
1460 )))|(((
1461 2021-03-10
1462 )))
1463 |(((
1464 **28421344**
1465 )))|(((
1466 39771
1467 )))|(((
1468 246944
1469 )))|(((
1470 787604
1471 )))|(((
1472 PC
1473 )))|(((
1474 fd2d53dbe2e7aa2198c19afce5a35cc6
1475 )))|(((
1476 impression
1477 )))|(((
1478 10001043
1479 )))|(((
1480 75c72eca-6cf1-3144-b00c-04ca49471363
1481 )))|(((
1482 36479
1483 )))|(((
1484 253729
1485 )))|(((
1486 19263
1487 )))|(((
1488 2021-03-10
1489 )))
1490
1491
1492 ==== **BrightCove Data Sample:** ====
1493
1494 (% class="wrapped" %)
1495 |(((
1496 **Contactid**
1497 )))|(((
1498 **Country**
1499 )))|(((
1500 **Createdat**
1501 )))|(((
1502 **Device**
1503 )))|(((
1504 **Id**
1505 )))|(((
1506 **Metriccode**
1507 )))|(((
1508 **Pageurl**
1509 )))|(((
1510 **Playerid**
1511 )))|(((
1512 **Timewatched**
1513 )))|(((
1514 **Updatedat**
1515 )))|(((
1516 **Utmcampaign**
1517 )))|(((
1518 **Utmmedium**
1519 )))|(((
1520 **Utmsource**
1521 )))|(((
1522 **Videoid**
1523 )))|(((
1524 **Videoname**
1525 )))|(((
1526 **Watched**
1527 )))
1528 |(((
1529 **3B07C282-170D-46C4-B8CC-AAADFD**
1530 )))|(((
1531 United States
1532 )))|(((
1533 2021-02-11
1534 )))|(((
1535 desktop
1536 )))|(((
1537 309529
1538 )))|(((
1539 V1
1540 )))|(((
1541 __https:~/~/preview.CUSTOMER.com/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video__
1542 )))|(((
1543 Sy80k7Mtg
1544 )))|(((
1545 0
1546 )))|(((
1547 2021-02-11
1548 )))|(((
1549
1550 )))|(((
1551
1552 )))|(((
1553
1554 )))|(((
1555 5982181673007
1556 )))|(((
1557 What is symptomatic neurogenic orthostatic hypotension?
1558 )))|(((
1559 0
1560 )))
1561 |(((
1562 **228DA837-9358-43AB-A6E6-DFSF**
1563 )))|(((
1564 United States
1565 )))|(((
1566 2021-01-25
1567 )))|(((
1568 desktop
1569 )))|(((
1570 306311
1571 )))|(((
1572 V1
1573 )))|(((
1574 __https:~/~/www.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1575 )))|(((
1576 Sy80k7Mtg
1577 )))|(((
1578 1
1579 )))|(((
1580 2021-01-25
1581 )))|(((
1582
1583 )))|(((
1584
1585 )))|(((
1586
1587 )))|(((
1588 6171615690004
1589 )))|(((
1590 TED Risk Factors & Symptoms
1591 )))|(((
1592 1
1593 )))
1594 |(((
1595 **1EFC18BF-E9A4-44D9-849F-FDSFS**
1596 )))|(((
1597 United States
1598 )))|(((
1599 2021-01-29
1600 )))|(((
1601 desktop
1602 )))|(((
1603 307009
1604 )))|(((
1605 V1
1606 )))|(((
1607 __https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1608 )))|(((
1609 Sy80k7Mtg
1610 )))|(((
1611 1
1612 )))|(((
1613 2021-01-29
1614 )))|(((
1615
1616 )))|(((
1617
1618 )))|(((
1619
1620 )))|(((
1621 6171615690003
1622 )))|(((
1623 TED Risk Factors & Symptoms
1624 )))|(((
1625 1
1626 )))
1627 |(((
1628 **228DA837-9358-43AB-A6E6-DFASFDASF**
1629 )))|(((
1630 United States
1631 )))|(((
1632 2021-02-12
1633 )))|(((
1634 desktop
1635 )))|(((
1636 309633
1637 )))|(((
1638 V1
1639 )))|(((
1640 __https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi__
1641 )))|(((
1642 Sy80k7Mtg
1643 )))|(((
1644 0
1645 )))|(((
1646 2021-02-12
1647 )))|(((
1648
1649 )))|(((
1650
1651 )))|(((
1652
1653 )))|(((
1654 6171632240005
1655 )))|(((
1656 TED Pathophysiology
1657 )))|(((
1658 0
1659 )))
1660 |(((
1661 **5835554F-9B8A-4BA2-BB31-FDSAF**
1662 )))|(((
1663 United States
1664 )))|(((
1665 2021-02-09
1666 )))|(((
1667 desktop
1668 )))|(((
1669 309052
1670 )))|(((
1671 V1
1672 )))|(((
1673 __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
1674 )))|(((
1675 Sy80k7Mtg
1676 )))|(((
1677 40
1678 )))|(((
1679 2021-02-09
1680 )))|(((
1681 cardiology educationlab
1682 )))|(((
1683 email
1684 )))|(((
1685 selligent
1686 )))|(((
1687 6185538439007
1688 )))|(((
1689 Chapter 5 — NORTHERA Safety Results
1690 )))|(((
1691 19
1692 )))
1693 |(((
1694 **5835554F-9B8A-4BA2-BB31-68C51F5632F7**
1695 )))|(((
1696 United States
1697 )))|(((
1698 2021-02-09
1699 )))|(((
1700 desktop
1701 )))|(((
1702 309058
1703 )))|(((
1704 V1
1705 )))|(((
1706 __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
1707 )))|(((
1708 Sy80k7Mtg
1709 )))|(((
1710 10
1711 )))|(((
1712 2021-02-09
1713 )))|(((
1714 cardiology educationlab
1715 )))|(((
1716 email
1717 )))|(((
1718 selligent
1719 )))|(((
1720 6185538439004
1721 )))|(((
1722 Chapter 5 — NORTHERA Safety Results
1723 )))|(((
1724 5
1725 )))
1726 |(((
1727 **5835554F-9B8A-4BA2-BB31-68C51F5632F7**
1728 )))|(((
1729 United States
1730 )))|(((
1731 2021-02-09
1732 )))|(((
1733 desktop
1734 )))|(((
1735 309064
1736 )))|(((
1737 V1
1738 )))|(((
1739 __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
1740 )))|(((
1741 Sy80k7Mtg
1742 )))|(((
1743 30
1744 )))|(((
1745 2021-02-09
1746 )))|(((
1747 cardiology educationlab
1748 )))|(((
1749 email
1750 )))|(((
1751 selligent
1752 )))|(((
1753 6185538439008
1754 )))|(((
1755 Chapter 5 — NORTHERA Safety Results
1756 )))|(((
1757 14
1758 )))
1759
1760 **ContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1761
1762
1763 ==== **Raw Web Impressions** ====
1764
1765 (% class="wrapped" %)
1766 |(((
1767 **VisitContactId**
1768 )))|(((
1769 **EventTime**
1770 )))|(((
1771 **PlatformViewed**
1772 )))|(((
1773 **RefererID**
1774 )))|(((
1775 **SessionId**
1776 )))|(((
1777 **SiteName**
1778 )))|(((
1779 **Url**
1780 )))
1781 |(((
1782 **59DA834C-803E-4C14-9C49-FDSA**
1783 )))|(((
1784 2021-03-09 01:35:12
1785 )))|(((
1786 mobile
1787 )))|(((
1788
1789 )))|(((
1790 2407411196308715909161529690620210309
1791 )))|(((
1792 __www.CUSTOMER.com__
1793 )))|(((
1794 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1795 )))
1796 |(((
1797 **D0717BB2-CCDB-4DBE-ADD6-REWQREQW**
1798 )))|(((
1799 2021-03-06 01:43:53
1800 )))|(((
1801 tablet
1802 )))|(((
1803
1804 )))|(((
1805 2419995085411609985161503823320210306
1806 )))|(((
1807 __www.CUSTOMER.com__
1808 )))|(((
1809 __http:~/~/www.hCUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1810 )))
1811 |(((
1812 **1AFE97E9-9931-4427-9C4E-VZCXVZ**
1813 )))|(((
1814 2021-02-22 11:04:20
1815 )))|(((
1816 tablet
1817 )))|(((
1818
1819 )))|(((
1820 3663669472315156695161403488520210222
1821 )))|(((
1822 __www.CUSTOMER.com__
1823 )))|(((
1824 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1825 )))
1826 |(((
1827 **59DA834C-803E-4C14-9C49-YHDGT**
1828 )))|(((
1829 2021-03-09 01:35:14
1830 )))|(((
1831 mobile
1832 )))|(((
1833
1834 )))|(((
1835 2407411196308715909161529690620210309
1836 )))|(((
1837 __wwwCUSTOMER.com__
1838 )))|(((
1839 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1840 )))
1841 |(((
1842 **31C5F8C6-3EFF-4DE7-A899-JGVMHGY**
1843 )))|(((
1844 2021-02-25 05:11:38
1845 )))|(((
1846 mobile
1847 )))|(((
1848
1849 )))|(((
1850 8233752448896666794161427278020210225
1851 )))|(((
1852 __www.CUSTOMER.com__
1853 )))|(((
1854 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d__
1855 )))
1856 |(((
1857 **68E8551F-AD4E-4AAF-B4E6-RTSDFSAFA**
1858 )))|(((
1859 2021-03-15 09:57:00
1860 )))|(((
1861 desktop
1862 )))|(((
1863
1864 )))|(((
1865
1866 )))|(((
1867 __www.CUSTOMER.com__
1868 )))|(((
1869 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~~contactid~~__
1870 )))
1871
1872 **VisitContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1873
1874
1875 ==== **Swapcard (Webinar/Virtual Event Platform)** ====
1876
1877 |(((
1878 **Title**
1879 )))|(((
1880 **Start date**
1881 )))|(((
1882 **Format**
1883 )))|(((
1884 **Topics**
1885 )))|(((
1886 **Group**
1887 )))|(((
1888 **Email**
1889 )))|(((
1890 **First**
1891 )))|(((
1892 **Last**
1893 )))|(((
1894 **Title**
1895 )))|(((
1896 **Company**
1897 )))
1898 |(((
1899 **Is COVID-19 FOR REAL?**
1900 )))|(((
1901 2-11-21 12:55 PM
1902 )))|(((
1903 PRE_RECORDED
1904 )))|(((
1905 Other, Human Health, Policy, Business
1906 )))|(((
1907 Premium Members
1908 )))|(((
1909 [[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com||shape="rect"]]
1910 )))|(((
1911 Ryan
1912 )))|(((
1913 Brown
1914 )))|(((
1915
1916 )))|(((
1917 2XXX Group
1918 )))
1919 |(((
1920 **BREAKING NEWS SESSION: Extreme **
1921 )))|(((
1922 2-17-21 1:15 PM
1923 )))|(((
1924 PRE_RECORDED
1925 )))|(((
1926
1927 )))|(((
1928 Premium Members
1929 )))|(((
1930 [[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com||shape="rect"]]
1931 )))|(((
1932 Ryan
1933 )))|(((
1934 Brown
1935 )))|(((
1936
1937 )))|(((
1938 2XXX Group
1939 )))
1940
1941
1942 ==== **Trade Show Registration Data** ====
1943
1944 |(((
1945 **Event Series**
1946 )))|(((
1947 **Event Edition**
1948 )))|(((
1949 **Source System**
1950 )))|(((
1951 **Reg Number**
1952 )))|(((
1953 **First Name**
1954 )))|(((
1955 **Last Name**
1956 )))|(((
1957 **Title**
1958 )))|(((
1959 **Company 1**
1960 )))|(((
1961 **Address 1**
1962 )))|(((
1963 **Address 2**
1964 )))|(((
1965 **City**
1966 )))|(((
1967 **State**
1968 )))|(((
1969 **Zip Code**
1970 )))|(((
1971 **Country**
1972 )))|(((
1973 **Phone Number**
1974 )))|(((
1975 **Fax Number**
1976 )))|(((
1977 **Email Address**
1978 )))|(((
1979 **Internet Address 2**
1980 )))|(((
1981 **Phone Area Code**
1982 )))|(((
1983 **Phone Number Only**
1984 )))|(((
1985 **Reg Code**
1986 )))|(((
1987 **Membership Flag**
1988 )))|(((
1989 **Member ID**
1990 )))|(((
1991 **Reg Code 3**
1992 )))|(((
1993 **Text 1**
1994 )))|(((
1995 **Credential**
1996 )))|(((
1997 **Amount Paid**
1998 )))|(((
1999 **Amount Refunded**
2000 )))|(((
2001 **Reg Code 2**
2002 )))|(((
2003 **Source Code**
2004 )))|(((
2005 **Link Reg ID**
2006 )))|(((
2007 **Business type:  Check all that apply.**
2008 )))|(((
2009 **Age range**
2010 )))|(((
2011 **Primary business**
2012 )))|(((
2013 **Is this your first time to attend the Expo?**
2014 )))|(((
2015 **Please keep me up-to-date with the latest events and services**
2016 )))|(((
2017 **I would like to hear from  directly about products and services**
2018 )))|(((
2019 **What is your gender?**
2020 )))|(((
2021 **Buying decisions**
2022 )))|(((
2023 **Job function**
2024 )))|(((
2025 **Primary Market**
2026 )))|(((
2027 **What is your job title/function?**
2028 )))|(((
2029 **What is your company's primary media type?**
2030 )))|(((
2031 **Products/services**
2032 )))|(((
2033 **Do you want to receive a free subscription to PVV Magazine?**
2034 )))|(((
2035 **Do you want to receive a free subscription to RXY Magazine?**
2036 )))|(((
2037 **Sales Volume**
2038 )))|(((
2039 **Do you want to receive a free subscription to our e-newsletter?**
2040 )))|(((
2041 **What services does your company provide?**
2042 )))
2043 |(((
2044 **Annual Trade Show**
2045 )))|(((
2046 EXPO 2022
2047 )))|(((
2048 CSI
2049 )))|(((
2050 1100339
2051 )))|(((
2052 Fred
2053 )))|(((
2054 Jones
2055 )))|(((
2056 Owner
2057 )))|(((
2058 Jones Construction Ent.
2059 )))|(((
2060 690 E Highway 90
2061 )))|(((
2062 690 e HWY 90
2063 )))|(((
2064 Tampa
2065 )))|(((
2066 FL
2067 )))|(((
2068 32425
2069 )))|(((
2070
2071 )))|(((
2072 1  8505551001
2073 )))|(((
2074
2075 )))|(((
2076 __fred@myaddress.com__
2077 )))|(((
2078 __officemgr@notmyaddress.com__
2079 )))|(((
2080 850
2081 )))|(((
2082 5471001
2083 )))|(((
2084 Conference Attendee
2085 )))|(((
2086 Y
2087 )))|(((
2088 412351
2089 )))|(((
2090
2091 )))|(((
2092
2093 )))|(((
2094
2095 )))|(((
2096 396
2097 )))|(((
2098
2099 )))|(((
2100 Super Pass
2101 )))|(((
2102
2103 )))|(((
2104 1100002
2105 )))|(((
2106 Contractor
2107 )))|(((
2108 51-60
2109 )))|(((
2110 Contractor
2111 )))|(((
2112 No
2113 )))|(((
2114 Yes
2115 )))|(((
2116
2117 )))|(((
2118 Male
2119 )))|(((
2120 Yes
2121 )))|(((
2122 Owner/CEO/President/Executive
2123 )))|(((
2124 Both
2125 )))|(((
2126
2127 )))|(((
2128
2129 )))|(((
2130 This, That, A little of the other, Something Else
2131 )))|(((
2132 Yes
2133 )))|(((
2134 Yes
2135 )))|(((
2136 $1,000,000-$4,999,999
2137 )))|(((
2138 Yes
2139 )))|(((
2140 Roofing, Pool Repair, Driveway Sealing, Electrical Contracting
2141 )))
2142 |(((
2143
2144 )))|(((
2145
2146 )))|(((
2147
2148 )))|(((
2149
2150 )))|(((
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 **Annual Trade Show**
2243 )))|(((
2244 EXPO 2022
2245 )))|(((
2246 CSI
2247 )))|(((
2248 1100005
2249 )))|(((
2250 Jim
2251 )))|(((
2252 Nordstrom
2253 )))|(((
2254 Spouse
2255 )))|(((
2256 Nordstrom Chain, LLC
2257 )))|(((
2258 690 E Highway 90
2259 )))|(((
2260
2261 )))|(((
2262 Miami
2263 )))|(((
2264 FL
2265 )))|(((
2266 33736
2267 )))|(((
2268
2269 )))|(((
2270 1  8502588247
2271 )))|(((
2272
2273 )))|(((
2274 __jimnordstrom@something.com__
2275 )))|(((
2276
2277 )))|(((
2278 850
2279 )))|(((
2280 3998247
2281 )))|(((
2282 Attendee Expo Only
2283 )))|(((
2284 N
2285 )))|(((
2286
2287 )))|(((
2288
2289 )))|(((
2290
2291 )))|(((
2292
2293 )))|(((
2294 66
2295 )))|(((
2296
2297 )))|(((
2298 Expo Only
2299 )))|(((
2300
2301 )))|(((
2302 1100002
2303 )))|(((
2304 No Response
2305 )))|(((
2306 41-50
2307 )))|(((
2308 Spouse/Guest
2309 )))|(((
2310 Yes
2311 )))|(((
2312 Yes
2313 )))|(((
2314
2315 )))|(((
2316 Male
2317 )))|(((
2318 No Response
2319 )))|(((
2320 Spouse/Guest
2321 )))|(((
2322
2323 )))|(((
2324
2325 )))|(((
2326
2327 )))|(((
2328 Rope, Twine, Chain
2329 )))|(((
2330 No
2331 )))|(((
2332 No
2333 )))|(((
2334 No Response
2335 )))|(((
2336 No
2337 )))|(((
2338 No Response [DB ONLY]
2339 )))