Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

How to get number of emails sent between two dates?
  • Vote Up0Vote Down scalarscalar
    Posts: 27Sendy user

    Is there a way to know how many emails were sent between two dates (for example between 01 january 2013 and 01 may 2013) ?

  • 3 Comments
  • Vote Up0Vote Down BenBen
    Posts: 3,484Sendy support

    Hi @scalar,

    Not from Sendy's interface. But you can run the following query directly in your database to find out:

    SELECT SUM(recipients) FROM campaigns WHERE FROM_UNIXTIME(sent) BETWEEN "2013-01-01" AND "2013-05-01"

    Date format is YYYY-MM-DD.

    Ben

  • Vote Up0Vote Down scalarscalar
    Posts: 27Sendy user

    Thanks! Do you know of an option in amazon api to get this number (in case some emails are sent not via sendy - outlook for example)

  • Vote Up0Vote Down BenBen
    Posts: 3,484Sendy support

    You're welcome!

    Do you know of an option in amazon api to get this number (in case some emails are sent not via sendy - outlook for example)

    No, as far as I understand, there's no way to get this number. Try asking this on Amazon SES's forum?

    Thanks.

    Ben

This discussion has been closed.
All Discussions