I was able to find a query which is supposed to pull the email, name, rule #, coupon #, and coupon code.
However, I noticed that, based on the coupon usage report, this query is missing 90% of the orders attributed to the code from the last two week period.
Is there a code for Magento 1.9 which can pull email, customer name, coupon code, and what they ordered in the same report? Or at least everything besides the product?
Thanks in advance!