Hello,

I recently started working at Wikimedia Germany. My focus is new editor retention work in the german community.

In that role my team created a tool to count views of videos the potential new editor viewed on a wiki-page. If you're interested you can find it here: https://tools.wmflabs.org/commons-video-clicks/ .

I have 2 questions to the data used in that tool and hope you can halp me with that.

First, the tool is using the following query to get the data in JSON from WMF-Database and showing it in the tool: https://tools.wmflabs.org/mediaplaycounts/api/1/FilePlaycount/date_range/How_Wikipedia_contributes_to_free_knowledge.webm/20170501/20170503.

A colleague told me that in the consecutive dates in the JSON output there is stated that the data is updated daily. The problem is, that form June on there is no data for the views. E. g. the following query gives no data: https://tools.wmflabs.org/mediaplaycounts/api/1/FilePlaycount/date_range/How_Wikipedia_contributes_to_free_knowledge.webm/20170601/20170603.Do you have more information on the update rates or missing update of the data itself?

Second, do you know in whitch time zone the date in the database is?

I would love to have a feedback if this message reached you and if or when you could help me with that. Maybe you know someone else who can support me here?

Big Thanks in advance and best regards,

Stefan

Stefan Schneider
Projektassistenz Neue Freiwillige

Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin
Tel. (030) 219 158 26-0
http://wikimedia.de

Stellen Sie sich eine Welt vor, in der jeder Mensch an der Menge allen Wissens frei teilhaben kann. Helfen Sie uns dabei!
http://spenden.wikimedia.de/

Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e. V. Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter der Nummer 23855 B. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/029/42207.