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.
Could you create lists for each source (pulling in anyone who was a contact on that source) and use the lists to pull the numbers?
This is a good question and a good workaround. I wonder the best way to account for Delivery/Media costs especially if they differ per source.
Hi Melissa! Did you create the lists for each source as suggested? I'm looking for a work-around as well.
Take care!
A list didn't work for me because I could get Analytics to return a way to see how many were on the list. I can easily find who gave to the source and appeal, but we were interested in how many were solicited. I ended up creating an SSRS report and using the SSRS report widget. It looks like this:
Is this something you would be willing to share, Melissa? I'm finding the same obstacle, and it really looks like there isn't a built-in solution other than lists, which isn't what I'm going for.
I'm happy to share with you, he forum won't let me attach the file so I'll email it to you.
Melissa, would you be willing to share with me as well? I am running into the same issue. Thanks!
Sure, can you send me your email?
rcanter@metopera.org
Thanks so much, Melissa!!
Melissa, I would love it you would be willing to share this report with me as well. It looks great! My email address is alarson@wttw-wfmt.com. Thanks so much! Angela
I am jumping on the bandwagon for this today and wondering how I missed this conversation last year! I would also appreciate a copy :) treese@trustarts.org
Happy to share! Emails sent out.
Can I join the crowd - mfrench@cballet.org
I hope you can imagine the virtual roses being tossed in your direction!