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.
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:
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?
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.