Forum Discussion

cblown's avatar
cblown
Boss
13 years ago

Ideas Statistics

Hi All

 

We are exploring options relating to the Lithium Ideas Exchange to create a custom component that displays

 

  • Number of ideas submitted

  • Number of votes submitted

  • Number of comments posted

  • Number of ideas implemented.  

Our understanding is that Ideas can be treated just like normal boards and that we'd query the board and tally the stats ourselves? Does the response data contain all the "Ideas" elements such that we could determine these statistics? 

 

Any advice appreciated 

CB

9 Replies

  • After reading the Metrics List it looks like we can fetch the following:

     

    Net Ideas - The number of ideas posted to idea exchanges (Ideas), minus the ideas that have been deleted (Ideas Deleted).

    Net Ideas Comments - The number of ideas added to idea exchanges (Ideas Comments), minus those that have been deleted (Ideas  Comments Deleted).

     

    2 down, 2 to go..

     

    Can't see any reference to "Ideas statuses" and "Ideas Votes" though.. any ideas?

     

  • cblown's avatar
    cblown
    Boss
    13 years ago

    We are still looking for help with this issue, here is what we have so far: 

     

    • Number of ideas submitted    -- Using metrics Net Ideas 

    • Number of kudo submitted    --  Using REST api -  /boards/id/<id>/kudos/count we can fetch total kudos for each Ideas board and tally.

    • Number of comments posted  -- Using metrics Net Ideas Comments 

    • Number of ideas implemented -- No solution found ( we can't see anything in the metrics? )

       

    We've looked at the REST call

     

     

    /board/id/<id>/threads/for/message_statuses/id/<implemented> .. /top/count  .. /recent/count  ../popular/count  

     

    But we are after a count for ALL "Implemented" Ideas to date.

     

     

  • BrodieJpk's avatar
    BrodieJpk
    Guide
    8 years ago

    This would be super helpful for our purposes too.

     

    Please forgive the ineptitude but in creating these calls, where it's like HTML code, as front-end users are we able to enter these somewhere to create reports? Or do we need access in the back-end?

     

    It would be really convenient for more detailed reports to come out of Ideas Exchange, including regularity of tags and labels, a status tracker to identify how long ideas have stayed in a status for, and how to measure individual ideas as well as figures taking into account how many ideas are moved and merged into others. 

     

    Would be super handy eh @ClaudiaS??

  • ClaudiusH's avatar
    ClaudiusH
    Khoros Alumni (Retired)
    8 years ago
    To create UI components showing these metrics you would need a bit more than just plain HTML. You would create a custom component in the Freemarker markup language.
    Also keep in mind that since this question was originally posted the new Community API v2 with the LIQL query language was introduced which allows to form queries for all of these metrics.

    Regarding your ask for more detailed reporting:
    I assume you've already looked at the Ideas report within LSI which gives a high level overview into idea submission and commenting stats. Also when in LSI you apply a Topic ID filter for an individual idea you can get a history of posting and kudoing activity as a graph.
    We currently don't have a status tracker, but the current default ideas UI gives a breakdown of number of ideas in each status.

    I found your request for "tags and label regularity" an interesting one: What insight would you get out of that and what action would that lead to?
  • BrodieJpk's avatar
    BrodieJpk
    Guide
    8 years ago

    Thanks ClaudiusH!

     

    I realise that in my hunt for content about the Ideas Exchange, I've fallen into Developer-land which isn't my function within my organisation (just an entry-level Moderator here trying to wrap my head around the platform).

     

    To be honest, it's a question I should've waited to ask because we don't have access to LSI within the staging environment and the production site isn't live yet so we haven't got data to work with or to test how to report on. That being said, knowing what to look out for is handy like the Topic ID filter.

     

    We'll definitely set up a manual status tracker so we can report on turnaround times for ideas, and pursue areas of the business who don't progress statuses in a timely manner. I don't think there are in-built reminder notifications?

     

    I suppose it's perhaps specific at an organisational level that we're interested in seeing how often certain tags are used, and because labels we're using apply to business areas, being able to compare how many ideas are attached to one area over another could be interesting comparisons. By understanding what tags (and therein phrases or key points) are coming up more regularly, we can attune communications to those keywords and determine whether the strategy of the exchange needs to be finessed if the tags being used aren't necessarily applicable, too broad, or too specific and aren't aiding in people searching ideas so we're not doubling up etc. By knowing which areas of the business are labelled more regularly, it can sensitize a focus on improvement for that area, provide them more resources and make more enquiries. I hope that makes sense.

     

    I really only asked because I only saw these types of features in the Labs part of LSI and I think it'd be great to work them in.  


    Thanks!
    Brodie

  • mdfw's avatar
    mdfw
    Genius
    4 years ago

    Hi cblown ,

    I'm resurrecting an old thread but wondered if you were ever able to grab " Number of ideas implemented ". I'm trying to filter by date as well. I'd love anything that says "filter by status changed between date1 and date2" but I'm not seeing that either. Wondered if you had any ideas based on this old issue?

    Thanks!

  • Yeah I haven't had a look back into V2 to see - but the CSV export is probably the only way if not. 

  • mdfw's avatar
    mdfw
    Genius
    4 years ago

    Hi StanGromer - Thanks! That's what I was afraid someone was going to suggest and what I assumed from poking around the API. I'll probably start doing that, but that also means I have no historical data to compare against. Disappointing gap.

    Thanks again.