Wiki source code of DExTr Import Files

Last modified by Admin User on 2024/12/27 09:51

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
8.1	1059	NOTE: For e-mail engagement activity date, message id, recipient id, activity type, email click url are required.
5.2	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
5.1	1324	==== LiveIntent Data Sample: ====
4.1	1325
5.1	1326	(% class="wrapped" %)
4.1	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
1.1	1490	==== BrightCove Data Sample: ====
	1491
3.1	1492	(% class="wrapped" %)
1.1	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	)))\|(((
4.1	1539	__https:~/~/preview.CUSTOMER.com/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video__
1.1	1540	)))\|(((
	1541	Sy80k7Mtg
	1542	)))\|(((
	1543	0
	1544	)))\|(((
	1545	2021-02-11
	1546	)))\|(((
5.2	1547
1.1	1548	)))\|(((
5.2	1549
1.1	1550	)))\|(((
5.2	1551
1.1	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	)))\|(((
4.1	1572	__https:~/~/www.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1.1	1573	)))\|(((
	1574	Sy80k7Mtg
	1575	)))\|(((
	1576	1
	1577	)))\|(((
	1578	2021-01-25
	1579	)))\|(((
5.2	1580
1.1	1581	)))\|(((
5.2	1582
1.1	1583	)))\|(((
5.2	1584
1.1	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	)))\|(((
4.1	1605	__https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1.1	1606	)))\|(((
	1607	Sy80k7Mtg
	1608	)))\|(((
	1609	1
	1610	)))\|(((
	1611	2021-01-29
	1612	)))\|(((
5.2	1613
1.1	1614	)))\|(((
5.2	1615
1.1	1616	)))\|(((
5.2	1617
1.1	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	)))\|(((
4.1	1638	__https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi__
1.1	1639	)))\|(((
	1640	Sy80k7Mtg
	1641	)))\|(((
	1642	0
	1643	)))\|(((
	1644	2021-02-12
	1645	)))\|(((
5.2	1646
1.1	1647	)))\|(((
5.2	1648
1.1	1649	)))\|(((
5.2	1650
1.1	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	)))\|(((
4.1	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
1.1	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	)))\|(((
4.1	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
1.1	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	)))\|(((
4.1	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
1.1	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
4.1	1761	==== Raw Web Impressions ====
1.1	1762
3.1	1763	(% class="wrapped" %)
1.1	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	)))\|(((
5.2	1786
1.1	1787	)))\|(((
	1788	2407411196308715909161529690620210309
	1789	)))\|(((
4.1	1790	__www.CUSTOMER.com__
1.1	1791	)))\|(((
4.1	1792	__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1.1	1793	)))
	1794	\|(((
	1795	D0717BB2-CCDB-4DBE-ADD6-REWQREQW
	1796	)))\|(((
	1797	2021-03-06 01:43:53
	1798	)))\|(((
	1799	tablet
	1800	)))\|(((
5.2	1801
1.1	1802	)))\|(((
	1803	2419995085411609985161503823320210306
	1804	)))\|(((
4.1	1805	__www.CUSTOMER.com__
1.1	1806	)))\|(((
4.1	1807	__http:~/~/www.hCUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1.1	1808	)))
	1809	\|(((
	1810	1AFE97E9-9931-4427-9C4E-VZCXVZ
	1811	)))\|(((
	1812	2021-02-22 11:04:20
	1813	)))\|(((
	1814	tablet
	1815	)))\|(((
5.2	1816
1.1	1817	)))\|(((
	1818	3663669472315156695161403488520210222
	1819	)))\|(((
4.1	1820	__www.CUSTOMER.com__
1.1	1821	)))\|(((
4.1	1822	__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1.1	1823	)))
	1824	\|(((
	1825	59DA834C-803E-4C14-9C49-YHDGT
	1826	)))\|(((
	1827	2021-03-09 01:35:14
	1828	)))\|(((
	1829	mobile
	1830	)))\|(((
5.2	1831
1.1	1832	)))\|(((
	1833	2407411196308715909161529690620210309
	1834	)))\|(((
4.1	1835	__wwwCUSTOMER.com__
1.1	1836	)))\|(((
4.1	1837	__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1.1	1838	)))
	1839	\|(((
	1840	31C5F8C6-3EFF-4DE7-A899-JGVMHGY
	1841	)))\|(((
	1842	2021-02-25 05:11:38
	1843	)))\|(((
	1844	mobile
	1845	)))\|(((
5.2	1846
1.1	1847	)))\|(((
	1848	8233752448896666794161427278020210225
	1849	)))\|(((
4.1	1850	__www.CUSTOMER.com__
1.1	1851	)))\|(((
4.1	1852	__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d__
1.1	1853	)))
	1854	\|(((
	1855	68E8551F-AD4E-4AAF-B4E6-RTSDFSAFA
	1856	)))\|(((
	1857	2021-03-15 09:57:00
	1858	)))\|(((
	1859	desktop
	1860	)))\|(((
5.2	1861
1.1	1862	)))\|(((
5.2	1863
1.1	1864	)))\|(((
4.1	1865	__www.CUSTOMER.com__
1.1	1866	)))\|(((
4.1	1867	__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~~contactid~~__
1.1	1868	)))
	1869
	1870	VisitContactID is a GUID assigned by the Customer's Internal Data Warehouse
5.1	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	\|(((
5.2	1897	Is COVID-19 FOR REAL?
5.1	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	)))\|(((
5.2	1913
5.1	1914	)))\|(((
	1915	2XXX Group
	1916	)))
	1917	\|(((
5.2	1918	BREAKING NEWS SESSION: Extreme
5.1	1919	)))\|(((
	1920	2-17-21 1:15 PM
	1921	)))\|(((
	1922	PRE_RECORDED
	1923	)))\|(((
5.2	1924
5.1	1925	)))\|(((
	1926	Premium Members
	1927	)))\|(((
	1928	[[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com\|\|shape="rect"]]
	1929	)))\|(((
	1930	Ryan
	1931	)))\|(((
	1932	Brown
	1933	)))\|(((
5.2	1934
5.1	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	)))\|(((
5.2	2012	Please keep me up-to-date with the latest events and services
5.1	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	\|(((
5.2	2041	Annual Trade Show
5.1	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	)))\|(((
5.2	2067
5.1	2068	)))\|(((
	2069	1 8505551001
	2070	)))\|(((
5.2	2071
5.1	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	)))\|(((
5.2	2087
5.1	2088	)))\|(((
5.2	2089
5.1	2090	)))\|(((
5.2	2091
5.1	2092	)))\|(((
	2093	396
	2094	)))\|(((
5.2	2095
5.1	2096	)))\|(((
	2097	Super Pass
	2098	)))\|(((
5.2	2099
5.1	2100	)))\|(((
	2101	1100002
	2102	)))\|(((
	2103	Contractor
	2104	)))\|(((
	2105	51-60
	2106	)))\|(((
	2107	Contractor
	2108	)))\|(((
	2109	No
	2110	)))\|(((
	2111	Yes
	2112	)))\|(((
5.2	2113
5.1	2114	)))\|(((
	2115	Male
	2116	)))\|(((
	2117	Yes
	2118	)))\|(((
	2119	Owner/CEO/President/Executive
	2120	)))\|(((
	2121	Both
	2122	)))\|(((
5.2	2123
5.1	2124	)))\|(((
5.2	2125
5.1	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	\|(((
5.2	2140
5.1	2141	)))\|(((
5.2	2142
5.1	2143	)))\|(((
5.2	2144
5.1	2145	)))\|(((
5.2	2146
5.1	2147	)))\|(((
5.2	2148
5.1	2149	)))\|(((
5.2	2150
5.1	2151	)))\|(((
5.2	2152
5.1	2153	)))\|(((
5.2	2154
5.1	2155	)))\|(((
5.2	2156
5.1	2157	)))\|(((
5.2	2158
5.1	2159	)))\|(((
5.2	2160
5.1	2161	)))\|(((
5.2	2162
5.1	2163	)))\|(((
5.2	2164
5.1	2165	)))\|(((
5.2	2166
5.1	2167	)))\|(((
5.2	2168
5.1	2169	)))\|(((
5.2	2170
5.1	2171	)))\|(((
5.2	2172
5.1	2173	)))\|(((
5.2	2174
5.1	2175	)))\|(((
5.2	2176
5.1	2177	)))\|(((
5.2	2178
5.1	2179	)))\|(((
5.2	2180
5.1	2181	)))\|(((
5.2	2182
5.1	2183	)))\|(((
5.2	2184
5.1	2185	)))\|(((
5.2	2186
5.1	2187	)))\|(((
5.2	2188
5.1	2189	)))\|(((
5.2	2190
5.1	2191	)))\|(((
5.2	2192
5.1	2193	)))\|(((
5.2	2194
5.1	2195	)))\|(((
5.2	2196
5.1	2197	)))\|(((
5.2	2198
5.1	2199	)))\|(((
5.2	2200
5.1	2201	)))\|(((
5.2	2202
5.1	2203	)))\|(((
5.2	2204
5.1	2205	)))\|(((
5.2	2206
5.1	2207	)))\|(((
5.2	2208
5.1	2209	)))\|(((
5.2	2210
5.1	2211	)))\|(((
5.2	2212
5.1	2213	)))\|(((
5.2	2214
5.1	2215	)))\|(((
5.2	2216
5.1	2217	)))\|(((
5.2	2218
5.1	2219	)))\|(((
5.2	2220
5.1	2221	)))\|(((
5.2	2222
5.1	2223	)))\|(((
5.2	2224
5.1	2225	)))\|(((
5.2	2226
5.1	2227	)))\|(((
5.2	2228
5.1	2229	)))\|(((
5.2	2230
5.1	2231	)))\|(((
5.2	2232
5.1	2233	)))\|(((
5.2	2234
5.1	2235	)))\|(((
5.2	2236
5.1	2237	)))
	2238	\|(((
5.2	2239	Annual Trade Show
5.1	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	)))\|(((
5.2	2257
5.1	2258	)))\|(((
	2259	Miami
	2260	)))\|(((
	2261	FL
	2262	)))\|(((
	2263	33736
	2264	)))\|(((
5.2	2265
5.1	2266	)))\|(((
	2267	1 8502588247
	2268	)))\|(((
5.2	2269
5.1	2270	)))\|(((
	2271	__jimnordstrom@something.com__
	2272	)))\|(((
5.2	2273
5.1	2274	)))\|(((
	2275	850
	2276	)))\|(((
	2277	3998247
	2278	)))\|(((
	2279	Attendee Expo Only
	2280	)))\|(((
	2281	N
	2282	)))\|(((
5.2	2283
5.1	2284	)))\|(((
5.2	2285
5.1	2286	)))\|(((
5.2	2287
5.1	2288	)))\|(((
5.2	2289
5.1	2290	)))\|(((
	2291	66
	2292	)))\|(((
5.2	2293
5.1	2294	)))\|(((
	2295	Expo Only
	2296	)))\|(((
5.2	2297
5.1	2298	)))\|(((
	2299	1100002
	2300	)))\|(((
	2301	No Response
	2302	)))\|(((
	2303	41-50
	2304	)))\|(((
	2305	Spouse/Guest
	2306	)))\|(((
	2307	Yes
	2308	)))\|(((
	2309	Yes
	2310	)))\|(((
5.2	2311
5.1	2312	)))\|(((
	2313	Male
	2314	)))\|(((
	2315	No Response
	2316	)))\|(((
	2317	Spouse/Guest
	2318	)))\|(((
5.2	2319
5.1	2320	)))\|(((
5.2	2321
5.1	2322	)))\|(((
5.2	2323
5.1	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	)))