How to find out what user used what coupon code in Magento

The Problem with Magento and Coupon Codes

Magento comes pre-built with a ton of great reporting options for things like sales, shopping cart, products, customer reviews and more. Unfortunately within Magento there is no easy way to get an exported list of all orders with the associated coupon code that was used. Thankfully a little magic, mixed with some SQL can solve that for us!

gist:/mehh/d2a9420ce41a41a7e6ef448d84c031d8

• this
• 123