Wiki source code of DExTr Import Files

Version 7.1 by Rayaan Ahmed on 2024/12/27 03:29
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 ==== LiveIntent Data Sample: ====
1325
1326 (% class="wrapped" %)
1327 |(((
1328 **Liveintentuserid**
1329 )))|(((
1330 **Advertiserid**
1331 )))|(((
1332 **Campaignid**
1333 )))|(((
1334 **Creativeid**
1335 )))|(((
1336 **Devtype**
1337 )))|(((
1338 **Emailasmdfive**
1339 )))|(((
1340 **Eventtype**
1341 )))|(((
1342 **Lineitemid**
1343 )))|(((
1344 **Liveintentdecisionid**
1345 )))|(((
1346 **Publisherid**
1347 )))|(((
1348 **Sectionid**
1349 )))|(((
1350 **Templateid**
1351 )))|(((
1352 **Timestamp**
1353 )))
1354 |(((
1355 **28427698**
1356 )))|(((
1357 39771
1358 )))|(((
1359 246944
1360 )))|(((
1361 787604
1362 )))|(((
1363 PC
1364 )))|(((
1365 d57dccaadbba6c4ad8f143de8c571771
1366 )))|(((
1367 impression
1368 )))|(((
1369 10001043
1370 )))|(((
1371 66233848-4580-3d7f-92b2-beb4741e8f7
1372 )))|(((
1373 36479
1374 )))|(((
1375 253729
1376 )))|(((
1377 19263
1378 )))|(((
1379 2021-03-10
1380 )))
1381 |(((
1382 **28422453**
1383 )))|(((
1384 39771
1385 )))|(((
1386 246944
1387 )))|(((
1388 787604
1389 )))|(((
1390 PC
1391 )))|(((
1392 2dece7448530fdf799254a875ebe0a77
1393 )))|(((
1394 impression
1395 )))|(((
1396 10001043
1397 )))|(((
1398 b8c41396-b896-333d-9945-522c21174e2
1399 )))|(((
1400 36479
1401 )))|(((
1402 277132
1403 )))|(((
1404 19263
1405 )))|(((
1406 2021-03-10
1407 )))
1408 |(((
1409 **28421392**
1410 )))|(((
1411 39771
1412 )))|(((
1413 246944
1414 )))|(((
1415 787604
1416 )))|(((
1417 PC
1418 )))|(((
1419 a4c0388d679348e467d27391b3fd456c
1420 )))|(((
1421 impression
1422 )))|(((
1423 10001043
1424 )))|(((
1425 844ebc51-0a02-3783-99c8-8ac96a29bc3
1426 )))|(((
1427 36479
1428 )))|(((
1429 277132
1430 )))|(((
1431 19263
1432 )))|(((
1433 2021-03-10
1434 )))
1435 |(((
1436 **28499279**
1437 )))|(((
1438 39771
1439 )))|(((
1440 246944
1441 )))|(((
1442 787604
1443 )))|(((
1444 PC
1445 )))|(((
1446 96032eb8da86e394b23c2a9647477d66
1447 )))|(((
1448 impression
1449 )))|(((
1450 10001043
1451 )))|(((
1452 69a0d6fd-7cb3-301d-b24a-04144d9ec74
1453 )))|(((
1454 36479
1455 )))|(((
1456 253729
1457 )))|(((
1458 19263
1459 )))|(((
1460 2021-03-10
1461 )))
1462 |(((
1463 **28421344**
1464 )))|(((
1465 39771
1466 )))|(((
1467 246944
1468 )))|(((
1469 787604
1470 )))|(((
1471 PC
1472 )))|(((
1473 fd2d53dbe2e7aa2198c19afce5a35cc6
1474 )))|(((
1475 impression
1476 )))|(((
1477 10001043
1478 )))|(((
1479 75c72eca-6cf1-3144-b00c-04ca49471363
1480 )))|(((
1481 36479
1482 )))|(((
1483 253729
1484 )))|(((
1485 19263
1486 )))|(((
1487 2021-03-10
1488 )))
1489
1490 ==== **BrightCove Data Sample:** ====
1491
1492 (% class="wrapped" %)
1493 |(((
1494 **Contactid**
1495 )))|(((
1496 **Country**
1497 )))|(((
1498 **Createdat**
1499 )))|(((
1500 **Device**
1501 )))|(((
1502 **Id**
1503 )))|(((
1504 **Metriccode**
1505 )))|(((
1506 **Pageurl**
1507 )))|(((
1508 **Playerid**
1509 )))|(((
1510 **Timewatched**
1511 )))|(((
1512 **Updatedat**
1513 )))|(((
1514 **Utmcampaign**
1515 )))|(((
1516 **Utmmedium**
1517 )))|(((
1518 **Utmsource**
1519 )))|(((
1520 **Videoid**
1521 )))|(((
1522 **Videoname**
1523 )))|(((
1524 **Watched**
1525 )))
1526 |(((
1527 **3B07C282-170D-46C4-B8CC-AAADFD**
1528 )))|(((
1529 United States
1530 )))|(((
1531 2021-02-11
1532 )))|(((
1533 desktop
1534 )))|(((
1535 309529
1536 )))|(((
1537 V1
1538 )))|(((
1539 __https:~/~/preview.CUSTOMER.com/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video__
1540 )))|(((
1541 Sy80k7Mtg
1542 )))|(((
1543 0
1544 )))|(((
1545 2021-02-11
1546 )))|(((
1547
1548 )))|(((
1549
1550 )))|(((
1551
1552 )))|(((
1553 5982181673007
1554 )))|(((
1555 What is symptomatic neurogenic orthostatic hypotension?
1556 )))|(((
1557 0
1558 )))
1559 |(((
1560 **228DA837-9358-43AB-A6E6-DFSF**
1561 )))|(((
1562 United States
1563 )))|(((
1564 2021-01-25
1565 )))|(((
1566 desktop
1567 )))|(((
1568 306311
1569 )))|(((
1570 V1
1571 )))|(((
1572 __https:~/~/www.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1573 )))|(((
1574 Sy80k7Mtg
1575 )))|(((
1576 1
1577 )))|(((
1578 2021-01-25
1579 )))|(((
1580
1581 )))|(((
1582
1583 )))|(((
1584
1585 )))|(((
1586 6171615690004
1587 )))|(((
1588 TED Risk Factors & Symptoms
1589 )))|(((
1590 1
1591 )))
1592 |(((
1593 **1EFC18BF-E9A4-44D9-849F-FDSFS**
1594 )))|(((
1595 United States
1596 )))|(((
1597 2021-01-29
1598 )))|(((
1599 desktop
1600 )))|(((
1601 307009
1602 )))|(((
1603 V1
1604 )))|(((
1605 __https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1606 )))|(((
1607 Sy80k7Mtg
1608 )))|(((
1609 1
1610 )))|(((
1611 2021-01-29
1612 )))|(((
1613
1614 )))|(((
1615
1616 )))|(((
1617
1618 )))|(((
1619 6171615690003
1620 )))|(((
1621 TED Risk Factors & Symptoms
1622 )))|(((
1623 1
1624 )))
1625 |(((
1626 **228DA837-9358-43AB-A6E6-DFASFDASF**
1627 )))|(((
1628 United States
1629 )))|(((
1630 2021-02-12
1631 )))|(((
1632 desktop
1633 )))|(((
1634 309633
1635 )))|(((
1636 V1
1637 )))|(((
1638 __https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi__
1639 )))|(((
1640 Sy80k7Mtg
1641 )))|(((
1642 0
1643 )))|(((
1644 2021-02-12
1645 )))|(((
1646
1647 )))|(((
1648
1649 )))|(((
1650
1651 )))|(((
1652 6171632240005
1653 )))|(((
1654 TED Pathophysiology
1655 )))|(((
1656 0
1657 )))
1658 |(((
1659 **5835554F-9B8A-4BA2-BB31-FDSAF**
1660 )))|(((
1661 United States
1662 )))|(((
1663 2021-02-09
1664 )))|(((
1665 desktop
1666 )))|(((
1667 309052
1668 )))|(((
1669 V1
1670 )))|(((
1671 __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
1672 )))|(((
1673 Sy80k7Mtg
1674 )))|(((
1675 40
1676 )))|(((
1677 2021-02-09
1678 )))|(((
1679 cardiology educationlab
1680 )))|(((
1681 email
1682 )))|(((
1683 selligent
1684 )))|(((
1685 6185538439007
1686 )))|(((
1687 Chapter 5 — NORTHERA Safety Results
1688 )))|(((
1689 19
1690 )))
1691 |(((
1692 **5835554F-9B8A-4BA2-BB31-68C51F5632F7**
1693 )))|(((
1694 United States
1695 )))|(((
1696 2021-02-09
1697 )))|(((
1698 desktop
1699 )))|(((
1700 309058
1701 )))|(((
1702 V1
1703 )))|(((
1704 __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
1705 )))|(((
1706 Sy80k7Mtg
1707 )))|(((
1708 10
1709 )))|(((
1710 2021-02-09
1711 )))|(((
1712 cardiology educationlab
1713 )))|(((
1714 email
1715 )))|(((
1716 selligent
1717 )))|(((
1718 6185538439004
1719 )))|(((
1720 Chapter 5 — NORTHERA Safety Results
1721 )))|(((
1722 5
1723 )))
1724 |(((
1725 **5835554F-9B8A-4BA2-BB31-68C51F5632F7**
1726 )))|(((
1727 United States
1728 )))|(((
1729 2021-02-09
1730 )))|(((
1731 desktop
1732 )))|(((
1733 309064
1734 )))|(((
1735 V1
1736 )))|(((
1737 __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
1738 )))|(((
1739 Sy80k7Mtg
1740 )))|(((
1741 30
1742 )))|(((
1743 2021-02-09
1744 )))|(((
1745 cardiology educationlab
1746 )))|(((
1747 email
1748 )))|(((
1749 selligent
1750 )))|(((
1751 6185538439008
1752 )))|(((
1753 Chapter 5 — NORTHERA Safety Results
1754 )))|(((
1755 14
1756 )))
1757
1758 **ContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1759
1760
1761 ==== **Raw Web Impressions** ====
1762
1763 (% class="wrapped" %)
1764 |(((
1765 **VisitContactId**
1766 )))|(((
1767 **EventTime**
1768 )))|(((
1769 **PlatformViewed**
1770 )))|(((
1771 **RefererID**
1772 )))|(((
1773 **SessionId**
1774 )))|(((
1775 **SiteName**
1776 )))|(((
1777 **Url**
1778 )))
1779 |(((
1780 **59DA834C-803E-4C14-9C49-FDSA**
1781 )))|(((
1782 2021-03-09 01:35:12
1783 )))|(((
1784 mobile
1785 )))|(((
1786
1787 )))|(((
1788 2407411196308715909161529690620210309
1789 )))|(((
1790 __www.CUSTOMER.com__
1791 )))|(((
1792 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1793 )))
1794 |(((
1795 **D0717BB2-CCDB-4DBE-ADD6-REWQREQW**
1796 )))|(((
1797 2021-03-06 01:43:53
1798 )))|(((
1799 tablet
1800 )))|(((
1801
1802 )))|(((
1803 2419995085411609985161503823320210306
1804 )))|(((
1805 __www.CUSTOMER.com__
1806 )))|(((
1807 __http:~/~/www.hCUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1808 )))
1809 |(((
1810 **1AFE97E9-9931-4427-9C4E-VZCXVZ**
1811 )))|(((
1812 2021-02-22 11:04:20
1813 )))|(((
1814 tablet
1815 )))|(((
1816
1817 )))|(((
1818 3663669472315156695161403488520210222
1819 )))|(((
1820 __www.CUSTOMER.com__
1821 )))|(((
1822 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1823 )))
1824 |(((
1825 **59DA834C-803E-4C14-9C49-YHDGT**
1826 )))|(((
1827 2021-03-09 01:35:14
1828 )))|(((
1829 mobile
1830 )))|(((
1831
1832 )))|(((
1833 2407411196308715909161529690620210309
1834 )))|(((
1835 __wwwCUSTOMER.com__
1836 )))|(((
1837 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1838 )))
1839 |(((
1840 **31C5F8C6-3EFF-4DE7-A899-JGVMHGY**
1841 )))|(((
1842 2021-02-25 05:11:38
1843 )))|(((
1844 mobile
1845 )))|(((
1846
1847 )))|(((
1848 8233752448896666794161427278020210225
1849 )))|(((
1850 __www.CUSTOMER.com__
1851 )))|(((
1852 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d__
1853 )))
1854 |(((
1855 **68E8551F-AD4E-4AAF-B4E6-RTSDFSAFA**
1856 )))|(((
1857 2021-03-15 09:57:00
1858 )))|(((
1859 desktop
1860 )))|(((
1861
1862 )))|(((
1863
1864 )))|(((
1865 __www.CUSTOMER.com__
1866 )))|(((
1867 __http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~~contactid~~__
1868 )))
1869
1870 **VisitContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1871
1872
1873 ==== **Swapcard (Webinar/Virtual Event Platform)** ====
1874
1875 |(((
1876 **Title**
1877 )))|(((
1878 **Start date**
1879 )))|(((
1880 **Format**
1881 )))|(((
1882 **Topics**
1883 )))|(((
1884 **Group**
1885 )))|(((
1886 **Email**
1887 )))|(((
1888 **First**
1889 )))|(((
1890 **Last**
1891 )))|(((
1892 **Title**
1893 )))|(((
1894 **Company**
1895 )))
1896 |(((
1897 **Is COVID-19 FOR REAL?**
1898 )))|(((
1899 2-11-21 12:55 PM
1900 )))|(((
1901 PRE_RECORDED
1902 )))|(((
1903 Other, Human Health, Policy, Business
1904 )))|(((
1905 Premium Members
1906 )))|(((
1907 [[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com||shape="rect"]]
1908 )))|(((
1909 Ryan
1910 )))|(((
1911 Brown
1912 )))|(((
1913
1914 )))|(((
1915 2XXX Group
1916 )))
1917 |(((
1918 **BREAKING NEWS SESSION: Extreme **
1919 )))|(((
1920 2-17-21 1:15 PM
1921 )))|(((
1922 PRE_RECORDED
1923 )))|(((
1924
1925 )))|(((
1926 Premium Members
1927 )))|(((
1928 [[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com||shape="rect"]]
1929 )))|(((
1930 Ryan
1931 )))|(((
1932 Brown
1933 )))|(((
1934
1935 )))|(((
1936 2XXX Group
1937 )))
1938
1939 ==== **Trade Show Registration Data** ====
1940
1941 |(((
1942 **Event Series**
1943 )))|(((
1944 **Event Edition**
1945 )))|(((
1946 **Source System**
1947 )))|(((
1948 **Reg Number**
1949 )))|(((
1950 **First Name**
1951 )))|(((
1952 **Last Name**
1953 )))|(((
1954 **Title**
1955 )))|(((
1956 **Company 1**
1957 )))|(((
1958 **Address 1**
1959 )))|(((
1960 **Address 2**
1961 )))|(((
1962 **City**
1963 )))|(((
1964 **State**
1965 )))|(((
1966 **Zip Code**
1967 )))|(((
1968 **Country**
1969 )))|(((
1970 **Phone Number**
1971 )))|(((
1972 **Fax Number**
1973 )))|(((
1974 **Email Address**
1975 )))|(((
1976 **Internet Address 2**
1977 )))|(((
1978 **Phone Area Code**
1979 )))|(((
1980 **Phone Number Only**
1981 )))|(((
1982 **Reg Code**
1983 )))|(((
1984 **Membership Flag**
1985 )))|(((
1986 **Member ID**
1987 )))|(((
1988 **Reg Code 3**
1989 )))|(((
1990 **Text 1**
1991 )))|(((
1992 **Credential**
1993 )))|(((
1994 **Amount Paid**
1995 )))|(((
1996 **Amount Refunded**
1997 )))|(((
1998 **Reg Code 2**
1999 )))|(((
2000 **Source Code**
2001 )))|(((
2002 **Link Reg ID**
2003 )))|(((
2004 **Business type:  Check all that apply.**
2005 )))|(((
2006 **Age range**
2007 )))|(((
2008 **Primary business**
2009 )))|(((
2010 **Is this your first time to attend the Expo?**
2011 )))|(((
2012 **Please keep me up-to-date with the latest events and services**
2013 )))|(((
2014 **I would like to hear from  directly about products and services**
2015 )))|(((
2016 **What is your gender?**
2017 )))|(((
2018 **Buying decisions**
2019 )))|(((
2020 **Job function**
2021 )))|(((
2022 **Primary Market**
2023 )))|(((
2024 **What is your job title/function?**
2025 )))|(((
2026 **What is your company's primary media type?**
2027 )))|(((
2028 **Products/services**
2029 )))|(((
2030 **Do you want to receive a free subscription to PVV Magazine?**
2031 )))|(((
2032 **Do you want to receive a free subscription to RXY Magazine?**
2033 )))|(((
2034 **Sales Volume**
2035 )))|(((
2036 **Do you want to receive a free subscription to our e-newsletter?**
2037 )))|(((
2038 **What services does your company provide?**
2039 )))
2040 |(((
2041 **Annual Trade Show**
2042 )))|(((
2043 EXPO 2022
2044 )))|(((
2045 CSI
2046 )))|(((
2047 1100339
2048 )))|(((
2049 Fred
2050 )))|(((
2051 Jones
2052 )))|(((
2053 Owner
2054 )))|(((
2055 Jones Construction Ent.
2056 )))|(((
2057 690 E Highway 90
2058 )))|(((
2059 690 e HWY 90
2060 )))|(((
2061 Tampa
2062 )))|(((
2063 FL
2064 )))|(((
2065 32425
2066 )))|(((
2067
2068 )))|(((
2069 1  8505551001
2070 )))|(((
2071
2072 )))|(((
2073 __fred@myaddress.com__
2074 )))|(((
2075 __officemgr@notmyaddress.com__
2076 )))|(((
2077 850
2078 )))|(((
2079 5471001
2080 )))|(((
2081 Conference Attendee
2082 )))|(((
2083 Y
2084 )))|(((
2085 412351
2086 )))|(((
2087
2088 )))|(((
2089
2090 )))|(((
2091
2092 )))|(((
2093 396
2094 )))|(((
2095
2096 )))|(((
2097 Super Pass
2098 )))|(((
2099
2100 )))|(((
2101 1100002
2102 )))|(((
2103 Contractor
2104 )))|(((
2105 51-60
2106 )))|(((
2107 Contractor
2108 )))|(((
2109 No
2110 )))|(((
2111 Yes
2112 )))|(((
2113
2114 )))|(((
2115 Male
2116 )))|(((
2117 Yes
2118 )))|(((
2119 Owner/CEO/President/Executive
2120 )))|(((
2121 Both
2122 )))|(((
2123
2124 )))|(((
2125
2126 )))|(((
2127 This, That, A little of the other, Something Else
2128 )))|(((
2129 Yes
2130 )))|(((
2131 Yes
2132 )))|(((
2133 $1,000,000-$4,999,999
2134 )))|(((
2135 Yes
2136 )))|(((
2137 Roofing, Pool Repair, Driveway Sealing, Electrical Contracting
2138 )))
2139 |(((
2140
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 **Annual Trade Show**
2240 )))|(((
2241 EXPO 2022
2242 )))|(((
2243 CSI
2244 )))|(((
2245 1100005
2246 )))|(((
2247 Jim
2248 )))|(((
2249 Nordstrom
2250 )))|(((
2251 Spouse
2252 )))|(((
2253 Nordstrom Chain, LLC
2254 )))|(((
2255 690 E Highway 90
2256 )))|(((
2257
2258 )))|(((
2259 Miami
2260 )))|(((
2261 FL
2262 )))|(((
2263 33736
2264 )))|(((
2265
2266 )))|(((
2267 1  8502588247
2268 )))|(((
2269
2270 )))|(((
2271 __jimnordstrom@something.com__
2272 )))|(((
2273
2274 )))|(((
2275 850
2276 )))|(((
2277 3998247
2278 )))|(((
2279 Attendee Expo Only
2280 )))|(((
2281 N
2282 )))|(((
2283
2284 )))|(((
2285
2286 )))|(((
2287
2288 )))|(((
2289
2290 )))|(((
2291 66
2292 )))|(((
2293
2294 )))|(((
2295 Expo Only
2296 )))|(((
2297
2298 )))|(((
2299 1100002
2300 )))|(((
2301 No Response
2302 )))|(((
2303 41-50
2304 )))|(((
2305 Spouse/Guest
2306 )))|(((
2307 Yes
2308 )))|(((
2309 Yes
2310 )))|(((
2311
2312 )))|(((
2313 Male
2314 )))|(((
2315 No Response
2316 )))|(((
2317 Spouse/Guest
2318 )))|(((
2319
2320 )))|(((
2321
2322 )))|(((
2323
2324 )))|(((
2325 Rope, Twine, Chain
2326 )))|(((
2327 No
2328 )))|(((
2329 No
2330 )))|(((
2331 No Response
2332 )))|(((
2333 No
2334 )))|(((
2335 No Response [DB ONLY]
2336 )))