Articles in this section

What is point CSV download?

  • Updated
Index
・What is point CSV download?
・How to download a CSV file
・Definition of each index
・Calculation methods
　┗ About the members eligible for the tally
　┗ What happens if a post receive a clap in the following month or after?
・Notes on date
・About the Reflection Time of Data
・Relevant articles

 

What is point CSV download?

You can confirm the point acquisition status per month for members.

Depending on the plan you are subscribed to, you can download up to 3 types of CSVs. This function will be useful for payroll calculation.

  • Pay/Gift cards
  • Donation (Individual members)
  • Donation (Organizations)

※Organizations using Culture Rewards will not be able to use the points CSV download. 

 

How to download a CSV file

  1. Access Team Admin > Point 
  2. Choose the month and type of CSV > Click and download
    ※You can search for the year or switch the year of data to be displayed from "Data collection year".

 

Definition of each index

The Definitions of each indicator are as follows

 

Pay / Gift card

  • fullName
  • emailAddress/login ID：Email address or Login ID
    ※If your organization doesn't use the Login ID function, all members will be displated email address members.
  • departments
    ※If a member belongs to multiple departments, they will be listed with commas.
  • position
  • employeeCode
  • employmentType : Employment status
    ※Numbers indicate the following employment statuses, respectively.
    1. Executive 2. Permanent staff 3. Contract staff 4. Agency temporary staff 5. Part-time staff 6. Subcontractor staff 7. Other 8. Unselected
  • point : The total points each employee earned within the designed period
  • totalAmount : The amount of money (points x point rate)
  • currencyUnit 
    ※Your team's registered currency unit will be displayed here. Please also refer to "totalAmount" above.

 

Donation (Individual users)

  • fullName
  • emailAddress
  • departments
    ※If a member belongs to multiple departments, they will be listed with commas.
  • position
  • employeeCode
  • employmentType : Employment status
    ※Numbers indicate the following employment statuses, respectively.
    1. Executive 2. Permanent staff 3. Contract staff 4. Agency temporary staff 5. Part-time staff 6. Subcontractor staff 7. Other 8. Unselected
  • point : The total points each employee earned within the designed period
  • donationAmount : The amount of money (points x point rate)
  • currencyUnit
    ※Your team's registered currency unit will be displayed here. Please also refer to "totalAmount"　above.
  • donationRecipientName
  • donationType

 

Donation (Organizations)

  • donationRecipientName
  • point : The total points each employee earned within the designed period
  • donationAmount : The amount of money (points x point rate)
  • currencyUnit
    ※Your team's registered currency unit will be displayed here.
  • donationType

 

Calculation methods

About the members eligible for the tally

Members who meet all of the following conditions as of the last day of each month will be eligible.

 

Pay / Gift card

  • Members in any status (Inviting, Active, Suspended and Deleted).
  • The employment status of the member is eligible for receiving incentive payment or making donation.
  • The member earned one point or more in the current month.

※The conditions for gift cards issuance differ from those listed above. Please click here to check the conditions for gift cards issuance based on the course of your company's contract.

 

Donation

  • Members in any status (Inviting, Active, Suspended and Deleted), excluding members deleted by the 5th of the month.
  • The employment status of the member is eligible for receiving incentive payment or making donation.
  • The member earned one point or more in the current month.

※At the time of your organization's initial registration with Unipos, the admin designates which employment statuses are eligible for receiving incentive payment or making donations. To change this information, please contact Unipos customer support.

 

What happens if a post receive a clap in the following month or after?

Point CSV download will reflect when each post received points/claps, regardless of the original posting date.

Example) There is a post which was sent/received in January. If that post receives a clap in February, the points associated with the clap will be reflected in Point CSV download for February.

 

Notes on date

  • CSV data reflects information as of the last day of each month.
    ※CSV data before February 2020 reflects the employment status as of March 27, 2020.
  • Any unregistered information will be displayed as a blank field.
  • If your organization does not have any incentives, the "totalAmount" field will display "0".
  • The “departments” field displays the lowest level of departments registered.
  • With the plan where users can choose from "incentive" or "donation", if one of these two point exchange methods is not selected by any users, that CSV file will not contain any data.

 

About the Reflection Time of Data

Data is updated by noon on the first day of each month at the latest.

The time when the latest CSV data (up to the last day of the previous month) is available for downloading may vary from month to month due to system reasons, so if you want to see the latest data on the day of the update, please download the data after noon.

 

Relevant articles

【For admins】Why does the Point CSV include Deleted/Suspended members?

Related articles