hey! my team and i are working through a worktable and could use some advice.
we’re trying to send salesloft messages to contacts from existing SFDC accounts, but some accounts have 50+ contacts and we don’t want to message everyone at once. we’ve figured out how to pull 5 random contacts per account, but we’re hoping to go a step further and send a new batch of 5 each day until we’ve worked through the full account.
we’ve tried a few approaches that didn’t quite work, including:
tracking contact ids in a comma-separated column
setting up a new architecture with multiple tables
we also considered adding a new SFDC field, but aren’t confident that would scale well as we expand this motion.
has anyone tried something like this before, have ideas on how to approach it, or know if this just isn’t doable? (all answers welcome!)