We met on apps, and http://etherpad.wikimedia.org/p/PV_Analytics_Infra documents a sample query. Analytics to look into UAParser user_agent_map field stuff to see if we can get down to the WMF-expressed way of doing the version (we believe it is well-formed), and @dr0ptp4kt and @JKatzWMF should talk to determine if additional columns will be needed for productionizing into an Oozie (Hadoop processing) job on some basis. Additional topics for consideration may be cyclical (e.g., same day last week or same hour and same day last week).

For web we would need to devise a suitable approach as well.