What exactly does "statistics.loves", "statstics.favorites", etc. measure in ScratchDB?

NFlex23

My first impression was that it would measure the total accumulated amount of that thing (loves, views, etc.), but now I'm not sure. ScratchStats seems to return different numbers, so what exactly do these numbers measure? There was an Aviate user who pointed this out to me.

Raw JSON:

{
  "username": "NFlex23",
  "id": 50024587,
  "sys_id": 134829,
  "joined": "2019-08-10T00:00:00.000Z",
  "country": "United States",
  "bio": "NFlex23 • 14 • #50024587 • Wiki editor • Male<br>⌁<br>○ Flutist<br>○ 1st degree black belt in Taekwondo<br>○ Programming language &amp; RPi enthusiast",
  "work": "Scratch Tutorials: scratchtutorials.vercel.app<br>Aviate: aviateapp.eu.org<br>⌁<br>Wiki account: <a href=\"https://en.scratch-wiki.info/wiki/User:NFlex23\">https://en.scratch-wiki.info/wiki/User:NFlex23</a><br>⌁<br>All of my art (PFP, banner, thumbnails, etc.) is by me. Please don't use it without permission.",
  "status": "Scratcher",
  "school": null,
  "statistics": {
    "ranks": {
      "country": {
        "loves": 6859,
        "favorites": 8039,
        "comments": 21113,
        "views": 19642,
        "followers": 12574,
        "following": 164676
      },
      "loves": 14801,
      "favorites": 17589,
      "comments": 38079,
      "views": 42026,
      "followers": 31679,
      "following": 344012
    },
    "loves": 1162,
    "favorites": 779,
    "comments": 468,
    "views": 10194,
    "followers": 294,
    "following": 22
  }
}

Last edited by NFlex23 (Nov. 11, 2022 16:55:48)

CST1229

If you look closely, those properties are actually under statistics.ranks, so it probably shows your position in the total loves/favorites/views leaderboard.

NFlex23

CST1229 wrote:
If you look closely, those properties are actually under statistics.ranks, so it probably shows your position in the total loves/favorites/views leaderboard.

Although it looks so, that's not the case:

Raw JSON:

{
  "username": "NFlex23",
  "id": 50024587,
  "sys_id": 134829,
  "joined": "2019-08-10T00:00:00.000Z",
  "country": "United States",
  "bio": "NFlex23 • 14 • #50024587 • Wiki editor • Male<br>⌁<br>○ Flutist<br>○ 1st degree black belt in Taekwondo<br>○ Programming language &amp; RPi enthusiast",
  "work": "Scratch Tutorials: scratchtutorials.vercel.app<br>Aviate: aviateapp.eu.org<br>⌁<br>Wiki account: <a href=\"https://en.scratch-wiki.info/wiki/User:NFlex23\">https://en.scratch-wiki.info/wiki/User:NFlex23</a><br>⌁<br>All of my art (PFP, banner, thumbnails, etc.) is by me. Please don't use it without permission.",
  "status": "Scratcher",
  "school": null,
  "statistics": {
    "ranks": {
      "country": {
        "loves": 6859,
        "favorites": 8039,
        "comments": 21113,
        "views": 19642,
        "followers": 12574,
        "following": 164676
      },
      "loves": 14801,
      "favorites": 17589,
      "comments": 38079,
      "views": 42026,
      "followers": 31679,
      "following": 344012
    },
    "loves": 1162,
    "favorites": 779,
    "comments": 468,
    "views": 10194,
    "followers": 294,
    "following": 22
  }
}

Last edited by NFlex23 (Nov. 11, 2022 16:51:10)

NFlex23

Bump.

NFlex23

Bump.

oxiti8

maybe it's the amount of loves you've given projects?

NFlex23

oxiti8 wrote:
maybe it's the amount of loves you've given projects?

That's what I thought as well, but the numbers don't match up.
My favorites on Scratch:

ScratchDB:

Steve0Greatness

My guess is that it's the total amount of favorites/loves your projects have gotten. I'll do a bit of data collection.

Edit: From adding up the loves on all my projects, I think I'm correct in my assumption.

Last edited by Steve0Greatness (Nov. 15, 2022 02:27:31)

NFlex23

Steve0Greatness wrote:
My guess is that it's the total amount of favorites/loves your projects have gotten. I'll do a bit of data collection.

Edit: From adding up the loves on all my projects, I think I'm correct in my assumption.

That makes sense, but why does ScratchStats have completely different numbers? I suppose it might just be out of date.

NFlex23

Bump

ajskateboarder

NFlex23 wrote:
Steve0Greatness wrote:
My guess is that it's the total amount of favorites/loves your projects have gotten. I'll do a bit of data collection.

Edit: From adding up the loves on all my projects, I think I'm correct in my assumption.
That makes sense, but why does ScratchStats have completely different numbers? I suppose it might just be out of date.

I think ScratchStats uses an indexer of some kind to index a project, either ScratchDB or something custom. Maybe the indexer only saved the views/loves/faves at a certain point and didn't update afterward? Just a guess

NFlex23

ajskateboarder wrote:
NFlex23 wrote:
Steve0Greatness wrote:
My guess is that it's the total amount of favorites/loves your projects have gotten. I'll do a bit of data collection.

Edit: From adding up the loves on all my projects, I think I'm correct in my assumption.
That makes sense, but why does ScratchStats have completely different numbers? I suppose it might just be out of date.

I think ScratchStats uses an indexer of some kind to index a project, either ScratchDB or something custom. Maybe the indexer only saved the views/loves/faves at a certain point and didn't update afterward? Just a guess

Another great theory! I think you may be right.

meunspeakable

NFlex23 wrote:
(#12)
ajskateboarder wrote:
NFlex23 wrote:
Steve0Greatness wrote:
My guess is that it's the total amount of favorites/loves your projects have gotten. I'll do a bit of data collection.

Edit: From adding up the loves on all my projects, I think I'm correct in my assumption.
That makes sense, but why does ScratchStats have completely different numbers? I suppose it might just be out of date.

I think ScratchStats uses an indexer of some kind to index a project, either ScratchDB or something custom. Maybe the indexer only saved the views/loves/faves at a certain point and didn't update afterward? Just a guess
Another great theory! I think you may be right.

It uses scratch db. I fetch my forum post count with scratch db and it takes a little while to update.

Discuss Scratch