Re: [Analytics] Ingoing and outgoing internal links enquiry

2018-03-10 Thread Nick Bell
Hello again, The query seemed to running fine but now I've got Query status: *killed* This query took longer than 30 minutes to execute and was killed. Would it be possible for someone else to run it? Many thanks, Nick On 10 March 2018 at 12:45, Nick Bell wrote: > Hi all, > > Thanks very much

Re: [Analytics] Ingoing and outgoing internal links enquiry

2018-03-10 Thread Nick Bell
Hi all, Thanks very much for your responses, I'm grateful to have so many options! I've followed the instructions from James, and I'm running the query now. If I have any issues I'll let you know! Many thanks, Nick On 10 March 2018 at 12:31, James Salsman wrote: > Hi Nick, > > I made a Quarry

Re: [Analytics] Ingoing and outgoing internal links enquiry

2018-03-10 Thread James Salsman
Hi Nick, I made a Quarry query to do this for you: https://quarry.wmflabs.org/query/25400 You will have to fork it and remove the "LIMIT 10" to get it to run on all the English Wikipedia articles. It may take too long or produce too much data, in which case please ask on this list for someone who

Re: [Analytics] Ingoing and outgoing internal links enquiry

2018-03-09 Thread Dan Andreescu
There was work to try to formalize and collect this data, it's part of this schema: https://meta.wikimedia.org/wiki/Schema:ExternalLinksChange But development is stalled on this code review: https://gerrit.wikimedia.org/r/#/c/346915/ On Fri, Mar 9, 2018 at 10:55 AM, Jaime Crespo wrote: > Hi, Ni

Re: [Analytics] Ingoing and outgoing internal links enquiry

2018-03-09 Thread Jaime Crespo
Hi, Nick, I am not in analytics, but, assuming you mean the English language Wikipedia, the all the internal links and the external links are available for download in sql format at: https://dumps.wikimedia.org/enwiki/20180220/ - (search "pagelinks" and "externallinks"). The latest dump is runing