cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-2041%22%20slang%3D%22en-US%22%3EGuest%20Post%3A%20Formulate%2C%20Predict%2C%20and%20Reformulate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2041%22%20slang%3D%22en-US%22%3E%3CP%3E%3CEM%3E%3CA%20title%3D%22GPS%20-%20Flight%20Speed%20Data%20by%20LaertesCTB%22%20href%3D%22http%3A%2F%2Fwww.flickr.com%2Fphotos%2Flaertes_za%2F2558688075%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CIMG%20style%3D%22margin%3A%2010px%3B%22%20src%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F77iC094135929CAB7BC%2Fimage-size%2Fsmall%3Fv%3Dmpbl-1%26amp%3Bpx%3D-1%22%20border%3D%220%22%20alt%3D%22GPS%20-%20Flight%20Speed%20Data.jpg%22%20title%3D%22GPS%20-%20Flight%20Speed%20Data.jpg%22%20align%3D%22right%22%20%2F%3E%3C%2FA%3EMichael%20Wu%20returns%20for%20the%20last%20installment%20in%20his%20series%20describing%20how%20the%20new%20Community%20Health%20Index%20was%20developed%3A%20%3CBR%20%2F%3E%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe've%20came%20a%20long%20way.%20This%20is%20the%20last%20blog%20in%20the%20series%20that%20describes%20the%20development%20of%20the%20community%20health%20index.%20Earlier%20posts%20in%20this%20topic%20are%20listed%20here%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2FEnterprise-on-the-Surface%2FGuest-Post-From-the-Brain-to-Community-Analytics%2Fba-p%2F1754%23A96%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EFrom%20the%20Brain%20to%20Community%20Analytics%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2FEnterprise-on-the-Surface%2FGuest-Post-Criteria-for-Creating-the-Community-Health-Index%2Fba-p%2F1803%23A98%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECriteria%20for%20Creating%20the%20Community%20Health%20Index%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2FEnterprise-on-the-Surface%2FGuest-Post-Crunching-Numbers-for-the-Community-Health-Index%2Fba-p%2F1851%23A99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECrunching%20Numbers%20for%20the%20Community%20Health%20Index%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2FEnterprise-on-the-Surface%2FGuest-Post-Interpreting-the-Statistics-for-CHI%2Fba-p%2F1933%23A100%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EInterpreting%20the%20Statistics%20for%20CHI%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELast%20time%2C%20we%20talked%20about%20the%20selection%20of%20predictive%20variables%2C%20and%20the%20tedious%20process%20of%20nonlinear%20analysis.%20Once%20we%20have%20the%20variables%20and%20the%20nonlinearities%2C%20we%20must%20combine%20them%20into%20a%20single%20function%2C%20which%20when%20evaluated%20give%20us%20the%20proper%20health%20level%20of%20a%20community.%26nbsp%3BBut%20the%20hard%20work%20is%20not%20over%20yet.%20The%20result%20of%20this%20process%20culminated%20in%20a%20health%20function%2C%20which%20is%20a%20product%20of%206%20health%20factors%20that%20are%20important%20in%20determining%20the%20health%20of%20online%20communities.%26nbsp%3BThese%20health%20factors%20are%20referred%20to%20as%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EMembers%3A%20the%20number%20of%20registered%20members%20over%20time%2C%3C%2FLI%3E%0A%3CLI%3EContent%3A%26nbsp%3Ba%20function%20of%20posts%20weighted%20by%20member%20and%20guest%20viewership%2C%3C%2FLI%3E%0A%3CLI%3ETraffic%3A%20the%20number%20of%20page%20views%20over%20time%20taking%20into%20account%20search%20crawlers%2C%3C%2FLI%3E%0A%3CLI%3ELiveliness%3A%26nbsp%3Ba%20function%20of%20the%20number%20of%20posts%20per%20board%20over%20time%20taking%20into%20account%20user%20expectations%20for%20engagement%3C%2FLI%3E%0A%3CLI%3EInteraction%3A%20the%20number%20of%20unique%20participants%20weighted%20by%20the%20amount%20of%20conversation%20between%20them%20within%20a%20thread%2C%20and%3C%2FLI%3E%0A%3CLI%3EResponsiveness%3A%20A%20measure%20of%20time%20to%20respond%20between%20successive%20message%20posts%20within%20a%20thread%20taking%20into%20account%20expected%20response%20time.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEach%20of%20these%20health%20factors%20usually%20involves%20one%20or%20more%20metrics%20with%20some%20nonlinear%20function%20applied%20to%20them.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20health%20function%20is%20smoothed%20to%20give%20the%20health%20trend%2C%20like%20smoothing%20the%20daily%20stock%20price%20to%20give%20a%20better%20indication%20of%20the%20underlying%20direction%20of%20movement.%20The%20health%20function%20is%20then%20normalized%20to%20remove%20some%20of%20the%20bias%20introduced%20by%20the%20size%20of%20the%20community.%20I%20did%20not%20remove%20the%20size%20bias%20completely%20because%20human%20experts%20also%20have%20such%20bias%20and%20tend%20to%20rate%20larger%20communities%20healthier.%20The%20normalization%20process%20takes%20into%20account%20of%20the%20health%20history%20of%20the%20community%2C%20weighting%20the%20recent%20health%20more%20heavily%2C%20as%20well%20as%20the%20volatility%20of%20health%20so%20that%20consistent%20progression%20of%20the%20health%20trend%20will%20result%20in%20a%20greater%20value%20of%20CHI.%20By%20design%20the%20community%20health%20index%20is%20constructed%20to%20be%20robust%20to%20outliers%20and%20also%20sensitive%3B%20if%20there%20is%20a%20consistent%20signal%20for%20a%20change%20in%20health%2C%20it%20will%20be%20reflected%20in%20the%20weekly%20value%20of%20CHI.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20final%20step%20of%20any%20mathematical%20modeling%20is%20model%20validation.%20Basically%2C%20this%20means%20that%20we%20must%20test%20the%20model%20on%20a%20data%20set%20that%20we%20did%20not%20use%20to%20build%20the%20model%2C%20and%20make%20sure%20that%20the%20model%20still%20performs%20as%20expected.%20Lithium%20now%20hosts%20roughly%20170%20communities%2C%20and%20I%20developed%20the%20community%20health%20index%20using%20data%20derived%20from%2016%20communities%20of%20varying%20size%2C%20age%2C%20and%20purpose%2C%20where%20we%20have%20plenty%20of%20non-metric%20data.%20Then%20I%20tested%20the%20resulting%20model%20in%204%20other%20communities.%20As%20with%20any%20scientific%20discovery%20process%2C%20this%20went%20through%20several%20iteration%20before%20the%20model%20begin%20to%20perform%20well%20during%20all%20the%20stages%20of%20the%20modeling%20process.%20Once%20the%20model%20predicted%20health%20start%20matching%20those%20assessed%20by%20human%20experts%2C%20I%20computed%20CHI%20for%20all%20our%20communities%20and%20gathered%20more%20data%20to%20refine%20the%20initial%20formulation.%20The%20computation%20published%20in%20our%20white%20paper%20is%20actually%20the%20result%20of%20three%20iterations%20of%20major%20reformulation%3B%20each%20introduces%20just%20a%20few%20minor%20but%20important%20tweaks%20that%20increase%20the%20prediction%20accuracy%20of%20community%20health%20for%20a%20greater%20variety%20of%20communities.%20And%26nbsp%3Bwe%20are%20already%20working%20on%26nbsp%3Bfuture%20refinements%20as%20we%20continue%20to%20learn%20from%20the%20data%20we%20collect.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHopefully%20this%20series%20of%20blogs%20have%20given%20you%20a%20peek%20at%20the%20development%20process%20behind%20the%20community%20health%20index%20and%20the%20effort%20that%20went%20into%20it.%20If%20you%20have%20any%20questions%20I'd%20be%20more%20than%20happy%20to%20address%20them%20in%20the%20comments%2C%20or%20feel%20free%20to%20ask%20me%20on%20Twitter%20at%20mich8elwu.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPhoto%20by%20LaertesCTB%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2041%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%20Management%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E

Guest Post: Formulate, Predict, and Reformulate

Lithium Alumni (Retired)

GPS - Flight Speed Data.jpgMichael Wu returns for the last installment in his series describing how the new Community Health Index was developed:

 

We've came a long way. This is the last blog in the series that describes the development of the community health index. Earlier posts in this topic are listed here:

 

  1. From the Brain to Community Analytics
  2. Criteria for Creating the Community Health Index
  3. Crunching Numbers for the Community Health Index
  4. Interpreting the Statistics for CHI

 

Last time, we talked about the selection of predictive variables, and the tedious process of nonlinear analysis. Once we have the variables and the nonlinearities, we must combine them into a single function, which when evaluated give us the proper health level of a community. But the hard work is not over yet. The result of this process culminated in a health function, which is a product of 6 health factors that are important in determining the health of online communities. These health factors are referred to as:

 

  • Members: the number of registered members over time,
  • Content: a function of posts weighted by member and guest viewership,
  • Traffic: the number of page views over time taking into account search crawlers,
  • Liveliness: a function of the number of posts per board over time taking into account user expectations for engagement
  • Interaction: the number of unique participants weighted by the amount of conversation between them within a thread, and
  • Responsiveness: A measure of time to respond between successive message posts within a thread taking into account expected response time.

 

Each of these health factors usually involves one or more metrics with some nonlinear function applied to them.

 

The health function is smoothed to give the health trend, like smoothing the daily stock price to give a better indication of the underlying direction of movement. The health function is then normalized to remove some of the bias introduced by the size of the community. I did not remove the size bias completely because human experts also have such bias and tend to rate larger communities healthier. The normalization process takes into account of the health history of the community, weighting the recent health more heavily, as well as the volatility of health so that consistent progression of the health trend will result in a greater value of CHI. By design the community health index is constructed to be robust to outliers and also sensitive; if there is a consistent signal for a change in health, it will be reflected in the weekly value of CHI.

 

The final step of any mathematical modeling is model validation. Basically, this means that we must test the model on a data set that we did not use to build the model, and make sure that the model still performs as expected. Lithium now hosts roughly 170 communities, and I developed the community health index using data derived from 16 communities of varying size, age, and purpose, where we have plenty of non-metric data. Then I tested the resulting model in 4 other communities. As with any scientific discovery process, this went through several iteration before the model begin to perform well during all the stages of the modeling process. Once the model predicted health start matching those assessed by human experts, I computed CHI for all our communities and gathered more data to refine the initial formulation. The computation published in our white paper is actually the result of three iterations of major reformulation; each introduces just a few minor but important tweaks that increase the prediction accuracy of community health for a greater variety of communities. And we are already working on future refinements as we continue to learn from the data we collect.

 

Hopefully this series of blogs have given you a peek at the development process behind the community health index and the effort that went into it. If you have any questions I'd be more than happy to address them in the comments, or feel free to ask me on Twitter at mich8elwu.

 

 

Photo by LaertesCTB

About the Author
Scott is a Client Services Engagement Manager at Lithium and the Community Manager for the Lithosphere community. In this role he helps enterprise organizations using social media to locate and engage their brand advocates and influencers to address real business challenges.