I am trying to report on what time people are opening across all recurring deliveries in a specific campaign. I can't find a way to aggregate the data to hourly without date, I can only find a breakdown that shows by date and hour.
Can anybody point me in the right direction?
Solved! Go to Solution.
Views
Replies
Total Likes
I don't believe it's possible out of the box via the available reports.
But you can create a workflow to calculate the number of opens at each hour across all your recurrent deliveries of your campaign.
Your final result should look something like this :
Bear in mind that your profiles can open the same delivery more than once. Adding a dedup step before your partition, to filter only the first open per profile and delivery might be useful.
Hope this helps.
I don't believe it's possible out of the box via the available reports.
But you can create a workflow to calculate the number of opens at each hour across all your recurrent deliveries of your campaign.
Your final result should look something like this :
Bear in mind that your profiles can open the same delivery more than once. Adding a dedup step before your partition, to filter only the first open per profile and delivery might be useful.
Hope this helps.
This is great, thank you very much.
Views
Likes
Replies