I have a client doing SMS outreach with bulk lists, purchased in csv format. Each record in the list is only a few fields, but the list may contain 25K rows. And they're using a lot of these lists.
The response rate is low, of course, so it doesn't make sense to import these as leads until someone has responded.
So, if I save a list in Files (or static resource), I can pull in the data and do a blast out (using the mobile phone number). When they respond, all I've have to identify them is their mobile phone number -- which could be on any one (or more) of these lists. When they respond, I need to go back to the lists, find the phone number, pull the other fields from that record (name, address, etc.) and create a Lead.
I know how to access the data in a File. What I'm looking for guidance on is the smartest way to look up that respondent by their phone number, when the data I'm searching is in a set of attached Files.
I'll be able to track which list has been used when, so my initial thinking is to go in reverse chronology, load in the data from the most recently used list, convert to string, and do an indexOf on the phone number string. If found, grab the data, if not, move on the the next most recently used list.
I'm thinking there might be a faster method using some kind of an index, but I don't have any experience with that. Any suggestions?
I realize that Campaigns probably deals with bulk lists... I'm off to research how they handle it.