- TLC Home Home
- Discussions Discussions
- Documentation Documentation
- Knowledge Base Knowledge Base
- Education Education
- Blog Blog
- Support Desk Support Desk
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?
09-10-2020 02:54 AM
09-10-2020 11:12 AM
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.
09-28-2020 03:49 PM
Copyright All Rights Reserved © 2008-2023