CSV export is available on the Pro plan for entries and winners. Exports run in the background and the completed file is made available when processing finishes.
Export entries
- Open the contest.
- Go to Results.
- Click Export CSV in the entries area.
The entries file includes:
- Contact and entry details: Email, optional Name and Phone, Entry Date, Source, UTM fields, Customer ID, and Surface.
- Contest outcome fields: Total Entries when bonus actions are configured and Winner.
- Entry state: Entry Status, which shows whether the entry is confirmed or still pending required actions.
- Consent evidence: Email Marketing Consent, Email Marketing Consent At, SMS Marketing Consent, SMS Marketing Consent At, Marketing Consent Source, and Marketing Consent Version.
Consent values are Yes only when the entrant opted in. The timestamp records when consent was captured; source and version identify the contest surface and disclosure shown at that time.
Export winners
Use the winner export action for a file containing:
- The winner's contact details, total earned entries when applicable, prize, selection method, selection time, notification and claim timestamps, and notes.
- Winner lifecycle fields: Winner Status, Invalidated At, and Invalidation Reason.
- Prize redemption fields: Redemption Status, Fulfillment Mode, Claim Submitted At, Declined At, and Shopify Order.
- The underlying entry status and the same email/SMS consent evidence included in the entries export.
Selection method is recorded as Random draw, Manual selection, or Most votes.
Use consent fields before marketing imports
Before importing entrants into an email marketing platform, filter the file to rows where Entry Status is confirmed and Email Marketing Consent is Yes.
Before importing phone numbers into an SMS platform, filter to rows where Entry Status is confirmed and SMS Marketing Consent is Yes.
The exported consent fields help you identify what UserLoop recorded, but you remain responsible for applying the legal and platform requirements that apply to your marketing activity.
Other common uses
- Prize fulfillment and winner outreach.
- Campaign acquisition analysis.
- Compliance and internal record keeping.
Handle exports securely
CSV files contain decrypted personal information. Restrict access, store them securely, avoid unnecessary sharing, and delete them in accordance with your privacy and retention policy.
Spreadsheet software can interpret values beginning with formula characters. UserLoop escapes potentially dangerous formula-like fields in generated files, but you should still open untrusted exports cautiously and avoid re-enabling formulas in entrant-supplied data.