Index for Wave based Communications

  • 3
  • Problem
  • Updated 3 months ago
  • In Progress
We've been working this on a while and can't seem to come up with an easy solution.

I have a list of over 50k emails I need to contact from an unindexed MDA object. Besides their name, these emails are linked to a specific account name, and an SFDC ID, but nothing else much to make them unique in a way that's meaningful.

I want to comm all of them, but not at the same time. There doesn't seem to be an easy way to segment them into say, groups of 5000, and Support was not able to point me in the right direction.

We can probably go back to the base level data source in our company and use its index, but that means there's no randomization, and I segment my customers by tenure, which is not ideal. Plus I'd need to work in a couple weeks of time for R&D to expose that data to us.

I'd love to hear solutions anyone has come up with, especially if it still allows us to use Advanced Outreaches as our solution.
Photo of Brad Jennings

Brad Jennings

  • 604 Points 500 badge 2x thumb
  • frustrated

Posted 5 months ago

  • 3
Photo of Karl Rumelhart

Karl Rumelhart, Official Rep

  • 10,242 Points 10k badge 2x thumb
Random idea (see what I did there?): create a new column and use the string functions to populate it with the third character of the account name (or the first character, or the secibd character of the address, or whatever). You can then create segments by selecting the records with that column = "a" or "b" or "c", etc. 
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 12,526 Points 10k badge 2x thumb
Hi Brad, I recently started going through all of the pending questions . Was checking to see if this has been answered. 

Please let us know if you need any help here?
Photo of Brad Jennings

Brad Jennings

  • 604 Points 500 badge 2x thumb
Absolutely. I still don't believe this has been solved because we can't apply a straight numbered indexed to our data sets.