Thanks!

On Mon, Jun 8, 2015 at 12:43 PM, Marcel Ruiz Forns <mforns@wikimedia.org> wrote:
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