Hi @Nic15 ! My name is Sviat from Mipler: Advanced Reports!
Mipler can be useful with this task by already having a built-in report with Sales by Discount Code. Additionally, you can add custom columns to this report and filters by Discount Code, Customers, orders, dates and any columns.
Below I am attaching a screenshot of what the report might look like (this is our test account and the values there are fake)
To prepare various reports, you can check the Mipler app
Our support team will be happy to implement any custom logic and solutions upon your request!