How to dynamically schedule delivery based on past open time?

Avatar

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct reply

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

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct reply

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

19-02-2018

Hi,

Does anyone know if you can schedule a delivery in a way that it is automatically sent on the best time per individual recipient or a group of recipients, based on results (opens) from the past?

Best regards,

Suzanne

Replies

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

13-03-2018

Hi Suzanne,

Which version of Campaign are you using? I know that for AC Standard we have an option called "send time optimization" located in the scheduling of a delivery, but I'm not sure we have the same in AC Classic.

Florent

Avatar

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct reply

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

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct reply

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

13-03-2018

Hi Florent,

We are using AC v6.

I've been experiencing now by scheduling a delivery (hourly), based on the hour that a previous delivery was opened by the recipient. This works, but it would be more interesting to choose the hour of the day that a recipient opens all received deliveries from us.

Below you can see our current query after the scheduler:

1441076_pastedImage_0.png

I need to check if there's a way to count the times that a recipient opened a delivery for every hour of the day and than use the highest count to dynamically schedule the new delivery per recipient, so it's really based on the open trend instead of open time of the last delivery. Any ideas of how to do this?

Best regards,

Suzanne

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

04-04-2018

Hi Suzanne,

I guess that would be possible by combining some aggregate functions and maybe some JS/custom code, but that goes beyond my knowledge.

For example, by extracting each Hours of the open time for all tracking logs of a single recipient, grouping them, and counting which has the most, and then storing that value in a new field of the recipient schema. I'm not 100% sure it's easily feasible and that might be really heavy to compute individually for each recipient of your database.

Let us know if you make progress on this.

Florent

Avatar

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct reply

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

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct reply

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

06-04-2018

Thanks Florent

Avatar

Avatar
Validate 1
Level 1
craigf66228339
Level 1

Like

1 like

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
craigf66228339
Level 1

Like

1 like

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
craigf66228339
Level 1

10-01-2019

Can multiple emails not be selected within the query?

i am wanting to do something similar but agree with Suzanne that doing it from 'last sent email or specified delivery isn't quite as useful.

Thanks

Craig

Avatar

Avatar
Validate 1
Level 1
craigf66228339
Level 1

Like

1 like

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
craigf66228339
Level 1

Like

1 like

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
craigf66228339
Level 1

10-01-2019

Apologies - by this I meant can you add an 'OR' statement within the query to add multiple deliveries?

Very manual but if its a case of updating the query each time a new newsletter is sent (for example) then that wouldn't present much extra work.

Just a thought and I could be wrong!