Send Email to 1000 people from my database each day for X amount of days

[Kara_Hammons]

I'm looking to send out the same email to my whole database but only to 1000 people at a time. Let it run every day until the full database is covered. Any suggestions?

[SanfordWhiteman]

Please move the thread to Products​ to continue. Move link will be at the right. This isn't a support space, it's for webmaster feedback.

[SanfordWhiteman]

Thanks for moving the thread.

So: this is one of those seemingly simple, even primitive, goals that Marketo is really not built to accomplish on its own. Some people will say you can use Random Sample to split your database into lists holding certain percentage of leads. But [a] this works on percentages, not on counts; [b] this doesn't have the granularity for >100K leads; and [c] this doesn't include new leads as the database changes, it's a one-time slice (that may indeed be OK for your case).

I would always use a webhook for this instead: you can precisely bucket the leads into 1000 per day. Then run a batch every day to send to that day's buckets.

[Kara_Hammons]

Thanks Sanford, could you provide some insight on how you would bucket?? All the processes I've thought through have their flaws that worry me. Thanks!

[SanfordWhiteman]

As a lead comes in, the webhook checks its schedule for the nearest future day (perhaps weekdays only) that isn't filled up with 1000 peeps.

Again, the 'hook is providing the intelligence and maintaining a precise counter here -- nothing is left to chance.

Is there something you see as flawed in the outcome?

[Kara_Hammons]

I already have the leads in our database. So I want to send them all the same email just in buckets of 1000 people at one time.

[SanfordWhiteman]

Yes, when I say "comes in" I mean into the webhook, not the database.