Segment Logs Schema

HeaderPositionDefinitionsql_datatypeDDL desc
auction_id1Unique ID for every bid request in the system. A joining key for all the events associated with the bid request, like impression, clicks, and activities.VARCHAR(255)
user_id2Device ID for mobile, cookie for desktop. Will populate with cookie on a desktop OR an iOS/Android ID for mobileVARCHAR(255)
user_id_hashed3GDPR-compliant hashed user_idVARCHAR(255)
segment_id4AIDEM segment ID; contains all segments the user qualifies for, comma-delimited, regardless if it is targeted on the line item that wonN/AThe length of this field is unbounded since there can be many segment IDs that a user qualifies for