Was Sent Multiple Emails in 7 Day Period | Community
Skip to main content
Eitan_Rapps1
Eitan_Rapps1
Level 4
August 20, 2017
Question

Was Sent Multiple Emails in 7 Day Period

  • August 20, 2017
  • 2 replies
  • 3008 views

We are trying to see how many people in our database received more than one email (any email) in a week-long period, over the course of the last 3 months.

This means the constraint Date of Activity: in past 1 week is not relevant, because I am not looking for just this past week, rather I want any week-long period over the last few months.

Any suggestions on how to set up such a Smart List?

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

SanfordWhiteman
SanfordWhiteman
Level 10
August 20, 2017

I can't see a path to constructing this kind of report in the UI. You could pull the Activity Log and crunch it offline (SQL window functions are built for this kind of thing).

    Dory_Viscoglio
    Dory_Viscoglio
    Level 10
    August 21, 2017

    If you have RCE, you can do this using an email analysis report and the Weekly send filters.

      SanfordWhiteman
      SanfordWhiteman
      Level 10
      August 21, 2017

      Not 7-calendar-day windows, though.

        Dory_Viscoglio
        Dory_Viscoglio
        Level 10
        August 21, 2017

        Haha, true.. but usually this can get close enough answers, especially if people are looking at a M-F week

        Terms & ConditionsAccessibility statement

        Loading footer...