Yes, it include all users who have used activated their user account in some way after 2015-01-01 00:00:00.
Merely reading pages while logged-in usually will not trigger such "touch". Logging in, changing preferences, and other actions do set the touch timestamp however. Remember that user sessions don't last forever. Currently, Wikimedia wikis have a session expiration of 30 days. This means users visiting frequently will still "log in" at least once 30 days if they want to remain logged-in while visiting. As included below, I also ran the same query for users active since 2015-03-01. This helps to get a sense of the drop off (or "comeback"). — Timo > On 29 Jun 2015, at 22:19, Jon Robson <[email protected]> wrote: > > Timo - so to clarify these are users who have logged in since 2015-01-01 ? > > It is possible to get a sense of whether they come back? > e.g. What if someone registered on 2015-01-01, switched to Monobook > and never came back - are they included? > > > On Mon, Jun 29, 2015 at 2:10 PM, Timo Tijhof <[email protected]> wrote: >> I specified that in the original mail but I guess that got lost: >> >> "Active" here relates to the MediaWiki user_touched database field. This is >> set whenever the user logs in, as well as after various other actions that >> users can perform. >> >> >> >> — Timo >> >> On 29 Jun 2015, at 21:47, Adam Baso <[email protected]> wrote: >> >> Timo, would you please clarify on the definition of "active"? >> >> On Mon, Jun 29, 2015 at 11:30 AM, Jon Robson <[email protected]> wrote: >>> >>> Can you clarify what "active" means? >>> Does that mean users visiting the page on a daily basis or does it relate >>> to editors or something else? >>> >>> I'm keen to understand if some of these accounts are dormant and unused or >>> are frequently logged into. >>> >>> On 29 Jun 2015 11:16 am, "Adam Baso" <[email protected]> wrote: >>>> >>>> Hi, >>>> >>>> I think it was Joaquin, Sam, and Bryan with whom I discussed relative >>>> skins usage on some popular skins, in the context of which skins Reading is >>>> on the hook for in the sense of full maintenance or high priority fixes >>>> (even if only coordinating) when issues arise. Here's that data, based on >>>> some queries Timo ran recently (thanks, Timo!). >>>> >>>> * en.wikipedia.org, users active since 2015-01-01, skin=cologneblue: 7k >>>> users. >>>> * en.wikipedia.org, users active since 2015-01-01, skin=monobook: 193k >>>> users. >>>> * en.wikipedia.org, users active since 2015-01-01: 3.1m users. >>>> >>>> * en.wikipedia.org, users active since 2015-03-01, skin=cologneblue: 6k >>>> users. >>>> * en.wikipedia.org, users active since 2015-03-01, skin=monobook: 179k >>>> users. >>>> * en.wikipedia.org, users active since 2015-03-01: 2.3m users. >>>> >>>> * commons.wikimedia.org, users active since 2015-03-01, skin=cologneblue: >>>> 1k users. >>>> * commons.wikimedia.org, users active since 2015-03-01, skin=monobook: >>>> 59k users. >>>> * commons.wikimedia.org, users active since 2015-03-01: 687k users. >>>> >>>> -Adam >>>> >>>> _______________________________________________ >>>> Mobile-l mailing list >>>> [email protected] >>>> https://lists.wikimedia.org/mailman/listinfo/mobile-l >>>> >> >> >> >> _______________________________________________ >> Mobile-l mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/mobile-l >> > > > > -- > Jon Robson > * http://jonrobson.me.uk > * https://www.facebook.com/jonrobson > * @rakugojon _______________________________________________ Mobile-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mobile-l
