click_id	person_id	external_person_id	mdn	message_id	click_timestamp	short_domain	short_key	long_url	first_click	first_device_click	activity_type	activity_id	company_id
11abcde2-efgh-2222-b1bb-2abc33defaa2	AA123456-11BB-22AB-AA11-C1234567D111		12345678910	ab12cd34-a123-11b2-c123-1a1234567a11	2018-03-13 17:32:21 -06:00	http://yourcompany.us/	A1b2cdeB	https://www.yourcompany.com/cobrand/services/	1	1	Broadcast	12345678-ab1c-1a2a-a1ab-23456789aab1	A12BcDEH
22abcde2-efgh-2222-b1bb-2abc33defaa2	BB123456-11BB-22AB-AA11-C1234567D222		13456789101	bc12cd34-b123-12b2-c123-2a1234567b12	2018-03-13 12:06:11 -06:00	http://yourcompany.us/	A1b2cdeC	https://www.yourcompany.com/cobrand/services/	1	1	Broadcast	23456789-bb1c-2a2a-a1ab-23456789aab2	A12BcDEH
33abcde2-efgh-2222-b1bb-2abc33defaa2	CC123456-11BB-22AB-AA11-C1234567D333		14567891012	cd12cd34-c123-13b2-c123-3a1234567c13	2018-03-13 13:20:50 -06:00	http://yourcompany.us/	B1b2cdeD	https://www.yourcompany.com/cobrand/services/	0	1	Broadcast	34567890-cb1c-3a2a-a1ab-23456789aab3	A12BcDEH
44abcde2-efgh-2222-b1bb-2abc33defaa2	DD123456-11BB-22AB-AA11-C1234567D444		15678910112	de12cd34-d123-14b2-c123-4a1234567d14	2018-03-13 16:02:43 -06:00	http://yourcompany.us/	C1b2cdeE	https://www.yourcompany.com/cobrand/services/	1	1	Broadcast	45678901-db1c-4a2a-a1ab-23456789aab4	A12BcDEH
55abcde2-efgh-2222-b1bb-2abc33defaa2	EE123456-11BB-22AB-AA11-C1234567D555		16789101112	ef12cd34-e123-15b2-c123-5a1234567e15	2018-03-13 12:58:51 -06:00	http://yourcompany.us/	D1b2cdeF	https://www.yourcompany.com/cobrand/services/	1	1	Broadcast	56789012-eb1c-5a2a-a1ab-23456789aab5	A12BcDEH
66abcde2-efgh-2222-b1bb-2abc33defaa2	FF123456-11BB-22AB-AA11-C1234567D666		17891011121	fg12cd34-f123-16b2-c123-6a1234567f16	2018-03-13 14:17:21 -06:00	http://yourcompany.us/	E1b2cdeG	https://www.yourcompany.com/cobrand/services/	1	1	Broadcast	67890123-fb1c-6a2a-a1ab-23456789aab6	A12BcDEH
77abcde2-efgh-2222-b1bb-2abc33defaa2	GG123456-11BB-22AB-AA11-C1234567D777		18910111213	gh12cd34-g123-17b2-c123-7a1234567g17	2018-03-13 10:47:18 -06:00	http://yourcompany.us/	F1b2cdeH	https://www.yourcompany.com/cobrand/services/	0	1	Broadcast	78901234-gb1c-7a2a-a1ab-23456789aab7	A12BcDEH
88abcde2-efgh-2222-b1bb-2abc33defaa2	HH123456-11BB-22AB-AA11-C1234567D888		19101112131	hi12cd34-h123-18b2-c123-8a1234567h18	2018-03-13 05:49:47 -06:00	http://yourcompany.us/	G1b2cdeI	https://www.yourcompany.com/cobrand/services/	0	0	Broadcast	89012345-hb1c-8a2a-a1ab-23456789aab8	A12BcDEH
99abcde2-efgh-2222-b1bb-2abc33defaa2	II123456-11BB-22AB-AA11-C1234567D999		11011121314	jk12cd34-j123-19b2-c123-9a1234567j19	2018-03-13 10:39:48 -06:00	http://yourcompany.us/	H1b2cdeJ	https://www.yourcompany.com/cobrand/services/	0	0	Broadcast	90123456-ib1c-9a2a-a1ab-23456789aab9	A12BcDEH