Page Properties Report Macro should allow users to filter the pages based on certain columns of the Page Properties. Such as Status added using Status macro, so that users can specifically create these macros to concentrate on certain pages that are in certain statuses.

Please note that the status filter exists on the server confluence but not in Cloud Confluence (see screenshots).