Wiki source code of DExTr Import Files

Version 6.1 by Rayaan Ahmed on 2024/12/27 03:28

version	line-number	content
1.1	1	DExTr is a data mapping tool that can be used to transform data coming into or out of ONEcount. DExTr mappings are capable of mapping almost every type of data ONEcount uses. For all of the data types discussed below, ONEcount can both ingest this data from outside sources, and export files like this to be consumed by outside sources.
	2
	3	Below are some sample formats for data coming into ONEcount via DExTr. These samples are meant as examples only. DExTr is capable of manipulating data in multiple formats, and variations in these formats are usually acceptable.
	4
	5	All files should be in CSV format, with fields enclosed in quotes. If you have quotes within the data of a field and do not enclose the fields in quotes, you will have problems importing your data.
	6
	7	There are three main types of data that you can exchange with ONEcount: User Demographic Data, Transactional Data, and Engagement Data.
	8
	9	=== User Demographic Data ===
	10
	11	Typically data about the person, including NAME, ADDRESS, CITY, STATE, ZIP, JOB TITLE, E-MAIL, HAIR COLOR, ETC. If the system you are bringing the data in from contains a unique identifier, such as a user or customer ID, it is important to bring that data in so that it can be used for matching and de-duping records later. ONEcount can use ANY field to de-dupe, records, not just e-mail. Typically, records are de-duplicated across different fields depending on the source system (ie., records from your CRM system are de-duped based on the CRM ID, records from your e-mail system may be de-duped on the email system ID).
	12
	13
3.1	14	(% class="wrapped" %)
1.1	15	\|(((
5.2	16	(% style="color:#003366" %)ACCOUNT NUMBER
1.1	17	)))\|(((
5.2	18	(% style="color:#003366" %)FIRST NAME
1.1	19	)))\|(((
5.2	20	(% style="color:#003366" %)LAST NAME
1.1	21	)))\|(((
5.2	22	(% style="color:#003366" %)MIDDLE NAME
1.1	23	)))\|(((
5.2	24	(% style="color:#003366" %)TITLE
1.1	25	)))\|(((
5.2	26	(% style="color:#003366" %)SUFFIX
1.1	27	)))\|(((
5.2	28	(% style="color:#003366" %)COMPANY
1.1	29	)))\|(((
5.2	30	(% style="color:#003366" %)JOB TITLE
1.1	31	)))\|(((
5.2	32	(% style="color:#003366" %)ADDRESS1
1.1	33	)))\|(((
5.2	34	(% style="color:#003366" %)ADDRESS2
1.1	35	)))\|(((
5.2	36	(% style="color:#003366" %)CITY
1.1	37	)))\|(((
5.2	38	(% style="color:#003366" %)STATE
1.1	39	)))\|(((
5.2	40	(% style="color:#003366" %)ZIP
1.1	41	)))\|(((
5.2	42	(% style="color:#003366" %)ZIP4
1.1	43	)))\|(((
5.2	44	(% style="color:#003366" %)COUNTRY
1.1	45	)))\|(((
5.2	46	(% style="color:#003366" %)TELEPHONE NUMBER
1.1	47	)))\|(((
5.2	48	(% style="color:#003366" %)FAX NUMBER
1.1	49	)))\|(((
5.2	50	(% style="color:#003366" %)E-MAIL ADDRESS
1.1	51	)))\|(((
5.2	52	(% style="color:#003366" %)E-MAIL CONTACT
1.1	53	)))\|(((
5.2	54	(% style="color:#003366" %)CUSTOM1
1.1	55	)))\|(((
5.2	56	(% style="color:#003366" %)CUSTOM2
1.1	57	)))\|(((
5.2	58	(% style="color:#003366" %)CUSTOM3
1.1	59	)))\|(((
5.2	60	(% style="color:#003366" %)LAST UPDATED
1.1	61	)))\|(((
5.2	62	(% style="color:#003366" %)OCID
1.1	63	)))
	64	\|(((
5.2	65	(% style="color:#003366" %)14010000431
1.1	66	)))\|(((
5.2	67	(% style="color:#003366" %)Graham
1.1	68	)))\|(((
5.2	69	(% style="color:#003366" %)O'Gorman
1.1	70	)))\|(((
5.2	71
1.1	72	)))\|(((
5.2	73
1.1	74	)))\|(((
5.2	75
1.1	76	)))\|(((
5.2	77	(% style="color:#003366" %)Graham O'Gorman Landscape
1.1	78	)))\|(((
5.2	79
1.1	80	)))\|(((
5.2	81	(% style="color:#003366" %)192 Olmstead Hill Rd
1.1	82	)))\|(((
5.2	83
1.1	84	)))\|(((
5.2	85	(% style="color:#003366" %)Wilton
1.1	86	)))\|(((
5.2	87	(% style="color:#003366" %)CT
1.1	88	)))\|(((
5.2	89	(% style="color:#003366" %)6897
1.1	90	)))\|(((
5.2	91	(% style="color:#003366" %)1816
1.1	92	)))\|(((
5.2	93	(% style="color:#003366" %)United States
1.1	94	)))\|(((
5.2	95
1.1	96	)))\|(((
5.2	97
1.1	98	)))\|(((
5.2	99
1.1	100	)))\|(((
5.2	101	(% style="color:#003366" %)N
1.1	102	)))\|(((
5.2	103
1.1	104	)))\|(((
5.2	105
1.1	106	)))\|(((
5.2	107
1.1	108	)))\|(((
5.2	109	(% style="color:#003366" %)20141113211102
1.1	110	)))\|(((
5.2	111
1.1	112	)))
	113	\|(((
5.2	114	(% style="color:#003366" %)14010000449
1.1	115	)))\|(((
5.2	116	(% style="color:#003366" %)Dale S
1.1	117	)))\|(((
5.2	118	(% style="color:#003366" %)Galbo
1.1	119	)))\|(((
5.2	120
1.1	121	)))\|(((
5.2	122
1.1	123	)))\|(((
5.2	124
1.1	125	)))\|(((
5.2	126	(% style="color:#003366" %)Law Offices
1.1	127	)))\|(((
5.2	128	(% style="color:#003366" %)Owner
1.1	129	)))\|(((
5.2	130	(% style="color:#003366" %)15 W Hill Rd
1.1	131	)))\|(((
5.2	132
1.1	133	)))\|(((
5.2	134	(% style="color:#003366" %)Bloomfield
1.1	135	)))\|(((
5.2	136	(% style="color:#003366" %)CT
1.1	137	)))\|(((
5.2	138	(% style="color:#003366" %)6002
1.1	139	)))\|(((
5.2	140	(% style="color:#003366" %)5016
1.1	141	)))\|(((
5.2	142	(% style="color:#003366" %)United States
1.1	143	)))\|(((
5.2	144	(% style="color:#003366" %)2032709821
1.1	145	)))\|(((
5.2	146
1.1	147	)))\|(((
5.2	148
1.1	149	)))\|(((
5.2	150	(% style="color:#003366" %)N
1.1	151	)))\|(((
5.2	152
1.1	153	)))\|(((
5.2	154
1.1	155	)))\|(((
5.2	156
1.1	157	)))\|(((
5.2	158	(% style="color:#003366" %)20141113211111
1.1	159	)))\|(((
5.2	160
1.1	161	)))
	162	\|(((
5.2	163	(% style="color:#003366" %)14010000648
1.1	164	)))\|(((
5.2	165	(% style="color:#003366" %)Patricia
1.1	166	)))\|(((
5.2	167	(% style="color:#003366" %)Cannon
1.1	168	)))\|(((
5.2	169
1.1	170	)))\|(((
5.2	171
1.1	172	)))\|(((
5.2	173
1.1	174	)))\|(((
5.2	175	(% style="color:#003366" %)Employee Assistance Program
1.1	176	)))\|(((
5.2	177	(% style="color:#003366" %)Director
1.1	178	)))\|(((
5.2	179	(% style="color:#003366" %)887 Bridgeport Ave Ste C
1.1	180	)))\|(((
5.2	181
1.1	182	)))\|(((
5.2	183	(% style="color:#003366" %)Shelton
1.1	184	)))\|(((
5.2	185	(% style="color:#003366" %)CT
1.1	186	)))\|(((
5.2	187	(% style="color:#003366" %)6484
1.1	188	)))\|(((
5.2	189	(% style="color:#003366" %)7602
1.1	190	)))\|(((
5.2	191	(% style="color:#003366" %)United States
1.1	192	)))\|(((
5.2	193	(% style="color:#003366" %)2039290681
1.1	194	)))\|(((
5.2	195
1.1	196	)))\|(((
5.2	197
1.1	198	)))\|(((
5.2	199	(% style="color:#003366" %)N
1.1	200	)))\|(((
5.2	201
1.1	202	)))\|(((
5.2	203
1.1	204	)))\|(((
5.2	205
1.1	206	)))\|(((
5.2	207	(% style="color:#003366" %)20141121163017
1.1	208	)))\|(((
5.2	209
1.1	210	)))
	211	\|(((
5.2	212	(% style="color:#003366" %)14010001843
1.1	213	)))\|(((
5.2	214	(% style="color:#003366" %)Susan
1.1	215	)))\|(((
5.2	216	(% style="color:#003366" %)Kent
1.1	217	)))\|(((
5.2	218
1.1	219	)))\|(((
5.2	220
1.1	221	)))\|(((
5.2	222
1.1	223	)))\|(((
5.2	224
1.1	225	)))\|(((
5.2	226
1.1	227	)))\|(((
5.2	228	(% style="color:#003366" %)38110 5th St E Apt 1
1.1	229	)))\|(((
5.2	230
1.1	231	)))\|(((
5.2	232	(% style="color:#003366" %)Los Angeles
1.1	233	)))\|(((
5.2	234	(% style="color:#003366" %)CA
1.1	235	)))\|(((
5.2	236	(% style="color:#003366" %)93550
1.1	237	)))\|(((
5.2	238	(% style="color:#003366" %)2317
1.1	239	)))\|(((
5.2	240	(% style="color:#003366" %)United States
1.1	241	)))\|(((
5.2	242
1.1	243	)))\|(((
5.2	244
1.1	245	)))\|(((
5.2	246
1.1	247	)))\|(((
5.2	248	(% style="color:#003366" %)N
1.1	249	)))\|(((
5.2	250
1.1	251	)))\|(((
5.2	252
1.1	253	)))\|(((
5.2	254
1.1	255	)))\|(((
5.2	256	(% style="color:#003366" %)20141212210537
1.1	257	)))\|(((
5.2	258
1.1	259	)))
	260	\|(((
5.2	261	(% style="color:#003366" %)14010001858
1.1	262	)))\|(((
5.2	263	(% style="color:#003366" %)Brendan
1.1	264	)))\|(((
5.2	265	(% style="color:#003366" %)Eppley
1.1	266	)))\|(((
5.2	267
1.1	268	)))\|(((
5.2	269
1.1	270	)))\|(((
5.2	271
1.1	272	)))\|(((
5.2	273
1.1	274	)))\|(((
5.2	275
1.1	276	)))\|(((
5.2	277	(% style="color:#003366" %)20 Driftway Ln
1.1	278	)))\|(((
5.2	279
1.1	280	)))\|(((
5.2	281	(% style="color:#003366" %)Darien
1.1	282	)))\|(((
5.2	283	(% style="color:#003366" %)CT
1.1	284	)))\|(((
5.2	285	(% style="color:#003366" %)6820
1.1	286	)))\|(((
5.2	287	(% style="color:#003366" %)6130
1.1	288	)))\|(((
5.2	289	(% style="color:#003366" %)United States
1.1	290	)))\|(((
5.2	291
1.1	292	)))\|(((
5.2	293
1.1	294	)))\|(((
5.2	295
1.1	296	)))\|(((
5.2	297	(% style="color:#003366" %)N
1.1	298	)))\|(((
5.2	299
1.1	300	)))\|(((
5.2	301
1.1	302	)))\|(((
5.2	303
1.1	304	)))\|(((
5.2	305	(% style="color:#003366" %)20141211230144
1.1	306	)))\|(((
5.2	307
1.1	308	)))
	309	\|(((
5.2	310	(% style="color:#003366" %)14010001862
1.1	311	)))\|(((
5.2	312
1.1	313	)))\|(((
5.2	314
1.1	315	)))\|(((
5.2	316
1.1	317	)))\|(((
5.2	318
1.1	319	)))\|(((
5.2	320
1.1	321	)))\|(((
5.2	322	(% style="color:#003366" %)Orchard Tree Care Llc
1.1	323	)))\|(((
5.2	324
1.1	325	)))\|(((
5.2	326	(% style="color:#003366" %)184 Ave
1.1	327	)))\|(((
5.2	328
1.1	329	)))\|(((
5.2	330	(% style="color:#003366" %)Darien
1.1	331	)))\|(((
5.2	332	(% style="color:#003366" %)CT
1.1	333	)))\|(((
5.2	334	(% style="color:#003366" %)6820
1.1	335	)))\|(((
5.2	336
1.1	337	)))\|(((
5.2	338	(% style="color:#003366" %)United States
1.1	339	)))\|(((
5.2	340	(% style="color:#003366" %)2036550618
1.1	341	)))\|(((
5.2	342
1.1	343	)))\|(((
5.2	344
1.1	345	)))\|(((
5.2	346	(% style="color:#003366" %)N
1.1	347	)))\|(((
5.2	348
1.1	349	)))\|(((
5.2	350
1.1	351	)))\|(((
5.2	352
1.1	353	)))\|(((
5.2	354	(% style="color:#003366" %)20150211133156
1.1	355	)))\|(((
5.2	356
1.1	357	)))
	358	\|(((
5.2	359	(% style="color:#003366" %)14010001870
1.1	360	)))\|(((
5.2	361	(% style="color:#003366" %)Avis Z
1.1	362	)))\|(((
5.2	363	(% style="color:#003366" %)Gray
1.1	364	)))\|(((
5.2	365
1.1	366	)))\|(((
5.2	367
1.1	368	)))\|(((
5.2	369
1.1	370	)))\|(((
5.2	371	(% style="color:#003366" %)Designers 5 Incorporated
1.1	372	)))\|(((
5.2	373	(% style="color:#003366" %)President
1.1	374	)))\|(((
5.2	375	(% style="color:#003366" %)96 5 Mile River Rd
1.1	376	)))\|(((
5.2	377
1.1	378	)))\|(((
5.2	379	(% style="color:#003366" %)Darien
1.1	380	)))\|(((
5.2	381	(% style="color:#003366" %)CT
1.1	382	)))\|(((
5.2	383	(% style="color:#003366" %)6820
1.1	384	)))\|(((
5.2	385	(% style="color:#003366" %)6234
1.1	386	)))\|(((
5.2	387	(% style="color:#003366" %)United States
1.1	388	)))\|(((
5.2	389	(% style="color:#003366" %)2036552033
1.1	390	)))\|(((
5.2	391
1.1	392	)))\|(((
5.2	393
1.1	394	)))\|(((
5.2	395	(% style="color:#003366" %)N
1.1	396	)))\|(((
5.2	397
1.1	398	)))\|(((
5.2	399
1.1	400	)))\|(((
5.2	401
1.1	402	)))\|(((
5.2	403	(% style="color:#003366" %)20150212210227
1.1	404	)))\|(((
5.2	405
1.1	406	)))
	407	\|(((
5.2	408	(% style="color:#003366" %)14010001889
1.1	409	)))\|(((
5.2	410	(% style="color:#003366" %)John
1.1	411	)))\|(((
5.2	412	(% style="color:#003366" %)Hertz
1.1	413	)))\|(((
5.2	414
1.1	415	)))\|(((
5.2	416
1.1	417	)))\|(((
5.2	418
1.1	419	)))\|(((
5.2	420	(% style="color:#003366" %)Hertz Construction Co
1.1	421	)))\|(((
5.2	422	(% style="color:#003366" %)Partner
1.1	423	)))\|(((
5.2	424	(% style="color:#003366" %)12 Hillside Ave
1.1	425	)))\|(((
5.2	426
1.1	427	)))\|(((
5.2	428	(% style="color:#003366" %)Darien
1.1	429	)))\|(((
5.2	430	(% style="color:#003366" %)CT
1.1	431	)))\|(((
5.2	432	(% style="color:#003366" %)6820
1.1	433	)))\|(((
5.2	434	(% style="color:#003366" %)5010
1.1	435	)))\|(((
5.2	436	(% style="color:#003366" %)United States
1.1	437	)))\|(((
5.2	438	(% style="color:#003366" %)2036564900
1.1	439	)))\|(((
5.2	440
1.1	441	)))\|(((
5.2	442
1.1	443	)))\|(((
5.2	444	(% style="color:#003366" %)N
1.1	445	)))\|(((
5.2	446
1.1	447	)))\|(((
5.2	448
1.1	449	)))\|(((
5.2	450
1.1	451	)))\|(((
5.2	452	(% style="color:#003366" %)20141121163018
1.1	453	)))\|(((
5.2	454
1.1	455	)))
	456	\|(((
5.2	457	(% style="color:#003366" %)14010001891
1.1	458	)))\|(((
5.2	459
1.1	460	)))\|(((
5.2	461
1.1	462	)))\|(((
5.2	463
1.1	464	)))\|(((
5.2	465
1.1	466	)))\|(((
5.2	467
1.1	468	)))\|(((
5.2	469	(% style="color:#003366" %)Niche Home Furnishings Ll
1.1	470	)))\|(((
5.2	471
1.1	472	)))\|(((
5.2	473	(% style="color:#003366" %)25 Old Kings Hwy N Ste 17
1.1	474	)))\|(((
5.2	475
1.1	476	)))\|(((
5.2	477	(% style="color:#003366" %)Darien
1.1	478	)))\|(((
5.2	479	(% style="color:#003366" %)CT
1.1	480	)))\|(((
5.2	481	(% style="color:#003366" %)6820
1.1	482	)))\|(((
5.2	483	(% style="color:#003366" %)4608
1.1	484	)))\|(((
5.2	485	(% style="color:#003366" %)United States
1.1	486	)))\|(((
5.2	487	(% style="color:#003366" %)2036566674
1.1	488	)))\|(((
5.2	489
1.1	490	)))\|(((
5.2	491
1.1	492	)))\|(((
5.2	493	(% style="color:#003366" %)N
1.1	494	)))\|(((
5.2	495
1.1	496	)))\|(((
5.2	497
1.1	498	)))\|(((
5.2	499
1.1	500	)))\|(((
5.2	501	(% style="color:#003366" %)20141121163018
1.1	502	)))\|(((
5.2	503
1.1	504	)))
	505	\|(((
5.2	506	(% style="color:#003366" %)14010001901
1.1	507	)))\|(((
5.2	508	(% style="color:#003366" %)Wendy
1.1	509	)))\|(((
5.2	510	(% style="color:#003366" %)Cole
1.1	511	)))\|(((
5.2	512
1.1	513	)))\|(((
5.2	514	(% style="color:#003366" %)Ms.
1.1	515	)))\|(((
5.2	516
1.1	517	)))\|(((
5.2	518	(% style="color:#003366" %)Wendy C Cole Interiors
1.1	519	)))\|(((
5.2	520	(% style="color:#003366" %)Principal
1.1	521	)))\|(((
5.2	522	(% style="color:#003366" %)3 Outlook Dr
1.1	523	)))\|(((
5.2	524
1.1	525	)))\|(((
5.2	526	(% style="color:#003366" %)Darien
1.1	527	)))\|(((
5.2	528	(% style="color:#003366" %)CT
1.1	529	)))\|(((
5.2	530	(% style="color:#003366" %)6820
1.1	531	)))\|(((
5.2	532	(% style="color:#003366" %)5616
1.1	533	)))\|(((
5.2	534	(% style="color:#003366" %)United States
1.1	535	)))\|(((
5.2	536	(% style="color:#003366" %)2036552954
1.1	537	)))\|(((
5.2	538
1.1	539	)))\|(((
5.2	540
1.1	541	)))\|(((
5.2	542	(% style="color:#003366" %)N
1.1	543	)))\|(((
5.2	544
1.1	545	)))\|(((
5.2	546
1.1	547	)))\|(((
5.2	548
1.1	549	)))\|(((
5.2	550	(% style="color:#003366" %)20150212210227
1.1	551	)))\|(((
5.2	552
1.1	553	)))
	554	\|(((
5.2	555	(% style="color:#003366" %)14010001917
1.1	556	)))\|(((
5.2	557	(% style="color:#003366" %)Frank
1.1	558	)))\|(((
5.2	559	(% style="color:#003366" %)Stone
1.1	560	)))\|(((
5.2	561
1.1	562	)))\|(((
5.2	563
1.1	564	)))\|(((
5.2	565
1.1	566	)))\|(((
5.2	567	(% style="color:#003366" %)Stones Landscape
1.1	568	)))\|(((
5.2	569	(% style="color:#003366" %)Owner
1.1	570	)))\|(((
5.2	571	(% style="color:#003366" %)258 West Ave
1.1	572	)))\|(((
5.2	573
1.1	574	)))\|(((
5.2	575	(% style="color:#003366" %)Darien
1.1	576	)))\|(((
5.2	577	(% style="color:#003366" %)CT
1.1	578	)))\|(((
5.2	579	(% style="color:#003366" %)6820
1.1	580	)))\|(((
5.2	581	(% style="color:#003366" %)4111
1.1	582	)))\|(((
5.2	583	(% style="color:#003366" %)United States
1.1	584	)))\|(((
5.2	585	(% style="color:#003366" %)2036569674
1.1	586	)))\|(((
5.2	587
1.1	588	)))\|(((
5.2	589
1.1	590	)))\|(((
5.2	591	(% style="color:#003366" %)N
1.1	592	)))\|(((
5.2	593
1.1	594	)))\|(((
5.2	595
1.1	596	)))\|(((
5.2	597
1.1	598	)))\|(((
5.2	599	(% style="color:#003366" %)20150212210227
1.1	600	)))\|(((
5.2	601
1.1	602	)))
	603	\|(((
5.2	604	(% style="color:#003366" %)14010002429
1.1	605	)))\|(((
5.2	606	(% style="color:#003366" %)Bruce
1.1	607	)))\|(((
5.2	608	(% style="color:#003366" %)Pomerance
1.1	609	)))\|(((
5.2	610
1.1	611	)))\|(((
5.2	612	(% style="color:#003366" %)Mr.
1.1	613	)))\|(((
5.2	614
1.1	615	)))\|(((
5.2	616	(% style="color:#003366" %)P L V Inc
1.1	617	)))\|(((
5.2	618	(% style="color:#003366" %)President
1.1	619	)))\|(((
5.2	620	(% style="color:#003366" %)1076 Post Rd
1.1	621	)))\|(((
5.2	622
1.1	623	)))\|(((
5.2	624	(% style="color:#003366" %)Darien
1.1	625	)))\|(((
5.2	626	(% style="color:#003366" %)CT
1.1	627	)))\|(((
5.2	628	(% style="color:#003366" %)6820
1.1	629	)))\|(((
5.2	630	(% style="color:#003366" %)5414
1.1	631	)))\|(((
5.2	632	(% style="color:#003366" %)United States
1.1	633	)))\|(((
5.2	634	(% style="color:#003366" %)2036554668
1.1	635	)))\|(((
5.2	636
1.1	637	)))\|(((
5.2	638
1.1	639	)))\|(((
5.2	640	(% style="color:#003366" %)N
1.1	641	)))\|(((
5.2	642
1.1	643	)))\|(((
5.2	644
1.1	645	)))\|(((
5.2	646
1.1	647	)))\|(((
5.2	648	(% style="color:#003366" %)20150212210227
1.1	649	)))\|(((
5.2	650
1.1	651	)))
	652	\|(((
5.2	653	(% style="color:#003366" %)14010002438
1.1	654	)))\|(((
5.2	655	(% style="color:#003366" %)Joanne
1.1	656	)))\|(((
5.2	657	(% style="color:#003366" %)Salvatore
1.1	658	)))\|(((
5.2	659
1.1	660	)))\|(((
5.2	661
1.1	662	)))\|(((
5.2	663
1.1	664	)))\|(((
5.2	665	(% style="color:#003366" %)Nassau Interests Llc
1.1	666	)))\|(((
5.2	667	(% style="color:#003366" %)Member
1.1	668	)))\|(((
5.2	669	(% style="color:#003366" %)42 N Meadows Ln
1.1	670	)))\|(((
5.2	671
1.1	672	)))\|(((
5.2	673	(% style="color:#003366" %)Stamford
1.1	674	)))\|(((
5.2	675	(% style="color:#003366" %)CT
1.1	676	)))\|(((
5.2	677	(% style="color:#003366" %)6903
1.1	678	)))\|(((
5.2	679	(% style="color:#003366" %)5151
1.1	680	)))\|(((
5.2	681	(% style="color:#003366" %)United States
1.1	682	)))\|(((
5.2	683	(% style="color:#003366" %)2036550303
1.1	684	)))\|(((
5.2	685
1.1	686	)))\|(((
5.2	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);"]]
1.1	688	)))\|(((
5.2	689	(% style="color:#003366" %)Y
1.1	690	)))\|(((
5.2	691
1.1	692	)))\|(((
5.2	693
1.1	694	)))\|(((
5.2	695
1.1	696	)))\|(((
5.2	697	(% style="color:#003366" %)20141212210537
1.1	698	)))\|(((
5.2	699
1.1	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
5.1	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.
1.1	717
	718	This will create the following work-flow:
	719
3.1	720	(% class="wrapped" %)
1.1	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
3.1	755	(% class="wrapped" %)
1.1	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	)))\|(((
5.2	790
1.1	791	)))\|(((
5.2	792
1.1	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	)))\|(((
5.2	809
1.1	810	)))\|(((
5.2	811
1.1	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	)))\|(((
5.2	828
1.1	829	)))\|(((
5.2	830
1.1	831	)))
	832	\|(((
	833	14010116098
	834	)))\|(((
	835	4215
	836	)))\|(((
	837	2015-02-08
	838	)))\|(((
	839	2015-02-08
	840	)))\|(((
	841	U
	842	)))\|(((
	843	1
	844	)))\|(((
5.2	845
1.1	846	)))\|(((
5.2	847
1.1	848	)))\|(((
5.2	849
1.1	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
5.1	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	)))\|(((
5.2	926
5.1	927	)))\|(((
	928	57 CHURCH ST
	929	)))\|(((
5.2	930
5.1	931	)))\|(((
	932	ROXBURY
	933	)))\|(((
	934	67831704
	935	)))\|(((
	936	CT
	937	)))\|(((
	938	M
	939	)))\|(((
	940	TREN68B
	941	)))\|(((
	942	5F
	943	)))\|(((
5.2	944
5.1	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	(((
5.2	964
5.1	965	)))\|(((
	966	Q
	967	)))\|(((
	968	JOSEPH
	969	)))\|(((
	970	JONES
	971	)))\|(((
	972	JONES & CO
	973	)))\|(((
	974	7632 WILDCAT PIKE
	975	)))\|(((
5.2	976
5.1	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	)))\|(((
5.2	1007
5.1	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	)))\|(((
5.2	1022
5.1	1023	)))\|(((
	1024	DETROIT
	1025	)))\|(((
	1026	482024093
	1027	)))\|(((
	1028	MI
	1029	)))\|(((
	1030	M
	1031	)))\|(((
	1032	RRT6GT
	1033	)))\|(((
	1034	1A
	1035	)))\|(((
5.2	1036
5.1	1037	)))\|(((
	1038	20201207
	1039	)))\|(((
	1040	20210401
	1041	)))\|(((
5.2	1042
5.1	1043	)))\|(((
	1044	PAID
	1045	)))\|(((
	1046	WAYNE
	1047	)))\|(((
	1048	USA
	1049	)))
1.1	1050
5.1	1051	PUBCODE maps to Package TERM
	1052
	1053
1.1	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
5.2	1058
	1059	NOTE: For e-mail engagement activity date, message id, recipient id, activity type, email click url
	1060
	1061
1.1	1062	Here are a couple of examples:
	1063
	1064	==== E-Mail Engagement (combined, from Eloqua) ====
	1065
3.1	1066	(% class="wrapped" %)
1.1	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	\|(((
5.2	1097
1.1	1098	)))\|(((
5.2	1099
1.1	1100	)))\|(((
5.2	1101
1.1	1102	)))\|(((
5.2	1103
1.1	1104	)))\|(((
5.2	1105
1.1	1106	)))\|(((
5.2	1107
1.1	1108	)))\|(((
5.2	1109
1.1	1110	)))\|(((
5.2	1111
1.1	1112	)))\|(((
5.2	1113
1.1	1114	)))\|(((
5.2	1115
1.1	1116	)))\|(((
5.2	1117
1.1	1118	)))\|(((
5.2	1119
1.1	1120	)))\|(((
5.2	1121
1.1	1122	)))\|(((
5.2	1123
1.1	1124	)))
	1125	\|(((
5.2	1126
1.1	1127	)))\|(((
5.2	1128
1.1	1129	)))\|(((
5.2	1130
1.1	1131	)))\|(((
5.2	1132
1.1	1133	)))\|(((
5.2	1134
1.1	1135	)))\|(((
5.2	1136
1.1	1137	)))\|(((
5.2	1138
1.1	1139	)))\|(((
5.2	1140
1.1	1141	)))\|(((
5.2	1142
1.1	1143	)))\|(((
5.2	1144
1.1	1145	)))\|(((
5.2	1146
1.1	1147	)))\|(((
5.2	1148
1.1	1149	)))\|(((
5.2	1150
1.1	1151	)))\|(((
5.2	1152
1.1	1153	)))
	1154	\|(((
5.2	1155
1.1	1156	)))\|(((
5.2	1157
1.1	1158	)))\|(((
5.2	1159
1.1	1160	)))\|(((
5.2	1161
1.1	1162	)))\|(((
5.2	1163
1.1	1164	)))\|(((
5.2	1165
1.1	1166	)))\|(((
5.2	1167
1.1	1168	)))\|(((
5.2	1169
1.1	1170	)))\|(((
5.2	1171
1.1	1172	)))\|(((
5.2	1173
1.1	1174	)))\|(((
5.2	1175
1.1	1176	)))\|(((
5.2	1177
1.1	1178	)))\|(((
5.2	1179
1.1	1180	)))\|(((
5.2	1181
1.1	1182	)))
	1183
	1184	ContactID is an Eloqua-specific ID
	1185
5.2	1186	VisitorID is a custom field in the e-mail system containing the user's GUID from the customer's internal data lake
1.1	1187
	1188	==== E-mail Engagement (Split Files) ====
	1189
	1190	email-clicks.csv:
	1191
3.1	1192	(% class="wrapped" %)
1.1	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	\|(((
5.2	1221
1.1	1222	)))\|(((
5.2	1223
1.1	1224	)))\|(((
5.2	1225
1.1	1226	)))\|(((
5.2	1227
1.1	1228	)))\|(((
5.2	1229
1.1	1230	)))\|(((
5.2	1231
1.1	1232	)))\|(((
5.2	1233
1.1	1234	)))\|(((
5.2	1235
1.1	1236	)))\|(((
5.2	1237
1.1	1238	)))\|(((
5.2	1239
1.1	1240	)))\|(((
5.2	1241
1.1	1242	)))\|(((
5.2	1243
1.1	1244	)))\|(((
5.2	1245
1.1	1246	)))
	1247
	1248	email-opens.csv
	1249
3.1	1250	(% class="wrapped" %)
1.1	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	\|(((
5.2	1269
1.1	1270	)))\|(((
5.2	1271
1.1	1272	)))\|(((
5.2	1273
1.1	1274	)))\|(((
5.2	1275
1.1	1276	)))\|(((
5.2	1277
1.1	1278	)))\|(((
5.2	1279
1.1	1280	)))\|(((
5.2	1281
1.1	1282	)))\|(((
5.2	1283
1.1	1284	)))
	1285
	1286	email-sends.csv
	1287
3.1	1288	(% class="wrapped" %)
1.1	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	\|(((
5.2	1307
1.1	1308	)))\|(((
5.2	1309
1.1	1310	)))\|(((
5.2	1311
1.1	1312	)))\|(((
5.2	1313
1.1	1314	)))\|(((
5.2	1315
1.1	1316	)))\|(((
5.2	1317
1.1	1318	)))\|(((
5.2	1319
1.1	1320	)))\|(((
5.2	1321
1.1	1322	)))
	1323
4.1	1324
5.1	1325	==== LiveIntent Data Sample: ====
4.1	1326
5.1	1327	(% class="wrapped" %)
4.1	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
1.1	1492	==== BrightCove Data Sample: ====
	1493
3.1	1494	(% class="wrapped" %)
1.1	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	)))\|(((
4.1	1541	__https:~/~/preview.CUSTOMER.com/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video__
1.1	1542	)))\|(((
	1543	Sy80k7Mtg
	1544	)))\|(((
	1545	0
	1546	)))\|(((
	1547	2021-02-11
	1548	)))\|(((
5.2	1549
1.1	1550	)))\|(((
5.2	1551
1.1	1552	)))\|(((
5.2	1553
1.1	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	)))\|(((
4.1	1574	__https:~/~/www.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1.1	1575	)))\|(((
	1576	Sy80k7Mtg
	1577	)))\|(((
	1578	1
	1579	)))\|(((
	1580	2021-01-25
	1581	)))\|(((
5.2	1582
1.1	1583	)))\|(((
5.2	1584
1.1	1585	)))\|(((
5.2	1586
1.1	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	)))\|(((
4.1	1607	__https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1.1	1608	)))\|(((
	1609	Sy80k7Mtg
	1610	)))\|(((
	1611	1
	1612	)))\|(((
	1613	2021-01-29
	1614	)))\|(((
5.2	1615
1.1	1616	)))\|(((
5.2	1617
1.1	1618	)))\|(((
5.2	1619
1.1	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	)))\|(((
4.1	1640	__https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi__
1.1	1641	)))\|(((
	1642	Sy80k7Mtg
	1643	)))\|(((
	1644	0
	1645	)))\|(((
	1646	2021-02-12
	1647	)))\|(((
5.2	1648
1.1	1649	)))\|(((
5.2	1650
1.1	1651	)))\|(((
5.2	1652
1.1	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	)))\|(((
4.1	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
1.1	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	)))\|(((
4.1	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
1.1	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	)))\|(((
4.1	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
1.1	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
4.1	1763	==== Raw Web Impressions ====
1.1	1764
3.1	1765	(% class="wrapped" %)
1.1	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	)))\|(((
5.2	1788
1.1	1789	)))\|(((
	1790	2407411196308715909161529690620210309
	1791	)))\|(((
4.1	1792	__www.CUSTOMER.com__
1.1	1793	)))\|(((
4.1	1794	__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1.1	1795	)))
	1796	\|(((
	1797	D0717BB2-CCDB-4DBE-ADD6-REWQREQW
	1798	)))\|(((
	1799	2021-03-06 01:43:53
	1800	)))\|(((
	1801	tablet
	1802	)))\|(((
5.2	1803
1.1	1804	)))\|(((
	1805	2419995085411609985161503823320210306
	1806	)))\|(((
4.1	1807	__www.CUSTOMER.com__
1.1	1808	)))\|(((
4.1	1809	__http:~/~/www.hCUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1.1	1810	)))
	1811	\|(((
	1812	1AFE97E9-9931-4427-9C4E-VZCXVZ
	1813	)))\|(((
	1814	2021-02-22 11:04:20
	1815	)))\|(((
	1816	tablet
	1817	)))\|(((
5.2	1818
1.1	1819	)))\|(((
	1820	3663669472315156695161403488520210222
	1821	)))\|(((
4.1	1822	__www.CUSTOMER.com__
1.1	1823	)))\|(((
4.1	1824	__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1.1	1825	)))
	1826	\|(((
	1827	59DA834C-803E-4C14-9C49-YHDGT
	1828	)))\|(((
	1829	2021-03-09 01:35:14
	1830	)))\|(((
	1831	mobile
	1832	)))\|(((
5.2	1833
1.1	1834	)))\|(((
	1835	2407411196308715909161529690620210309
	1836	)))\|(((
4.1	1837	__wwwCUSTOMER.com__
1.1	1838	)))\|(((
4.1	1839	__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1.1	1840	)))
	1841	\|(((
	1842	31C5F8C6-3EFF-4DE7-A899-JGVMHGY
	1843	)))\|(((
	1844	2021-02-25 05:11:38
	1845	)))\|(((
	1846	mobile
	1847	)))\|(((
5.2	1848
1.1	1849	)))\|(((
	1850	8233752448896666794161427278020210225
	1851	)))\|(((
4.1	1852	__www.CUSTOMER.com__
1.1	1853	)))\|(((
4.1	1854	__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d__
1.1	1855	)))
	1856	\|(((
	1857	68E8551F-AD4E-4AAF-B4E6-RTSDFSAFA
	1858	)))\|(((
	1859	2021-03-15 09:57:00
	1860	)))\|(((
	1861	desktop
	1862	)))\|(((
5.2	1863
1.1	1864	)))\|(((
5.2	1865
1.1	1866	)))\|(((
4.1	1867	__www.CUSTOMER.com__
1.1	1868	)))\|(((
4.1	1869	__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~~contactid~~__
1.1	1870	)))
	1871
	1872	VisitContactID is a GUID assigned by the Customer's Internal Data Warehouse
5.1	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	\|(((
5.2	1899	Is COVID-19 FOR REAL?
5.1	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	)))\|(((
5.2	1915
5.1	1916	)))\|(((
	1917	2XXX Group
	1918	)))
	1919	\|(((
5.2	1920	BREAKING NEWS SESSION: Extreme
5.1	1921	)))\|(((
	1922	2-17-21 1:15 PM
	1923	)))\|(((
	1924	PRE_RECORDED
	1925	)))\|(((
5.2	1926
5.1	1927	)))\|(((
	1928	Premium Members
	1929	)))\|(((
	1930	[[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com\|\|shape="rect"]]
	1931	)))\|(((
	1932	Ryan
	1933	)))\|(((
	1934	Brown
	1935	)))\|(((
5.2	1936
5.1	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	)))\|(((
5.2	2015	Please keep me up-to-date with the latest events and services
5.1	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	\|(((
5.2	2044	Annual Trade Show
5.1	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	)))\|(((
5.2	2070
5.1	2071	)))\|(((
	2072	1 8505551001
	2073	)))\|(((
5.2	2074
5.1	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	)))\|(((
5.2	2090
5.1	2091	)))\|(((
5.2	2092
5.1	2093	)))\|(((
5.2	2094
5.1	2095	)))\|(((
	2096	396
	2097	)))\|(((
5.2	2098
5.1	2099	)))\|(((
	2100	Super Pass
	2101	)))\|(((
5.2	2102
5.1	2103	)))\|(((
	2104	1100002
	2105	)))\|(((
	2106	Contractor
	2107	)))\|(((
	2108	51-60
	2109	)))\|(((
	2110	Contractor
	2111	)))\|(((
	2112	No
	2113	)))\|(((
	2114	Yes
	2115	)))\|(((
5.2	2116
5.1	2117	)))\|(((
	2118	Male
	2119	)))\|(((
	2120	Yes
	2121	)))\|(((
	2122	Owner/CEO/President/Executive
	2123	)))\|(((
	2124	Both
	2125	)))\|(((
5.2	2126
5.1	2127	)))\|(((
5.2	2128
5.1	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	\|(((
5.2	2143
5.1	2144	)))\|(((
5.2	2145
5.1	2146	)))\|(((
5.2	2147
5.1	2148	)))\|(((
5.2	2149
5.1	2150	)))\|(((
5.2	2151
5.1	2152	)))\|(((
5.2	2153
5.1	2154	)))\|(((
5.2	2155
5.1	2156	)))\|(((
5.2	2157
5.1	2158	)))\|(((
5.2	2159
5.1	2160	)))\|(((
5.2	2161
5.1	2162	)))\|(((
5.2	2163
5.1	2164	)))\|(((
5.2	2165
5.1	2166	)))\|(((
5.2	2167
5.1	2168	)))\|(((
5.2	2169
5.1	2170	)))\|(((
5.2	2171
5.1	2172	)))\|(((
5.2	2173
5.1	2174	)))\|(((
5.2	2175
5.1	2176	)))\|(((
5.2	2177
5.1	2178	)))\|(((
5.2	2179
5.1	2180	)))\|(((
5.2	2181
5.1	2182	)))\|(((
5.2	2183
5.1	2184	)))\|(((
5.2	2185
5.1	2186	)))\|(((
5.2	2187
5.1	2188	)))\|(((
5.2	2189
5.1	2190	)))\|(((
5.2	2191
5.1	2192	)))\|(((
5.2	2193
5.1	2194	)))\|(((
5.2	2195
5.1	2196	)))\|(((
5.2	2197
5.1	2198	)))\|(((
5.2	2199
5.1	2200	)))\|(((
5.2	2201
5.1	2202	)))\|(((
5.2	2203
5.1	2204	)))\|(((
5.2	2205
5.1	2206	)))\|(((
5.2	2207
5.1	2208	)))\|(((
5.2	2209
5.1	2210	)))\|(((
5.2	2211
5.1	2212	)))\|(((
5.2	2213
5.1	2214	)))\|(((
5.2	2215
5.1	2216	)))\|(((
5.2	2217
5.1	2218	)))\|(((
5.2	2219
5.1	2220	)))\|(((
5.2	2221
5.1	2222	)))\|(((
5.2	2223
5.1	2224	)))\|(((
5.2	2225
5.1	2226	)))\|(((
5.2	2227
5.1	2228	)))\|(((
5.2	2229
5.1	2230	)))\|(((
5.2	2231
5.1	2232	)))\|(((
5.2	2233
5.1	2234	)))\|(((
5.2	2235
5.1	2236	)))\|(((
5.2	2237
5.1	2238	)))\|(((
5.2	2239
5.1	2240	)))
	2241	\|(((
5.2	2242	Annual Trade Show
5.1	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	)))\|(((
5.2	2260
5.1	2261	)))\|(((
	2262	Miami
	2263	)))\|(((
	2264	FL
	2265	)))\|(((
	2266	33736
	2267	)))\|(((
5.2	2268
5.1	2269	)))\|(((
	2270	1 8502588247
	2271	)))\|(((
5.2	2272
5.1	2273	)))\|(((
	2274	__jimnordstrom@something.com__
	2275	)))\|(((
5.2	2276
5.1	2277	)))\|(((
	2278	850
	2279	)))\|(((
	2280	3998247
	2281	)))\|(((
	2282	Attendee Expo Only
	2283	)))\|(((
	2284	N
	2285	)))\|(((
5.2	2286
5.1	2287	)))\|(((
5.2	2288
5.1	2289	)))\|(((
5.2	2290
5.1	2291	)))\|(((
5.2	2292
5.1	2293	)))\|(((
	2294	66
	2295	)))\|(((
5.2	2296
5.1	2297	)))\|(((
	2298	Expo Only
	2299	)))\|(((
5.2	2300
5.1	2301	)))\|(((
	2302	1100002
	2303	)))\|(((
	2304	No Response
	2305	)))\|(((
	2306	41-50
	2307	)))\|(((
	2308	Spouse/Guest
	2309	)))\|(((
	2310	Yes
	2311	)))\|(((
	2312	Yes
	2313	)))\|(((
5.2	2314
5.1	2315	)))\|(((
	2316	Male
	2317	)))\|(((
	2318	No Response
	2319	)))\|(((
	2320	Spouse/Guest
	2321	)))\|(((
5.2	2322
5.1	2323	)))\|(((
5.2	2324
5.1	2325	)))\|(((
5.2	2326
5.1	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	)))