Index
・What is the Redemption history CSV?
・"Redemptions" CSV
・"Individual" CSV
▼What is the Redemption history CSV?
Team Admin > Rewards > Redemption history CSV
The following 2 kinds of CSV files are available for each month.
- Redemptions
- Individual
(※Data from the previous month will be added and displayed around 14:00 on the first day of the month.)
You can confirm the history of approval, delivery, and return of custom rewards.
A CSV file will include requests for which any of these 3 actions were taken in the specified month.
Rejected requests will not be included.
Example)
Yumi Satoh's request (A) was approved on October 15 and was delivered on November 1.
Yoshito Yamada's request (B) was approved and returned on October 15.
- October CSV will include both (A) and (B).
- November CSV will include only (A).
▼"Redemptions" CSV
This CSV includes all the redemption history for custom rewards.
The following items are available.
- requestedID：The redemption request ID
- approvedDate：The date when the request was approved
- deliverdDate：The date when the request was delivered
- refundedDate：The date when the request was returned
- fullName：The name of the applicant
- emailAddress：The email address of the applicant
- departments：The department of the applicant
- position：The position of the applicant
- employeeCode：The employee number of the applicant
- employmentType：The employment type of the applicant
- rewardName：The name of the requested custom reward
- category：The type of the reward ※A custom reward will be indicated as "custom."
- totalPoints：Points used for the request
- totalAmount：The value of the requested reward
※This field will be left blank for a custom reward. - currencyUnit：Currency ※This field will be left blank for a custom reward.
- Admin memo：The memo entered on the custom reward settings page will be displayed here.
▼"Individual" CSV
The data from the "Redemptions" CSV is sorted by individuals or reward types.
- fullName：The name of the applicant
- emailAddress：The email address of the applicant
- departments：The department of the applicant
- position：The position of the applicant
- employeeCode：The employee number of the applicant
- employmentType：The employment type of the applicant
- category：The type of the reward ※A custom reward will be indicated as "custom."
- totalPoints：Points used for the request
- totalAmount：The value of the requested reward
※This field will be left blank for a custom reward. - currencyUnit：Currency ※This field will be left blank for a custom reward.
- redemptionStatus：The type of the redemption (approved, delivered, or refunded)
Example)
The image below means "Yumi Satoh's custom reward request worth 1000 points were approved.