Coupon Code tracking - No value
I am trying to track purchases from a special mailing and I would like to use a coupon code to do it but there is no discount or value to the code. How can I see the transactions in the SQL database to pull a report? I did a test transaction and I can not seem to find where the code is recorded except the coupon value on the order table. I would like to have the coupon code track a special area of clientel. Please let me know where either when a customer enters the code if there is a way to track the code if there is no discount. Or do I have to create a new code field (say call it drawing field) and ad it to the order table?