90-9-1 rule calculated with bulk data api?

[LainieH]

 =Hello, we are using the bulk data api in our own software to run reports.

I would like to create a pie chart or other graph that displayes the 90-9-1 rule: http://community.lithium.com/t5/Science-of-Social-blog/The-90-9-1-Rule-in-Reality/ba-p/5463 in a way that we can measure it over time.

We are using the fields in the bulk data api: http://community.lithium.com/t5/Lithium-Social-Intelligence-LSI/Using-the-Lithium-Bulk-Data-API/ta-p...

I am wondering.. would it be better to (1) take the action_key and segment that by "lurker, occasional contributor, hypercontributor"?

or, would it be better to (2) segment the ranks given into anonymous (where rank is null), occasional contributor, lurker, etc..?

I think (1) ..?  any advice appreciated..

cc @cjdinger

[BrianOblinger · Accepted solution]

Hi Lainie,

I agree that actions are a more logical choice.

You'll need to define for yourself what constitutes each group (does a "Lurker" include users that sign up for an account, post once and never post again? What does a "superuser" mean in the context of your business?).

I'd love to hear more about how you're processing and visualizing the data from the bulk API. It is something we're working on here at Alteryx as well.

[LainieH]

Thanks, Brian, I appreciate your response!