Khoros Atlas Logo

%3CLINGO-SUB%20id%3D%22lingo-sub-270102%22%20slang%3D%22en-US%22%3EHow%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270102%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20for%20the%20most%20straightforward%20way%20to%20measure%20Weekly%20Active%20Users%20(WAU)%20and%20Monthly%20Active%20Users%20(MAU).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20criteria%20for%20'active'%20is%20posted%26nbsp%3Ba%20member%20who%20has%20logged%20in%20and%20submitted%20%E2%89%A5%201%20posts%20within%20the%20last%207%20or%2030%20days.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI'm%20figuring%20this%20out%20using%20User%20Exports%20both%20from%20Community%20Admin%20and%20Lithium%20Social%20Intelligence%20but%20it%20involves%20a%20lot%20filtering%20on%20my%20end%20with%20excel%20and%20then%20further%20sums.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ECan%20anyone%20recommend%20the%20most%20efficient%20(and%20of%20course)%20accurate%20way%20to%20do%20this%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-509651%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-509651%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%2C%20this%20helped%20me.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270457%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270457%22%20slang%3D%22en-US%22%3E%3CP%3EActive%20Members%20should%20be%20a%20standard%20metric%20in%20LSI.%20If%20you%20agree%2C%20vote%20with%20your%20clicks%20and%20comments%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2FProduct-Ideas%2FAdd-Active-Members-Metric-to-LSI%2Fidi-p%2F213082%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcommunity.lithium.com%2Ft5%2FProduct-Ideas%2FAdd-Active-Members-Metric-to-LSI%2Fidi-p%2F213082%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20has%20been%20thoroughly%20illustrated%20in%20this%20thread%2C%20getting%20at%20the%20metric%20today%20is%20painful.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61567%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40MattDe%3C%2FA%3E's%20solution%20is%20awesome%20because%20it%20doesn't%20require%20any%20repetitive%20tasks%20like%20exporting%20of%20files%20or%20manual%20Excel%20work.%20We're%20happy%20to%20build%20these%20and%20share%20as%20we%20go.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270398%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270398%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61019%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40roisinkirby%3C%2FA%3E!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20took%20the%20route%20of%20using%20the%20Lithium%20API%20so%20we%20wouldn't%20have%20to%20make%20exports%20repetitively%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20331px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42657iCF437AF46336EEC3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20srcset%3D%22%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42657iCF437AF46336EEC3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%201.0x%22%20alt%3D%22Interface.png%22%20title%3D%22Interface.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20600px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42658i46D82D7F657A370D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20srcset%3D%22%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42658i46D82D7F657A370D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%201.0x%22%20alt%3D%22View%202.png%22%20title%3D%22View%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3BWe%20automated%20the%20requests%20with%20a%20macro%20in%20our%20software%2C%20Alteryx%2C%20that%20fires%20off%20an%20authentication%20request%20with%20the%20provided%20credentials%20(%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2FSingle-Sign-On-SSO%2FAuthenticating-via-REST-API-non-SSO%2Fta-p%2F61862%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ev1%20API%2C%20non-SSO%3C%2FA%3E)%20and%20uses%20the%20Community%20URL%20and%20Board%20ID%20to%20create%20the%20%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2FDeveloper-Documentation%2Fbd-p%2Fdev-doc-portal%3Fsection%3Dcommv1%26amp%3Bleaf-id%3DBoard.threads%23Board.threads%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Erequest%3C%2FA%3E%20to%20query%20a%20given%20board.%20We%20did%20a%20little%20parsing%20of%20the%20response%20and%20added%20a%20filter%20to%20the%20date%20specified%20in%20the%20interface.%20You%E2%80%99re%20welcome%20to%20use%20the%20tool%20if%20you%20like!%20It%20looks%20like%20the%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20600px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42660i245F2AECBE05DFE7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20srcset%3D%22%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42660i245F2AECBE05DFE7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%201.0x%22%20alt%3D%22Active%20Users.png%22%20title%3D%22Active%20Users.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EYou%E2%80%99d%20need%20a%20%3CA%20href%3D%22http%3A%2F%2Fanalytics.alteryx.com%2Falteryx%3Futm_source%3Dgoogle%26amp%3Blsm%3Dgoogle%26amp%3Butm_medium%3Dcpc%26amp%3Butm_campaign%3DDemgen%2520Mixed%2520-%2520Brand_New%26amp%3Butm_content%3DTrial%26amp%3Butm_term%3Dalteryx%2520free%2520trial%26amp%3Butm_adid%3D164950511248%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Etrial%20license%3C%2FA%3E%20to%20run%20%3CA%20href%3D%22https%3A%2F%2Fwww.dropbox.com%2Fs%2Fjsyx9j3os4pq7l6%2FActive%2520Users.yxzp%3Fdl%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ethe%20maco%3C%2FA%3E%2C%20but%20it%20should%20bring%20down%20all%20the%20data%20you%20were%20looking%20for%20and%20save%20you%20some%20clicks%20in%20the%20process!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20of%20luck%2C%3C%2FP%3E%3CP%3EMattDe%3C%2FP%3E%3CBR%20%2F%3E%3CIMG%20src%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42661iC39E137B6BE82DAF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D600%22%20border%3D%220%22%20alt%3D%22Active%20Users.png%22%20title%3D%22Active%20Users.png%22%20%2F%3E%3CIMG%20src%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42662i5A4017C8D43D4246%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D600%22%20border%3D%220%22%20alt%3D%22View%201.png%22%20title%3D%22View%201.png%22%20%2F%3E%3CIMG%20src%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42663i70AD1D1A529377C2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D600%22%20border%3D%220%22%20alt%3D%22View%202.png%22%20title%3D%22View%202.png%22%20%2F%3E%3CIMG%20src%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42664i2483DBEBC71FE4FB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D600%22%20border%3D%220%22%20alt%3D%22View%203.png%22%20title%3D%22View%203.png%22%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270379%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270379%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F33381%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40DanK%3C%2FA%3E%2C%20I%20agree.%20Depending%20on%20the%20size%20of%20the%20community%20and%20the%20particular%20query%20you%20are%20running%2C%20that%20can%20be%20a%20limitation.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270372%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270372%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61019%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40roisinkirby%3C%2FA%3E%26nbsp%3BAdmin%20metrics%20are%20a%20bit%20finickity%2C%20if%20you%20use%20the%20%3CSPAN%3E%3CSTRONG%3EUser%20Report%20Filters%3C%2FSTRONG%3E%26nbsp%3B%3C%2FSPAN%3Efilters%20first%20and%20press%20search%20it%20narrows%20the%20data%20to%20users%20that%20meet%20those%20criteria.%20Once%20you%20have%20done%20that%20set%20the%26nbsp%3BActivity%20date%20range%20and%20search%20again%20on%20those%20search%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EFor%20some%20reason%20if%20you%20use%20the%26nbsp%3BActivity%20date%20range%20filter%20first%20it%20never%20properly%20filters%20out%20based%20on%20the%20lower%20options.%20I%20find%20that%20if%20you%20filter%20the%20data%20first%20and%20only%20after%20that%20is%20done%20put%20a%20date%20range%20on%20it%20works%20fine.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHope%20that%20makes%20sense%20%3CIMG%20class%3D%22emoticon%20emoticon-smileyvery-happy%22%20id%3D%22smileyvery-happy%22%20src%3D%22https%3A%2F%2Flithosphere.lithium.com%2Fi%2Fsmilies%2F16x16_smiley-very-happy.png%22%20alt%3D%22Smiley%20Very%20Happy%22%20title%3D%22Smiley%20Very%20Happy%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40RobbL%3C%2FA%3E%26nbsp%3BI%20agree%20for%20the%20most%20part%2C%20LSI%20is%20very%20useful%20for%20insights%20and%20as%20a%20bonus%20you%20can%20schedule%20reports.%20However%2C%20some%20of%20the%20reports%20have%20result%20limits.%20Getting%20member%20reports%20from%20the%20Content%20tab%20for%20example%20only%20returns%202000%20results.%20If%20I%20were%20to%20want%20to%20obtain%20a%20list%20of%20active%20users%20over%20the%20period%20of%20a%20month%20this%20would%20be%20insufficient%20to%20the%20task.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270350%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270350%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61019%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40roisinkirby%3C%2FA%3E.%20Yes%20that%20is%20how%20the%20Activity%20Date%20Range%20works.%20It%20is%20not%20a%20filter.%20It%20does%20not%20limit%20the%20result%20set.%20That%20is%20why%20it%20is%20set%20off%20from%20the%20filters%20which%20are%20listed%20in%20a%20set%20below%20the%20line.%20But%20if%20you%20compare%20results%20with%20and%20without%20engaging%20the%20date%20range%2C%20you%20will%20notice%20that%20without%20it%2C%20the%20number%20of%20posts%20listed%20for%20many%20users%20will%20be%20higher.%20With%20it%20engaged%2C%20it%20shows%20the%20number%20of%20posts%20per%20person%2C%20during%20the%20selected%20time%20range.%20By%20using%20the%20CSV%20export%20and%20bringing%20it%20in%20to%20Excel%2C%20you%20can%20then%20sort%20on%20posts%20so%20you%20group%20the%20people%20who%20posted%20more%20than%20zero%20times%20during%20that%20time%20range%20and%20just%20focus%20on%20them.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3374%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40Wendy_S%3C%2FA%3E%2C%20while%20there%20are%20relatively%20few%20times%20when%20I%20use%20Admin%20Metrics%20instead%20of%20LSI%20these%20days%2C%20User%20Reports%20remains%20the%20exception%2C%20as%20there%20is%20user%20information%20available%20that%20is%20just%20not%20available%20in%20LSI%20unless%20you%20are%20using%20the%20Bulk%20Data%20Export.%20%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61019%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40roisinkirby%3C%2FA%3E%20I%20would%20definitely%20recommend%20that%20you%20experiment%20with%20LSI%20rather%20than%20Admin%20Metrics.%20I%20think%20you%20will%20find%20that%20it%20provides%20a%20wealth%20of%20valuable%20information%20about%20your%20community.%20Just%20note%20that%20every%20metric%20is%20bounded%20by%20the%20date%20range%20set%20at%20the%20top%20of%20the%20page%2C%20which%20defaults%20to%20the%20most%20recent%2030%20days%2C%20but%20which%20you%20can%20extend%20to%20any%20six%20month%20period.%20One%20advantage%20of%20LSI%2C%20among%20many%2C%20is%20that%20every%20%22views%22%20metric%20follows%20current%20industry%20standards%20for%20calculation.%20Unlike%20Admin%20Metrics%20%22views%2C%22%20LSI%20does%20not%20include%20crawlers%2C%20api%20calls%20or%20RSS%20feeds.%20Also%2C%20the%20ratios%20listed%20and%20the%20filters%2C%20provide%20many%20ways%20to%20look%20at%20your%20data%20that%20we%20have%20found%20relevant%20to%20communities.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270289%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270289%22%20slang%3D%22en-US%22%3EIt's%20something%20I%22m%20in%20the%20process%20of%20figuring%20out%20%2Festablishing.Would%20you%20have%20any%20insight%20as%20to%20the%20industry%20norm%20for%20Support%20Communities%3FIf%20we%20set%20a%20goal%20for%20WAU%20(where%20a%20WAU%20is%20just%20posting)%20then%20that%20could%20drive%20incident%20rates.So%20I%20agree%20there%20should%20be%20other%20factors%20to%20consider.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270281%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270281%22%20slang%3D%22en-US%22%3EIs%20this%20because%20they'll%20be%20sunsetting%20these%20tools%3F%20This%20is%20news%20to%20me%2C%20justfinished%20onboarding%20with%20Lithium%20and%20had%20hoped%20to%20use%20Admin%20Metrics%20indepth.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270279%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270279%22%20slang%3D%22en-US%22%3EOh%20gosh%2C%20I%20have%20had%20that%20problem%20for%20a%20long%20time%20also.%20Never%20cared%20to%20report%20it.Also%20because%20the%20response%20from%20Lithium%20is%20usually%20that%20LSI%20should%20be%20used%20as%20the%20primary%20source%20for%20pulling%20data%20since%20engineering%20is%20no%20longer%20fixing%20bugs%20in%20Admin%20Metrics.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270269%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270269%22%20slang%3D%22en-US%22%3EThank%20all!%20%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40RobbL%3C%2FA%3E%20the%20only%20issue%20I'm%20finding%20in%20Community%20Admin%20%26gt%3B%20User%20Reports%20is%20that%20the%20'Number%20of%20Posts'%20filter%20is%20not%20working.%3CBR%20%2F%3E%3CBR%20%2F%3ENo%20matter%20what%20numbers%20I%20put%20in%2C%20e.g.%201%20-10000%20the%20report%20pulls%20in%20contacts%20with%200%20posts%20for%20the%20Activity%20Period%20set.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20this%20working%20as%20designed%3F%20I%20can%20provide%20screenshots%20if%20that%20helps%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270222%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270222%22%20slang%3D%22en-US%22%3EHave%20you%20considered%20including%20other%20measures%20in%20the%20definition%20of%20active%3F%20We%20typically%20define%20a%20user%20as%20active%20if%20they%20have%20started%20a%20thread%2C%20replied%20to%20an%20existing%20thread%2C%20given%20a%20kudo%20or%20marked%20a%20solution.%20The%20fact%20they%20have%20logged%20in%20to%20take%20these%20last%20two%20actions%2C%20although%20not%20overt%20for%20other%20users%20is%20still%20a%20user%20showing%20they%20are%20actively%20participating.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270199%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270199%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61019%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40roisinkirby%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20I%20do%20this%20with%20user%20reports.%20Quick%20and%20easy.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJason%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270180%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20measure%20Weekly%20%2F%20Monthly%20Active%20Users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270180%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20the%20best%20way%20to%20do%20this%20is%20through%20User%20Reports%20in%20Admin%20Metrics.%20Click%20Community%20Admin%2C%20Metrics%2C%20User%20Reports%20subtab.%20Use%20the%20Activity%20Date%20Range%20to%20specify%20the%20range%20you%20want%20for%20the%20report.%20Also%2C%20enter%201%20for%20number%20of%20posts%20lower%20number%2C%20and%20a%20high%20number%20for%20the%20top%20of%20the%20range.%20Just%20put%20in%20more%20than%20anyone%20will%20do.%20What%20is%20confusing%20with%20this%20report%20is%20that%20the%20Activity%20Date%20Range%20will%20not%20restrict%20the%20number%20of%20records.%20You%20will%20still%20get%20everyone.%20But%20the%20number%20of%20posts%20will%20be%20restricted%20to%20the%20number%20created%20during%20the%20Activity%20Range%20you%20specify.%20Export%20to%20CSV%2C%20bring%20it%20into%20Excel%20and%20sort%20on%20number%20of%20posts.%20Depending%20on%20the%20number%20of%20registered%20users%20in%20your%20community%20this%20can%20work%20well.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20issue%20with%20LSI%20in%20this%20case%2C%20is%20that%20we%20break%20out%20Conversations%20Initiated%20and%20Replies%20and%20don't%20have%20a%20single%20Posts%20metric%20for%20Members.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20this%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Lithium Alumni (Retired) Lithium Alumni (Retired)
Lithium Alumni (Retired)

Re: How do you measure Weekly / Monthly Active Users?

Jump to solution

Yes, @DanK, I agree. Depending on the size of the community and the particular query you are running, that can be a limitation.



If my post answers your question, please mark it as an "Accepted Solution."
0 Kudos
Reply
Loading...
Highlighted
Occasional Advisor
Occasional Advisor

Re: How do you measure Weekly / Monthly Active Users?

Jump to solution

Hey @roisinkirby!

 

We took the route of using the Lithium API so we wouldn't have to make exports repetitively:

 

Interface.png

 

 View 2.png

 

  We automated the requests with a macro in our software, Alteryx, that fires off an authentication request with the provided credentials (v1 API, non-SSO) and uses the Community URL and Board ID to create the request to query a given board. We did a little parsing of the response and added a filter to the date specified in the interface. You’re welcome to use the tool if you like! It looks like the below:

 

 Active Users.png

  

You’d need a trial license to run the maco, but it should bring down all the data you were looking for and save you some clicks in the process!

 

Best of luck,

MattDe


Active Users.pngView 1.pngView 2.pngView 3.png
Reply
Loading...
Highlighted

Re: How do you measure Weekly / Monthly Active Users?

Jump to solution

Active Members should be a standard metric in LSI. If you agree, vote with your clicks and comments: https://community.lithium.com/t5/Product-Ideas/Add-Active-Members-Metric-to-LSI/idi-p/213082

 

As has been thoroughly illustrated in this thread, getting at the metric today is painful. @MattDe's solution is awesome because it doesn't require any repetitive tasks like exporting of files or manual Excel work. We're happy to build these and share as we go.

Reply
Loading...
Highlighted

Re: How do you measure Weekly / Monthly Active Users?

Jump to solution

thank you, this helped me. 

0 Kudos
Reply
Loading...