Hi there,
We are trying to tap into some potential and I've been asked to pull a list of anyone in our database who has an address with a certain zip code. I've set up the extraction and have had success EXCEPT for it also includes names of people who have an INACTIVE address with that zip code. Why on earth would the extraction include people with these inactive addresses and is it possible to change this?!
Thanks!
Michele is correct; you could also do the flip side of that and say Primary Address IN Y to only get default addresses (which must be active).
At City Center we have done extractions that would be fine with inactive addresses! EX: A touring company from a certain city comes through and we want to send it to ticket buyers who have lived in that city, even if they no longer live there.
-- Mike
Michael, thanks for the suggestion. In this instance, I don't want to include only primary addresses. We are looking at some "off-season" programming for this region, which is mostly vacation/secondary homes, and we want to see how many of our constituents have an address there to see if it'd be worth doing anything.