Category: Synagogue Membership Tracking

Export Chart Data

NEW — you can now export chart data to CSV or Excel–or display the underlying data right on the page!

(see blue highlighted area in the screen shot)

 

Revenue by Category

Revenue by Category, with options to export

In case you haven’t seen our application, let’s list the available charts:

  • Families by year
    • Joined by year (this is the number of households who joined the congregation, year by year)
    • Joined minus resigned by year (which gives you a net membership count, by year)
  • Families by Zip (bar graph, showing number of households by zip, with hyperlinks to those households).
  • Pledges by Year (stacked bar graph, interactively showing pledged and paid, by year)
  • Revenue by Category (pictured above)
  • Pledged-Paid Gap (line graph, going back several years, showing the cumulative difference between pledged amounts and paid amounts).

For each chart, there is a little symbol toward the upper right that lets you export the chart to PDF, JPG, PNG, or just print it directly.

With this change, that same symbol allows you to export the data that goes into making the chart, into a spreadsheet-compatible format.

 

Better Queries

We have three improvements in which you might be interested, with a six-minute video that runs through all three:

Queries with ‘NOT’; bulk status changes.

  • Bulk change of family status:  when you run a family/household query, you will now see a button on the bottom left of the screen.  That button enables you to change the status of any families that you check.  For example, you might query for all families with attribute “moved away.”  From there, in one step, you could change all of those families to a status of “Inactive.”
  • On family/household queries, you can now pull lists of families who do not have a certain attribute.  There is one example in the video above.  Here’s another example–suppose you want to do a paper mailing, appealing to raise funds for a new roof.  You maintain an attribute called “Founding Families,” to whom you might make a personal appeal.  You would want to exclude from that query the Founding Families, so as not to send them the general appeal communication.
  • Likewise on individual member queries. There is a good example in the video, namely pulling a list of ladies in your congregation who are not in the Sisterhood.

 

 

Member Portal, Part III

Members of your congregation can now add people to their families via the member portal.

Previously, your members could change only existing information. Now, they will be able to round out your membership by adding, for example,

  • children
  • elderly parents
  • adult children who may have moved back home.

 

 

Two New Fields for Member Records

We have added middle name and suffix to the fields available on the individual person records:

These fields are also available for update in the user portal.  Moreover, with the recent addition of the audit trail, synagogue administrators can now find the source of every update–the who, what, and when of updates to any of the family/member information.

 

Find Individuals by Zip Code

There is one additional field included in the member query–current zip code.
current_zip

Zip had already been available in the Family/Household query, but this brings a little more convenience to gather info about individuals.

Couple of points:

It is not necessary to enter an entire zip–if you enter 1234, the program will find persons in 12340, 12341, … , 12349.

The term “current zip” means that the query is aware of whether that person is residing at the primary or secondary address.  For example, if the primary address is within zip code 12345, with the secondary address at 98765–if the person is currently at the secondary address, asking for 12345 will not include that person.

Small enhancement to Household Query

Previously, when you selected Queries => Household (a.k.a Family), and you wanted to pull by billing status,  such as Active, Inactive, or Resigned, you were limited to

  1. selecting All,  or
  2. selecting one specific billing status.

With this enhancement, you can select as many statuses as you wish, by simply sweeping your mouse pointer over several consecutive items, or using Ctrl-click to select several non-consecutive items.

ShalomCloud Multi-select on Billing Status from Norman Snyder on Vimeo.

 

Households by Date Joined

Suppose you want to know

  • which families have joined your Temple during the current fiscal year; or
  • which families have belonged to your synagogue for at least ten years.

There is now a way to pull that data (and export it to spreadsheet).

This three-minute video shows how.

ShalomCloud Query by Date Joined from Norman Snyder on Vimeo.

New feature: role within family

If you wish to gain a finer designation of family members, beyond what can be inferred from age alone, we now offer a field that we’re calling Role within Family.  Typical values would be Parent, Minor child, Adult child, and perhaps others such as Elderly parent.

You may then use these fields within the queries and reports–for example, to find all the minor children not enrolled in religious school.

Below is a 3 1/2 minute video illustrating the feature.

Produce a Synagogue Directory in Three Clicks

Creating your annual directory can be a daunting challenge.

No longer: After you’ve designated your format using the ShalomCloud Letter Templates, you are now able to product a directory in three mouse clicks.

Have a look at this three-minute video to see the end-to-end process.

ShalomCloud_Directory from Norman Snyder on Vimeo.

New Chart–Membership Units by Year

A common, but non-trivial, question that constantly occurs is simply this: “How many membership units do we have?”

ShalomCloud answers this question two ways, in seconds.

  1. By a bar chart that shows membership counts going back twenty years
  2. By a table that shows members joined, members resigned, and membership count, by year.
Chart_of_families_by_year

Chart of families by year

member_by_year_table