Hello,
Has anyone found a reliable way to get data on subscribers that have subscribed for a certain number of years or more? Our current criteria doesn't seem to lend itself to being able to parce out only those who have subscribed for a certain number of CONSECUTIVE years or more not just total years subscribed.
Rika Dixon White
There is probably an easier way to do this, but when I was very new to lists I did the following to determine consecutive contributions and it worked
- Create separate lists for each year, i.e.
o List Year 1 = contribution date between Year 1 start and Year 1 end
o List Year 2 = contribution date between Year 2 start and Year 2 end
o Etc.
- Next create a list of these lists, i.e.
o Line 1: Criteria=List Operator=Has Value = Year 1 List
o Line 2: Criteria=List Operator=Has Value = Year 2 List
Was a bit tedious but it worked.
Barbara Pinney
Consortium Manager
Tulsa Arts Management Consortium / 401 S. Boston Ave Ste 250 / Tulsa, OK 74103
bpinney@tamc-tulsa.org / 918.409.9639
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Rika Dixon Sent: Thursday, January 16, 2014 3:01 PM To: Barbara Pinney Subject: [Tessitura Marketing Forum] Pulling Subscriber Tenure Data
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!