I originally posted this message elsewhere on the forum under suggestions, within a relevant thread on segmentation, but I haven't had a response. Maybe it is better framed as a help request. Here it is:
I am trying to create a list of "inactive" contacts which I am defining as those that have been consistently receiving our emails for a length of time (let's say two years) AND have never opened any. I want to begin the process of updating or removing these inactive emails from our email list (managed in an outside CRM). Having more options in segmentation would vastly improve this.
My current idea to accomplish this is to (Step 1) create 24 segments by contact activity, each segment with the criteria of "were sent" for a one-month timeframe, such as "were sent 1/1/2017-1/31/2017." (I can't simply do one segment with a two-year timeframe because I want to ensure the contacts have been getting emails the whole time, not just once or a few or even half of that two-year timeframe. We send emails to our entire list at least once a month.). Next (Step 2) I take the 24 segments, export them, and combine them into one Excel spreadsheet, then remove all the records that don't appear in every segment (very time-consuming). Now I have a list of contacts that were sent email in every single month for two years. (Step 3) I create one more segment by activity, for "opened" during that total two-year time frame. I export and add that to my Excel sheet and remove duplicates so that the only remaining contacts are those which received email campaigns in every month for two years but never opened any.
This feels like a ridiculous amount of work to get a list that meets this criteria: Was sent email in every month from Jan. 2017 through Jan. 2019 AND never opened. Is there a better way to do this?? Adding multiple criteria for each segmentation category seems to be the answer, but until that feature is available (IF it become available), what do I do?
Thanks!
