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 Gloria,
That should work, but keep in mind that you won’t be able to combine criteria that look at that view with other criteria that look at the ticket history to find a single purchase that meets the keyword criteria and other purchase criteria. For example you can’t say give me anyone who spent $50 on something with the comedy keyword. If you tried to do that what you would really get would be someone who spent $50 on anything and also spent any amount on something with the comedy keyword. That might be o.k. for what you want to do, but just something you should be sure to warn you users about so they fully understand what they can and can’t do with the criteria.
Interests are the standard link between constituents and keywords, though you have to set up a weighting procedure to make it work. For example, anyone who purchases something with a particular keyword gets a weight of 1 added for the corresponding interest. Then you can build a list based on people who have a weight for that interest. Of course, you still run into the same issue about not being able look for a single purchase that meets the keyword and some other purchase criteria. But the advantage is that you can start to use interest functionality for suggestions/upselling, and can easily get creative with the weight value so you can see who is really interested in something (made lots of purchases) as opposed to just tried something out.
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
Hi Kevin,
What about if we use the criteria in an extraction? If I create a keycode that looks for all purchases with a ticket keyword, then add other keycodes, it will pull correctly, right?