Campaign Codes

Export the redemption codes tied to a specific campaign as a CSV file — useful for auditing code usage or reconciling stock of codes issued outside Open Loyalty.

File format: CSV

Sample CSV file

Campaign Codes Sample Export.csv

9KB

Open

codeId,code,status,createdAt,usedByMemberId,usedAt
6f29398a-f49d-4d3e-92a8-20118dbe4773,CNDG3W5D65AS,unused,2026-03-10T04:32:08+01:00,,
735aa96d-65fc-46a1-8dd2-d43c6235c52b,5ZMFNF7QFJ3Z,unused,2026-03-10T04:32:08+01:00,,

Field reference

Field	Description
codeId	Open Loyalty UUID for the code
code	The redemption code string
status	unused once generated/uploaded; changes once a member redeems the code
createdAt	Timestamp the code was generated or uploaded (ISO 8601, with offset)
usedByMemberId	UUID of the member who redeemed the code — empty while unused
usedAt	Timestamp the code was redeemed — empty while unused

The sample above only shows the unused state. usedByMemberId and usedAt populate once a member redeems the code — confirm the exact status value used for redeemed codes against your own export if you're building automation around this field.

How to export

Codes are exported per campaign, from the campaign's redemption codes list. Once scheduled, the export appears in Imports & Exports → Exports for download, like other report exports.