How to get the number of mentions groups have had over the past year, and number of members

Community Building Data & reporting
,
2

Hello,

Just to clarify, you need three queries?

  1. For all groups that are older than 365 days, list how many mentions they have had, in ascending order
  2. For all groups that are older than 365 days, list how many mentions they have had, in ascending order, only if they have had less than five mentions
  3. For all groups with less than 10 members, list how many members they have

If so, I can do this for you - all the information you need would be stored in groups, group_users and group_mentions.