Hi Beth,
If you want to use ranking for just this one thing, you don’t need to do anything fancy (like come up with a ranking scheme and a stored procedure to apply it). Just create a rank type for this special offer, then add it to the constituents in question manually (or do it in bulk in SQL Server based on your list). You can just set the rank value to 1, because the only people with the rank type will be the ones who are getting the comp offer.
Kevin Sheehan
Senior Documentation & Learning Resources Specialist
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com