Automatically set active members to follow a category

For a little context:

  • Our forum has ~95K members
  • Around a year ago, we migrated 3 separate forums and combined them into 1
  • We currently have an “Announcement” category which T1, T2, T3 & T4 groups are automatically “Watching first post”
  • Topics in the announcement category can only be made by Admins

At the end of each week, we create a “newsletter” style topic, celebrating community achievements, product releases, upcoming events and more.

Currently, all members within the above Trust Levels are notified when this topic is created. That being said, we’re beginning to evaluate if this is the best way forward.

When we migrated our previous forums, we brought over a lot of inactive accounts.

We’re looking for potential ways for only active members/within a time frame to be “Watching first post” in the category.

For example, instead of all Trust Levels following, we’d have it setup so only accounts that have been active since August 2023 are following.

Any ideas on how to achieve this? Would Data Explorer help us here? Perhaps the Automation plugin?

I think it may be possible to create a group of ‘recent users’ that you could apply the Watching First Post criteria to rather than the trust level.

One way could be to create a custom SQL badge that ran daily based on ‘last seen’. This could be set to auto-revoke for anyone who doesn’t meet the criteria. You can then have an Automation to add the users with that badge to the group (and remove them when they lose it).

Does that sound feasible?

1 Like

That seems like it might be a potential solution.

So, to clarify:

  • The “Recent Users” group is the one that is following the category
  • Automation is run daily which adds/removes people from the group according to the criteria
  • A SQL badge determining if they fit within the criteria

Are there any resources available that might help with understanding how this works fully?

1 Like

That’s essentially the gist of it. :+1:

There’s some info on the custom SQL badges in this topic - Create Triggered Custom Badge Queries

I think the query itself will be quite a simple one if you base it on something like ‘seen in the last x months’.

And a walkthrough for the specific Automation here: 'Add user to group through custom field' Automation Nope, scratch that, it’s the wrong one. I thought I’d done one for the badge version too, but now I’m not sure.

There’s a few moving parts to it, so it’d also be worth a test run to make sure everything gels together. :slight_smile: