querying recipients of a particular delivery in the past 24 hours | Community
Skip to main content
edwardr28531298
edwardr28531298
Level 2
August 14, 2019
Solved

querying recipients of a particular delivery in the past 24 hours

  • August 14, 2019
  • 6 replies
  • 5249 views

Hello, I'm trying to create a query that will look at the event date of a recipient who received a Welcome Email but did not open it in the last 24 hours. For example on 8/14 I want to send another email to recipients who were sent the first email on 8/13 but did not open it. I'm having a problem with calculating the event date. If I hardcode the date I can get it to work. but when I use 'current date minus n days' the query just spins and doesn't produce a result.

any ideas?

Thank you!

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

    Hi Edwardr,

    Please try below and let me know how it goes

    For Speedup your query

    A) Try to use your query as

         Targeting dimension is Deliveries and

         Filtering dimension Recipient delivery logs

    Extra check for scenario like this :

    B) Add check for status of delivery : You don't want to track for those who never received delivery .

    C) Add a check to avoid Proof/Seed Emails

    Thanks,

    Kapil

    6 replies

    Anita_punmiya
    Anita_punmiya
    Level 5
    August 15, 2019

    Hi Edward,

    Your query on the eventDate seems to be correct. However, you can remove "recipient delivery logs exist" as you are already querying upon the same using "exist such as" operator.

    You can just try re-running the query.

    Thanks,

    Anita

    edwardr28531298
    edwardr28531298Author
    Level 2
    August 15, 2019

    Thank you for your prompt reply. I removed the additional 'recipient delivery log exist' line and ran it again, but no dice. the query is staying in limbo with the gear at the top running. Like you mentioned the query regarding the event date seems correct. in fact, when I hard code the dates I get the recipient population I'm looking for. this only happens when I try using a function.

    edwardr28531298
    edwardr28531298Author
    Level 2
    August 15, 2019

    UPDATE: IT RAN! however, it took 9 minutes to do so. I figure there is probably a more efficient way of doing this.

    Anita_punmiya
    Anita_punmiya
    Level 5
    August 16, 2019

    Yes , efficiency is a key here .

    In your query ,you can probably use "Recipient delivery logs" in the filtering dimension and "Recipient" in the targeting as these two are linked .

    Thanks,

    Anita

    kapilKochar
    kapilKocharAccepted solution
    Level 6
    August 16, 2019

    Hi Edwardr,

    Please try below and let me know how it goes

    For Speedup your query

    A) Try to use your query as

         Targeting dimension is Deliveries and

         Filtering dimension Recipient delivery logs

    Extra check for scenario like this :

    B) Add check for status of delivery : You don't want to track for those who never received delivery .

    C) Add a check to avoid Proof/Seed Emails

    Thanks,

    Kapil

      edwardr28531298
      edwardr28531298Author
      Level 2
      August 16, 2019

      Thank a lot all! it worked in 18 seconds now!

      Terms & ConditionsAccessibility statement

      Loading footer...