To get started, open your Account Dashboard and click on the Orders tile.
To export the order data, click the Export drop-down menu at the top of the screen and choose Export orders from the options.
This will generate an Excel spreadsheet that captures all your order details in a straightforward format. Exported fields will include the customer's name, email and mailing addresses along with order ID, profits and/or gift and discount amounts applied for the order. Tracking information is also included on the spreadsheet.
Now, sort that data range in column "R" (CustomerPayment_DiscountCode) which gives the specific discount code used on the order along with discounted total and order info. This will show the order number and the discount code used for that order.