5

Since the new profile was introduced, there is a new stat for impact, which measures how many people you have reached (based on views of highest-voted answers on questions etc).

I've been a bit curious about my statistic, and I was wondering which of my posts contributed most of the views.

So is there any way I see a list of my posts sorted by impact?

Built in design features, search terms, SEDE queries, or other methods are all appreciated!

7

I ripped the per database query from this answer and added the per question viewcount which gave me this query

declare @userid int = ##userid:int##

select p.id as [Post Link]
     , p.viewcount
from posts p
inner join (
  Select Id 
  From Posts 
  Where PostTypeId = 1 
  and owneruserid = @userid
  Union
  Select ParentId
    From Posts
   Where PostTypeId = 2
     And Id in (select AcceptedAnswerId from Posts)
     and owneruserid = @userid
  Union
  Select ParentId
    From Posts
   Where PostTypeId = 2
     And Score > 5
     and owneruserid = @userid
  Union
  Select a.ParentId
    From Posts a
         Join Posts q On a.ParentId = q.Id
   Where a.PostTypeId = 2
     And a.Score > 0.20 * (select sum(Score) from Posts where ParentId=q.Id)
     And a.Score > 0
     and a.owneruserid = @userid
  Union
  Select x.ParentId
    From (Select a.ParentId, Rank() Over(Partition By a.ParentId Order By ta.Score Desc) AnswerRank
            From Posts a
                 Join Posts ta On ta.ParentId = a.ParentId
           Where a.PostTypeId = 2
             And a.Score > 0
             and a.owneruserid = @userid
          ) x
          Where AnswerRank <= 3) 
rp on rp.id = p.id
order by viewcount desc

Here is what the result looks like for you at the day of posting:

post viewcount for people reached posts

| improve this answer | |
  • +1 Rene to the rescue... what took you so long? I pinged you about 10 hours ago :) – HackerKarma Sep 1 '15 at 21:19
  • 1
    @HackerKarma yeah, tnx, I saw that but I have a job that pays me although it does distract from participating here... – rene Sep 1 '15 at 21:21
  • Got it...How hard will this be to run on other sites e.g. Meta.SE? – HackerKarma Sep 1 '15 at 21:28
  • 2
    Easy you can switch the site using the selector under the run query button – rene Sep 1 '15 at 21:30
  • Thanks - I assumed it would be a data exchange query. – angussidney Sep 2 '15 at 6:16

You must log in to answer this question.

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