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.