Hi @AHoran! Sorry for the delay in getting back to you on this!
This really depends on what information you need in the report. If you want the report to be user-facing, you’d need to use a database app that they could look at, so something like Airtable, for example.
Then you would need to set up a Zap for each ‘event’ that you want in the report. For example, whenever there’s a new purchase, send the details to the table, when there’s a new customer added in Shopify, send the details to the table, etc.
To get an idea of the kind of information that you can send with Zapier, take a look at the triggers available for Shopify: https://zapier.com/apps/shopify/integrations#triggers-and-actions
Does that help to give you a better idea of what you can do? Don’t forget that you can get a 14 day free trial with Zapier so you can try some of those triggers to see if you can get the information that you need for the report.