Create A Membership Summary List

Hiya,

to make some reporting easy, I would like to create an (admin only) page that simply lists the plan name and at least the number of active users in the plan.

It would also be great to show the number of expired users and maybe expiries in the next 30 days etc.

This can be a separate page from the core CB, but I am unsure how to call the totals. I appreciate that the total figures are shown in the plan list but am unsure how to pull them out to create the simple summary.

Anyone with ideas?

One option is to use CB Query Field and simple query the database for that information. Then display it on a custom page (e.g. maybe an article with CB Content Bot). Another is a userlist setup to filter users to your plan so it only shows users with an active or expired plan (can be specific or any plan). Then there's CB Auto Actions and a Code action with Method set to PHP where you could use CBSubs API to get that information, but you'd need to be pretty familiar with CB Auto Actions, PHP, and CBSubs API to do that. Userlist usage is by far the easiest to accomplish using an advanced filter. Example as follows.


The above should show any user with an active subscription of any kind for example.

Thanks for the pointers.

One for the weekend, I think!