Benchmarking Data Dictionary

Name Description
Total Number of Orgs
Total Opted-In to the Benchmarking Program (not anonymous to Higher Logic clients)
TNOM Total Number of (Active) Members
TNOS Total Number of ~Subscribers
TNOT Total Number Of Threads
TNORTG Total Number of Reply(s) to Group
TGM Total Number of Messages (Sum of TNOT and TNORTG)
Org_Size_Members Orgs broken out by size based on number of members: Small (0 - 1,499), Small/Medium (1,500 - 4,999), Medium (5,000 - 19,999), Medium/Large (20,000 - 49,999), Large(50,000 – 99,999), X-Large (100,000+)
D100MP Date of the 100th Discussion Message Posted (as an indicator of whether the org has launched or not)
WSTMR Weighted Subscriber to Member Ratio (TNOS/TNOM) * Weighting
WMPMR Weighted Messages per Member Ratio (TGM/TNOM) * Weighting
WGRTTR Weighted Group Replies to Thread Ratio (TNORTG/TNOT) * Weighting (with an IF divide by zero error catch)
CES Composite Engagement Score to rank engagement across different organizations ((WSTMR+WMPMR+WGRTTR)*100)
TNONM Total Number of (Active) Non-Members
TNOU Total Number of Users (Active Members and Non-Members)
TNOMS Total number of Member Subscribers
TNONMS Total Number of Non-Member Subscribers
TNOSWB Total Number of Subscribers with Bio
TNOSWP Total Number of Subscribers with Photo
TNOSWPOB Total Number of Subscribers with Photo or Bio
TNOSWPAB Total Number of Subscribers with Photo AND Bio
TM Total Number of Messages (Sum of TNOT, TNORTG and TNORTS)
ANMA Average Number of Messages (Threads, Replies to Sender or Group) per Author : TGM/TNOAOTOGORTSM
TNOAORTGOSM Total Number of Authors of Replies to Group or Sender Messages
TNOAOTOGORTSM Total Number of Authors of Threads or Group or Reply to Sender Messages
TNOAOT Total Number of Authors of Threads
TNOAWCOONT Total Number of Authors Who Created Only One New Thread
TNOAWCMTOT Total Number of Authors Who Created More Than One Thread
TNOAORTS Total Number of Authors of Reply(s) to Sender
TNOAWCOORTS Total Number of Authors Who Created Only One Reply to Sender
TNOAWCMTORTS Total Number of Authors Who Created More Than One Reply to Sender
TNOAORTGM Total Number of Authors of Reply to Group Messages
TNOAWCOORTG Total Number of Authors Who Created Only One Reply to Group
TNOAWCMTORTG Total Number of Authors Who Created More Than One Reply to Group
TNOTWRTG ~~Total Number of Threads with Reply(s) to Group
TNOTWRTS Total Number of Threads with Reply(s) to Sender
TNOTWRTGORTS Total Number of Threads with Reply(s) to Group or Reply(s) to Sender
TNOTWNRTGOS Total Number of Threads With No Reply to Group or To Sender
TNOTWNRTG Total Number of Threads With No Reply to Group
TNOTWNRTS Total Number of Threads With No Reply to Sender
TNORTGORTSWALOGR Total Number of Reply(s) to Group or Reply(s) to Sender Where At Least One Group Reply (does not include msgs where there is a Reply to Sender but not a Group Reply)
TNORTG Total Number of Reply(s) to Group
TNORTS Total Number of Reply(s) to Sender
TNORTGORTS Total Number of Reply(s) to Group or Reply(s) to Sender
TNOAOLEIDGL Total Number of Authors of Library Entries in Discussion Group Library
TNOAOLEIDGLCMTOLE Total Number of Authors of Library Entries in Discussion Group Library Which have Created More Than One Library Entry
TNOAOLEATDGCOOLE Total Number of Authors of Library Entries in Discussion Group Library Which have Created Only One Library Entry
TNOLEVOLEIDGL Total Number of Library Entry Viewers of Library Entries in Discussion Group Library (by logged in users)
TNODSAOBP Total Number of Discussion Subscribers (who are set to receive discussion emails) Who are Authors of Blog Posts
TNODSACOOBP Total Number of Discussion Subscribers (who are set to receive discussion emails) Who are Authors Who have Created Only One Blog Post
TNODSACMTOBP Total Number of Discussion Subscribers (who are set to receive discussion emails) Who are Authors Who have Created More Than One Blog Post
TNODSBPV Total Number of Blog Post Viewers (authenticated active or inactive users)