Skip to content

How to get number of emails sent between two dates?

scalarscalar
edited May 2013 in Questions

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

Comments

  • BenBen

    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

  • scalarscalar

    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)

  • BenBen

    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.

© Sendy.co 2024