What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 134 Stack Exchange communities.

I have seen the following question which is about what edits contributes towards badges:

Also these questions which talk about where I can see how many posts I have edited:

However, why do the number of edits reported in my Profile (see point 3 below) and the number of edits reported in Users Tab (see point 1 below) differ?

All the images are for my profile on Ask Ubuntu.

  1. As per this answer, in Users Tab → Editors Tab → all filter → it's 592:

    users>editors

  2. As per this answer, the one's which count towards badges, it's 509 (no problem, this is clear why it's different):

    badges

  3. As per this answer, in my Profile → Activity → Revisions → it's 616:

    revisions

  4. As per this answer, this data-query shows it as 739 (completely contrary to what the comment on that answer says):

    data-query

Why are these numbers different — specially the ones mentioned in points 1 and 3?

share|improve this question
    
BTW the data explorer is updated weekly (no live data). –  juergen d Feb 21 '13 at 12:53
1  
@juergend: Yes, I know - it should be lagging in numbers. However, it shows the maximum count - this is why I have included it, otherwise I wouldn't have :) –  Aditya Feb 21 '13 at 12:54
    
Hmm, in /users I'm 1,451; I've got the same in the badge progress, which is what I'd expect. I think these two numbers should be identical and are the number of posts you've edited that are not yours/wikis etc. I have 1,738 revisions in total, which includes my own posts which I've edited, which is kind of depressing. It means I've edited over 50% of my posts post posting... –  ben is uǝq backwards Feb 21 '13 at 13:17
    
I bet the counts are for deleted versus still-available posts. –  Martijn Pieters Feb 21 '13 at 13:18
    
It seems unlikely that I've never edited a deleted post whereas someone who's just got 2k rep has edited 83 @Martijn. Unless the Ask Ubuntu community really like deletions... though I guess I could now be eligible to see deleted posts so my numbers have become the same. Let's check meta... –  ben is uǝq backwards Feb 21 '13 at 13:23
    
@benisuǝqbackwards: Yeah, the guess was wrong. But I have a better answer below. –  Martijn Pieters Feb 21 '13 at 13:25
    
@benisuǝqbackwards: Difference between /users and badge progress is because of this answer. –  Aditya Feb 21 '13 at 13:25
    
Yes Aditya, that's pretty much my guess. I think @Martijn's got it with his answer as I've just realised my review thing has 1,294. –  ben is uǝq backwards Feb 21 '13 at 13:27

1 Answer 1

up vote 5 down vote accepted
  • The first count (592) includes edits to your own posts, and only counts specific types of edits (excluding title and tag-only edits for example).

    (To verify, I made a (justifiable) edit to an older post of mine and my count rose by 1. Making another (justifiable) edit to a post I already edited this week and the count rose. I then removed a useless tag name from a question title, and the editors-tab count did not change. Similarly, edits that only add or remove tags do not increase the count either).

  • The Data explorer query you used counts unique edits; editing a post twice counts as two edits. The badge counts edits to unique posts, where two edits to one post count as one edit for the badge.

    To get unique posts instead, query for COUNT(DISTINCT PostId).

  • For the copy editor badge, a series of types of edits are excluded, prominently edits to your own posts.

share|improve this answer
    
It looks like users may be unique edits to non-deleted posts (below 10k) and all posts (10k +) that are not owned by you... sigh –  ben is uǝq backwards Feb 21 '13 at 13:28
    
@Aditya: trying to figure that out next. –  Martijn Pieters Feb 21 '13 at 13:36
    
@Aditya: Unique posts versus repeat edits explains the difference. –  Martijn Pieters Feb 21 '13 at 13:44
    
@MartijnPieters: So, this means that point 1 includes any number of edits we make to our own posts (if we edit our post 100 times - it's count would rise by 100). However, if we edit someone else's post for 100 times, it would only count it as once. However, Revision Activity tab would increase the count for both of them by 100. Is this what you are saying? –  Aditya Feb 21 '13 at 13:50
    
And regarding data-query, I don't know how to edit them. Can you please fork the query and provide a link to it. Thanks!! –  Aditya Feb 21 '13 at 13:52
    
@Aditya: No, that's not what I am saying. I am saying that the first count only counts unique posts that you edited. –  Martijn Pieters Feb 21 '13 at 13:52
    
@Aditya: There is a fork query right there. Create an account on the data explorer and you can do it yourself! :-) –  Martijn Pieters Feb 21 '13 at 13:53
    
What is the meaning of 'unique posts` - do you mean revisions? Regarding data query, do i need to edit just 1st line of the actual code? I actually don't know SQL and its commands :) –  Aditya Feb 21 '13 at 13:55
    
@Aditya: The first line, yes, so instead of where count(id) is replaced with where count(distinct postid). –  Martijn Pieters Feb 21 '13 at 13:56
    
Ah with repeat edits you mean: if we edit our own question/answer - it doesn't count as repeat post. However, if we edit someone else's question/answer consecutively (say thrice), then /users would count them as 1 and revision activity would count them as 3. Is this what you mean? However, if we edit someone else's post once > then a 3rd user edits the post > and then we edit it again. Both the counts would increase by 2. I know it's complicated :) –  Aditya Feb 21 '13 at 14:02
    
@Aditya: Actually I am wrong about the tab count being for unique posts. Verifying the actual counts now. –  Martijn Pieters Feb 21 '13 at 14:04
    
@Aditya: Multiple edits per post do count separately, but edits to just the title (and possibly just the tags) do not count. –  Martijn Pieters Feb 21 '13 at 14:15
    
@MartijnPieters: are you sure about that? If yes, I would accept it. Otherwise, I would wait for SE staff/moderators to clear the confusion. However, I highly doubt that it doesn't count titles. –  Aditya Feb 21 '13 at 14:18
    
@Aditya: Just editing a title is a separate PostHistoryTypeId in the database, actually, so it's not so surprising. I just had another opportunity to edit just the title, and again the count did not go up. So yes, I am sure. :-) –  Martijn Pieters Feb 21 '13 at 14:20
1  
@Aditya: No, I don't necessarily think that that is a bug, no. –  Martijn Pieters Feb 21 '13 at 16:03

You must log in to answer this question.

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