Does anyone know of a relatively easy way to identify the acquisition channel (by donor) for a large group of donors? To clarify, I'm looking to identify the channel through which they made their very first gift ever made to the org.
Thanks in advance!
Hi fellow West Coaster,
This is a great idea. We have some output elements AF_First_Gift_Amt and AF_First_Gift_Dt, so I'm sure a channel element and perhaps an appeal name element could be built pretty easily. The query data select is !.first_af_gift_amt, unfortunately from a custom table lcv_cust_don_attr_sso. Happy to connect your DBA with ours or it might be pretty clear for them how to build the element(s) you want.
MeganSeattle Symphony