Hi!
Wikimetrics <https://metrics.wmflabs.org/> development has been frozen
since 2017, and we Analytics consider it's time to sunset this tool. Its
last day of operation will be March 24th, 2019.
If you're a Wikimetrics user, please consider working with Event Metrics
<https://eventmetrics.wmflabs.org/>, a newer tool that, like Wikimetrics,
allows to gather statistics on cohorts of wiki users. It has been running
for one year now, has great documentation
<https://meta.wikimedia.org/wiki/Event_Metrics>, and is supported by
the Community
Tech <https://meta.wikimedia.org/wiki/Community_Tech> team.
For more information, you can read this Phabricator task
<https://phabricator.wikimedia.org/T211835>.
Please, post any questions or comments in there.
Thanks!
--
*Marcel Ruiz Forns** (he/him)*
Analytics Developer @ Wikimedia Foundation
Hi Agnes,
We don't have any datasets that track video plays, yet. The closest thing
we have that's public is to count media views, so the number of times
someone loaded the page that the video is on, and you can find that here:
https://dumps.wikimedia.org/other/mediacounts/
I've created this task, and we'll see where we can prioritize it (but
probably not for quite a few months). I'm not sure who maintains the tool
you linked to, but it runs on our cloud infrastructure, and it looks like
it was created by Stefan Schneider from WMDE, based on this:
https://www.mediawiki.org/wiki/User_talk:Harej
On Fri, Jun 29, 2018 at 4:24 AM Agnes Bruszik <
agnes.bruszik(a)wikimedia.org.uk> wrote:
> Dear All,
>
> We are experiencing problems with this tool:
> https://tools.wmflabs.org/commons-video-clicks/help.html#, the tool for
> measuring the number of plays is not functioning at present.
>
> Can you please suggest alternative tools to see the number of plays for
> these 14 x OER MOOC video snippets attached we have uploaded to
> Wikimedia Commons and inserted into relevant Wikipedia pages?
>
>
>
> Thank you very much!
>
> Agnes
>
> WMUK
>
>
> --
> Best,
>
> *Agnes Bruszik - *Programme Evaluation Assistant
> Wikimedia UK
> +44 2033720769
>
> *Wikimedia UK* is the national chapter for the global Wikimedia open
> knowledge movement. We rely on donations from individuals to support our
> work to make knowledge open for all. Have you considered supporting
> Wikimedia? https://donate.wikimedia.org.uk
>
> Wikimedia UK is a Company Limited by Guarantee registered in England and
> Wales, Registered No. 6741827. Registered Charity No.1144513. Registered
> Office 4th Floor, Development House, 56-64 Leonard Street, London EC2A 4LT.
> United Kingdom. Wikimedia UK is the UK chapter of a global Wikimedia
> movement. The Wikimedia projects are run by the Wikimedia Foundation (who
> operate Wikipedia, amongst other projects).
>
> *Wikimedia UK is an independent non-profit charity with no legal control
> over Wikipedia nor responsibility for its contents.*
>
Hi everyone,
Wikimetrics was using a stale database for the past 2 weeks (since about
November 1st). I have fixed the problem, but if you ran any reports in the
past 2 weeks, the numbers might be stale and you should rerun them to check.
Apologies for the trouble.
Hi everyone,
It's about a week that Wikimetrics doeasn't show real numbers for our
Armenian Wikisource program. Could you check if something is wrong with the
tool? I'm also attaching the bytes doc which might be of any help to you.
And I also can't do wikimetrics for Armenian Wikipedia as half of the user
names are shown to be invaild but all the user names are correct. Could you
check it as well?
Best,
Lilit Tarkhanyan
Wikimedia Armenia
Wikipedia Education Program Leader
2a Arshakunyats ave., 4th floor
tel. +374 55 534 011
Hello,
I don't know if people from other organisations have been experiencing
problems, but reports from the magic button seem to be consistently failing
and re-running isn't helping. Any ideas what the problem might be?
Richard
--
Richard Nevell
Project Coordinator
Wikimedia UK - sign up to our newsletter <http://eepurl.com/cnYOw5>
+44 (0) 20 7065 0921
Wikimedia UK is a Company Limited by Guarantee registered in England and
Wales, Registered No. 6741827. Registered Charity No.1144513. Registered
Office 4th Floor, Development House, 56-64 Leonard Street, London EC2A 4LT.
United Kingdom. Wikimedia UK is the UK chapter of a global Wikimedia
movement. The Wikimedia projects are run by the Wikimedia Foundation (who
operate Wikipedia, amongst other projects).
*Wikimedia UK is an independent non-profit charity with no legal control
over Wikipedia nor responsibility for its contents.*
Hello,
I just created a cohort of 44 user names. Wikimetrics has been able to
expand the user names to all projects (532 altogether) but for some reason
only 12 are valid. Any idea what the problem might be?
Richard Nevell
--
Richard Nevell
Project Coordinator
Wikimedia UK - sign up to our newsletter <http://eepurl.com/cnYOw5>
+44 (0) 20 7065 0921
Wikimedia UK is a Company Limited by Guarantee registered in England and
Wales, Registered No. 6741827. Registered Charity No.1144513. Registered
Office 4th Floor, Development House, 56-64 Leonard Street, London EC2A 4LT.
United Kingdom. Wikimedia UK is the UK chapter of a global Wikimedia
movement. The Wikimedia projects are run by the Wikimedia Foundation (who
operate Wikipedia, amongst other projects).
*Wikimedia UK is an independent non-profit charity with no legal control
over Wikipedia nor responsibility for its contents.*
I'm going to stop the Wikimetrics website and service because it's having
some serious problems working with the databases to get data. Most of the
jobs it launches end up failing partially, which makes it hard for the user
to know what's going on.
I'll update this message once we can put it back up.
Forwarding to Analytics, Research, and Wikimetrics in case this is of
interest to people who aren't subscribed to the Labs mailing list.
Pine
---------- Forwarded message ----------
From: Bryan Davis <bd808(a)wikimedia.org>
Date: Tue, Dec 6, 2016 at 9:28 AM
Subject: [Labs-l] Tell us about the SQL that you can't get to work
To: labs-l <labs-l(a)lists.wikimedia.org>
In early January there is going to be a Developer Summit in San
Francisco [0]. Chase and I are in charge of scheduling talks on the
topic "Building on Wikimedia services: APIs and Developer Resources".
One of the more interesting to me talks that has been proposed for
this is "Labsdbs for WMF tools and contributors: get more data,
faster" by Jamie Crespo [1].
I know that most of you won't be able to attend in person, but if we
can show that there is enough interest in this topic we can get the
talk scheduled in a main room and recorded so anyone can watch it
later.
An idea I just had for showing interest is to get Tool Labs
maintainers and other Labs users to describe questions that they have
tried and failed to answer using SQL queries. We can look at the kinds
of questions that come up and ask Jamie (and others) if there are some
general recommendations that can be made about how to improve
performance or understand how the bits and pieces of our data model
fit together.
To kick things off, here's an example I tried to help with over the
weekend. A Quarry user was adapting a query they had used before to
find non-redirect File namespace pages not paired with binary files on
Commons. The query they had come up with was:
SELECT DISTINCT page_title, img_name
FROM (
SELECT DISTINCT page_title
FROM page WHERE page_namespace = 6
AND page_is_redirect = 0
) AS page
LEFT JOIN (
SELECT DISTINCT img_name
FROM image
) AS image ON page_title=img_name
WHERE img_name IS NULL;
The performance of this is horrible for several reasons including the
excessive use of DISTINCT. The query was consistently killed by the 30
minute runtime limit. MaxSem and I both came up with about the same
optimization that eliminated the sub-queries and use of DISTINCT:
SELECT page_title, img_name
FROM page LEFT OUTER JOIN image ON page_title=img_name
WHERE page_namespace = 6
AND page_is_redirect = 0
AND img_name IS NULL;
This new query is not fast in any sense of the word, but it does
finish without timing out. There is still some debate about whether
the 906 rows it returned are correct or not [2].
[0]: https://www.mediawiki.org/wiki/Wikimedia_Developer_Summit
[1]: https://phabricator.wikimedia.org/T149624
[2]: https://quarry.wmflabs.org/query/14501
Bryan
--
Bryan Davis Wikimedia Foundation <bd808(a)wikimedia.org>
[[m:User:BDavis_(WMF)]] Sr Software Engineer Boise, ID USA
irc: bd808 v:415.839.6885 x6855
_______________________________________________
Labs-l mailing list
Labs-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/labs-l