Recipe - SQL for Lapsed Givers

Skill level: Intermediate

Organization: Simple

Requires Rock: 1.7.0

---

{# strip images & classes from the HTML but otherwise leave structure #}

GET THE SQL: https://gist.github.com/joshcrews/e010290be730a77250ba3da385b21911

SQL version with Campus Filtering: https://gist.github.com/joshcrews/6d77d9ec9fafdf7e6b5a32d86977d754

Slides from Rx2019: https://www.dropbox.com/s/2wucaiazqoenvlo/joshcrews_rx2019_lapsed_givers.pdf?dl=0


This SQL searches your Rock database for "recent lapsed givers". The definition of a recent lapsed giver is someone who gives $3,000 / yr, who has given less than $100 in the past 8 weeks, __who was giving normally this same 8-week period last year__.

That last clause is key, because many people give a lot, but can have 8 week non-giving periods. Maybe they take the summer off. Maybe the winter off.

Maybe they give a large amount in December, then don't start again til March. Without comparing their giving to the same 8-week period last yearit's hard to know.

How to use this

1. Create a Dynamic Data block on a page for a Pastor to send, "Hey, how's it been going?" emails
2. Create a DataView that you can use to build other reports or automatations on top of

You can see step-by-step how to go from SQL either a DataView or a Dynamic Data Block in the slides: https://www.dropbox.com/s/2wucaiazqoenvlo/joshcrews_rx2019_lapsed_givers.pdf?dl=0

Screenshots

• /GetImage.ashx?guid=8a5549ea-83fd-4ba5-b50b-2ea8b014544b