Schema talk:MobileWikiAppSessions

Add topic
Active discussions
J Train (1973-1979).svg
Maintainer:Mikhail Popov & Dmitry Brant
Team:Mobile Apps
Project:Mobile Apps
Status:active
Sampling:1:100 for production, 1:1 for Beta
Purge:Auto-purge just eventCapsule PII after 90 days, keep the rest indefinitely

[[Category:Schemas (Mobile Apps team)]]

Sampling on production vs. betaEdit

Just a note for myself and anyone else using this schema that (to my understanding), it is sampling 1% of app IDs for production versions, but is apparently not sampled for beta versions. The majority of events currently come from beta (see below). This means one should use something like "WHERE userAgent LIKE '%-r-%'" to restrict events to production. (On the other hand, it's nice that there are no Googlebot user agents present in the current table - MobileWikiAppSessions_14031591 -, cf. phab:T117631.)

mysql:research@analytics-store.eqiad.wmnet [(none)]> SELECT MID(LEFT(userAgent,INSTR(userAgent," ")-1),INSTR(userAgent,"/")+1) AS app_version, COUNT(*) AS sessions FROM log.MobileWikiAppSessions_14031591 WHERE timestamp BETWEEN '20160509' AND '20160516' GROUP BY app_version ORDER BY sessions DESC;
+---------------------------------+----------+
| app_version                     | sessions |
+---------------------------------+----------+
| 2.1.144-beta-2016-05-09         |   208091 |
| 2.1.144-r-2016-05-09            |   116571 |
| 2.1.143-beta-2016-03-16         |   114359 |
| 2.1.141-r-2016-02-10            |    74273 |
| 2.1.143-r-2016-03-16            |    63345 |
| 2.1.141-beta-2016-02-10         |    50684 |
| 2.1.136-beta-2015-12-09         |     4983 |
| 2.1.139-beta-2016-01-22         |     4846 |
| 2.1.134-beta-2015-11-12         |     4580 |
| 2.1.138-r-2016-01-21            |     3852 |
| 2.1.136-r-2015-12-09            |     3598 |
| 2.1.137-beta-2016-01-11         |     3163 |
| 2.1.135-beta-2015-12-03         |     2567 |
| 2.1.142-beta-2016-03-07         |     2192 |
| 2.1.140-beta-2016-02-04         |     1753 |
| 2.1.141-amazon-2016-02-10       |     1683 |
| 2.1.134-r-2015-11-12            |     1550 |
| 2.1.133-r-2015-10-26            |     1529 |
| 2.1.133-beta-2015-10-26         |     1508 |
| 2.1.132-beta-2015-10-23         |      665 |
| 2.1.137-r-2016-01-11            |      591 |
| 2.1.241-beta-2016-03-03         |      327 |
| 2.1.139-r-2016-01-22            |      191 |
| 2.1.143-fdroid                  |      164 |
| 2.1.138-amazon-2016-01-21       |      131 |
| 2.1.138-beta-2016-01-21         |       52 |
| 2.1.136-amazon-2015-12-09       |       28 |
| 2.1.141-fdroid                  |       28 |
| 2.1.133-fdroid                  |       23 |
| 2.1.136-fdroid                  |       10 |
| 2.1.134-amazon-2015-11-12       |        7 |
| 2.1.133-amazon-2015-10-26       |        4 |
| 2.1.139-fdroid                  |        4 |
| 2.1.140-fdroid                  |        4 |
| 2.1.143-releasesprod-2016-03-16 |        3 |
| 2.1.137-fdroid                  |        3 |
| 2.1.134-fdroid                  |        3 |
| 2.1.141-dtac-2016-02-10         |        2 |
| 2.1.139-beta-2016-01-29         |        2 |
| 2.1.137-releasesprod-2016-01-11 |        1 |
+---------------------------------+----------+

Regards, Tbayer (WMF) (talk) 22:55, 16 May 2016 (UTC)

fromBack not counted in totalPagesEdit

Another note about a non-obvious property of the schema which one should be aware of during analysis:

Pageviews resulting from the back button (fromBack) are not included in the total page view count for the session. I.e. totalPages = Search + Random + Langlink + Internal + External + History + Saved + Nearby + Disambig.

Regards, Tbayer (WMF) (talk) 04:50, 9 June 2016 (UTC)

Definition of a sessionEdit

Currently, when a user stop using the app for more than 30 minutes (with basically any interaction with the app counting as usage), then we consider the current session as over, and send the event once the user interacts with the app again (code).

Return to "MobileWikiAppSessions" page.