1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Drag to adjust the number of frozen columns
Table
Portal
Columns In the Table
Data Type
Description
coupon_performance_summary_vc
VC
id
Integer
Unique number assigned to every line in the table
coupon_performance_summary_vc
VC
_created_on
timestamp with time zone
Date the record was created
coupon_performance_summary_vc
VC
_last_updated_on
timestamp with time zone
Date the record was last updated
coupon_performance_summary_vc
VC
_revision
Integer
Number of times the record has changed
coupon_performance_summary_vc
VC
_partneruuid
Character Varying
Partner Unique Identifier
coupon_performance_summary_vc
VC
coupon_id
character varying
Coupon ID
coupon_performance_summary_vc
VC
merchant_id
character varying
Merchant ID
coupon_performance_summary_vc
VC
marketplace_id
character varying
ID for the marketplace currently running the promotion
coupon_performance_summary_vc
VC
currency_code
character varying
The code for the form of currency for the coupon
coupon_performance_summary_vc
VC
name
character varying
Coupon Name
coupon_performance_summary_vc
VC
website_message
integer
The promotional message displayed on the website
coupon_performance_summary_vc
VC
start_date
timestamp with time zone
The promotion start date
coupon_performance_summary_vc
VC
end_date
timestamp with time zone
The promotion end date
coupon_performance_summary_vc
VC
discount_type
character varying
The discount type - percent, amount, etc.
coupon_performance_summary_vc
VC
discount
Integer
The discount amount offered
coupon_performance_summary_vc
VC
total_discount
timestamp with time zone
The maximum discount amount a customer can redeem.
coupon_performance_summary_vc
VC
clips
Integer
Number of clipped coupons
coupon_performance_summary_vc
VC
redemptions
Integer
Total number of coupons redeemed
coupon_performance_summary_vc
VC
budget
integer
The budget allotted for the promotion.
coupon_performance_summary_vc
VC
budget_spent
integer
The amount of the budget spent thus far.
coupon_performance_summary_vc
VC
budget_remaining
integer
The remaining amount of the budget that has not been spent.
coupon_performance_summary_vc
VC
budget_pct_used
integer
The percent of the budget used.
coupon_performance_summary_vc
VC
sales
integer
The amount of sales that resulted from the coupon.
coupon_performance_summary_vc
snapshot_date
timestamp with time zone
Data of the report (Weekly or Monthly)
24 records

Alert

Lorem ipsum
Okay