you will need to create filtering typology rule where you do query as follows
you know the exists such as queries right? you can also check the amount of them by adding Count () in front of the expression. In our case Count(broadLog)
You can filter down on broad log records as much you want. e.g. you can add status equal sent as well as nature, ...
after you need to create date range from last monday to the current date. There is a sql function which will give you the first past monday from any date, in our case current date:
so the condition will look like
If the TruncWeek will not return midnight you should change it toDate(truncWeek(getDate()))
Also this rule the more recipients you have the more time it takes to process. If its unbearable.. you will need to put this condition inside technical workflow and update your custom flag inside the recipient profile on daily basis. Then what is left is to set up the typology rule based on the flag
"Air Traffic Control" for campaigns is very tough subject and cannot be perfect. Keep in mind the more complex the rules, the slower is the delivery prep since Typology rules/Pressure rules will applied at the time of delivery activity node execution.
Having said that, you can always calculate the Monday of the week using expression and they use Today - Monday of the week date to calculate # of communications/messages sent to a customer and use that in the pressure rule. Assuming here the week is Mon-Sun. Similar approach of your week is Sun-Sat (calculate Sunday date of the current week).
Of course things can get complex if you want the rule to apply to certain type of campaigns/communications but not all of them (back to my first statement above).
the recipients of future deliveries you could not do with the default setup. Why would you need that in the first place?
If you need it.. you will also have to implement delivery priorities. let's say on Monday you run your delivery and the pressure rule sees that the recipient has another 3 other deliveries scheduled that week, what will happen then?
You can do it by creating set of technical workflows, enhancing the recipient schema which will hold the current week deliveries scheduled most probably as link to another table also enhance delivery schema by delivery priority and when you run you proofing workflows you will have to update these tables so your pressure rule sees the future counts and priorities.
I have created the rule and added it to a Typology. But how can I set it so it evaluates the week from Monday to Sunday? So if the max numero of deliveries is two in a week, that checks only from last Monday to next Sunday (if there are scheduled deliveries).