GET activity events API vs usage metrics datasets

I currently have a usage report which is based on the data from the 'Report Usage Metrics Model' datasets which I download once a week by connecting to the dataset for each workspace and exporting the results from a table visual. I would like to automate this process as it is time consuming and I have to keep track of the workspaces in our organisation. I have looked at using the admin API activityevents for activity 'viewreport' but this is not returning the same fields as the usage metrics dataset specifically it is missing the report page information. Is there another activity type I should be filtering for on this API or can anyone tell me how to automate exporting the usage metrics from each workspace and save me 30 mins every Monday morning?