Within our organization people often end up wearing multiple hats. They may be the secretary of their club, but also the chair of something at the district level or something similar. So they end up having multiple titles. Our goal is to be able to email all the presidents, or all the council chairpersons or maybe the presidents the secretaries and 3 other titles, so we'll be tweaking the segmentation often. If a person has multiple titles, then in our reports they will have multiple entries. My excel import sheet had duplicates rows for anyone with more than one title. Everything but the title column was duplicate data. Since the email matched, these duplicates were not loaded into my contact list. In order to segment they way I need to I needed to add a series of custom columns, one for each possible title an individual may have. In excel I then populated the cells in these new columns when the person held that role, otherwise the cells were left blank. To make them easy to read I populated them with the title, so in my segmentation my criteria needs to be if 'President' field is 'President' instead of simply if 'President' field is not empty. I will go one step further though, and say that if 'Add Tags' had been a field option when importing a spreadsheet, then any of the unique titles would have been tagged with their title, and I could have used tags instead of segmentation. Because I would have had to add ~5500 tags manually to my records, I instead went with the data layout I describe above. Allow me to explain. If I could have set the Title field to something like 'Add Tag' when importing, then each unique value in the title column would have become a new tag, and that tag would be applied to every applicable record. I have about 5500 records, but only around 2 dozen titles, so those 2 dozen titles would have automatically been created as tags, and the records automatically tagged with those values.
... View more
