Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How to dynamically schedule delivery based on past open time?

Suzanne_J_
Level 2
Level 2

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

4 Replies
florentlb
Level 10
Level 10

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

Suzanne_J_
Level 2
Level 2

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

florentlb
Level 10
Level 10

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

craigf66228339
Level 1
Level 1

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

craigf66228339
Level 1
Level 1

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!