I want to include the ticketing keyword in t_keyword and I'm getting stuck on the parameters. Basically we want to be able to select all customers who bought a ticket to a performance with a particular keyword. Can anyone help?
Hi Becci,
There is not any documentation on interests at this time.
To use weights for interests you have to set up a stored procedure in your database that evaluates people’s purchases and then calculates a corresponding weight for interests/keywords associated with those performances. For example, for each purchase of a performance with a particular keyword increment the corresponding interest weight by 1. In your case you might want to set it up to start incrementing only after a constituent has purchased 2 performances with a particular keyword. The procedure would then need to be scheduled to run on a regular basis. You’ll have to get an IT resource to do this for you.
You can find a sample weighting procedure on the Tessitura website with the recording of the Lean Mean Marketing webinar, and if you listen to the webinar you’ll get some explanation to go with the sample code.
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
A question came up here regarding whether or not Credits could be involved with weighting - or at least in pulling lists of patrons who have attended performances which feature a particular artist associated with any performance. Any thoughts?