Rewards - Thanx

The rewards earned and redeemed by your customers.

SFTP Exports

Sample rewards.csv

Thanx Connex

Table name: rewards

Attributes

Column	Data Type	Description
`reward_id`	`string`	The unique identifier of the reward in Thanx.
`reward_uid`	`string`	The unique identifier for the reward in Thanx APIs.
`merchant_id`	`string`	The unique identifier of the merchant in Thanx.
`program_id`	`string`	The unique identifier of the program in Thanx. The program is what issues rewards.
`user_id`	`string`	The unique identifier of the customer in Thanx.
`earning_purchase_id`	`string`	The ID of the purchase that resulted in this reward reaching 100% progress.
`redemption_purchase_id`	`string`	The ID of the purchase that is associated with this reward being redeemed.
`redeem_title`	`string`	The title of the reward. This value is defined by the merchant when they create a reward template and visible to the consumer.
`program_type`	`string`	The type of program that issues the reward.
		`automated campaign`
		`automated campaign - referral program`
		`birthday program`
		`exclusive deals`
		`feedback`
		`intro offer - premium`
		`intro offer - standard`
		`loyalty - incremental`
		`loyalty - points`
		`loyalty - spend`
		`loyalty - surprise and delight`
		`loyalty - visit`
		`one-time campaign`
		`one-time campaign - afternoon shoppers`
		`one-time campaign - close a location`
		`one-time campaign - evening shoppers`
		`one-time campaign - midday shoppers`
		`one-time campaign - morning shoppers`
		`one-time campaign - promote a location`
		`one-time campaign - reopen a location`
		`one-time campaign - vips`
		`one-time campaign - weekday shoppers`
		`one-time campaign - weekend shoppers`
		`reputation manager`
		`special offer`
		`special offer at a location`
		`vip program - spend`
		`vip program - visit based`
		`winback program`
`state`	`string`	The state of the reward. (`active`, `delivered`, `fraudulent`, `pending use`, `refunded`, `retired`, `used`)
`delivered_at`	`timestamp`	The time and date that the reward was delivered to the user. This is in UTC.
`activated_at`	`timestamp`	The time and date that the user activated the reward. This is in UTC.
`used_at`	`timestamp`	The time and date that the user used the reward. This is in UTC.
`retired_at`	`timestamp`	The time and date that the reward expired (if it wasn’t used). This is in UTC.
`expiration_at`	`timestamp`	The time and date this reward expires/expired. This is in UTC.
`estimated_cost`	`number`	The estimated cost of the reward. This value is based on COGS defined by the merchant, or estimated margins.
`discount`	`number`	The applied discount amount of the reward. When we have the exact discount amount via integrated redemption, this will be the exact amount discounted from the purchase. For some reward types with non-integrated redemption, this will be a value based on the estimate you provided when configuring the reward template in the merchant dashboard.
`redemption_pos_order_id`	`string`	POS ID of the order with which this reward was redeemed. Set for merchants with in-store POS integrations enabled for rewards that were redeemed in-store.
`redemption_pos_provider`	`string`	POS provider for the integrated in-store redemption.

⌘I