Interesting article on gender values in databases

Some time ago I had made an inquiry with Tess support about the possibility of altering the potential values of the gender dropdown in the application. The answer at the time was that making such a change wasn't possible in the current application, but that some consideration might be given to it in the design of the NextGen product.

This morning I came across a blog post from one of the developers on the Diaspora project. (Diaspora is intended to be a Facebook-esque social network in which the backbone consists of "nodes" installed onto servers by the users of the system.)

The blog post, Why Gender is a text field on Diaspora, is a brief look at the developers thought process in making gender a very flexible piece of data.

Four years ago, at my first rails job, I worked at a company with a mostly-*** customer base. It turns out, in that context, knowing if someone is “male” or “female” gives you almost no useful information. The *** community has other widely-accepted categories of gender, but the company’s internal order tracking software — a well-known package from a national vendor — offered only male or female.

...

I made this change to Diaspora so that I won’t alienate anyone I love before they finish signing up.

The comments seem to be running about 50/50 between "So happy you've done this!" and "Meh".

I know there are a lot of design considerations being made in the planning for the NextGen project.  Just wanted to share this link as a bit of a thought provoker and conversation starter.  I suspect that some Tessitura licensees find themselves with unique constituent populations that might benefit from this type of flexibility.

-Levi

 

  • Levi - 

    My husband (who donates to and follows Diaspora development) was just mentioning this to me over the weekend which started our own weird dinner conversation. The question that it raised for me, is why do we want/need the gender column? (In a kind of big picture question, not actually saying to get rid of the gender value). In my own organization we currently use it for three reasons:

    1. For the box office/phone room: to know that 'Pat' is actually a 'she' or 'he' when calling or speaking to the person in question.

    2. To help generate formal salutations or custom text (i.e. if gender = 'female' then 'her')

    3. For any sort of grant reporting we might eke out of some statistical info.

    Granted, since we don't often ask the gender question unless there's something unusual, we mostly use it for reason #1.

    If we go down the Diaspora way of a free text field, what we gain in flexibility we lose in any sort of data integrity. Even the Diaspora blogger recognizes that she's going to see answers like 'have not checked today', 'man-boy', etc. Like another commenter on the blog, that leads me to ask, why ask for gender? Why not a random question? Is the moon made of cheese?

    Now, I'm just playing devil's advocate here as you wanted to start a conversation... So I'm obliging. But I really do have a serious question for all the organizations out there.

    Why gender?

    It seems to me that we have to answer the question of why it is stored before we can determine how it is stored.

    - Heather

  • Heather and Levi, thanks for bringing this question up.

    I use Tessitura in an education setting, and in addition to Heather's No. 1 and No. 2 reasons for collecting the information, gender is very useful to us in class and camp registrations, birthday parties and other youth-focused programming. This piece of data is in fact required by our web code.

    Perhaps the most important reason for us is to have data about what performance titles and keywords have more sales with boys vs. girls. For example, if our engineering classes are attracting mostly boys, we may modify our offerings and marketing to appeal to families with girls. (In fact, we are participating in a grant-funded program involving girl-specific classes tied to the PBS show SciGirls.)

    Second, we will look ahead and select or pair teachers and assistants who can best teach whatever the gender composition of the class happens to be, so that we can play to the strengths of our staff and enhance everyone's experience.

    In addition, we ensure that everyone who registers in (for example) "Camp Curie for Girls" is in fact a girl. We answer parents' worries that their child will be the only child of their gender in a class.

    These are the education-related ideas that come to my mind. Thanks again for bringing this up!

    Michael Wilcox
    Program manager, Youth and Family Programs
    Science Museum of Minnesota
    mwilcox@smm.org
    (651) 221-4571

    Showing for the very first time on the Omnitheater’s 90-foot domed screen, Hubble will take you on an awe-inspiring tour of the cosmos.  Make plans to see it today, and marvel at the great wonders that the Hubble Space Telescope has revealed.  For more information and a trailer, visit www.smm.org/hubble.

  • Heather - 

    I completely agree that a free text field makes the data worthless in a Tessitura environment since we want to use that information for other purposes (reporting for grants is the one I was thinking of in particular).  For a social networking site, I can see it being more user friendly to be free text.

    As for the need for gender as a field at all, I'm a fan of getting as much demographic information as possible.  If for no other reason than to make programming decisions.  Age, gender, zip code and income level are pretty powerful tools to analyze your customer base with.

    While alternate gender values might not make up a large percentage of the constituent base, I would think that development departments would find that information even more valuable in their efforts to make a more personalized (and potentially less embarrassing or offensive) donation ask.

    I was, frankly, a little surprised at the vehemence of the "No! There are only 2 genders!" comments on the original blog post.  So I may be underestimating how sensitive of a topic this is. But if the goal of the organization is to create the best and most personal customer experience possible, it seems like it would be advantageous to have the ability to gather as much information as easily as possible.  Of course, that has to be balanced with ease of use in the software and on the web.

    Thanks for chiming in Heather, always fun to have questions to think about!

  • Kudos for raising a sensitive but legitimate issue, and for asking a good question: why?

    I'll add a Marketing department perspective on how we might use gender: who is making decisions in a family is an oft-discussed topic.  Moms are often said to be the main decision makers regarding activity programming for the family.  In a recent nation-wide survey of museum patrons, entire segments of data analysis are being given to analyzing what "kinds" of moms and what "kinds" of dads use museums, how those groups differ, and how we can get under-engaged fathers more involved.  Movie theaters have "Movies for Moms" type activities; a museum (or other institution) might want to offer something similar.  Having a gender field allows you to identify these customer segments, so that you can address the "Movies for Moms" postcard to any female adults on the membership, for example.  Similarly, an institution might want to target some marketing or events at dads, and would need a similar field for that purpose.  It would also help in data mining; if I understand the theoretical new architecture correctly, we'd be able to see which parent (male vs female) actually made the reservation for a given visit, which speaks to my first point about who makes the plans for the family.

    I'll also say that personally, I think it's always wise to consider all your options, so I'd love to see us consider how to accommodate various gender identities; however, I don't think I'd try to find the solution by myself.  If it were up to me, I'd do some quick research on the top gender-identity organizations in the US (and other member countries) and request a quick consult on their organization's perspective.  Better to ask people what they want directly than to try to guess on their behalf.  Free-text may not be the only - or best - option.  Let's ask the experts.

    Beth

  • Beth,

    Thanks for a marketing take on things.  Being a DBA means I love data and its always good to see how it is being used by different disciplines.

    My hope would be that the gender field would become something that organizations could customize to their needs (either through system tables or something similar).There will obviously be organizations who never touch the default values, but for those who do see a need to customize it, it would be a great tool to have.

    There was some follow up to this conversation on the web through a few other blog posts.  The most interesting one I saw was from Metafilter.com.  One of the DBAs did some quick analysis on their database.  It is a realtively small sample size (< 10,000 records with a value entered for gender) but even with a free text field in place, they were still able to identify over 75% of the values as indicating a preference for being identified as either male or female.  The full comment has a detailed breakdown of the remaining values (along with his caveats), but it is interesting to see what kinds of things people will enter when left to their own devices.