These examples illustrate supported content structures for event logs.
Samba TV can accept multiple sources, each with their own format configuration.
If the suggested formats or batch collection methods do not apply to your data ecosystem, please contact Samba TV for alternatives.
Example 1 - Two ID types
Each ID type has its own column: timestamp, IP, cookie ID, IDFA, and UserAgent.
| IP | Timestamp | CookieID | IDFA | UserAgent |
|---|---|---|---|---|
| 1.2.3.4 | 1412845993 | 123456789 | 987654321 | Mozilla/5/... |
Example 2 - First-Party and Third-Party Cookies
If your data contains 1st party cookies (cookies set on the domain of the website), then the domain on which the cookie was set should be listed in a UID Type column.
You can mix 1st and 3rd party cookies by setting a default domain in case of 3rd party cookies (use an empty string or "yourdomain.com").
| Datetime | IP | CookieID | UIDType | UserAgent |
|---|---|---|---|---|
| 2014-10-03T06:58:45+00:00 | 1.2.3.4 | 12345678 | host2.com | Mozilla/5/... |
| 2014-10-03T06:59:12+00:00 | 5.6.7.8 | 34567890 | host1.com | Mozilla/5/... |
| 2014-10-03T06:59:52+00:00 | 3.4.5.6 | 23456789 | yourdomain.com | Mozilla/5/... |
Example 3 - Multiple Types in One Column + UID Type Column
In this example, there are separate columns for CookieIDs and DeviceIDs.
The type of DeviceID is further specified in the DeviceID_type column.
| Datetime | IP | CookieID | DeviceID | DeviceIDtype | UserAgent |
|---|---|---|---|---|---|
| 2014-10-03T06:58:45+00:00 | 1.2.3.4 | 123456789 | abcdef | didmd5 | Mozilla/5/... |
| 2014-10-03T06:59:22+00:00 | 5.6.7.8 | 987654321 | ghijklm | ifa | Mozilla/5/... |
Preferred Method
Samba TV strongly recommends providing each UID type in its own column.
If this is not technically feasible, UID type columns may be used as an alternative.
Example 4 - TSV text data
35.196.97.36<tab>1537358370<tab>abcdef12345<tab>Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36
35.196.97.36<tab>1537356920<tab>dfdkkdf34567<tab>Mozilla/5.0 (Linux; Android 8.0.0; SM-G950F Build/R16NW) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.91 Mobile Safari/537.36