Khoros Atlas Logo

%3CLINGO-SUB%20id%3D%22lingo-sub-515556%22%20slang%3D%22en-US%22%3ENumber%20of%20members%20that%20have%20logged%20in%20within%206%20months%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-515556%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20view%20the%20members%20that%20have%20logged%20in%20over%20the%20past%206%20months%20only.%20I'd%20like%20to%20measure%20how%20active%20my%20community%20is%20in%20terms%20of%20the%20members%20that%20have%20signed%20in%2Flogged%20in%20within%20the%20last%206%20months.%20Anyone%20outside%20of%20that%20I%20am%20calling%20inactive.%20I've%20looked%20in%20Community%20admin%20under%20user%20reports%20and%20can%20see%20sign%20ins%26nbsp%3Bbut%20I%20think%20this%20is%20total%20sign-ins%20and%20not%20unique%20to%20a%20member%20i.e.%20if%20I%20sign%20in%20as%20a%20member%20500%20times%20in%206%20months%20then%20the%20figure%20shows%20each%20of%20my%20sign-ins%20and%20counts%20that%20instead%20of%20counting%20me%20as%201%20which%20is%20what%20I%20need%20to%20see.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20how%20i%20can%20get%20a%20list%20of%20the%20members%20that%20have%20signed%20in%20for%20the%20last%206%20months%20only%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-516120%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20of%20members%20that%20have%20logged%20in%20within%206%20months%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-516120%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20I%20do%2C%20almost%20similar%20to%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53294%22%20target%3D%22_blank%22%3E%40Payal%3C%2FA%3E%2C%26nbsp%3Bas%20I'm%20also%20interested%20in%20what%20the%20user%20does%3A%20%26nbsp%3BI%20use%20the%20%22activity%20date%20range%22%20e.g.%206%20month%20and%20than%20I%20select%20the%20columns%3A%26nbsp%3B%3C%2FP%3E%3CP%3E-%20registration%20date%3C%2FP%3E%3CP%3E-%20most%20recent%20signin%3C%2FP%3E%3CP%3E-%20Total%20Post%20read%3C%2FP%3E%3CP%3E-%20Number%20of%20posts%3C%2FP%3E%3CP%3E-%20Amount%20of%20read%20posts%3C%2FP%3E%3CP%3E-%20minutes%20online%26nbsp%3B%3C%2FP%3E%3CP%3E-%20kudos%20given%3C%2FP%3E%3CP%3E-%20Net%20Forum%20Topics%3C%2FP%3E%3CP%3E-%20username%3C%2FP%3E%3CP%3E-%20rank%3C%2FP%3E%3CP%3EWith%20this%20I%20have%20list%20of%20all%20User%20that%20where%20%22active%22%20within%20this%20period%20and%20I%20can%20see%20what%20they%20did.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20%26nbsp%3Balso%20use%20the%20%22registration%20date%22%20selector%20to%20build%20cohorts%20to%20show%20me%20if%20users%20are%20still%20active%20in%20month%201%2F2%2F3%2Fx%20after%20registration.%3C%2FP%3E%3CP%3EBest%26nbsp%3B%3C%2FP%3E%3CP%3EJan%3C%2FP%3E%3CP%3Ep.s.%20what%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53294%22%20target%3D%22_blank%22%3E%40Payal%3C%2FA%3E%26nbsp%3Bdescribed%20also%20works%20correct%20(tested%20it%20with%202%20different%20communities)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-515566%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20of%20members%20that%20have%20logged%20in%20within%206%20months%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-515566%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72978%22%20target%3D%22_blank%22%3E%40Rachie1986%3C%2FA%3E%26nbsp%3B-%20Actually%2C%20it%20is%20working%20correctly%20in%20both%20ways%20with%20the%20time%20range%20and%20without%20time%20range%20for%20me.%20Could%20you%20please%20share%20your%20SS%20if%20possible%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-515565%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20of%20members%20that%20have%20logged%20in%20within%206%20months%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-515565%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20that.%20When%20I%20do%20that%2C%20despite%20setting%20my%20date%20range%20I'm%20seeing%20last%20sign%20in%20date%20from%20a%20time%20before%20my%20date%20range%20which%26nbsp%3Bis%20really%20odd%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-515564%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20of%20members%20that%20have%20logged%20in%20within%206%20months%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-515564%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72978%22%20target%3D%22_blank%22%3E%40Rachie1986%3C%2FA%3E%26nbsp%3B-%20As%20per%20my%20knowledge%2C%20there%20is%20no%20direct%20way%20to%20find%20a%20unique%20number%20for%20sign-ins.%20But%20if%20you%20go%20to%20Admin%20-%26gt%3B%20Metrics%20-%26gt%3B%20User%20Reports%2C%20and%20enter%20the%20most%20recent%20sign-in%20period%20as%20per%20your%20requirement%2C%20click%20on%20search.%20Here%20you%20will%20find%20the%20list%20of%20unique%20users.%3C%2FP%3E%3CP%3ESS%20for%20reference%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F151326iA774A8F11AB72667%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20srcset%3D%22%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F151326iA774A8F11AB72667%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%201.0x%22%20alt%3D%22screenshot-community.myzap.com-2019.03.04-15-59-09.png%22%20title%3D%22screenshot-community.myzap.com-2019.03.04-15-59-09.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Advisor
Frequent Advisor

Number of members that have logged in within 6 months

I need to view the members that have logged in over the past 6 months only. I'd like to measure how active my community is in terms of the members that have signed in/logged in within the last 6 months. Anyone outside of that I am calling inactive. I've looked in Community admin under user reports and can see sign ins but I think this is total sign-ins and not unique to a member i.e. if I sign in as a member 500 times in 6 months then the figure shows each of my sign-ins and counts that instead of counting me as 1 which is what I need to see.

 

Any ideas how i can get a list of the members that have signed in for the last 6 months only?

Tags (2)
0 Kudos
4 Replies 4
Highlighted
Honored Contributor
Honored Contributor

Re: Number of members that have logged in within 6 months

@Rachie1986 - As per my knowledge, there is no direct way to find a unique number for sign-ins. But if you go to Admin -> Metrics -> User Reports, and enter the most recent sign-in period as per your requirement, click on search. Here you will find the list of unique users.

SS for reference:

screenshot-community.myzap.com-2019.03.04-15-59-09.png

Thanks!

 

Reply
Loading...
Highlighted
Frequent Advisor
Frequent Advisor

Re: Number of members that have logged in within 6 months

Thanks for that. When I do that, despite setting my date range I'm seeing last sign in date from a time before my date range which is really odd

0 Kudos
Reply
Loading...
Highlighted
Honored Contributor
Honored Contributor

Re: Number of members that have logged in within 6 months

@Rachie1986 - Actually, it is working correctly in both ways with the time range and without time range for me. Could you please share your SS if possible? 

0 Kudos
Reply
Loading...
Highlighted
Trusted Contributor
Trusted Contributor

Re: Number of members that have logged in within 6 months

What I do, almost similar to @Payal, as I'm also interested in what the user does:  I use the "activity date range" e.g. 6 month and than I select the columns: 

- registration date

- most recent signin

- Total Post read

- Number of posts

- Amount of read posts

- minutes online 

- kudos given

- Net Forum Topics

- username

- rank

With this I have list of all User that where "active" within this period and I can see what they did. 

I  also use the "registration date" selector to build cohorts to show me if users are still active in month 1/2/3/x after registration.

Best 

Jan

p.s. what @Payal described also works correct (tested it with 2 different communities) 

 


0 Kudos
Reply
Loading...