Getting the Active Device for an Event

[Terry_Howard]

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?

[dsavvy]

Hi

Whats the setup you are using?
Is the audiencestream data coming from IQ or another source?
Also do you have eventstream active?

It could be that you have to either declare it in your events attribute if it is not coming from IQ.

[BFioretta]

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.

[TealiumJustin]

Here's the documented method for joining data from EventDB with AudienceDB:
https://community.tealiumiq.com/t5/Customer-Data-Hub/AudienceDB-Data-Guide/ta-p/9399#toc-hId--248860...