for reporting purposes on Google Analytics 4 data, we regularly need to fetch weekly and monthly users for our clients that work with fivetran. Currently the Google analytics 4 connector has date as required dimension. Adding date to a custom report will split out users by day where the sum of this is always higher than what is shown in the UI where it is a distinct count of users by week or month.
In order to provide this highly requested KPI it would be necessary to either provide a standard report to pick or to make date non-mandatory in the custom report section. It would fully suffice from our end, if there is a premade report in the GA4 connector that lets you fetch either weekly or monthly users for any given (ISO-)week or month. If no user ID is available in GA4 raw data there is regularly a column user_pseudo_id in the google analytics exports we use, that let's you get to the number needed.
I am happy to support you on this with more insights if needed.