> For the complete documentation index, see [llms.txt](https://docs.rafflex.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.rafflex.io/downloads-and-reports/downloads/draw-winners-export.md). # Draw Winners Export Export your main competition draw winners with the competition, prize, winning ticket, contact, address, bank details and paid status. *** The Draw Winners export gives you a record of everyone who has won a main competition draw, as a spreadsheet (CSV file). Each row is one winner and includes the competition, the prize, the winning ticket, the winner's contact and address details, their bank details, and whether you have marked the prize as paid. Use it to: * Get a list of draw prizes you still need to pay or deliver, with everything you need in one place. * Keep a record of your draw winners for your accounts or your own records. * Check a month or quarter of draws in one go. This is the main draw version of the [Instant Winners Export](/downloads-and-reports/downloads/instant-winners-export.md). One covers your instant win prizes, the other covers your main draws. To see and manage draw winners in your admin panel, see [Managing Draw Winners](/drawing-winners/managing-draw-winners.md). *** ### How to Generate 1. In the **admin panel**, open **Analytics** from the left-hand menu. 2. Click the **Download Reports** button at the top of the page. This opens the **Downloads** page. 3. Click **Data Export**. 4. Choose **Draw Winners** from the menu. 5. Set your **Date Range** and **Payment Status** (see below). 6. Click **Submit**. You will see a **Download Started** message. The export is prepared in the background, and you will receive an email when it is ready. You can also stay on the **Downloads** page and click **Download** next to the export once its status shows as complete. In the list, it appears as **Draw Winners Export**. {% hint style="info" %} **Can't see the Download Reports button?** Contact Rafflex support and we will help you get access. If you are a staff member and cannot see **Analytics** in the menu at all, your account probably has the **Restrict Financials** restriction, which blocks Analytics and all downloads. The site owner can change this, as explained in [Staff Accounts and Access](/managing-your-site/customers/staff-accounts-and-access.md). {% endhint %} {% hint style="info" %} You can have up to 3 reports being prepared at once. If you see **Report Limit Reached**, wait for one to finish before starting another. {% endhint %} *** ### Filters #### Date Range Choose one of the ready made ranges: **Last 1 Day**, **Last 3 Days**, **Last 5 Days**, **Last 7 Days**, **Last 14 Days**, **Last 30 Days** (the default) or **Last 60 Days**. To pick your own dates, choose **Custom**. Two date boxes appear, **From Date** and **To Date**. For this export, a custom range can cover **up to 6 months**. For a longer period, run the export more than once (for example one half year at a time) and combine the files. Winners are included based on the date they were **drawn**, which is when the winner was saved on your site. #### Payment Status * **All** (the default). Every draw winner in the date range. * **Paid**. Only winners you have marked as paid. * **Unpaid**. Only winners still waiting for their prize. Use this to see what you still need to pay out. {% hint style="info" %} **Draw prizes are never marked as paid automatically.** A winner only shows as paid once you mark them as paid on the **Draw Winners** page. If the **Unpaid** list contains prizes you have already sent, mark them as paid there. See [Managing Draw Winners](/drawing-winners/managing-draw-winners.md#how-to-mark-draw-winners-as-paid). {% endhint %} *** ### What's Included Each row represents one draw winner. The most recent winners are at the top. | Column | What it shows | | ----------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Winner ID** | The winner record's reference number. It matches the **Id** column on the **Draw Winners** page, so you can find the same winner there. | | **Product Title** | The competition that was drawn. | | **Prize** | The prize text, if one was entered for this winner (for example when you entered the winners by hand on the competition, or edited the winner record on the **Draw Winners** page). If it is blank, the prize is the competition itself. | | **Ticket Number** | The winning ticket number. | | **Full Name** | The name the customer saved with their bank details on their **Payouts** page. If they have not saved any, the name on their account is used instead. | | **Email** | The customer's account email address. | | **Phone** | The phone number on the customer's profile. | | **Street**, **Town**, **County**, **Postcode**, **Country** | The address on the customer's profile. | | **Bank Sortcode** | The bank sort code from the customer's payout details. | | **Bank Account Number** | The bank account number from the customer's payout details. | | **IBAN** | The IBAN from the customer's payout details, if they entered one. | | **Paid** | **Yes** if you have marked the prize as paid, **No** if not. | | **Won At** | The date and time the winner was drawn. | {% hint style="info" %} **Bank details or address empty?** These come from the customer's account. If a winner has not added their bank details yet, ask them to log in, open their account and fill in their **Payouts** page. You can also check their address and details on their customer account, as explained in [Managing Draw Winners](/drawing-winners/managing-draw-winners.md#find-the-details-you-need-to-pay-a-winner). {% endhint %} {% hint style="danger" %} **This file contains customer bank details and addresses.** Keep it somewhere secure, only share it with people who need it, and delete your copy when you have finished. You can also remove it from the **Downloads** page by clicking **Delete** next to the export. {% endhint %} {% hint style="info" %} **Sort codes or account numbers missing a leading 0?** Spreadsheet programs such as Excel often remove a 0 at the start of a number. If one looks a digit short, format that column as **Text** before opening the file, or check the details on the customer's account. {% endhint %} *** ### Related Pages {% content-ref url="/pages/aVbTKBGNRwXYAkwVukWr" %} [Managing Draw Winners](/drawing-winners/managing-draw-winners.md) {% endcontent-ref %} {% content-ref url="/pages/aiDj9iEnAczaaOKz6qNU" %} [Instant Winners Export](/downloads-and-reports/downloads/instant-winners-export.md) {% endcontent-ref %}