It's that time of the month again!!

%3CLINGO-SUB%20id%3D%22lingo-sub-816257%22%20slang%3D%22en-US%22%3EIt's%20that%20time%20of%20the%20month%20again!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816257%22%20slang%3D%22en-US%22%3EEvery%20month%20our%20community%20managers%20run%20a%20'group%20audit'%20basically%20it's%20where%20we%20reach%20out%20to%20group%20admins%20who%20have%20inactive%20groups%20(no%20unique%20posts%20for%2030%20days%20or%20more)%20invite%20them%20to%20training%20%2C%20workshops%2C%20etc%20or%20ask%20them%20if%20they%20still%20have%20a%20need%20for%20the%20group.%20The%20idea%20is%20that%20we%20delete%20old%20groups%20that%20no%20longer%20serve%20a%20purpose%20and%20improve%20those%20that%20have%20legs%20but%20need%20a%20little%20bit%20of%20love.%20Problem%3A%20We%20have%20almost%201%2C000%20groups%2C%20of%20which%20380%20fall%20into%20the%20inactive%20status%2C%20we%20need%20to%20contact%20all%20group%20admins%20of%20these%20groups%2C%20but%20there%20is%20no%20way%20to%20export%20a%20list%20from%20Yammer%2C%20or%20any%20other%20analytics%20tool%20we%20know%20of%2C%20which%20includes%20group%20name%20AND%20group%20admin%20name%20-%20nothing.%20Our%20only%20option%20at%20this%20stage%20is%20to%20manually%20look%20up%20every%20single%20group%20individually%20to%20identify%20the%20group%20admin%20and%20manually%20add%20it%20to%20our%20list%20of%201%2C000%2B%20groups.%20%23facepalm.%20Does%20anyone%20else%20face%20this%20problem%2C%20does%20anyone%20have%20a%20better%20way%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-816257%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%20Management%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-816273%22%20slang%3D%22en-US%22%3ERe%3A%20It's%20that%20time%20of%20the%20month%20again!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816273%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F240983%22%20target%3D%22_blank%22%3E%40Ryan%20Crocker%3C%2FA%3EI%20do%20this%20manually%20as%20well%2C%20but%20only%20about%20once%20or%20twice%20a%20year.%20Also%20interested%20in%20alternate%20solutions%20as%20it%20is%20very%20labour%20intensive.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-820245%22%20slang%3D%22en-US%22%3ERe%3A%20It's%20that%20time%20of%20the%20month%20again!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-820245%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F240983%22%20target%3D%22_blank%22%3E%40Ryan%20Crocker%3C%2FA%3EAssuming%20that%20the%20majority%20of%20those%20inactive%20groups%20stay%20inactive%20and%20then%20are%20deleted%2C%20shouldn't%20that%20number%20of%201000%20go%20down%20substantially%20over%20time%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-822127%22%20slang%3D%22en-US%22%3ERe%3A%20It's%20that%20time%20of%20the%20month%20again!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-822127%22%20slang%3D%22en-US%22%3EYes!%20Absolutely%20-%20we%20are%20newly%20launched%2C%20not%20even%2012months%20in%20yet%20so%20there%20has%20been%20a%20lot%20of%20initial%20excitement%20and%20a%20flurry%20of%20group%20creation%20which%20we%20have%20now%20seen%20slow%20down...%3C%2FLINGO-BODY%3E
Occasional Contributor
Every month our community managers run a 'group audit' basically it's where we reach out to group admins who have inactive groups (no unique posts for 30 days or more) invite them to training , workshops, etc or ask them if they still have a need for the group. The idea is that we delete old groups that no longer serve a purpose and improve those that have legs but need a little bit of love. Problem: We have almost 1,000 groups, of which 380 fall into the inactive status, we need to contact all group admins of these groups, but there is no way to export a list from Yammer, or any other analytics tool we know of, which includes group name AND group admin name - nothing. Our only option at this stage is to manually look up every single group individually to identify the group admin and manually add it to our list of 1,000+ groups. #facepalm. Does anyone else face this problem, does anyone have a better way?
3 Replies
Highlighted

@Ryan CrockerI do this manually as well, but only about once or twice a year. Also interested in alternate solutions as it is very labour intensive. 

Highlighted

@Ryan Crocker Assuming that the majority of those inactive groups stay inactive and then are deleted, shouldn't that number of 1000 go down substantially over time?

Highlighted
Yes! Absolutely - we are newly launched, not even 12months in yet so there has been a lot of initial excitement and a flurry of group creation which we have now seen slow down...