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
On Wed, Jun 28, 2017 at 2:52 AM, Stefan Schneider stefan.schneider@wikimedia.de wrote:
Second, do you know in whitch time zone the date in the database is?
All timestamps in Wikimedia stored data should be in UTC time.
Bryan