Send Email to 1000 people from my database each day for X amount of days | Community
Skip to main content
Kara_Hammons
Kara_Hammons
Level 2
July 25, 2018
Question

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

  • July 25, 2018
  • 3 replies
  • 2867 views

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?

3 replies

SanfordWhiteman
SanfordWhiteman
Level 10
July 25, 2018

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
SanfordWhiteman
Level 10
July 25, 2018

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
    Kara_HammonsAuthor
    Level 2
    July 26, 2018

    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
    SanfordWhiteman
    Level 10
    July 26, 2018

    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
    Kara_HammonsAuthor
    Level 2
    July 27, 2018

    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
    SanfordWhiteman
    Level 10
    July 27, 2018

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

    Terms & ConditionsAccessibility statement

    Loading footer...