Commerce Server Blog

Through marketing manager, business users can create promotion codes. These promotion codes are stored in a tabled named – “mktg_promocode” in SQL Server. Sometimes we might want to know what are the promotion codes available and how many times the user has used this promotion code. Either you can search for the coupon code using marketing manager advance search or use following query to get details of all coupon codes.

use [StarterSite_marketing]
Go

Select
pc.u_pc_code as ‘Promotion Code’,
pc.u_pc_target_user as ‘Target User’,
pct.i_pctrans_used_count as ‘No. of Times Promo Used’,
i_pctrans_reserved_count as ‘No. of users reserved this promo’
From [mktg_promocode] pc , [mktg_promocode_transactions] pct
where pc.i_pc_id = pct.i_pc_id

For more information about Marketing tables related to coupons, visit following link.
http://msdn.microsoft.com/en-us/library/bb520796.aspx