Postal Address Month start & end dates

Normal 0 false false false EN-AU X-NONE X-NONE MicrosoftInternetExplorer4

Hi Guys,

We are just starting to incorporate active dates into our postal address TAB in Tessitura and filter by these for  mailings.

I can’t seem to see an ‘out of the box’ filter criteria in list manager to use for an extraction.

Do we have to create one? If so that’s fine our SA can do that – but I just wanted to check I wasn’t looking in the wrong area or under the wrong title.

(the logical side of my brain says it should be ‘postal address active date’ or the like??)

Would love some info on this

Cheers!!

Parents
  • Hi Ranie,

     

    Any utility that outputs addresses (like User Defined Format from a List or Extractions) has parameters used to select addresses based on date (as well as address purpose if you choose to use those).  If you used criteria in a list or extraction that looked at address dates, you wouldn’t be filtering addresses you would be filtering constituents based on whether or not they have an address that meets the date criteria.  That probably would not be the result you want when you consider people who have multiple addresses ( you still would have to choose which one to output) and those who have only one address with no date info.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

Reply
  • Hi Ranie,

     

    Any utility that outputs addresses (like User Defined Format from a List or Extractions) has parameters used to select addresses based on date (as well as address purpose if you choose to use those).  If you used criteria in a list or extraction that looked at address dates, you wouldn’t be filtering addresses you would be filtering constituents based on whether or not they have an address that meets the date criteria.  That probably would not be the result you want when you consider people who have multiple addresses ( you still would have to choose which one to output) and those who have only one address with no date info.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

Children
  • I have a similar problem, so my question is, what if we DO want that Kevin?

    I'm trying to send a mailing that will only go to constituents who have a Florida address in the fall (Oct or Nov). I know I could do this manually with the spreadsheet that results from my extraction, but I'd really like to track it, as I will be sending the same letter to the remainder of our donor-base at a later date. 

    Any advice? 

    For the record, because we're a Florida company and deal with the FL Address v. Northern Address with most of our constituents, we have pretty clean "Month" data.