File:Day-7 retention of Wikipedia Android app users (2016-).png

Original file (2,070 × 490 pixels, file size: 150 KB, MIME type: image/png)

Summary

Description
English: Retention of new users of the Android Wikipedia app after seven days


Data source:SELECT LEFT(timestamp, 8) AS date, SUM(IF(event_appInstallAgeDays = 0, 1, 0)) AS day0_active, SUM(IF(event_appInstallAgeDays = 7, 1, 0)) AS day7_active FROM log.MobileWikiAppDailyStats_12637385 WHERE userAgent LIKE '%-r-%' AND userAgent NOT LIKE '%Googlebot%' GROUP BY date ORDER BY DATE;

(with the retention rate calculated as day7_active divided by day0_active from seven days earlier)
Date
Source Own work
Author Tbayer (WMF)

Licensing

I, the copyright holder of this work, hereby publish it under the following license:
w:en:Creative Commons
attribution share alike
This file is licensed under the Creative Commons Attribution-Share Alike 4.0 International license.
You are free:
  • to share – to copy, distribute and transmit the work
  • to remix – to adapt the work
Under the following conditions:
  • attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
  • share alike – If you remix, transform, or build upon the material, you must distribute your contributions under the same or compatible license as the original.

Captions

Add a one-line explanation of what this file represents

Items portrayed in this file

depicts

2 March 2018

image/png

58f3f5d7f3607bf09d3a746fc7039af79475aa50

153,661 byte

490 pixel

2,070 pixel

File history

Click on a date/time to view the file as it appeared at that time.

Date/TimeThumbnailDimensionsUserComment
current19:25, 2 March 2018Thumbnail for version as of 19:25, 2 March 20182,070 × 490 (150 KB)Tbayer (WMF)User created page with UploadWizard

The following page uses this file: