Sure,

+analytics

On Mon, Jun 8, 2015 at 5:50 PM, Adam Baso <abaso@wikimedia.org> wrote:

Okay to move this to the public list and remove the internal list?

On Monday, June 8, 2015, Joseph Allemandou <jallemandou@wikimedia.org> wrote:

Hi,

In fact instead of using isAppPageview UDF, one should use access_method = 'mobile app' :)

On Mon, Jun 8, 2015 at 12:44 PM, Marcel Ruiz Forns <mforns@wikimedia.org> wrote:

+ analytics internal

Hi Jon and Adam,

Yes, this totally helps. It confirms the work that we are doing.

In fact, 3 of the items you list are already working and available for querying:

• app (yes/no), through the UDF in hive 'isAppPageview()'
• OS (android, iOS, other), through the user_agent_map['os_family'] field
• OS version, through the user_agent_map['os_major'] field

And, as discussed, we'll add in short the possibility of querying for the 'app version' through the user_agent_map['app_version'] field.

Thanks!

Marcel

On Fri, Jun 5, 2015 at 10:48 PM, Jon Katz <jkatz@wikimedia.org> wrote:

+Adam, who has been diving deep into this stuff lately.

Hi Marcel, 

I am a bit swamped right now, so can't look at the tickets, but of the strings you showed, the fields more important to me are:

• app (yes/no)
  
• OS (android,iOS, other)
  
• app version (numeric)
  
• tablet/phone (ios only, right)
  
• OS version (is this possible?)

Bolded are big deals :)  Does this help?

Thanks!

-J

On Fri, Jun 5, 2015 at 11:13 AM, Marcel Ruiz Forns <mforns@wikimedia.org> wrote:

Hi Jon,

Here is Marcel from Analytics, how are you?!

I am developing the analytics-refinery-source code that will parse the missing user-agent info for the mobile app requests. See the task: https://phabricator.wikimedia.org/T99932

I think I understand what your team wants in that respect, so I already implemented the functionality, you can check it here: https://gerrit.wikimedia.org/r/#/c/216060/

but I still wanted to confirm with you :-)

Considering these user agent strings:

WikipediaApp/2.0-r-2015-04-23 (Android 5.0.1; Phone) Google Play

WikipediaApp/4.1.2 (iPhone OS 8.3; Tablet)

The program should take the part after "WikipediaApp/" and before the next " " (space), for example: "2.0-r-2015-04-23" or "4.1.2".

And store it as part of the user agent map, in a field named i.e. "app_version".

So that it is easy queryable like: SELECT user_agent_map["app_version"] FROM ...

Is that right?

That was the question. Thanks!

Marcel

_______________________________________________
Analytics-internal mailing list
Analytics-internal@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics-internal

--

Joseph Allemandou

Data Engineer @ Wikimedia Foundation

IRC: joal

_______________________________________________
Analytics-internal mailing list
Analytics-internal@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics-internal

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics