I am trying to find out the column that identifies the mobile device type (other/mobile phone/tablet etc.) in the Adobe clickstream feed. Basically, looking to the column that would be equivalent to the mobile device type report on the front-end.
I'm afraid this information is not directly available within data feeds. Adobe Analytics takes the mobile_id column, pairs it with a backend lookup table provided by DeviceAtlas, then displays that value in reporting. Due to contractual obligations Adobe has with DeviceAtlas, that lookup table cannot be disclosed.
In the raw data feed the mobile id column is an integer (8 digits Eg: 13548343) or a '0'. Does this means if mobile_id=0 then its a desktop and if mobile_id <> 0 then it could be any mobile device( cellphone,tablet) ?
I believe so, which would be derived from the user_agent column.
If you wanted to go your own route in device type, parsing the user agent would be the best way to go. Bear in mind though that there are a lot of different devices out there, which is why Adobe partners with DeviceAtlas - so Adobe does not have to go through the trouble of continuously categorizing new devices as they are released.