You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org

Analytics/Data Lake/Traffic/mobile apps session metrics

From Wikitech-static
< Analytics‎ | Data Lake‎ | Traffic
Revision as of 13:48, 7 April 2017 by imported>Milimetric (Milimetric moved page Analytics/Data/mobile apps session metrics to Analytics/Data Lake/Traffic/mobile apps session metrics)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The tables mobile_apps_session_metrics and mobile_apps_session_metrics_by_os (available on Hive) contain aggregate stats about pageview sessions on the Android and iOS Wikipedia mobile apps, updated weekly.

mobile_apps_session_metrics_by_os calculates them for a timespan of 7 days each, for iOS and Android separately. mobile_apps_session_metrics has numbers for overlapping 30-day timespans, without distinguishing between the two apps.

A session is defined as a sequence of pageviews from the same app ID that does not exceed 30 minutes of inactivity.

File:Reading and Comm Tech Quarterly Review Q1 2016-17.pdf In both tables, each row provides the minimum, maximum, and four percentiles (10th, 50th, 90th, 99th) for one of the following three metrics, as well as an overall count:

  • Sessions per user (i.e. app UUID)
  • Pageviews per session
  • Session length (the time between the first and last event. Not reported for sessions consisting of only one pageview)


Schema (as of 2017)

> DESCRIBE wmf.mobile_apps_session_metrics;

col_name	data_type	comment
year	int	Unpadded year of report run date
month	int	Unpadded month of report run date
day	int	Unpadded day of report run date
date_range	string	Period for which report was run
type	string	Type of session metric
count	int	Value of count for given metric
min	int	Min value for given metric
max	int	Max value for given metric
p_1	string	1st Percentile for given metric
p_50	string	50th Percentile for given metric
p_90	string	90th Percentile for given metric
p_99	string	99th Percentile for given metric


> DESCRIBE wmf.mobile_apps_session_metrics_by_os;

col_name	data_type	comment
year	int	Unpadded year of report run date
month	int	Unpadded month of report run date
day	int	Unpadded day of report run date
date_range	string	Period for which report was run
type	string	Type of session metric
os_family	string	OS family breakdown
count	int	Value of count for given metric
min	int	Min value for given metric
max	int	Max value for given metric
p_1	string	1st Percentile for given metric
p_50	string	50th Percentile for given metric
p_90	string	90th Percentile for given metric
p_99	string	99th Percentile for given metric

Caveats

  • The field name p_1 and its description are inaccurate - it contains the 10th percentile, not the 1st.
  • The stats only cover users who have opted-in to usage data (iOS) / have not opted out (Android).

See also

  • Scala code that calculates the data
  • phab:T86535 2015 task about the introduction of these metrics, with an outline of the calculation method
  • phab:T117615 2015/16 task about the creation of the by_os variant (providing the data separately for iOS and Android, and for weekly instead of monthly timespans)