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

From MediaWiki.org
Jump to navigation Jump to search

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

Summary

Description
English: Chart overlaying the total 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 estimated corrections to account for changes in the pageview definition and artefacts (e.g. T154735, T157528
Date
Source Own work
Author Tbayer (WMF)


See also:

Version for desktop pageviews
Version for mobile pageviews

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 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 alter, transform, or build upon this work, you may distribute the resulting work only under the same or similar license to this one.

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:26, 15 March 2019Thumbnail for version as of 20:26, 15 March 20191,122 × 579 (101 KB)Tbayer (WMF)update
22:16, 12 February 2019Thumbnail for version as of 22:16, 12 February 20191,122 × 579 (100 KB)Tbayer (WMF)update
02:49, 12 January 2019Thumbnail for version as of 02:49, 12 January 20191,122 × 579 (100 KB)Tbayer (WMF)update
02:00, 12 December 2018Thumbnail for version as of 02:00, 12 December 20181,122 × 579 (99 KB)Tbayer (WMF)update
13:56, 22 October 2018Thumbnail for version as of 13:56, 22 October 20181,122 × 579 (98 KB)Tbayer (WMF)update
16:09, 13 August 2018Thumbnail for version as of 16:09, 13 August 20181,122 × 579 (96 KB)Tbayer (WMF)update
15:58, 13 May 2018Thumbnail for version as of 15:58, 13 May 20181,122 × 579 (94 KB)Tbayer (WMF)update
05:11, 19 April 2018Thumbnail for version as of 05:11, 19 April 20181,122 × 579 (91 KB)Tbayer (WMF)update
00:56, 24 March 2018Thumbnail for version as of 00:56, 24 March 20181,122 × 579 (93 KB)Tbayer (WMF)update
02:34, 13 February 2018Thumbnail for version as of 02:34, 13 February 20181,122 × 579 (92 KB)Tbayer (WMF)update
(newest | oldest) View (newer 10 | ) (10 | 20 | 50 | 100 | 250 | 500)

Global file usage

The following other wikis use this file: