Device Type Column in Adobe Analytics Clickstream Feed?

[sanjayg40845008]

Hello.

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.

Thanks for any pointers.

Sanjay

[Gigazelle · Accepted solution]

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.

[taj88]

Hi Gigazelle - is this still valid? Is there no way to get the text description of a device from the clickstream?

[sanjayg40845008]

Thanks for your response. Is the Mobile_ID column that is populated in the feed specific to Device Atlas?

[Gigazelle]

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.

[Shaista_L]

Hi Gigazelle​

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) ?

Thank you in advance.

[Ankit_Sharma_]

Shaista.L​ your understanding is correct, also keep in mind that you can have one (user_agent or mobile_id lookup) in your feed, you can;t have both at the same time.

How to enable Dynamic (Mobile Attributes) Lookup in Data Feed

[annieMalhotra]

Hi Ankit, 

Thank you for your reply. It is very helpful. Why can't you have both user_agent and mobile_id in a lookup. I am doing some analysis on customers who access the member login area using the browser on their mobile device. I have found 1900 instances where mobile_id is available but user_agent is blank. I have also found 5000 instances where user_agent is available but mobile_id is blank. 

Do you the scenarios where the above would be applicable, please? 

Cheers, 

Annie