Extractions: household records with no email address

**self-hosted organization**

Our organization is wondering how other organizations manage not having an email address at the household level when you are pulling an extraction to email patrons? When all transactions and contribution are on a household record, and many households do not have emails how do you get down to the individuals email address?

Are you guys in the habit of moving the individuals email addresses to the household record? Tessitura recommend this earlier this year, but our 'house' is divided. Marketing/Ticketing don't think it is wise to put one individuals email address on the household record, while Philanthropy believes it is absolutely the way to go. 

Our organization is not in the habit of using the contact point purposes or category consistently, so those option in the extraction header are not resolving our problem.

We want to know how others are dealing with this, so I welcome your thoughts.

Ashley Elliott

Database Administrator

St. Louis Symphony Orchestra

314-286-4198

ashleye@slso.org

Parents
  • When I extract e-mails, I pull by purpose and get all e-mails in a household or its members, as long as one of the accounts (usually the household) has the appropriate ticket or contribution history—or whatever we’re looking for.
     
    So: If I’m looking for households who have tickets in a particular season, I select people with an Electronic Address Purpose IN WordFly Marketing (the purpose that is automatically added to appropriate e-mail addresses in our system) AND Ticket History Season HAS the season in question.
    Lucie


    Lucie Spieler
    IT Dev. & Training Manager 



    Miami Office
    8390 NW 25th Street | Miami, Florida 33122
    Direct: 305.403.3291 | Box Office: 800.741.1010
    Broward Office
    300 SE 2nd Street, Suite 600
    Fort Lauderdale, FL 33301
    954.928.8266
       


     

Reply Children
No Data