Upload batch · Screen time, sleep and mood (pilot)

Screen time, sleep and mood (pilot)Screen time, sleep and mood (pilot)

Recruiting

Coupon file

Drop the vendor file here or choose it

CSV, TSV or pipe-separated text, UTF-8. XLSX is not read here - export the sheet to CSV first.

Or paste the rows

A file takes precedence over pasted rows. The header row is optional; a bad row is reported by its line number and never by its code.

Face value (HK$)

One value for the whole batch - not per row: a typo on line 300 of a vendor export must not pay somebody the wrong amount. Cents are allowed (50.10); left as it is, the batch is worth exactly what this study promises.

Coupon type

Defaults to what this study promises.

Load a sample file

Expected format

One coupon per line. Only the first two columns are read - the face value and the type belong to the batch, and you set them beside the file:

coupon_code: The vendor's code, at least 8 characters. Stored encrypted; a keyed hash catches duplicates without keeping a code in the clear.
redemption_link: Optional URL the participant opens to redeem. It redeems the coupon on its own, so it is encrypted too.

This study pays HK$50 as Supermarket voucher.

Separators: comma, tab, semicolon or pipe. Quotes around values are stripped.

Coupon codes in this study

19Available

20Total

New codes join the available pool immediately and are claimed in upload order when a completion is approved.

What happens to the codes

They are never listed in plaintext again. Staff and participants see a masked value; a single code can be revealed on request, and every reveal is recorded in the audit log.