Hello friends,
I am trying to make a list of new subscribers who ordered the day before. I have literally tried every permutation of package history package and ticket history package with price types and order date that is relative to run date. I have tried in, has, not in, and does not have, every way possible, and cannot get new subs. I've even tried in Extractions just to see if I could get it to work there. I could not.
We are on V15. Any advice?
- Chris
Hey Chris,
I'm interested to see what other folks' responses are—we've also had a heck of a time pulling subscriber data (both current and past subs) through List Manager/Extraction Manager.
Here's what we do at our organization:
We run a Package Order Listing report through Reports & Utilities, update the Season field, and make the Order Date Start/Order Date End both the day we're trying to pull the list for. Then I save it as a list so I can use it for various other lists/extractions. As far as I can tell, this gives us the most accurate info for folks who have subscribed.
I hope this works for you, or that you're able to find an easy solution!!
Best,Emily
Hey Emily,
Unfortunately we need the list to be dynamic and just generate each morning so WordFly can send a triggered email.
I thought about just doing a scheduled report...but it would still require some clean up. I'm really someone has some SQL code I can just plot into a new list and be done. LOL
Also..fun fact....I used to be the Senior Manager of Ticketing and Patron Services at LOKC.
Chris