Has anyone put together a widget that shows ROI on an appeal or source? I can track how much and how many have given to the source, but I want to see how many people we reached out to so I can track how the source did overall. In Tessitura there is number of contacts on a source, but that's not available in Analytics so I'm looking for a workaround, if possible.
I have been manually adding the "Number Solicited" to my appeal tracking dashboards, so if you could also please share with me, Melissa Scott that would be amazing! My email is rachel.mentkow@strazcenter.org :-)
i realize you are being bombarded - but only because this is awesome. I, too, would appreciate a copy. Thanks! jen@pnb.org
Could I ask for this as well? Thanks so much in advance!
creid@sfmoma.org
It's too bad you couldn't attach! May I also get: mark.boyer@dallaszoo.com
I know! Sending the email now.
Got it! Thank you SO much!!
Hi all! Melissa Scott's GG Appeal Report can be accessed and downloaded here. In addition to the report, Melissa shared the following sql code:
select a.appeal_no, ap.description, source_name, num_contacts, a.num_success_cust from TX_APPEAL_MEDIA_TYPE a join T_APPEAL ap on a.appeal_no = ap.appeal_no where a.num_success_cust > 0 and ap.description like 'FY20 Fall%' or ap.description like 'FY20 Spring%' group by a.appeal_no, source_name, num_contacts, a.num_success_cust,ap.description,ap.category order by ap.category