7

Is there a good Data Explorer query to find how "SFF-linky" my answers are in-site?

In more technical terms, for a given user, how many links to SFF.SE are on average in their answers on the site?

||||||
  • This question is posted in honor of Ted Nelson – DVK-on-Ahch-To Aug 9 '16 at 13:20
  • I'm willing to bet that I'm very linky indeed. – Valorum Aug 9 '16 at 15:15
  • Do you mean how many other questions link to answers you've posted? Or how many links you've included to other answers on the site? – Valorum Aug 9 '16 at 15:21
  • @Valorum - the latter (but not only to answers, but to ANY site URLs) – DVK-on-Ahch-To Aug 9 '16 at 15:36
  • Whoops, missed the "to SFF URLs" bit in that; that changes my numbers more than a little – Jason Baker Aug 9 '16 at 18:09
  • Okay, I'm getting a bit mixed up in the language of the question. Are you asking for a way to determine how many links you've put in answers? – PiousVenom Aug 12 '16 at 18:19
  • @MyCodeSucks - links in answers, pointing to SFF pages. – DVK-on-Ahch-To Aug 12 '16 at 18:39
  • FWIW Here's the full rankings data.stackexchange.com/scifi/query/edit/524384 – Hack-R Aug 15 '16 at 3:29
  • @Hack-R Yoink – Jason Baker Sep 19 '16 at 17:30
  • 1
    I feel like I did math, by getting that query to work! I am 0.5121951219512195% linky. :) – Slytherincess Sep 19 '16 at 20:39
  • @DVK Ted Nelson is the High Sparrow of http. :) – Möoz Sep 19 '16 at 23:42
8

Ask and ye shall receive

Standard SEDE disclaimers apply:

  • Updated once weekly; currently we're about two days behind reality
  • Doesn't include deleted posts

Plug your SFF UserId into the box and away you go.

  • Mine is 0.453
  • Yours is 0.111
  • Valorum's (since he asked) is 0.047

Note that this hasn't really been tested, since I'm not inclined to manually count all the links in all of my answers. I'm always welcome to corrections.

An earlier version of the query counted all links, but the one above only counts links to SFF.SE (and not meta).

With due credit to Hack-R for doing most of the hard work, you can also check out the Linky Leaderboard, though it isn't very instructive; indeed, the top five are:

  • errantlinguist, with four links in one answer
  • USFBS, with five links in two answers
  • user137369, with two links in one answer
  • The unregistered Vates, also with two links in one answer
  • Tony R, still with two links in one post

To my eternal shame, I am merely the 139th most linky user of the site.

||||||
  • Apparently I'm not very linky at all :-( Unless you count 'all links', in which case I'm quite linky indeed. – Valorum Aug 9 '16 at 18:09
  • The share link below posts (which is what I usually use for post linking) seems to provide an http link. And indeed, if I remove the whole a href="https business from your query, the people listed here are way more linky. – TARS says Reinstate Monica Aug 9 '16 at 20:14
  • 1
    @Cahir Hm, that's annoying. Query updated; thanks – Jason Baker Aug 9 '16 at 20:18
  • Mine's 0.79 is that bad? – Möoz Aug 9 '16 at 21:57
  • 2
    @Mooz - Yes. Dreadful. Possibly. – Valorum Aug 9 '16 at 22:29
  • Oh gosh, and if I include all links, then I get 7.15! What do I win? – Möoz Aug 9 '16 at 23:30
  • Nothing. That doesnt seep like too much – bleh Aug 11 '16 at 23:10
  • 1
    @Mooz - It's good if you're into the whole interwebz idea. – DVK-on-Ahch-To Aug 12 '16 at 18:40
  • Made a similar query: Linkyness Leaderboard (including external links) – Möoz Sep 19 '16 at 22:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .