I'm looking to run a workflow that will output all of our deliveries over a specific time period with metrics such as opens/clicks etc. However, the deliveries I want to look at are sent out every day and create a separate record on the deliveries table as we normally append a date to the delivery label. For example, for each brands welcome email, in a week it will appear 7 times for each brand.
How do I build a workflow that will aggregate the sends to one line while bringing in opens/clicks for that set period? For each delivery, the delivery code remains constant so I could group by that.
I have tried using counts/group by but not having any luck so far.