File:Wikimedia mobile pageviews year-over-year comparison (since May 2013).png

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

Original file ‎(1,122 × 579 pixels, file size: 82 KB, MIME type: image/png)

Captions

Captions

Add a one-line explanation of what this file represents

Summary[edit]

Description
English: Chart overlaying the total mobile (web+app) pageview numbers for all Wikimedia projects since May 2013 (the earliest time for which there is data that is based on the current pageview metric).


Data source:

SELECT year, month, day, CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) as date, sum(IF(access_method <> 'desktop', view_count, null)) AS mobileviews, SUM(view_count) AS allviews FROM wmf.projectview_hourly WHERE year>0 AND agent_type = 'user' GROUP BY year, month, day ORDER BY year, month, day LIMIT 1000;

SELECT LEFT(timestamp, 10) AS date, sum(IF(access_method <> 'desktop', pageviews, null)) AS mobileviews, SUM(pageviews) AS allviews FROM staging.pageviews05 WHERE is_spider = FALSE AND is_automata = FALSE GROUP BY date;

Includes some corrections to account for changes in the pageview definition
Date
Source Own work
Author Tbayer (WMF)


See also:

Version for total pageviews
Version for desktop pageviews

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.

(newest | oldest) View (newer 10 | ) (10 | 20 | 50 | 100 | 250 | 500)
Date/TimeThumbnailDimensionsUserComment
current20:28, 15 March 2019Thumbnail for version as of 20:28, 15 March 20191,122 × 579 (82 KB)Tbayer (WMF) (talk | contribs)update
22:17, 12 February 2019Thumbnail for version as of 22:17, 12 February 20191,122 × 579 (81 KB)Tbayer (WMF) (talk | contribs)update
02:48, 12 January 2019Thumbnail for version as of 02:48, 12 January 20191,122 × 579 (81 KB)Tbayer (WMF) (talk | contribs)update
02:02, 12 December 2018Thumbnail for version as of 02:02, 12 December 20181,122 × 579 (80 KB)Tbayer (WMF) (talk | contribs)update
22:33, 22 October 2018Thumbnail for version as of 22:33, 22 October 20181,122 × 579 (83 KB)Tbayer (WMF) (talk | contribs)update
16:10, 13 August 2018Thumbnail for version as of 16:10, 13 August 20181,122 × 579 (82 KB)Tbayer (WMF) (talk | contribs)update
15:59, 13 May 2018Thumbnail for version as of 15:59, 13 May 20181,122 × 579 (80 KB)Tbayer (WMF) (talk | contribs)update
05:12, 19 April 2018Thumbnail for version as of 05:12, 19 April 20181,122 × 579 (79 KB)Tbayer (WMF) (talk | contribs)update
00:58, 24 March 2018Thumbnail for version as of 00:58, 24 March 20181,122 × 579 (79 KB)Tbayer (WMF) (talk | contribs)upload
02:33, 13 February 2018Thumbnail for version as of 02:33, 13 February 20181,122 × 579 (79 KB)Tbayer (WMF) (talk | contribs)update
(newest | oldest) View (newer 10 | ) (10 | 20 | 50 | 100 | 250 | 500)

You cannot overwrite this file.

Retrieved from "https://commons.wikimedia.org/w/index.php?title=File:Wikimedia_mobile_pageviews_year-over-year_comparison_(since_May_2013).png&oldid=494807179"