Device Type Column in Adobe Analytics Clickstream Feed? | Community
Skip to main content
January 21, 2019
Solved

Device Type Column in Adobe Analytics Clickstream Feed?

  • January 21, 2019
  • 5 replies
  • 37653 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Gigazelle

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.

5 replies

Gigazelle
Adobe Employee
GigazelleAdobe EmployeeAccepted solution
Adobe Employee
January 29, 2019

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.

January 19, 2021
Hi Gigazelle - is this still valid? Is there no way to get the text description of a device from the clickstream?
gosainAuthor
January 29, 2019

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

Gigazelle
Adobe Employee
Adobe Employee
January 29, 2019

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.

November 15, 2019

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.

Adobe Employee
November 18, 2019

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

June 3, 2024

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