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

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

Original file ‎(1,167 × 467 pixels, file size: 108 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 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 Zareenf

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 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.

File history

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

Date/TimeThumbnailDimensionsUserComment
current19:53, 7 January 2017Thumbnail for version as of 19:53, 7 January 20171,167 × 467 (108 KB)Zareenf (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_April_2016_-_).png&oldid=463882107"