File:Day-7 retention of Wikipedia Android app users (install dates 2015-10-01..2016-04-17).png

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

Original file ‎(928 × 371 pixels, file size: 38 KB, MIME type: image/png)

Captions

Captions

Add a one-line explanation of what this file represents

Summary

[edit]
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 timestamp LIKE '2016%' AND 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

[edit]
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 3.0 Unported 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.

File history

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

Date/TimeThumbnailDimensionsUserComment
current18:30, 2 May 2016Thumbnail for version as of 18:30, 2 May 2016928 × 371 (38 KB)Tbayer (WMF) (talk | contribs)User created page with UploadWizard

You cannot overwrite this file.

There are no pages that use this file.

Retrieved from "https://commons.wikimedia.org/w/index.php?title=File:Day-7_retention_of_Wikipedia_Android_app_users_(install_dates_2015-10-01..2016-04-17).png&oldid=466984470"