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:


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


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


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


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

  • BTW the data explorer is updated weekly (no live data).
    – juergen d
    Commented Feb 21, 2013 at 12:53
  • 2
    @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
    Commented Feb 21, 2013 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... Commented Feb 21, 2013 at 13:17
  • I bet the counts are for deleted versus still-available posts. Commented Feb 21, 2013 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... Commented Feb 21, 2013 at 13:23
  • @benisuǝqbackwards: Yeah, the guess was wrong. But I have a better answer below. Commented Feb 21, 2013 at 13:25
  • @benisuǝqbackwards: Difference between /users and badge progress is because of this answer.
    – Aditya
    Commented Feb 21, 2013 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. Commented Feb 21, 2013 at 13:27

1 Answer 1

  • 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.

  • 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 Commented Feb 21, 2013 at 13:28
  • @Aditya: trying to figure that out next. Commented Feb 21, 2013 at 13:36
  • @Aditya: Unique posts versus repeat edits explains the difference. Commented Feb 21, 2013 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
    Commented Feb 21, 2013 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
    Commented Feb 21, 2013 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. Commented Feb 21, 2013 at 13:52
  • @Aditya: There is a fork query right there. Create an account on the data explorer and you can do it yourself! :-) Commented Feb 21, 2013 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
    Commented Feb 21, 2013 at 13:55
  • @Aditya: The first line, yes, so instead of where count(id) is replaced with where count(distinct postid). Commented Feb 21, 2013 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
    Commented Feb 21, 2013 at 14:02
  • @Aditya: Actually I am wrong about the tab count being for unique posts. Verifying the actual counts now. Commented Feb 21, 2013 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. Commented Feb 21, 2013 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
    Commented Feb 21, 2013 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. :-) Commented Feb 21, 2013 at 14:20
  • 1
    @Aditya: No, I don't necessarily think that that is a bug, no. Commented Feb 21, 2013 at 16:03

You must log in to answer this question.

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