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.
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