September 25, 2017 Admin Feature by

New SQL Recipe: Org Search Member Stats

We recently created this new recipe to give you a look at attendance for multiple orgs. The report is generated from the Organization > Search Manage page and gives attendance statistics for the members of those orgs. That is why it is named OrgSearchMemberStats.

The report displays the ID# and name of each organization included in your filters on the search page. Each member is listed and presents not only the person’s name, but also his church join date (blank if not a church member), and the following relating to his attendance in that org: date last attended, attendance percent, and the attendance string. You can also download it in Excel.

Remember, these SQL reports are super-simple to add to your own database. Create a new SQL report, then copy and paste the code, save the script, run it, and then add to the toolbar.

Read more



 Back to blog

Leave a Reply

Your email address will not be published. Required fields are marked *