By action items do you mean Confluence Tasks? If yes:
Some of your points could certainly be built by querying the ao_9412a1_aotask table in the database. These 3 should be relatively easy:
Quantity per project
Quantity due in the next 7 working days
Quantity over due
You could use PocketQuery to create SQL Queries that can be executed via macros. You might also be interested in Task Reminder which can send out emails containing overdue tasks, tasks that are due in the next 7 days, etc. (but it doesn't have macros).
I'm afraid these two might not be possible, though:
Quantity closed without resolution
Quantity closed on time or by due date
I'm not 100% sure but the last time I looked at the tasks database table I think it only contained assignee, comment, due date, page and whether the task is complete or not. No resolution date, resolution type or anything like that. If you require something like that you'll have to use Jira.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.