Yammer's data export

%3CLINGO-SUB%20id%3D%22lingo-sub-10837%22%20slang%3D%22en-US%22%3EYammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-10837%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Yammeners%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20part%20of%20the%20Yammer%20dashboard%20is%20now%20included%20to%20the%20O365%20admin%2C%20are%20the%20data%20in%20the%20export%20still%20correct%20%3F%3C%2FP%3E%3CP%3E!!)Additionnally%2C%20any%20advices%20about%20a%20specific%20(and%20complete%20!!)%20tool%20for%20statistics%20(primary%20network%20and%20external%20...)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-10837%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECommunity%20Management%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EYammer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-81104%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-81104%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20Tom%20and%20Victor%2C%20that%20is%20really%20helpful!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-80325%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-80325%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20want%20to%20know%20who%20exactly%20is%20following%20who%2C%20you%20can%20use%20Tom's%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you're%20attempting%20to%20recreate%20some%20of%20TyGraphs%20or%20Swoops%20ones%20where%20they%20show%20who%20has%20the%20most%20followers%20or%20is%20following%20the%20most%20people%2C%20I%20use%20the%20second%20one%20Tom%20mentioned...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.yammer.com%2Fapi%2Fv1%2Fusers.json%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.yammer.com%2Fapi%2Fv1%2Fusers.json%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20this%20all%20in%20powershell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20loop%20Until%20(Until%20%24object.count%20-lt%2050)%3C%2FP%3E%3CP%3EHit%20the%20API%3C%2FP%3E%3CP%3EAdd%20object%20to%20master%20object%3C%2FP%3E%3CP%3EPaginate%20through%20with%20a%20loop%20until%20the%20object%20returned%20has%20less%20than%2050%20users.%3C%2FP%3E%3CP%3Eexport-csv%20with%20-notype%20flag.%3C%2FP%3E%3CP%3EUtilize%20that%20in%20any%20presentation%20on%20Tableau.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20also%20do%20likes%20through%20this%20sort%20of%20method%20too%2C%20but%20to%20date%20stamp%20them%20requires%20some%20more%20tricks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20dumb%20down%20version%20of%20the%20script%2C%20you'll%20have%20to%20add%20your%20own%20try%20catch%20and%20error%20handling%20as%20well%20as%20object%20handling.%20I%20know%20I%20missed%20some%20things%2C%20such%20as%20making%20sure%20to%20instantiate%20the%20master%20object%20first...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%24pagenum%20%3D%201%3C%2FP%3E%3CP%3EDo%3CBR%20%2F%3E%7B%3CBR%20%2F%3E%24usersURI%20%3D%20('%3CA%20href%3D%22https%3A%2F%2Fwww.yammer.com%2Fapi%2Fv1%2Fusers.json%3Fpage%3D'%2B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.yammer.com%2Fapi%2Fv1%2Fusers.json%3Fpage%3D'%2B%3C%2FA%3E%20%24pagenum)%3CBR%20%2F%3E%24file%20%3D%20(Invoke-WebRequest%20-uri%20%24usersURI%20-header%20%24headers%20-Method%20get%20%7C%20ConvertFrom-Json)%3CBR%20%2F%3E%24retrieved%20%3D%20%24file%20%7C%20select%20id%2C%20name%2C%20email%2C%20state%2C%20department%2C%20%40%7Bn%3D'followers'%3B%20e%3D%7B%20%24_.stats.followers%20%7D%7D%2C%20%40%7Bn%3D'following'%3B%20e%3D%7B%20%24_.stats.following%20%7D%7D%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%24pagenum%20%2B%3D%201%3C%2FP%3E%3CP%3E%24master%20%2B%3D%20retrieved%3C%2FP%3E%3CP%3E%7D%3C%2FP%3E%3CP%3EUntil%20(%24file.count%20-lt%2050)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-78239%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-78239%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20could%20probably%20use%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3Ehttps%3A%2F%2Fwww.yammer.com%2Fapi%2Fv1%2Fusers%2Ffollowed_by%2F%5B%3AUserID%5D.json%3Fpage%3D1%3C%2FPRE%3E%3CP%3Eand%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3Ehttps%3A%2F%2Fwww.yammer.com%2Fapi%2Fv1%2Fusers%2Ffollowing%2F%5B%3AUserID%5D.json%3Fpage%3D1%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20would%20do%20is%20use%20my%20data%20export%20to%20get%20a%20list%20of%20user%20IDs%2C%20and%20then%20use%20a%20for%20%2F%20each%20loop%20in%20PowerShell%20to%20go%20query%20for%20each%20user.%20%26nbsp%3BYou%20need%20to%20do%20a%20do%20%2F%20while%20loop%20%26nbsp%3Bor%20something%20similar%20to%20get%20all%20the%20pages.%20%26nbsp%3B(It%20only%20gives%20but%20so%20many%20at%20a%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20see%20how%20it%20works%2C%20try%20putting%20in%20your%20ID%2C%20and%20instead%20of%20.json%2C%20use%20.xml.%20%26nbsp%3B%20The%20first%2050%20people%20you%20follow%20or%20who%20are%20following%20you%20should%20be%20displayed.%20%26nbsp%3BThe%20script%20would%20have%20to%20go%20get%20for%20each%20page.%20%26nbsp%3BAnother%20way%20to%20get%20the%20pages%20is%20to%20query%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.yammer.com%2Fapi%2Fv1%2Fusers%2F%5B%3AUserID%5D.json%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.yammer.com%2Fapi%2Fv1%2Fusers%2F%5B%3AUserID%5D.json%3C%2FA%3E%20and%20read%20the%20total%20following%20and%20followers%20number%20from%20the%20stats%20section%2C%20and%20then%20divide%20by%2050%20and%20loop%20through%20that%20many%20times%20until%20all%20the%20pages%20are%20returned.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20it's%20not%20more%20complete%2C%20this%20just%20points%20in%20the%20direction%20to%20go.%20Does%20this%20help%20at%20all%3F%3C%2FP%3E%3CDIV%20class%3D%22wrapper%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-78037%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-78037%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Victor%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20of%20our%20project%20requirement%20is%20to%20get%20the%20no%20of%20followers%2F%20followed%20%2C%20could%20you%20please%20shed%20some%20light%20on%20how%20did%20you%20get%20this%20information%20also%20wher%20did%20you%20extract%20this%20information%20from%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EShantanu%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-31905%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-31905%22%20slang%3D%22en-US%22%3EFor%20me%20SWOOP%20or%20TyGraph%20is%20a%20'Form%20or%20Function'%20question.%20SWOOP%20is%20instantly%20visually%20accessible%20but%20it's%20form%20is%20relatively%20fixed.%20TyGraph%20is%20accessible%20(in%20a%20'it%20looks%20like%20Excel%20on%20steroids'%20kind%20of%20way)%20but%20it's%20strength%20lies%20in%20its%20malleability.%20So%20if%20your%20requirement%20is%20to%20slice%20and%20dice%20data%20your%20way%20then%20TyGraph%20is%20probably%20the%20tool%20for%20you.%20If%20visual%20accessibility%20is%20the%20key%20combined%20with%20unique%20takes%20on%20personas%20and%20collaboration%20then%20perhaps%20SWOOP%20is%20the%20tool%20for%20you.%20If%20your%20pockets%20are%20deep%20enough%20then%20consider%20both%20as%20they%20compliment%20each%20other.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-31233%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-31233%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20not%20sure%20if%20this%20answers%20your%20question%2C%20but%20piggy%20backing%20off%20of%20it%3A%20I%20just%20did%20a%20data%20export%20on%20the%20last%2030%20days%20within%20the%20yammer%20data%20extract%2C%20and%20O365%20data%20extract%20for%20Yammer%2C%20looking%20at%20active%20users.%20The%20numbers%20didn't%20match%20by%20about%20240%20users.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimilarly%2C%20the%20number%20of%20users%20listed%20as%20members%20in%20All%20Co.%20was%20different%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20the%20data%20exports%20measure%20active%20users%20differently%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-29690%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-29690%22%20slang%3D%22en-US%22%3E%3CP%3EI%20just%20learned%20powershell%20a%20few%20months%20ago%20(4%20or%20so)%20and%20I%20was%20able%20to%20make%20a%20solution%20using%20PowerShell%20and%20Tableau%20(You%20can%20swap%20Tableau%20with%20Power%20BI%20if%20you%20want)%20fairly%20easily......%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20honestly%20it%20provides%20a%20lot%20more%20than%20most%20of%20those%20solutions....%20and%20doesn't%20require%20you%20to%20send%20your%20data%20externally.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEdit%3A%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20really%20don't%20need%20powershell%20either%20if%20you%20aren't%20interested%20in%20likes...%20people's%20followers%2Ffollowed%20statistics....%20etc...%20just%20manipulating%20the%20messages.csv%20%2F%20users.csv%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-23472%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-23472%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20cost%20of%20the%20statistics%20plugins%20for%20Yammer%20seem%20VERY%20high.%20I%20wish%20there%20was%20an%20easier%20way%20to%20pull%20reports%20from%20Yammer.%20I%20hear%20if%20an%20admin%20has%20O365%20access%20more%20Yammer%20stats%20are%20in%20that%20dashboard.%20I%20do%20not%20have%20that%20access%20so%20cannot%20tell%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20you%20report%20on%20for%20your%20Yammer%20community%20to%20show%20growth%20or%20success%20and%20what%20tools%20do%20you%20use%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-15557%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-15557%22%20slang%3D%22en-US%22%3E%3CP%3EFair%20question.%20%26nbsp%3BI%20should%20clarify%20that%20I've%20only%20used%20tyGraph%20and%20have%20been%20very%20impressed%20with%20both%20the%20product%20and%20the%20support%20team.%20%26nbsp%3BI%20shouldn't%20have%20said%20%22I%20like%20it%20most%22%2C%20since%20I've%20only%20used%20the%20one%20product.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20like%20the%20approach%2C%20though%2C%20of%20open%20non-proprietary%20evaluation%20of%20the%20health%20and%20vitality%20of%20a%20network%20based%20on%20its%20activity.%20%26nbsp%3BWhen%20presenting%20the%20findings%20of%20an%20analytics%20tool%2C%20I%20like%20to%20be%20able%20to%20answer%20questions%20from%20the%20audience%20about%20the%20methodology%20of%20getting%20the%20results.%20%26nbsp%3BI%20also%20like%20the%20high-degree%20of%20customization%20available%20in%20the%20PowerBI-based%20report.%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-15436%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-15436%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Tom%20-%20can%20you%20elaborate%20as%20to%20your%20preference%20for%20tyGraph%20over%20Swoop%3F%20I'm%20yet%20to%20see%20tyGraphy%20but%20I%20really%20like%20the%20strong%20business%20lens%20that%20Swoop%20has%2C%20enabling%20insights%20to%20be%20accessed%20and%20understood%20easily%20across%20the%20organisation...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-11136%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-11136%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20data%20in%20the%20export%20is%20absolutely%20correct.%26nbsp%3B%20Every%20user%2C%20post%2C%20and%20group%20is%20recorded%20in%20that%20export.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20built-in%20Yammer%20analytics%20feature%20(%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fwww.yammer.com%2F%3CNETWORKNAME%3E%2Fanalytics%3C%2FNETWORKNAME%3E%3C%2FA%3E)%2C%20however%2C%20does%20not%20have%20reliable%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20many%20third%20party%20tools%20which%20will%20look%20at%20your%20network%20and%20give%20you%20phenomenal%20reports.%26nbsp%3B%20I%20like%20tyGraph%20the%20most%2C%20but%20there%20are%20others%20such%20as%20Swoop.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESpecific%20and%20complete%20tool%20-%20not%20sure%20what%20you%20mean%20there.%26nbsp%3B%20No%20software%20in%20the%20world%20is%20perfect.%26nbsp%3B%20(Though%20Notepad.exe%20comes%20close%2C%20in%20my%20opinion.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562863%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer's%20data%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562863%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20I%20am%20using%20the%20yammer%20export%20api%20to%20get%20yammer%20data%20from%20something%20like%203%2F4%20years%20back%20.%20%3CA%20href%3D%22https%3A%2F%2Fdeveloper.yammer.com%2Fdocs%2Fdata-export-api%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.yammer.com%2Fdocs%2Fdata-export-api%3C%2FA%3E%20%26nbsp%3B%26nbsp%3B%20I%20am%20finding%20I%20cannot%20export%20large%20chunks%20of%20data%20just%20using%20the%20%22since%22%20parameter.%20The%20%22until%22%20parameter%20does%20not%20work%20.%20Does%20anyone%20know%20how%20to%20get%20around%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fexport.yammer.com%2Fapi%2Fv1%2Fexport%3Fsince%3D2012-02-09T00%3A00%3A00%2B00%3A00%26amp%3Buntil%3D2012-03-10T00%3A00%3A00%2B00%3A00%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fexport.yammer.com%2Fapi%2Fv1%2Fexport%3Fsince%3D2012-02-09T00%3A00%3A00%2B00%3A00%26amp%3Buntil%3D2012-03-10T00%3A00%3A00%2B00%3A00%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Ethanks.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Yammeners,

 

As a part of the Yammer dashboard is now included to the O365 admin, are the data in the export still correct ?

!!)Additionnally, any advices about a specific (and complete !!) tool for statistics (primary network and external ...)

 

Thank you.

12 Replies

The data in the export is absolutely correct.  Every user, post, and group is recorded in that export.

 

The built-in Yammer analytics feature (https://www.yammer.com/<networkname>/analytics), however, does not have reliable data.

 

There are many third party tools which will look at your network and give you phenomenal reports.  I like tyGraph the most, but there are others such as Swoop.

 

Specific and complete tool - not sure what you mean there.  No software in the world is perfect.  (Though Notepad.exe comes close, in my opinion.)

 

 

Hi Tom - can you elaborate as to your preference for tyGraph over Swoop? I'm yet to see tyGraphy but I really like the strong business lens that Swoop has, enabling insights to be accessed and understood easily across the organisation...

Fair question.  I should clarify that I've only used tyGraph and have been very impressed with both the product and the support team.  I shouldn't have said "I like it most", since I've only used the one product. 

 

I like the approach, though, of open non-proprietary evaluation of the health and vitality of a network based on its activity.  When presenting the findings of an analytics tool, I like to be able to answer questions from the audience about the methodology of getting the results.  I also like the high-degree of customization available in the PowerBI-based report.   

The cost of the statistics plugins for Yammer seem VERY high. I wish there was an easier way to pull reports from Yammer. I hear if an admin has O365 access more Yammer stats are in that dashboard. I do not have that access so cannot tell :(

 

What do you report on for your Yammer community to show growth or success and what tools do you use?

I just learned powershell a few months ago (4 or so) and I was able to make a solution using PowerShell and Tableau (You can swap Tableau with Power BI if you want) fairly easily......

 

And honestly it provides a lot more than most of those solutions.... and doesn't require you to send your data externally.

 

Edit:

You really don't need powershell either if you aren't interested in likes... people's followers/followed statistics.... etc... just manipulating the messages.csv / users.csv

I'm not sure if this answers your question, but piggy backing off of it: I just did a data export on the last 30 days within the yammer data extract, and O365 data extract for Yammer, looking at active users. The numbers didn't match by about 240 users.

 

Similarly, the number of users listed as members in All Co. was different again.

 

Do the data exports measure active users differently? 

For me SWOOP or TyGraph is a 'Form or Function' question. SWOOP is instantly visually accessible but it's form is relatively fixed. TyGraph is accessible (in a 'it looks like Excel on steroids' kind of way) but it's strength lies in its malleability. So if your requirement is to slice and dice data your way then TyGraph is probably the tool for you. If visual accessibility is the key combined with unique takes on personas and collaboration then perhaps SWOOP is the tool for you. If your pockets are deep enough then consider both as they compliment each other.

Hi Victor,

 

One of our project requirement is to get the no of followers/ followed , could you please shed some light on how did you get this information also wher did you extract this information from?

 

Appreciate your help!

 

Thanks,

Shantanu

You could probably use

 

https://www.yammer.com/api/v1/users/followed_by/[:UserID].json?page=1

and

 

https://www.yammer.com/api/v1/users/following/[:UserID].json?page=1

 

What I would do is use my data export to get a list of user IDs, and then use a for / each loop in PowerShell to go query for each user.  You need to do a do / while loop  or something similar to get all the pages.  (It only gives but so many at a time.

 

To see how it works, try putting in your ID, and instead of .json, use .xml.   The first 50 people you follow or who are following you should be displayed.  The script would have to go get for each page.  Another way to get the pages is to query https://www.yammer.com/api/v1/users/[:UserID].json and read the total following and followers number from the stats section, and then divide by 50 and loop through that many times until all the pages are returned.

 

Sorry it's not more complete, this just points in the direction to go. Does this help at all?

 

If you want to know who exactly is following who, you can use Tom's solution.

 

If you're attempting to recreate some of TyGraphs or Swoops ones where they show who has the most followers or is following the most people, I use the second one Tom mentioned...

 

https://www.yammer.com/api/v1/users.json 

 

I do this all in powershell.

 

Do loop Until (Until $object.count -lt 50)

Hit the API

Add object to master object

Paginate through with a loop until the object returned has less than 50 users.

export-csv with -notype flag.

Utilize that in any presentation on Tableau.

 

You can also do likes through this sort of method too, but to date stamp them requires some more tricks.

 

Here's a dumb down version of the script, you'll have to add your own try catch and error handling as well as object handling. I know I missed some things, such as making sure to instantiate the master object first...

 

$pagenum = 1

Do
{
$usersURI = ('https://www.yammer.com/api/v1/users.json?page='+ $pagenum)
$file = (Invoke-WebRequest -uri $usersURI -header $headers -Method get | ConvertFrom-Json)
$retrieved = $file | select id, name, email, state, department, @{n='followers'; e={ $_.stats.followers }}, @{n='following'; e={ $_.stats.following }}


$pagenum += 1

$master += retrieved

}

Until ($file.count -lt 50)

Thank you Tom and Victor, that is really helpful!

 

Hi, I am using the yammer export api to get yammer data from something like 3/4 years back . https://developer.yammer.com/docs/data-export-api    I am finding I cannot export large chunks of data just using the "since" parameter. The "until" parameter does not work . Does anyone know how to get around this?

https://export.yammer.com/api/v1/export?since=2012-02-09T00:00:00+00:00&until=2012-03-10T00:00:00+00...

thanks.