Changes for page DExTr Import Files

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

From version 1.1
edited by Admin
on 2022/09/19 11:55
Change comment: There is no comment for this version
To version 6.1
edited by Rayaan Ahmed
on 2024/12/27 03:28
Change comment: There is no comment for this version

Summary

Details

Page properties
Parent
... ... @@ -1,0 +1,1 @@
1 +How-To Info:
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.Admin
1 +XWiki.rayaan
Content
... ... @@ -10,693 +10,693 @@
10 10  
11 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 12  
13 -\\
14 14  
14 +(% class="wrapped" %)
15 15  |(((
16 -(% style="color: rgb(0,51,102);" %)**ACCOUNT NUMBER**
16 +(% style="color:#003366" %)**ACCOUNT NUMBER**
17 17  )))|(((
18 -(% style="color: rgb(0,51,102);" %)**FIRST NAME**
18 +(% style="color:#003366" %)**FIRST NAME**
19 19  )))|(((
20 -(% style="color: rgb(0,51,102);" %)**LAST NAME**
20 +(% style="color:#003366" %)**LAST NAME**
21 21  )))|(((
22 -(% style="color: rgb(0,51,102);" %)**MIDDLE NAME**
22 +(% style="color:#003366" %)**MIDDLE NAME**
23 23  )))|(((
24 -(% style="color: rgb(0,51,102);" %)**TITLE**
24 +(% style="color:#003366" %)**TITLE**
25 25  )))|(((
26 -(% style="color: rgb(0,51,102);" %)**SUFFIX**
26 +(% style="color:#003366" %)**SUFFIX**
27 27  )))|(((
28 -(% style="color: rgb(0,51,102);" %)**COMPANY**
28 +(% style="color:#003366" %)**COMPANY**
29 29  )))|(((
30 -(% style="color: rgb(0,51,102);" %)**JOB TITLE**
30 +(% style="color:#003366" %)**JOB TITLE**
31 31  )))|(((
32 -(% style="color: rgb(0,51,102);" %)**ADDRESS1**
32 +(% style="color:#003366" %)**ADDRESS1**
33 33  )))|(((
34 -(% style="color: rgb(0,51,102);" %)**ADDRESS2**
34 +(% style="color:#003366" %)**ADDRESS2**
35 35  )))|(((
36 -(% style="color: rgb(0,51,102);" %)**CITY**
36 +(% style="color:#003366" %)**CITY**
37 37  )))|(((
38 -(% style="color: rgb(0,51,102);" %)**STATE**
38 +(% style="color:#003366" %)**STATE**
39 39  )))|(((
40 -(% style="color: rgb(0,51,102);" %)**ZIP**
40 +(% style="color:#003366" %)**ZIP**
41 41  )))|(((
42 -(% style="color: rgb(0,51,102);" %)**ZIP4**
42 +(% style="color:#003366" %)**ZIP4**
43 43  )))|(((
44 -(% style="color: rgb(0,51,102);" %)**COUNTRY**
44 +(% style="color:#003366" %)**COUNTRY**
45 45  )))|(((
46 -(% style="color: rgb(0,51,102);" %)**TELEPHONE NUMBER**
46 +(% style="color:#003366" %)**TELEPHONE NUMBER**
47 47  )))|(((
48 -(% style="color: rgb(0,51,102);" %)**FAX NUMBER**
48 +(% style="color:#003366" %)**FAX NUMBER**
49 49  )))|(((
50 -(% style="color: rgb(0,51,102);" %)**E-MAIL ADDRESS**
50 +(% style="color:#003366" %)**E-MAIL ADDRESS**
51 51  )))|(((
52 -(% style="color: rgb(0,51,102);" %)**E-MAIL CONTACT**
52 +(% style="color:#003366" %)**E-MAIL CONTACT**
53 53  )))|(((
54 -(% style="color: rgb(0,51,102);" %)**CUSTOM1**
54 +(% style="color:#003366" %)**CUSTOM1**
55 55  )))|(((
56 -(% style="color: rgb(0,51,102);" %)**CUSTOM2**
56 +(% style="color:#003366" %)**CUSTOM2**
57 57  )))|(((
58 -(% style="color: rgb(0,51,102);" %)**CUSTOM3**
58 +(% style="color:#003366" %)**CUSTOM3**
59 59  )))|(((
60 -(% style="color: rgb(0,51,102);" %)**LAST UPDATED**
60 +(% style="color:#003366" %)**LAST UPDATED**
61 61  )))|(((
62 -(% style="color: rgb(0,51,102);" %)**OCID**
62 +(% style="color:#003366" %)**OCID**
63 63  )))
64 64  |(((
65 -(% style="color: rgb(0,51,102);" %)**14010000431**
65 +(% style="color:#003366" %)**14010000431**
66 66  )))|(((
67 -(% style="color: rgb(0,51,102);" %)Graham
67 +(% style="color:#003366" %)Graham
68 68  )))|(((
69 -(% style="color: rgb(0,51,102);" %)O'Gorman
69 +(% style="color:#003366" %)O'Gorman
70 70  )))|(((
71 -\\
71 +
72 72  )))|(((
73 -\\
73 +
74 74  )))|(((
75 -\\
75 +
76 76  )))|(((
77 -(% style="color: rgb(0,51,102);" %)Graham O'Gorman Landscape
77 +(% style="color:#003366" %)Graham O'Gorman Landscape
78 78  )))|(((
79 -\\
79 +
80 80  )))|(((
81 -(% style="color: rgb(0,51,102);" %)192 Olmstead Hill Rd
81 +(% style="color:#003366" %)192 Olmstead Hill Rd
82 82  )))|(((
83 -\\
83 +
84 84  )))|(((
85 -(% style="color: rgb(0,51,102);" %)Wilton
85 +(% style="color:#003366" %)Wilton
86 86  )))|(((
87 -(% style="color: rgb(0,51,102);" %)CT
87 +(% style="color:#003366" %)CT
88 88  )))|(((
89 -(% style="color: rgb(0,51,102);" %)6897
89 +(% style="color:#003366" %)6897
90 90  )))|(((
91 -(% style="color: rgb(0,51,102);" %)1816
91 +(% style="color:#003366" %)1816
92 92  )))|(((
93 -(% style="color: rgb(0,51,102);" %)United States
93 +(% style="color:#003366" %)United States
94 94  )))|(((
95 -\\
95 +
96 96  )))|(((
97 -\\
97 +
98 98  )))|(((
99 -\\
99 +
100 100  )))|(((
101 -(% style="color: rgb(0,51,102);" %)N
101 +(% style="color:#003366" %)N
102 102  )))|(((
103 -\\
103 +
104 104  )))|(((
105 -\\
105 +
106 106  )))|(((
107 -\\
107 +
108 108  )))|(((
109 -(% style="color: rgb(0,51,102);" %)20141113211102
109 +(% style="color:#003366" %)20141113211102
110 110  )))|(((
111 -\\
111 +
112 112  )))
113 113  |(((
114 -(% style="color: rgb(0,51,102);" %)**14010000449**
114 +(% style="color:#003366" %)**14010000449**
115 115  )))|(((
116 -(% style="color: rgb(0,51,102);" %)Dale S
116 +(% style="color:#003366" %)Dale S
117 117  )))|(((
118 -(% style="color: rgb(0,51,102);" %)Galbo
118 +(% style="color:#003366" %)Galbo
119 119  )))|(((
120 -\\
120 +
121 121  )))|(((
122 -\\
122 +
123 123  )))|(((
124 -\\
124 +
125 125  )))|(((
126 -(% style="color: rgb(0,51,102);" %)Law Offices
126 +(% style="color:#003366" %)Law Offices
127 127  )))|(((
128 -(% style="color: rgb(0,51,102);" %)Owner
128 +(% style="color:#003366" %)Owner
129 129  )))|(((
130 -(% style="color: rgb(0,51,102);" %)15 W Hill Rd
130 +(% style="color:#003366" %)15 W Hill Rd
131 131  )))|(((
132 -\\
132 +
133 133  )))|(((
134 -(% style="color: rgb(0,51,102);" %)Bloomfield
134 +(% style="color:#003366" %)Bloomfield
135 135  )))|(((
136 -(% style="color: rgb(0,51,102);" %)CT
136 +(% style="color:#003366" %)CT
137 137  )))|(((
138 -(% style="color: rgb(0,51,102);" %)6002
138 +(% style="color:#003366" %)6002
139 139  )))|(((
140 -(% style="color: rgb(0,51,102);" %)5016
140 +(% style="color:#003366" %)5016
141 141  )))|(((
142 -(% style="color: rgb(0,51,102);" %)United States
142 +(% style="color:#003366" %)United States
143 143  )))|(((
144 -(% style="color: rgb(0,51,102);" %)2032709821
144 +(% style="color:#003366" %)2032709821
145 145  )))|(((
146 -\\
146 +
147 147  )))|(((
148 -\\
148 +
149 149  )))|(((
150 -(% style="color: rgb(0,51,102);" %)N
150 +(% style="color:#003366" %)N
151 151  )))|(((
152 -\\
152 +
153 153  )))|(((
154 -\\
154 +
155 155  )))|(((
156 -\\
156 +
157 157  )))|(((
158 -(% style="color: rgb(0,51,102);" %)20141113211111
158 +(% style="color:#003366" %)20141113211111
159 159  )))|(((
160 -\\
160 +
161 161  )))
162 162  |(((
163 -(% style="color: rgb(0,51,102);" %)**14010000648**
163 +(% style="color:#003366" %)**14010000648**
164 164  )))|(((
165 -(% style="color: rgb(0,51,102);" %)Patricia
165 +(% style="color:#003366" %)Patricia
166 166  )))|(((
167 -(% style="color: rgb(0,51,102);" %)Cannon
167 +(% style="color:#003366" %)Cannon
168 168  )))|(((
169 -\\
169 +
170 170  )))|(((
171 -\\
171 +
172 172  )))|(((
173 -\\
173 +
174 174  )))|(((
175 -(% style="color: rgb(0,51,102);" %)Employee Assistance Program
175 +(% style="color:#003366" %)Employee Assistance Program
176 176  )))|(((
177 -(% style="color: rgb(0,51,102);" %)Director
177 +(% style="color:#003366" %)Director
178 178  )))|(((
179 -(% style="color: rgb(0,51,102);" %)887 Bridgeport Ave Ste C
179 +(% style="color:#003366" %)887 Bridgeport Ave Ste C
180 180  )))|(((
181 -\\
181 +
182 182  )))|(((
183 -(% style="color: rgb(0,51,102);" %)Shelton
183 +(% style="color:#003366" %)Shelton
184 184  )))|(((
185 -(% style="color: rgb(0,51,102);" %)CT
185 +(% style="color:#003366" %)CT
186 186  )))|(((
187 -(% style="color: rgb(0,51,102);" %)6484
187 +(% style="color:#003366" %)6484
188 188  )))|(((
189 -(% style="color: rgb(0,51,102);" %)7602
189 +(% style="color:#003366" %)7602
190 190  )))|(((
191 -(% style="color: rgb(0,51,102);" %)United States
191 +(% style="color:#003366" %)United States
192 192  )))|(((
193 -(% style="color: rgb(0,51,102);" %)2039290681
193 +(% style="color:#003366" %)2039290681
194 194  )))|(((
195 -\\
195 +
196 196  )))|(((
197 -\\
197 +
198 198  )))|(((
199 -(% style="color: rgb(0,51,102);" %)N
199 +(% style="color:#003366" %)N
200 200  )))|(((
201 -\\
201 +
202 202  )))|(((
203 -\\
203 +
204 204  )))|(((
205 -\\
205 +
206 206  )))|(((
207 -(% style="color: rgb(0,51,102);" %)20141121163017
207 +(% style="color:#003366" %)20141121163017
208 208  )))|(((
209 -\\
209 +
210 210  )))
211 211  |(((
212 -(% style="color: rgb(0,51,102);" %)**14010001843**
212 +(% style="color:#003366" %)**14010001843**
213 213  )))|(((
214 -(% style="color: rgb(0,51,102);" %)Susan
214 +(% style="color:#003366" %)Susan
215 215  )))|(((
216 -(% style="color: rgb(0,51,102);" %)Kent
216 +(% style="color:#003366" %)Kent
217 217  )))|(((
218 -\\
218 +
219 219  )))|(((
220 -\\
220 +
221 221  )))|(((
222 -\\
222 +
223 223  )))|(((
224 -\\
224 +
225 225  )))|(((
226 -\\
226 +
227 227  )))|(((
228 -(% style="color: rgb(0,51,102);" %)38110 5th St E Apt 1
228 +(% style="color:#003366" %)38110 5th St E Apt 1
229 229  )))|(((
230 -\\
230 +
231 231  )))|(((
232 -(% style="color: rgb(0,51,102);" %)Los Angeles
232 +(% style="color:#003366" %)Los Angeles
233 233  )))|(((
234 -(% style="color: rgb(0,51,102);" %)CA
234 +(% style="color:#003366" %)CA
235 235  )))|(((
236 -(% style="color: rgb(0,51,102);" %)93550
236 +(% style="color:#003366" %)93550
237 237  )))|(((
238 -(% style="color: rgb(0,51,102);" %)2317
238 +(% style="color:#003366" %)2317
239 239  )))|(((
240 -(% style="color: rgb(0,51,102);" %)United States
240 +(% style="color:#003366" %)United States
241 241  )))|(((
242 -\\
242 +
243 243  )))|(((
244 -\\
244 +
245 245  )))|(((
246 -\\
246 +
247 247  )))|(((
248 -(% style="color: rgb(0,51,102);" %)N
248 +(% style="color:#003366" %)N
249 249  )))|(((
250 -\\
250 +
251 251  )))|(((
252 -\\
252 +
253 253  )))|(((
254 -\\
254 +
255 255  )))|(((
256 -(% style="color: rgb(0,51,102);" %)20141212210537
256 +(% style="color:#003366" %)20141212210537
257 257  )))|(((
258 -\\
258 +
259 259  )))
260 260  |(((
261 -(% style="color: rgb(0,51,102);" %)**14010001858**
261 +(% style="color:#003366" %)**14010001858**
262 262  )))|(((
263 -(% style="color: rgb(0,51,102);" %)Brendan
263 +(% style="color:#003366" %)Brendan
264 264  )))|(((
265 -(% style="color: rgb(0,51,102);" %)Eppley
265 +(% style="color:#003366" %)Eppley
266 266  )))|(((
267 -\\
267 +
268 268  )))|(((
269 -\\
269 +
270 270  )))|(((
271 -\\
271 +
272 272  )))|(((
273 -\\
273 +
274 274  )))|(((
275 -\\
275 +
276 276  )))|(((
277 -(% style="color: rgb(0,51,102);" %)20 Driftway Ln
277 +(% style="color:#003366" %)20 Driftway Ln
278 278  )))|(((
279 -\\
279 +
280 280  )))|(((
281 -(% style="color: rgb(0,51,102);" %)Darien
281 +(% style="color:#003366" %)Darien
282 282  )))|(((
283 -(% style="color: rgb(0,51,102);" %)CT
283 +(% style="color:#003366" %)CT
284 284  )))|(((
285 -(% style="color: rgb(0,51,102);" %)6820
285 +(% style="color:#003366" %)6820
286 286  )))|(((
287 -(% style="color: rgb(0,51,102);" %)6130
287 +(% style="color:#003366" %)6130
288 288  )))|(((
289 -(% style="color: rgb(0,51,102);" %)United States
289 +(% style="color:#003366" %)United States
290 290  )))|(((
291 -\\
291 +
292 292  )))|(((
293 -\\
293 +
294 294  )))|(((
295 -\\
295 +
296 296  )))|(((
297 -(% style="color: rgb(0,51,102);" %)N
297 +(% style="color:#003366" %)N
298 298  )))|(((
299 -\\
299 +
300 300  )))|(((
301 -\\
301 +
302 302  )))|(((
303 -\\
303 +
304 304  )))|(((
305 -(% style="color: rgb(0,51,102);" %)20141211230144
305 +(% style="color:#003366" %)20141211230144
306 306  )))|(((
307 -\\
307 +
308 308  )))
309 309  |(((
310 -(% style="color: rgb(0,51,102);" %)**14010001862**
310 +(% style="color:#003366" %)**14010001862**
311 311  )))|(((
312 -\\
312 +
313 313  )))|(((
314 -\\
314 +
315 315  )))|(((
316 -\\
316 +
317 317  )))|(((
318 -\\
318 +
319 319  )))|(((
320 -\\
320 +
321 321  )))|(((
322 -(% style="color: rgb(0,51,102);" %)Orchard Tree Care Llc
322 +(% style="color:#003366" %)Orchard Tree Care Llc
323 323  )))|(((
324 -\\
324 +
325 325  )))|(((
326 -(% style="color: rgb(0,51,102);" %)184 Ave
326 +(% style="color:#003366" %)184 Ave
327 327  )))|(((
328 -\\
328 +
329 329  )))|(((
330 -(% style="color: rgb(0,51,102);" %)Darien
330 +(% style="color:#003366" %)Darien
331 331  )))|(((
332 -(% style="color: rgb(0,51,102);" %)CT
332 +(% style="color:#003366" %)CT
333 333  )))|(((
334 -(% style="color: rgb(0,51,102);" %)6820
334 +(% style="color:#003366" %)6820
335 335  )))|(((
336 -\\
336 +
337 337  )))|(((
338 -(% style="color: rgb(0,51,102);" %)United States
338 +(% style="color:#003366" %)United States
339 339  )))|(((
340 -(% style="color: rgb(0,51,102);" %)2036550618
340 +(% style="color:#003366" %)2036550618
341 341  )))|(((
342 -\\
342 +
343 343  )))|(((
344 -\\
344 +
345 345  )))|(((
346 -(% style="color: rgb(0,51,102);" %)N
346 +(% style="color:#003366" %)N
347 347  )))|(((
348 -\\
348 +
349 349  )))|(((
350 -\\
350 +
351 351  )))|(((
352 -\\
352 +
353 353  )))|(((
354 -(% style="color: rgb(0,51,102);" %)20150211133156
354 +(% style="color:#003366" %)20150211133156
355 355  )))|(((
356 -\\
356 +
357 357  )))
358 358  |(((
359 -(% style="color: rgb(0,51,102);" %)**14010001870**
359 +(% style="color:#003366" %)**14010001870**
360 360  )))|(((
361 -(% style="color: rgb(0,51,102);" %)Avis Z
361 +(% style="color:#003366" %)Avis Z
362 362  )))|(((
363 -(% style="color: rgb(0,51,102);" %)Gray
363 +(% style="color:#003366" %)Gray
364 364  )))|(((
365 -\\
365 +
366 366  )))|(((
367 -\\
367 +
368 368  )))|(((
369 -\\
369 +
370 370  )))|(((
371 -(% style="color: rgb(0,51,102);" %)Designers 5 Incorporated
371 +(% style="color:#003366" %)Designers 5 Incorporated
372 372  )))|(((
373 -(% style="color: rgb(0,51,102);" %)President
373 +(% style="color:#003366" %)President
374 374  )))|(((
375 -(% style="color: rgb(0,51,102);" %)96 5 Mile River Rd
375 +(% style="color:#003366" %)96 5 Mile River Rd
376 376  )))|(((
377 -\\
377 +
378 378  )))|(((
379 -(% style="color: rgb(0,51,102);" %)Darien
379 +(% style="color:#003366" %)Darien
380 380  )))|(((
381 -(% style="color: rgb(0,51,102);" %)CT
381 +(% style="color:#003366" %)CT
382 382  )))|(((
383 -(% style="color: rgb(0,51,102);" %)6820
383 +(% style="color:#003366" %)6820
384 384  )))|(((
385 -(% style="color: rgb(0,51,102);" %)6234
385 +(% style="color:#003366" %)6234
386 386  )))|(((
387 -(% style="color: rgb(0,51,102);" %)United States
387 +(% style="color:#003366" %)United States
388 388  )))|(((
389 -(% style="color: rgb(0,51,102);" %)2036552033
389 +(% style="color:#003366" %)2036552033
390 390  )))|(((
391 -\\
391 +
392 392  )))|(((
393 -\\
393 +
394 394  )))|(((
395 -(% style="color: rgb(0,51,102);" %)N
395 +(% style="color:#003366" %)N
396 396  )))|(((
397 -\\
397 +
398 398  )))|(((
399 -\\
399 +
400 400  )))|(((
401 -\\
401 +
402 402  )))|(((
403 -(% style="color: rgb(0,51,102);" %)20150212210227
403 +(% style="color:#003366" %)20150212210227
404 404  )))|(((
405 -\\
405 +
406 406  )))
407 407  |(((
408 -(% style="color: rgb(0,51,102);" %)**14010001889**
408 +(% style="color:#003366" %)**14010001889**
409 409  )))|(((
410 -(% style="color: rgb(0,51,102);" %)John
410 +(% style="color:#003366" %)John
411 411  )))|(((
412 -(% style="color: rgb(0,51,102);" %)Hertz
412 +(% style="color:#003366" %)Hertz
413 413  )))|(((
414 -\\
414 +
415 415  )))|(((
416 -\\
416 +
417 417  )))|(((
418 -\\
418 +
419 419  )))|(((
420 -(% style="color: rgb(0,51,102);" %)Hertz Construction Co
420 +(% style="color:#003366" %)Hertz Construction Co
421 421  )))|(((
422 -(% style="color: rgb(0,51,102);" %)Partner
422 +(% style="color:#003366" %)Partner
423 423  )))|(((
424 -(% style="color: rgb(0,51,102);" %)12 Hillside Ave
424 +(% style="color:#003366" %)12 Hillside Ave
425 425  )))|(((
426 -\\
426 +
427 427  )))|(((
428 -(% style="color: rgb(0,51,102);" %)Darien
428 +(% style="color:#003366" %)Darien
429 429  )))|(((
430 -(% style="color: rgb(0,51,102);" %)CT
430 +(% style="color:#003366" %)CT
431 431  )))|(((
432 -(% style="color: rgb(0,51,102);" %)6820
432 +(% style="color:#003366" %)6820
433 433  )))|(((
434 -(% style="color: rgb(0,51,102);" %)5010
434 +(% style="color:#003366" %)5010
435 435  )))|(((
436 -(% style="color: rgb(0,51,102);" %)United States
436 +(% style="color:#003366" %)United States
437 437  )))|(((
438 -(% style="color: rgb(0,51,102);" %)2036564900
438 +(% style="color:#003366" %)2036564900
439 439  )))|(((
440 -\\
440 +
441 441  )))|(((
442 -\\
442 +
443 443  )))|(((
444 -(% style="color: rgb(0,51,102);" %)N
444 +(% style="color:#003366" %)N
445 445  )))|(((
446 -\\
446 +
447 447  )))|(((
448 -\\
448 +
449 449  )))|(((
450 -\\
450 +
451 451  )))|(((
452 -(% style="color: rgb(0,51,102);" %)20141121163018
452 +(% style="color:#003366" %)20141121163018
453 453  )))|(((
454 -\\
454 +
455 455  )))
456 456  |(((
457 -(% style="color: rgb(0,51,102);" %)**14010001891**
457 +(% style="color:#003366" %)**14010001891**
458 458  )))|(((
459 -\\
459 +
460 460  )))|(((
461 -\\
461 +
462 462  )))|(((
463 -\\
463 +
464 464  )))|(((
465 -\\
465 +
466 466  )))|(((
467 -\\
467 +
468 468  )))|(((
469 -(% style="color: rgb(0,51,102);" %)Niche Home Furnishings Ll
469 +(% style="color:#003366" %)Niche Home Furnishings Ll
470 470  )))|(((
471 -\\
471 +
472 472  )))|(((
473 -(% style="color: rgb(0,51,102);" %)25 Old Kings Hwy N Ste 17
473 +(% style="color:#003366" %)25 Old Kings Hwy N Ste 17
474 474  )))|(((
475 -\\
475 +
476 476  )))|(((
477 -(% style="color: rgb(0,51,102);" %)Darien
477 +(% style="color:#003366" %)Darien
478 478  )))|(((
479 -(% style="color: rgb(0,51,102);" %)CT
479 +(% style="color:#003366" %)CT
480 480  )))|(((
481 -(% style="color: rgb(0,51,102);" %)6820
481 +(% style="color:#003366" %)6820
482 482  )))|(((
483 -(% style="color: rgb(0,51,102);" %)4608
483 +(% style="color:#003366" %)4608
484 484  )))|(((
485 -(% style="color: rgb(0,51,102);" %)United States
485 +(% style="color:#003366" %)United States
486 486  )))|(((
487 -(% style="color: rgb(0,51,102);" %)2036566674
487 +(% style="color:#003366" %)2036566674
488 488  )))|(((
489 -\\
489 +
490 490  )))|(((
491 -\\
491 +
492 492  )))|(((
493 -(% style="color: rgb(0,51,102);" %)N
493 +(% style="color:#003366" %)N
494 494  )))|(((
495 -\\
495 +
496 496  )))|(((
497 -\\
497 +
498 498  )))|(((
499 -\\
499 +
500 500  )))|(((
501 -(% style="color: rgb(0,51,102);" %)20141121163018
501 +(% style="color:#003366" %)20141121163018
502 502  )))|(((
503 -\\
503 +
504 504  )))
505 505  |(((
506 -(% style="color: rgb(0,51,102);" %)**14010001901**
506 +(% style="color:#003366" %)**14010001901**
507 507  )))|(((
508 -(% style="color: rgb(0,51,102);" %)Wendy
508 +(% style="color:#003366" %)Wendy
509 509  )))|(((
510 -(% style="color: rgb(0,51,102);" %)Cole
510 +(% style="color:#003366" %)Cole
511 511  )))|(((
512 -\\
512 +
513 513  )))|(((
514 -(% style="color: rgb(0,51,102);" %)Ms.
514 +(% style="color:#003366" %)Ms.
515 515  )))|(((
516 -\\
516 +
517 517  )))|(((
518 -(% style="color: rgb(0,51,102);" %)Wendy C Cole Interiors
518 +(% style="color:#003366" %)Wendy C Cole Interiors
519 519  )))|(((
520 -(% style="color: rgb(0,51,102);" %)Principal
520 +(% style="color:#003366" %)Principal
521 521  )))|(((
522 -(% style="color: rgb(0,51,102);" %)3 Outlook Dr
522 +(% style="color:#003366" %)3 Outlook Dr
523 523  )))|(((
524 -\\
524 +
525 525  )))|(((
526 -(% style="color: rgb(0,51,102);" %)Darien
526 +(% style="color:#003366" %)Darien
527 527  )))|(((
528 -(% style="color: rgb(0,51,102);" %)CT
528 +(% style="color:#003366" %)CT
529 529  )))|(((
530 -(% style="color: rgb(0,51,102);" %)6820
530 +(% style="color:#003366" %)6820
531 531  )))|(((
532 -(% style="color: rgb(0,51,102);" %)5616
532 +(% style="color:#003366" %)5616
533 533  )))|(((
534 -(% style="color: rgb(0,51,102);" %)United States
534 +(% style="color:#003366" %)United States
535 535  )))|(((
536 -(% style="color: rgb(0,51,102);" %)2036552954
536 +(% style="color:#003366" %)2036552954
537 537  )))|(((
538 -\\
538 +
539 539  )))|(((
540 -\\
540 +
541 541  )))|(((
542 -(% style="color: rgb(0,51,102);" %)N
542 +(% style="color:#003366" %)N
543 543  )))|(((
544 -\\
544 +
545 545  )))|(((
546 -\\
546 +
547 547  )))|(((
548 -\\
548 +
549 549  )))|(((
550 -(% style="color: rgb(0,51,102);" %)20150212210227
550 +(% style="color:#003366" %)20150212210227
551 551  )))|(((
552 -\\
552 +
553 553  )))
554 554  |(((
555 -(% style="color: rgb(0,51,102);" %)**14010001917**
555 +(% style="color:#003366" %)**14010001917**
556 556  )))|(((
557 -(% style="color: rgb(0,51,102);" %)Frank
557 +(% style="color:#003366" %)Frank
558 558  )))|(((
559 -(% style="color: rgb(0,51,102);" %)Stone
559 +(% style="color:#003366" %)Stone
560 560  )))|(((
561 -\\
561 +
562 562  )))|(((
563 -\\
563 +
564 564  )))|(((
565 -\\
565 +
566 566  )))|(((
567 -(% style="color: rgb(0,51,102);" %)Stones Landscape
567 +(% style="color:#003366" %)Stones Landscape
568 568  )))|(((
569 -(% style="color: rgb(0,51,102);" %)Owner
569 +(% style="color:#003366" %)Owner
570 570  )))|(((
571 -(% style="color: rgb(0,51,102);" %)258 West Ave
571 +(% style="color:#003366" %)258 West Ave
572 572  )))|(((
573 -\\
573 +
574 574  )))|(((
575 -(% style="color: rgb(0,51,102);" %)Darien
575 +(% style="color:#003366" %)Darien
576 576  )))|(((
577 -(% style="color: rgb(0,51,102);" %)CT
577 +(% style="color:#003366" %)CT
578 578  )))|(((
579 -(% style="color: rgb(0,51,102);" %)6820
579 +(% style="color:#003366" %)6820
580 580  )))|(((
581 -(% style="color: rgb(0,51,102);" %)4111
581 +(% style="color:#003366" %)4111
582 582  )))|(((
583 -(% style="color: rgb(0,51,102);" %)United States
583 +(% style="color:#003366" %)United States
584 584  )))|(((
585 -(% style="color: rgb(0,51,102);" %)2036569674
585 +(% style="color:#003366" %)2036569674
586 586  )))|(((
587 -\\
587 +
588 588  )))|(((
589 -\\
589 +
590 590  )))|(((
591 -(% style="color: rgb(0,51,102);" %)N
591 +(% style="color:#003366" %)N
592 592  )))|(((
593 -\\
593 +
594 594  )))|(((
595 -\\
595 +
596 596  )))|(((
597 -\\
597 +
598 598  )))|(((
599 -(% style="color: rgb(0,51,102);" %)20150212210227
599 +(% style="color:#003366" %)20150212210227
600 600  )))|(((
601 -\\
601 +
602 602  )))
603 603  |(((
604 -(% style="color: rgb(0,51,102);" %)**14010002429**
604 +(% style="color:#003366" %)**14010002429**
605 605  )))|(((
606 -(% style="color: rgb(0,51,102);" %)Bruce
606 +(% style="color:#003366" %)Bruce
607 607  )))|(((
608 -(% style="color: rgb(0,51,102);" %)Pomerance
608 +(% style="color:#003366" %)Pomerance
609 609  )))|(((
610 -\\
610 +
611 611  )))|(((
612 -(% style="color: rgb(0,51,102);" %)Mr.
612 +(% style="color:#003366" %)Mr.
613 613  )))|(((
614 -\\
614 +
615 615  )))|(((
616 -(% style="color: rgb(0,51,102);" %)P L V Inc
616 +(% style="color:#003366" %)P L V Inc
617 617  )))|(((
618 -(% style="color: rgb(0,51,102);" %)President
618 +(% style="color:#003366" %)President
619 619  )))|(((
620 -(% style="color: rgb(0,51,102);" %)1076 Post Rd
620 +(% style="color:#003366" %)1076 Post Rd
621 621  )))|(((
622 -\\
622 +
623 623  )))|(((
624 -(% style="color: rgb(0,51,102);" %)Darien
624 +(% style="color:#003366" %)Darien
625 625  )))|(((
626 -(% style="color: rgb(0,51,102);" %)CT
626 +(% style="color:#003366" %)CT
627 627  )))|(((
628 -(% style="color: rgb(0,51,102);" %)6820
628 +(% style="color:#003366" %)6820
629 629  )))|(((
630 -(% style="color: rgb(0,51,102);" %)5414
630 +(% style="color:#003366" %)5414
631 631  )))|(((
632 -(% style="color: rgb(0,51,102);" %)United States
632 +(% style="color:#003366" %)United States
633 633  )))|(((
634 -(% style="color: rgb(0,51,102);" %)2036554668
634 +(% style="color:#003366" %)2036554668
635 635  )))|(((
636 -\\
636 +
637 637  )))|(((
638 -\\
638 +
639 639  )))|(((
640 -(% style="color: rgb(0,51,102);" %)N
640 +(% style="color:#003366" %)N
641 641  )))|(((
642 -\\
642 +
643 643  )))|(((
644 -\\
644 +
645 645  )))|(((
646 -\\
646 +
647 647  )))|(((
648 -(% style="color: rgb(0,51,102);" %)20150212210227
648 +(% style="color:#003366" %)20150212210227
649 649  )))|(((
650 -\\
650 +
651 651  )))
652 652  |(((
653 -(% style="color: rgb(0,51,102);" %)**14010002438**
653 +(% style="color:#003366" %)**14010002438**
654 654  )))|(((
655 -(% style="color: rgb(0,51,102);" %)Joanne
655 +(% style="color:#003366" %)Joanne
656 656  )))|(((
657 -(% style="color: rgb(0,51,102);" %)Salvatore
657 +(% style="color:#003366" %)Salvatore
658 658  )))|(((
659 -\\
659 +
660 660  )))|(((
661 -\\
661 +
662 662  )))|(((
663 -\\
663 +
664 664  )))|(((
665 -(% style="color: rgb(0,51,102);" %)Nassau Interests Llc
665 +(% style="color:#003366" %)Nassau Interests Llc
666 666  )))|(((
667 -(% style="color: rgb(0,51,102);" %)Member
667 +(% style="color:#003366" %)Member
668 668  )))|(((
669 -(% style="color: rgb(0,51,102);" %)42 N Meadows Ln
669 +(% style="color:#003366" %)42 N Meadows Ln
670 670  )))|(((
671 -\\
671 +
672 672  )))|(((
673 -(% style="color: rgb(0,51,102);" %)Stamford
673 +(% style="color:#003366" %)Stamford
674 674  )))|(((
675 -(% style="color: rgb(0,51,102);" %)CT
675 +(% style="color:#003366" %)CT
676 676  )))|(((
677 -(% style="color: rgb(0,51,102);" %)6903
677 +(% style="color:#003366" %)6903
678 678  )))|(((
679 -(% style="color: rgb(0,51,102);" %)5151
679 +(% style="color:#003366" %)5151
680 680  )))|(((
681 -(% style="color: rgb(0,51,102);" %)United States
681 +(% style="color:#003366" %)United States
682 682  )))|(((
683 -(% style="color: rgb(0,51,102);" %)2036550303
683 +(% style="color:#003366" %)2036550303
684 684  )))|(((
685 -\\
685 +
686 686  )))|(((
687 -(% style="color: rgb(0,51,102);" %)[[(% style="color: rgb(0,51,102);" %)__joannesal@aol.com__>>mailto:joannesal@aol.com||style="color: rgb(0,51,102);" shape="rect"]]
687 +(% style="color:#003366" %)[[(% style="color: rgb(0, 51, 102); color: rgb(0, 51, 102)" %)__joannesal@aol.com__>>mailto:joannesal@aol.com||shape="rect" style="color: rgb(0,51,102);"]]
688 688  )))|(((
689 -(% style="color: rgb(0,51,102);" %)Y
689 +(% style="color:#003366" %)Y
690 690  )))|(((
691 -\\
691 +
692 692  )))|(((
693 -\\
693 +
694 694  )))|(((
695 -\\
695 +
696 696  )))|(((
697 -(% style="color: rgb(0,51,102);" %)20141212210537
697 +(% style="color:#003366" %)20141212210537
698 698  )))|(((
699 -\\
699 +
700 700  )))
701 701  
702 702  NOTE: Dates need to be in YYYY-mm-dd format
... ... @@ -713,10 +713,11 @@
713 713  
714 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 715  
716 -When syncing ONEcount with a remote system like a fulfillment database or e-commerce system on a regular basis, say every day or every week, 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.
716 +When syncing ONEcount with a remote system like a fulfillment database or e-commerce system on a regular basis (See FULFILLEMENT SAMPLE below), it is best to import and export both the remote system ID, and the ONEcount ID, or OCID. This will ensure new customers added by either system are handled appropriately.
717 717  
718 718  This will create the following work-flow:
719 719  
720 +(% class="wrapped" %)
720 720  |=(((
721 721  Subscriber ID
722 722  )))|=(((
... ... @@ -749,10 +749,9 @@
749 749  User exists in both systems, update record with incoming data
750 750  )))
751 751  
752 -\\
753 -
754 754  === Transaction Data Sample: ===
755 755  
755 +(% class="wrapped" %)
756 756  |(((
757 757  **SubscriberID**
758 758  )))|(((
... ... @@ -787,9 +787,9 @@
787 787  )))|(((
788 788  15
789 789  )))|(((
790 -\\
790 +
791 791  )))|(((
792 -\\
792 +
793 793  )))
794 794  |(((
795 795  **14010114326**
... ... @@ -806,9 +806,9 @@
806 806  )))|(((
807 807  24.95
808 808  )))|(((
809 -\\
809 +
810 810  )))|(((
811 -\\
811 +
812 812  )))
813 813  |(((
814 814  **14010114326**
... ... @@ -825,9 +825,9 @@
825 825  )))|(((
826 826  13
827 827  )))|(((
828 -\\
828 +
829 829  )))|(((
830 -\\
830 +
831 831  )))
832 832  |(((
833 833  **14010116098**
... ... @@ -842,11 +842,11 @@
842 842  )))|(((
843 843  1
844 844  )))|(((
845 -\\
845 +
846 846  )))|(((
847 -\\
847 +
848 848  )))|(((
849 -\\
849 +
850 850  )))
851 851  
852 852  Transaction type must be one of the following values:
... ... @@ -861,16 +861,209 @@
861 861  
862 862  Status Code: This for subscriber status changes (Current Subscriber, Expired, Pended Add, etc.)
863 863  
864 -\\
864 +=== Fulfillment Sample: Advantage/Omeda/PCS/CDS ===
865 865  
866 +|(((
867 +**PUBCDE**
868 +)))|(((
869 +**CUSTNUMB**
870 +)))|(% colspan="1" %)(% colspan="1" %)
871 +(((
872 +OCID
873 +)))|(((
874 +**CRCSTS**
875 +)))|(((
876 +**FIRST**
877 +)))|(((
878 +**LAST**
879 +)))|(((
880 +**COMPANY**
881 +)))|(((
882 +**ADD1**
883 +)))|(((
884 +**ADD2**
885 +)))|(((
886 +**CITY**
887 +)))|(((
888 +**ZIPCDE**
889 +)))|(((
890 +**STATE**
891 +)))|(((
892 +**ADRCDE**
893 +)))|(((
894 +**KEYCDE**
895 +)))|(((
896 +**QUALSRC**
897 +)))|(((
898 +**EMAIL**
899 +)))|(((
900 +**CTMDTE**
901 +)))|(((
902 +**FINDTE**
903 +)))|(((
904 +**PHONE**
905 +)))|(((
906 +**LISTIND**
907 +)))|(((
908 +**County**
909 +)))|(((
910 +**COUNTRY**
911 +)))
912 +|(((
913 +**AAI**
914 +)))|(((
915 +404304
916 +)))|(% colspan="1" %)(% colspan="1" %)
917 +(((
918 +33675
919 +)))|(((
920 +E
921 +)))|(((
922 +FRED
923 +)))|(((
924 +SMITH
925 +)))|(((
926 +
927 +)))|(((
928 +57 CHURCH ST
929 +)))|(((
930 +
931 +)))|(((
932 +ROXBURY
933 +)))|(((
934 +67831704
935 +)))|(((
936 +CT
937 +)))|(((
938 +M
939 +)))|(((
940 +TREN68B
941 +)))|(((
942 +5F
943 +)))|(((
944 +
945 +)))|(((
946 +20161205
947 +)))|(((
948 +20190101
949 +)))|(((
950 +8005551234
951 +)))|(((
952 +NONACTIVE
953 +)))|(((
954 +LITCHFIELD
955 +)))|(((
956 +USA
957 +)))
958 +|(((
959 +**AIB**
960 +)))|(((
961 +445771
962 +)))|(% colspan="1" %)(% colspan="1" %)
963 +(((
964 +
965 +)))|(((
966 +Q
967 +)))|(((
968 +JOSEPH
969 +)))|(((
970 +JONES
971 +)))|(((
972 +JONES & CO
973 +)))|(((
974 +7632 WILDCAT PIKE
975 +)))|(((
976 +
977 +)))|(((
978 +NEW BLOOMINGTON
979 +)))|(((
980 +433419532
981 +)))|(((
982 +OH
983 +)))|(((
984 +M
985 +)))|(((
986 +E3CC1220
987 +)))|(((
988 +5F
989 +)))|(((
990 +[[__JMBUCKOHIO@AOL.COM__>>mailto:JMBUCKOHIO@AOL.COM||shape="rect"]]
991 +)))|(((
992 +20201201
993 +)))|(((
994 +20231201
995 +)))|(((
996 +9546783214
997 +)))|(((
998 +QUAL
999 +)))|(((
1000 +MARION
1001 +)))|(((
1002 +USA
1003 +)))
1004 +|(((
1005 +**AXW**
1006 +)))|(((
1007 +
1008 +)))|(% colspan="1" %)(% colspan="1" %)
1009 +(((
1010 +3324
1011 +)))|(((
1012 +G
1013 +)))|(((
1014 +MARK
1015 +)))|(((
1016 +ROBERTS
1017 +)))|(((
1018 +TRF Inc.
1019 +)))|(((
1020 +5201 WOODWARD AVE
1021 +)))|(((
1022 +
1023 +)))|(((
1024 +DETROIT
1025 +)))|(((
1026 +482024093
1027 +)))|(((
1028 +MI
1029 +)))|(((
1030 +M
1031 +)))|(((
1032 +RRT6GT
1033 +)))|(((
1034 +1A
1035 +)))|(((
1036 +
1037 +)))|(((
1038 +20201207
1039 +)))|(((
1040 +20210401
1041 +)))|(((
1042 +
1043 +)))|(((
1044 +PAID
1045 +)))|(((
1046 +WAYNE
1047 +)))|(((
1048 +USA
1049 +)))
1050 +
1051 +**PUBCODE maps to Package TERM**
1052 +
1053 +
866 866  === Engagement Data ===
867 867  
868 868  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.
869 869  
1058 +
1059 +**NOTE**: For e-mail engagement activity date, message id, recipient id, activity type, email click url 
1060 +
1061 +
870 870  Here are a couple of examples:
871 871  
872 872  ==== **E-Mail Engagement (combined, from Eloqua)** ====
873 873  
1066 +(% class="wrapped" %)
874 874  |(((
875 875  **ActivityDate**
876 876  )))|(((
... ... @@ -901,104 +901,102 @@
901 901  **VisitorId**
902 902  )))
903 903  |(((
904 -\\
1097 +
905 905  )))|(((
906 -\\
1099 +
907 907  )))|(((
908 -\\
1101 +
909 909  )))|(((
910 -\\
1103 +
911 911  )))|(((
912 -\\
1105 +
913 913  )))|(((
914 -\\
1107 +
915 915  )))|(((
916 -\\
1109 +
917 917  )))|(((
918 -\\
1111 +
919 919  )))|(((
920 -\\
1113 +
921 921  )))|(((
922 -\\
1115 +
923 923  )))|(((
924 -\\
1117 +
925 925  )))|(((
926 -\\
1119 +
927 927  )))|(((
928 -\\
1121 +
929 929  )))|(((
930 -\\
1123 +
931 931  )))
932 932  |(((
933 -**
934 -**
1126 +
935 935  )))|(((
936 -\\
1128 +
937 937  )))|(((
938 -\\
1130 +
939 939  )))|(((
940 -\\
1132 +
941 941  )))|(((
942 -\\
1134 +
943 943  )))|(((
944 -\\
1136 +
945 945  )))|(((
946 -\\
1138 +
947 947  )))|(((
948 -\\
1140 +
949 949  )))|(((
950 -\\
1142 +
951 951  )))|(((
952 -\\
1144 +
953 953  )))|(((
954 -\\
1146 +
955 955  )))|(((
956 -\\
1148 +
957 957  )))|(((
958 -\\
1150 +
959 959  )))|(((
960 -\\
1152 +
961 961  )))
962 962  |(((
963 -**
964 -**
1155 +
965 965  )))|(((
966 -\\
1157 +
967 967  )))|(((
968 -\\
1159 +
969 969  )))|(((
970 -\\
1161 +
971 971  )))|(((
972 -\\
1163 +
973 973  )))|(((
974 -\\
1165 +
975 975  )))|(((
976 -\\
1167 +
977 977  )))|(((
978 -\\
1169 +
979 979  )))|(((
980 -\\
1171 +
981 981  )))|(((
982 -\\
1173 +
983 983  )))|(((
984 -\\
1175 +
985 985  )))|(((
986 -\\
1177 +
987 987  )))|(((
988 -\\
1179 +
989 989  )))|(((
990 -\\
1181 +
991 991  )))
992 992  
993 993  **ContactID is an Eloqua-specific ID **
994 994  
995 -**VisitorID is a custom field in the e-mail system containing the user's GUID from the customer's internal data lake
996 -**
1186 +**VisitorID is a custom field in the e-mail system containing the user's GUID from the customer's internal data lake**
997 997  
998 998  ==== **E-mail Engagement (Split Files)** ====
999 999  
1000 1000  **email-clicks.csv:**
1001 1001  
1192 +(% class="wrapped" %)
1002 1002  |(((
1003 1003  **ActivityDate**
1004 1004  )))|(((
... ... @@ -1027,35 +1027,36 @@
1027 1027  **clicked**
1028 1028  )))
1029 1029  |(((
1030 -\\
1221 +
1031 1031  )))|(((
1032 -\\
1223 +
1033 1033  )))|(((
1034 -\\
1225 +
1035 1035  )))|(((
1036 -\\
1227 +
1037 1037  )))|(((
1038 -\\
1229 +
1039 1039  )))|(((
1040 -\\
1231 +
1041 1041  )))|(((
1042 -\\
1233 +
1043 1043  )))|(((
1044 -\\
1235 +
1045 1045  )))|(((
1046 -\\
1237 +
1047 1047  )))|(((
1048 -\\
1239 +
1049 1049  )))|(((
1050 -\\
1241 +
1051 1051  )))|(((
1052 -\\
1243 +
1053 1053  )))|(((
1054 -\\
1245 +
1055 1055  )))
1056 1056  
1057 1057  **email-opens.csv**
1058 1058  
1250 +(% class="wrapped" %)
1059 1059  |(((
1060 1060  **ActivityDate**
1061 1061  )))|(((
... ... @@ -1074,25 +1074,26 @@
1074 1074  **OCID**
1075 1075  )))
1076 1076  |(((
1077 -\\
1269 +
1078 1078  )))|(((
1079 -\\
1271 +
1080 1080  )))|(((
1081 -\\
1273 +
1082 1082  )))|(((
1083 -\\
1275 +
1084 1084  )))|(((
1085 -\\
1277 +
1086 1086  )))|(((
1087 -\\
1279 +
1088 1088  )))|(((
1089 -\\
1281 +
1090 1090  )))|(((
1091 -\\
1283 +
1092 1092  )))
1093 1093  
1094 1094  **email-sends.csv**
1095 1095  
1288 +(% class="wrapped" %)
1096 1096  |(((
1097 1097  **ActivityDate**
1098 1098  )))|(((
... ... @@ -1111,25 +1111,194 @@
1111 1111  **OCID**
1112 1112  )))
1113 1113  |(((
1114 -\\
1307 +
1115 1115  )))|(((
1116 -\\
1309 +
1117 1117  )))|(((
1118 -\\
1311 +
1119 1119  )))|(((
1120 -\\
1313 +
1121 1121  )))|(((
1122 -\\
1315 +
1123 1123  )))|(((
1124 -\\
1317 +
1125 1125  )))|(((
1126 -\\
1319 +
1127 1127  )))|(((
1128 -\\
1321 +
1129 1129  )))
1130 1130  
1324 +
1325 +==== LiveIntent Data Sample: ====
1326 +
1327 +(% class="wrapped" %)
1328 +|(((
1329 +**Liveintentuserid**
1330 +)))|(((
1331 +**Advertiserid**
1332 +)))|(((
1333 +**Campaignid**
1334 +)))|(((
1335 +**Creativeid**
1336 +)))|(((
1337 +**Devtype**
1338 +)))|(((
1339 +**Emailasmdfive**
1340 +)))|(((
1341 +**Eventtype**
1342 +)))|(((
1343 +**Lineitemid**
1344 +)))|(((
1345 +**Liveintentdecisionid**
1346 +)))|(((
1347 +**Publisherid**
1348 +)))|(((
1349 +**Sectionid**
1350 +)))|(((
1351 +**Templateid**
1352 +)))|(((
1353 +**Timestamp**
1354 +)))
1355 +|(((
1356 +**28427698**
1357 +)))|(((
1358 +39771
1359 +)))|(((
1360 +246944
1361 +)))|(((
1362 +787604
1363 +)))|(((
1364 +PC
1365 +)))|(((
1366 +d57dccaadbba6c4ad8f143de8c571771
1367 +)))|(((
1368 +impression
1369 +)))|(((
1370 +10001043
1371 +)))|(((
1372 +66233848-4580-3d7f-92b2-beb4741e8f7
1373 +)))|(((
1374 +36479
1375 +)))|(((
1376 +253729
1377 +)))|(((
1378 +19263
1379 +)))|(((
1380 +2021-03-10
1381 +)))
1382 +|(((
1383 +**28422453**
1384 +)))|(((
1385 +39771
1386 +)))|(((
1387 +246944
1388 +)))|(((
1389 +787604
1390 +)))|(((
1391 +PC
1392 +)))|(((
1393 +2dece7448530fdf799254a875ebe0a77
1394 +)))|(((
1395 +impression
1396 +)))|(((
1397 +10001043
1398 +)))|(((
1399 +b8c41396-b896-333d-9945-522c21174e2
1400 +)))|(((
1401 +36479
1402 +)))|(((
1403 +277132
1404 +)))|(((
1405 +19263
1406 +)))|(((
1407 +2021-03-10
1408 +)))
1409 +|(((
1410 +**28421392**
1411 +)))|(((
1412 +39771
1413 +)))|(((
1414 +246944
1415 +)))|(((
1416 +787604
1417 +)))|(((
1418 +PC
1419 +)))|(((
1420 +a4c0388d679348e467d27391b3fd456c
1421 +)))|(((
1422 +impression
1423 +)))|(((
1424 +10001043
1425 +)))|(((
1426 +844ebc51-0a02-3783-99c8-8ac96a29bc3
1427 +)))|(((
1428 +36479
1429 +)))|(((
1430 +277132
1431 +)))|(((
1432 +19263
1433 +)))|(((
1434 +2021-03-10
1435 +)))
1436 +|(((
1437 +**28499279**
1438 +)))|(((
1439 +39771
1440 +)))|(((
1441 +246944
1442 +)))|(((
1443 +787604
1444 +)))|(((
1445 +PC
1446 +)))|(((
1447 +96032eb8da86e394b23c2a9647477d66
1448 +)))|(((
1449 +impression
1450 +)))|(((
1451 +10001043
1452 +)))|(((
1453 +69a0d6fd-7cb3-301d-b24a-04144d9ec74
1454 +)))|(((
1455 +36479
1456 +)))|(((
1457 +253729
1458 +)))|(((
1459 +19263
1460 +)))|(((
1461 +2021-03-10
1462 +)))
1463 +|(((
1464 +**28421344**
1465 +)))|(((
1466 +39771
1467 +)))|(((
1468 +246944
1469 +)))|(((
1470 +787604
1471 +)))|(((
1472 +PC
1473 +)))|(((
1474 +fd2d53dbe2e7aa2198c19afce5a35cc6
1475 +)))|(((
1476 +impression
1477 +)))|(((
1478 +10001043
1479 +)))|(((
1480 +75c72eca-6cf1-3144-b00c-04ca49471363
1481 +)))|(((
1482 +36479
1483 +)))|(((
1484 +253729
1485 +)))|(((
1486 +19263
1487 +)))|(((
1488 +2021-03-10
1489 +)))
1490 +
1491 +
1131 1131  ==== **BrightCove Data Sample:** ====
1132 1132  
1494 +(% class="wrapped" %)
1133 1133  |(((
1134 1134  **Contactid**
1135 1135  )))|(((
... ... @@ -1176,7 +1176,7 @@
1176 1176  )))|(((
1177 1177  V1
1178 1178  )))|(((
1179 -[[__https:~~/~~/preview.CUSTOMER.com/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video__>>url:https://preview.healio.com/cardiology/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video||shape="rect"]]
1541 +__https:~/~/preview.CUSTOMER.com/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video__
1180 1180  )))|(((
1181 1181  Sy80k7Mtg
1182 1182  )))|(((
... ... @@ -1184,11 +1184,11 @@
1184 1184  )))|(((
1185 1185  2021-02-11
1186 1186  )))|(((
1187 -\\
1549 +
1188 1188  )))|(((
1189 -\\
1551 +
1190 1190  )))|(((
1191 -\\
1553 +
1192 1192  )))|(((
1193 1193  5982181673007
1194 1194  )))|(((
... ... @@ -1209,7 +1209,7 @@
1209 1209  )))|(((
1210 1210  V1
1211 1211  )))|(((
1212 -[[__https:~~/~~/www.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__>>url:https://www.healio.com/endocrinology/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video||shape="rect"]]
1574 +__https:~/~/www.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1213 1213  )))|(((
1214 1214  Sy80k7Mtg
1215 1215  )))|(((
... ... @@ -1217,11 +1217,11 @@
1217 1217  )))|(((
1218 1218  2021-01-25
1219 1219  )))|(((
1220 -\\
1582 +
1221 1221  )))|(((
1222 -\\
1584 +
1223 1223  )))|(((
1224 -\\
1586 +
1225 1225  )))|(((
1226 1226  6171615690004
1227 1227  )))|(((
... ... @@ -1242,7 +1242,7 @@
1242 1242  )))|(((
1243 1243  V1
1244 1244  )))|(((
1245 -[[__https:~~/~~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__>>url:https://preview.healio.com/endocrinology/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video||shape="rect"]]
1607 +__https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video__
1246 1246  )))|(((
1247 1247  Sy80k7Mtg
1248 1248  )))|(((
... ... @@ -1250,11 +1250,11 @@
1250 1250  )))|(((
1251 1251  2021-01-29
1252 1252  )))|(((
1253 -\\
1615 +
1254 1254  )))|(((
1255 -\\
1617 +
1256 1256  )))|(((
1257 -\\
1619 +
1258 1258  )))|(((
1259 1259  6171615690003
1260 1260  )))|(((
... ... @@ -1275,7 +1275,7 @@
1275 1275  )))|(((
1276 1276  V1
1277 1277  )))|(((
1278 -[[__https:~~/~~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi__>>url:https://preview.healio.com/endocrinology/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi||shape="rect"]]
1640 +__https:~/~/preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi__
1279 1279  )))|(((
1280 1280  Sy80k7Mtg
1281 1281  )))|(((
... ... @@ -1283,11 +1283,11 @@
1283 1283  )))|(((
1284 1284  2021-02-12
1285 1285  )))|(((
1286 -\\
1648 +
1287 1287  )))|(((
1288 -\\
1650 +
1289 1289  )))|(((
1290 -\\
1652 +
1291 1291  )))|(((
1292 1292  6171632240005
1293 1293  )))|(((
... ... @@ -1308,7 +1308,7 @@
1308 1308  )))|(((
1309 1309  V1
1310 1310  )))|(((
1311 -[[__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__>>url:https://www.healio.com/cardiology/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology||shape="rect"]] educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605
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
1312 1312  )))|(((
1313 1313  Sy80k7Mtg
1314 1314  )))|(((
... ... @@ -1341,7 +1341,7 @@
1341 1341  )))|(((
1342 1342  V1
1343 1343  )))|(((
1344 -[[__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__>>url:https://www.healio.com/cardiology/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology||shape="rect"]] educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605
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
1345 1345  )))|(((
1346 1346  Sy80k7Mtg
1347 1347  )))|(((
... ... @@ -1374,7 +1374,7 @@
1374 1374  )))|(((
1375 1375  V1
1376 1376  )))|(((
1377 -[[__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__>>url:https://www.healio.com/cardiology/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology||shape="rect"]] educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605
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
1378 1378  )))|(((
1379 1379  Sy80k7Mtg
1380 1380  )))|(((
... ... @@ -1397,10 +1397,10 @@
1397 1397  
1398 1398  **ContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1399 1399  
1400 -\\
1401 1401  
1402 -==== **Web Impressions** ====
1763 +==== **Raw Web Impressions** ====
1403 1403  
1765 +(% class="wrapped" %)
1404 1404  |(((
1405 1405  **VisitContactId**
1406 1406  )))|(((
... ... @@ -1423,13 +1423,13 @@
1423 1423  )))|(((
1424 1424  mobile
1425 1425  )))|(((
1426 -\\
1788 +
1427 1427  )))|(((
1428 1428  2407411196308715909161529690620210309
1429 1429  )))|(((
1430 -[[__www.healio.com__>>url:http://www.healio.com||shape="rect"]]
1792 +__www.CUSTOMER.com__
1431 1431  )))|(((
1432 -[[__http:~~/~~/www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression||shape="rect"]]
1794 +__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1433 1433  )))
1434 1434  |(((
1435 1435  **D0717BB2-CCDB-4DBE-ADD6-REWQREQW**
... ... @@ -1438,13 +1438,13 @@
1438 1438  )))|(((
1439 1439  tablet
1440 1440  )))|(((
1441 -\\
1803 +
1442 1442  )))|(((
1443 1443  2419995085411609985161503823320210306
1444 1444  )))|(((
1445 -[[__www.healio.com__>>url:http://www.healio.com||shape="rect"]]
1807 +__www.CUSTOMER.com__
1446 1446  )))|(((
1447 -[[__http:~~/~~/www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis||shape="rect"]]
1809 +__http:~/~/www.hCUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1448 1448  )))
1449 1449  |(((
1450 1450  **1AFE97E9-9931-4427-9C4E-VZCXVZ**
... ... @@ -1453,13 +1453,13 @@
1453 1453  )))|(((
1454 1454  tablet
1455 1455  )))|(((
1456 -\\
1818 +
1457 1457  )))|(((
1458 1458  3663669472315156695161403488520210222
1459 1459  )))|(((
1460 -[[__www.healio.com__>>url:http://www.healio.com||shape="rect"]]
1822 +__www.CUSTOMER.com__
1461 1461  )))|(((
1462 -[[__http:~~/~~/www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis||shape="rect"]]
1824 +__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis__
1463 1463  )))
1464 1464  |(((
1465 1465  **59DA834C-803E-4C14-9C49-YHDGT**
... ... @@ -1468,13 +1468,13 @@
1468 1468  )))|(((
1469 1469  mobile
1470 1470  )))|(((
1471 -\\
1833 +
1472 1472  )))|(((
1473 1473  2407411196308715909161529690620210309
1474 1474  )))|(((
1475 -[[__www.healio.com__>>url:http://www.healio.com||shape="rect"]]
1837 +__wwwCUSTOMER.com__
1476 1476  )))|(((
1477 -[[__http:~~/~~/www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression||shape="rect"]]
1839 +__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression__
1478 1478  )))
1479 1479  |(((
1480 1480  **31C5F8C6-3EFF-4DE7-A899-JGVMHGY**
... ... @@ -1483,13 +1483,13 @@
1483 1483  )))|(((
1484 1484  mobile
1485 1485  )))|(((
1486 -\\
1848 +
1487 1487  )))|(((
1488 1488  8233752448896666794161427278020210225
1489 1489  )))|(((
1490 -[[__www.healio.com__>>url:http://www.healio.com||shape="rect"]]
1852 +__www.CUSTOMER.com__
1491 1491  )))|(((
1492 -[[__http:~~/~~/www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d||shape="rect"]]
1854 +__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d__
1493 1493  )))
1494 1494  |(((
1495 1495  **68E8551F-AD4E-4AAF-B4E6-RTSDFSAFA**
... ... @@ -1498,13 +1498,480 @@
1498 1498  )))|(((
1499 1499  desktop
1500 1500  )))|(((
1501 -\\
1863 +
1502 1502  )))|(((
1503 -\\
1865 +
1504 1504  )))|(((
1505 -[[__www.healio.com__>>url:http://www.healio.com||shape="rect"]]
1867 +__www.CUSTOMER.com__
1506 1506  )))|(((
1507 -[[__http:~~/~~/www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~~~~contactid~~~~__>>url:http://www.healio.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~~contactid~~||shape="rect"]]
1869 +__http:~/~/www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~~contactid~~__
1508 1508  )))
1509 1509  
1510 1510  **VisitContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1873 +
1874 +
1875 +==== **Swapcard (Webinar/Virtual Event Platform)** ====
1876 +
1877 +|(((
1878 +**Title**
1879 +)))|(((
1880 +**Start date**
1881 +)))|(((
1882 +**Format**
1883 +)))|(((
1884 +**Topics**
1885 +)))|(((
1886 +**Group**
1887 +)))|(((
1888 +**Email**
1889 +)))|(((
1890 +**First**
1891 +)))|(((
1892 +**Last**
1893 +)))|(((
1894 +**Title**
1895 +)))|(((
1896 +**Company**
1897 +)))
1898 +|(((
1899 +**Is COVID-19 FOR REAL?**
1900 +)))|(((
1901 +2-11-21 12:55 PM
1902 +)))|(((
1903 +PRE_RECORDED
1904 +)))|(((
1905 +Other, Human Health, Policy, Business
1906 +)))|(((
1907 +Premium Members
1908 +)))|(((
1909 +[[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com||shape="rect"]]
1910 +)))|(((
1911 +Ryan
1912 +)))|(((
1913 +Brown
1914 +)))|(((
1915 +
1916 +)))|(((
1917 +2XXX Group
1918 +)))
1919 +|(((
1920 +**BREAKING NEWS SESSION: Extreme **
1921 +)))|(((
1922 +2-17-21 1:15 PM
1923 +)))|(((
1924 +PRE_RECORDED
1925 +)))|(((
1926 +
1927 +)))|(((
1928 +Premium Members
1929 +)))|(((
1930 +[[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com||shape="rect"]]
1931 +)))|(((
1932 +Ryan
1933 +)))|(((
1934 +Brown
1935 +)))|(((
1936 +
1937 +)))|(((
1938 +2XXX Group
1939 +)))
1940 +
1941 +
1942 +==== **Trade Show Registration Data** ====
1943 +
1944 +|(((
1945 +**Event Series**
1946 +)))|(((
1947 +**Event Edition**
1948 +)))|(((
1949 +**Source System**
1950 +)))|(((
1951 +**Reg Number**
1952 +)))|(((
1953 +**First Name**
1954 +)))|(((
1955 +**Last Name**
1956 +)))|(((
1957 +**Title**
1958 +)))|(((
1959 +**Company 1**
1960 +)))|(((
1961 +**Address 1**
1962 +)))|(((
1963 +**Address 2**
1964 +)))|(((
1965 +**City**
1966 +)))|(((
1967 +**State**
1968 +)))|(((
1969 +**Zip Code**
1970 +)))|(((
1971 +**Country**
1972 +)))|(((
1973 +**Phone Number**
1974 +)))|(((
1975 +**Fax Number**
1976 +)))|(((
1977 +**Email Address**
1978 +)))|(((
1979 +**Internet Address 2**
1980 +)))|(((
1981 +**Phone Area Code**
1982 +)))|(((
1983 +**Phone Number Only**
1984 +)))|(((
1985 +**Reg Code**
1986 +)))|(((
1987 +**Membership Flag**
1988 +)))|(((
1989 +**Member ID**
1990 +)))|(((
1991 +**Reg Code 3**
1992 +)))|(((
1993 +**Text 1**
1994 +)))|(((
1995 +**Credential**
1996 +)))|(((
1997 +**Amount Paid**
1998 +)))|(((
1999 +**Amount Refunded**
2000 +)))|(((
2001 +**Reg Code 2**
2002 +)))|(((
2003 +**Source Code**
2004 +)))|(((
2005 +**Link Reg ID**
2006 +)))|(((
2007 +**Business type:  Check all that apply.**
2008 +)))|(((
2009 +**Age range**
2010 +)))|(((
2011 +**Primary business**
2012 +)))|(((
2013 +**Is this your first time to attend the Expo?**
2014 +)))|(((
2015 +**Please keep me up-to-date with the latest events and services**
2016 +)))|(((
2017 +**I would like to hear from  directly about products and services**
2018 +)))|(((
2019 +**What is your gender?**
2020 +)))|(((
2021 +**Buying decisions**
2022 +)))|(((
2023 +**Job function**
2024 +)))|(((
2025 +**Primary Market**
2026 +)))|(((
2027 +**What is your job title/function?**
2028 +)))|(((
2029 +**What is your company's primary media type?**
2030 +)))|(((
2031 +**Products/services**
2032 +)))|(((
2033 +**Do you want to receive a free subscription to PVV Magazine?**
2034 +)))|(((
2035 +**Do you want to receive a free subscription to RXY Magazine?**
2036 +)))|(((
2037 +**Sales Volume**
2038 +)))|(((
2039 +**Do you want to receive a free subscription to our e-newsletter?**
2040 +)))|(((
2041 +**What services does your company provide?**
2042 +)))
2043 +|(((
2044 +**Annual Trade Show**
2045 +)))|(((
2046 +EXPO 2022
2047 +)))|(((
2048 +CSI
2049 +)))|(((
2050 +1100339
2051 +)))|(((
2052 +Fred
2053 +)))|(((
2054 +Jones
2055 +)))|(((
2056 +Owner
2057 +)))|(((
2058 +Jones Construction Ent.
2059 +)))|(((
2060 +690 E Highway 90
2061 +)))|(((
2062 +690 e HWY 90
2063 +)))|(((
2064 +Tampa
2065 +)))|(((
2066 +FL
2067 +)))|(((
2068 +32425
2069 +)))|(((
2070 +
2071 +)))|(((
2072 +1  8505551001
2073 +)))|(((
2074 +
2075 +)))|(((
2076 +__fred@myaddress.com__
2077 +)))|(((
2078 +__officemgr@notmyaddress.com__
2079 +)))|(((
2080 +850
2081 +)))|(((
2082 +5471001
2083 +)))|(((
2084 +Conference Attendee
2085 +)))|(((
2086 +Y
2087 +)))|(((
2088 +412351
2089 +)))|(((
2090 +
2091 +)))|(((
2092 +
2093 +)))|(((
2094 +
2095 +)))|(((
2096 +396
2097 +)))|(((
2098 +
2099 +)))|(((
2100 +Super Pass
2101 +)))|(((
2102 +
2103 +)))|(((
2104 +1100002
2105 +)))|(((
2106 +Contractor
2107 +)))|(((
2108 +51-60
2109 +)))|(((
2110 +Contractor
2111 +)))|(((
2112 +No
2113 +)))|(((
2114 +Yes
2115 +)))|(((
2116 +
2117 +)))|(((
2118 +Male
2119 +)))|(((
2120 +Yes
2121 +)))|(((
2122 +Owner/CEO/President/Executive
2123 +)))|(((
2124 +Both
2125 +)))|(((
2126 +
2127 +)))|(((
2128 +
2129 +)))|(((
2130 +This, That, A little of the other, Something Else
2131 +)))|(((
2132 +Yes
2133 +)))|(((
2134 +Yes
2135 +)))|(((
2136 +$1,000,000-$4,999,999
2137 +)))|(((
2138 +Yes
2139 +)))|(((
2140 +Roofing, Pool Repair, Driveway Sealing, Electrical Contracting
2141 +)))
2142 +|(((
2143 +
2144 +)))|(((
2145 +
2146 +)))|(((
2147 +
2148 +)))|(((
2149 +
2150 +)))|(((
2151 +
2152 +)))|(((
2153 +
2154 +)))|(((
2155 +
2156 +)))|(((
2157 +
2158 +)))|(((
2159 +
2160 +)))|(((
2161 +
2162 +)))|(((
2163 +
2164 +)))|(((
2165 +
2166 +)))|(((
2167 +
2168 +)))|(((
2169 +
2170 +)))|(((
2171 +
2172 +)))|(((
2173 +
2174 +)))|(((
2175 +
2176 +)))|(((
2177 +
2178 +)))|(((
2179 +
2180 +)))|(((
2181 +
2182 +)))|(((
2183 +
2184 +)))|(((
2185 +
2186 +)))|(((
2187 +
2188 +)))|(((
2189 +
2190 +)))|(((
2191 +
2192 +)))|(((
2193 +
2194 +)))|(((
2195 +
2196 +)))|(((
2197 +
2198 +)))|(((
2199 +
2200 +)))|(((
2201 +
2202 +)))|(((
2203 +
2204 +)))|(((
2205 +
2206 +)))|(((
2207 +
2208 +)))|(((
2209 +
2210 +)))|(((
2211 +
2212 +)))|(((
2213 +
2214 +)))|(((
2215 +
2216 +)))|(((
2217 +
2218 +)))|(((
2219 +
2220 +)))|(((
2221 +
2222 +)))|(((
2223 +
2224 +)))|(((
2225 +
2226 +)))|(((
2227 +
2228 +)))|(((
2229 +
2230 +)))|(((
2231 +
2232 +)))|(((
2233 +
2234 +)))|(((
2235 +
2236 +)))|(((
2237 +
2238 +)))|(((
2239 +
2240 +)))
2241 +|(((
2242 +**Annual Trade Show**
2243 +)))|(((
2244 +EXPO 2022
2245 +)))|(((
2246 +CSI
2247 +)))|(((
2248 +1100005
2249 +)))|(((
2250 +Jim
2251 +)))|(((
2252 +Nordstrom
2253 +)))|(((
2254 +Spouse
2255 +)))|(((
2256 +Nordstrom Chain, LLC
2257 +)))|(((
2258 +690 E Highway 90
2259 +)))|(((
2260 +
2261 +)))|(((
2262 +Miami
2263 +)))|(((
2264 +FL
2265 +)))|(((
2266 +33736
2267 +)))|(((
2268 +
2269 +)))|(((
2270 +1  8502588247
2271 +)))|(((
2272 +
2273 +)))|(((
2274 +__jimnordstrom@something.com__
2275 +)))|(((
2276 +
2277 +)))|(((
2278 +850
2279 +)))|(((
2280 +3998247
2281 +)))|(((
2282 +Attendee Expo Only
2283 +)))|(((
2284 +N
2285 +)))|(((
2286 +
2287 +)))|(((
2288 +
2289 +)))|(((
2290 +
2291 +)))|(((
2292 +
2293 +)))|(((
2294 +66
2295 +)))|(((
2296 +
2297 +)))|(((
2298 +Expo Only
2299 +)))|(((
2300 +
2301 +)))|(((
2302 +1100002
2303 +)))|(((
2304 +No Response
2305 +)))|(((
2306 +41-50
2307 +)))|(((
2308 +Spouse/Guest
2309 +)))|(((
2310 +Yes
2311 +)))|(((
2312 +Yes
2313 +)))|(((
2314 +
2315 +)))|(((
2316 +Male
2317 +)))|(((
2318 +No Response
2319 +)))|(((
2320 +Spouse/Guest
2321 +)))|(((
2322 +
2323 +)))|(((
2324 +
2325 +)))|(((
2326 +
2327 +)))|(((
2328 +Rope, Twine, Chain
2329 +)))|(((
2330 +No
2331 +)))|(((
2332 +No
2333 +)))|(((
2334 +No Response
2335 +)))|(((
2336 +No
2337 +)))|(((
2338 +No Response [DB ONLY]
2339 +)))
demo-sample.csv
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +5.5 KB
Content
... ... @@ -1,0 +1,23 @@
1 +��"ACCOUNT NUMBER","FIRST NAME","LAST NAME","MIDDLE NAME","TITLE","SUFFIX","COMPANY","JOB TITLE","ADDRESS1","ADDRESS2","CITY","STATE","ZIP","ZIP4","COUNTRY","TELEPHONE NUMBER","FAX NUMBER","E-MAIL ADDRESS","E-MAIL CONTACT","CUSTOM1","CUSTOM2","CUSTOM3","LAST UPDATED","OCID"
2 +14010000431,"Graham","O'Gorman",,,,"Graham O'Gorman Landscape",,"192 Olmstead Hill Rd",,"Wilton","CT",6897,1816,"United States",,,,"N",,,,20141113211102,
3 +14010000449,"Dale S","Galbo",,,,"Law Offices","Owner","15 W Hill Rd",,"Bloomfield","CT",6002,5016,"United States",2032709821,,,"N",,,,20141113211111,
4 +14010000648,"Patricia","Cannon",,,,"Employee Assistance Program","Director","887 Bridgeport Ave Ste C",,"Shelton","CT",6484,7602,"United States",2039290681,,,"N",,,,20141121163017,
5 +14010001843,"Susan","Kent",,,,,,"38110 5th St E Apt 1",,"Los Angeles","CA",93550,2317,"United States",,,,"N",,,,20141212210537,
6 +14010001858,"Brendan","Eppley",,,,,,"20 Driftway Ln",,"Darien","CT",6820,6130,"United States",,,,"N",,,,20141211230144,
7 +14010001862,,,,,,"Orchard Tree Care Llc",,"184 Ave",,"Darien","CT",6820,,"United States",2036550618,,,"N",,,,20150211133156,
8 +14010001870,"Avis Z","Gray",,,,"Designers 5 Incorporated","President","96 5 Mile River Rd",,"Darien","CT",6820,6234,"United States",2036552033,,,"N",,,,20150212210227,
9 +14010001889,"John","Hertz",,,,"Hertz Construction Co","Partner","12 Hillside Ave",,"Darien","CT",6820,5010,"United States",2036564900,,,"N",,,,20141121163018,
10 +14010001891,,,,,,"Niche Home Furnishings Ll",,"25 Old Kings Hwy N Ste 17",,"Darien","CT",6820,4608,"United States",2036566674,,,"N",,,,20141121163018,
11 +14010001901,"Wendy","Cole",,"Ms.",,"Wendy C Cole Interiors","Principal","3 Outlook Dr",,"Darien","CT",6820,5616,"United States",2036552954,,,"N",,,,20150212210227,
12 +14010001917,"Frank","Stone",,,,"Stones Landscape","Owner","258 West Ave",,"Darien","CT",6820,4111,"United States",2036569674,,,"N",,,,20150212210227,
13 +14010002429,"Bruce","Pomerance",,"Mr.",,"P L V Inc","President","1076 Post Rd",,"Darien","CT",6820,5414,"United States",2036554668,,,"N",,,,20150212210227,
14 +14010002438,"Joanne","Salvatore",,,,"Nassau Interests Llc","Member","42 N Meadows Ln",,"Stamford","CT",6903,5151,"United States",2036550303,,"joannesal@aol.com","Y",,,,20141212210537,
15 +,,,,,,,,,,,,,,,,,,,,,,,
16 +,,,,,,,,,,,,,,,,,,,,,,,
17 +,,,,,,,,,,,,,,,,,,,,,,,
18 +,,,,,,,,,,,,,,,,,,,,,,,
19 +"Rules:","Dates need to be in YYYY-mm-dd format",,,,,,,,,,,,,,,,,,,,,,
20 +"OCID = ONEcount ID","send only when available",,,,,,,,,,,,,,,,,,,,,,
21 +"CUSTOM1, CUSTOM2.... are questions that are publisher specific questions which is other than the standard personal information question.",,,,,,,,,,,,,,,,,,,,,,,
22 +"When available, values of those questions can be sent in that column. If not available don't send those columns.",,,,,,,,,,,,,,,,,,,,,,,
23 +
Confluence.Code.ConfluencePageClass[0]
id
... ... @@ -1,1 +1,1 @@
1 -77496434
1 +77496432
url
... ... @@ -1,1 +1,1 @@
1 -https://info.onecount.net//wiki/spaces/OD/pages/77496434/DExTr Import Files
1 +https://info.onecount.net//wiki/spaces/OD/pages/77496432/DExTr Import Files