Unfortunately in dynamic reporting al you can do is to define a date range.
Though this won't fit your requirements as e.g. a click might be reported on another day than the delivery.
Brst guess for such aggregated numbers would indeed be a workflow:
* Query activity to load the deliveries
* Extract file to generate a csv file
* Transfer file to upload the file to SFTP/S3