Coupon Report

Card Name: Coupon Report

Card Link: https://symphonycommerce.domo.com/page/543113726/kpis/details/1362702801

DOMO Page: Orders

Description: The report lists the usage of each coupon code. 

Date Range Filter: coupon activation time

Key columns:

order_average average of order subtotal (merchandise price after promotion discount)
coupon_average average of order's coupon value (<= $0)

 

amount

coupon amount, use with "type". 

For example, type = 'PERCENT' and amount = 10 means this coupon is 10% discount

code coupon code
type coupon type: CREDIT, FREESHIPPING or PERCENT

 

coupon code id in PT
active_at in PT
expire_at in PT
order_max_price maximum order subtotal
order_min_price minimum order subtotal
Number Uses

number of orders which use this coupon

first_used_date the creation time of first order which used this coupon
last_used_date the creation time of latest order which used this coupon

Comments

0 comments

Please sign in to leave a comment.