I have set up several different coupon codes, which allows me to see which marketing campaign is working.

I can't figure out how to track which sales come from which coupon codes. Is this possible?

I checked out the orders table and saw the CouponID field, however it lists 0, which means no coupon code was used. It does have the coupon discount listed, but the code is not assigned correctly. Please note that I chose a % discount, not a flat $ discount.

I am not sure why coupon would be at the order level since it can be assigned at the product level. Is it impossible to apply two coupons to an order?