For mobile device data, you need to speak to a Client Care person and ask for mobile attributes to be enabled. This will give you mobile_attributes.tsv and carrier.tsv. You can then lookup mobile_id in the clickstream and map it to a Mobile Device Type in mobile_attributes.In terms of the relationsh...