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

Kara_Hammons
Level 2

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

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?

6 REPLIES 6
SanfordWhiteman
Level 10 - Community Moderator

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

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
Level 10 - Community Moderator

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

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
Level 2

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

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
Level 10 - Community Moderator

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

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
Level 2

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

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
Level 10 - Community Moderator

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

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