Hi,
I am wondering if anyone has any experience with assisning RFM scores in Tessitura.
What I hope to achieve is to assign Recency, Frequency and Monetary scores at a customer level, most likely using an attribute to mark it on their account (but open to suggestions). I have manually extracted the data to start and have worked out the scores but I would like this to be an automatic procedure that runs monthly to update the scores. If anyone has experience in this or SSIS scripts to calculate RFM I would love to hear from you.
Thanks,
Katrina
Hi Katrina,
I've actually seen it as a custom tab, but it was for a performing arts organization that had lots of seasons and wanted to track individual scores for recency, frequency, monetary as well as a combined RFM score. I imagine you could also use Rankings, and then that would give you the added bonus of being able to offer some web perks to customers based on their RFM rank.
Sorry if this is hijacking the conversation. Totally new to Tessitura here, so please be gentle!
Trying to export a list of our constituents with: lifetime giving, number of gifts, date of last gift -- to calculate an RFM score.
Could anyone point me in the right direction?
Louis
Hi Louis,
Have you tried creating an output set (most of the things you are after are in the Contribution folder)? Then run Execute an Output Set in the Reports and Utilities module. Holler out if you need a help with the list. Creating new Output Set Elements is another rabbit hole you might not want to get in but if you have a friendly SQL-savy colleague you can put them to use designing some.You'll also find a bunch of resources for output sets searching the site.
All the best
H