querying recipients of a particular delivery in the past 24 hours

Avatar

Avatar
Validate 1
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
edwardr28531298
Level 2

14-08-2019

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.

1813422_pastedImage_1.png

any ideas?

Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
MVP

15-08-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

Answers (5)

Answers (5)

Avatar

Avatar
Validate 1
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
edwardr28531298
Level 2

16-08-2019

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

Avatar

Avatar
Contributor
MVP
Anita_p
MVP

Likes

119 likes

Total Posts

119 posts

Correct reply

29 solutions
Top badges earned
Contributor
Shape 1
Ignite 3
Ignite 1
Validate 1
View profile

Avatar
Contributor
MVP
Anita_p
MVP

Likes

119 likes

Total Posts

119 posts

Correct reply

29 solutions
Top badges earned
Contributor
Shape 1
Ignite 3
Ignite 1
Validate 1
View profile
Anita_p
MVP

15-08-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

Avatar

Avatar
Validate 1
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
edwardr28531298
Level 2

15-08-2019

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

Avatar

Avatar
Validate 1
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
edwardr28531298
Level 2

15-08-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.

Avatar

Avatar
Contributor
MVP
Anita_p
MVP

Likes

119 likes

Total Posts

119 posts

Correct reply

29 solutions
Top badges earned
Contributor
Shape 1
Ignite 3
Ignite 1
Validate 1
View profile

Avatar
Contributor
MVP
Anita_p
MVP

Likes

119 likes

Total Posts

119 posts

Correct reply

29 solutions
Top badges earned
Contributor
Shape 1
Ignite 3
Ignite 1
Validate 1
View profile
Anita_p
MVP

14-08-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