I want to take some event data from AudienceStream I have and join the event's active device from the visit associated with that event, as the event data only contains the unparsed user-agent. However, I cannot seem to find the "visit - id" on the event data at all. There is a Tealium session ID, but that field seems to have nothing to do with visits, or at least I can't find a field with session ID values in it on visit data.
It seems like the logical thing to exist. Visitor ID is on Events and Visits and Visitors data, why wouldn't any events that make up a visit be associated by a Visit - ID? What am I missing?
I don't think you're missing anything, we've run into the same scenario with trying to pull Visit data for particular events. To get around it we've created a Session ID attribute at the visit level and set it to the utag_main_ses_id event attribute. You still have to be careful because utag_main_ses_id is not unique (it's just a timestamp) so when joining from Events to Visits make sure to join both on Visitor ID and Session ID. Its not perfect but has been working for us. Would love to hear any other solutions others have come up with.