Exporting Raffle Results & Reports

How to export results for your raffle. (Customer Email Lists)

Do you want to check out how your raffle is doing? Or need to provide compliance reports to your province's gaming authority? 

Log into your Trellis account and into your Raffle Builder tab.

 

Along the top of the page is an Export Results button.

 

Click that and choose what kind of Export you'd like and the date range :)

 

  • Standard Event Report one line summary of entire draw.

    • Organization Name

    • Licensee ID

    • Licensee Name

    • Draw ID

    • Draw Name

    • Draw Date

    • Ticket Sales Start Date

    • Ticket Sales End Date

    • Draw Numbers in Play Count

    • Number of Void Requests

    • Dollar Amount Refunded

    • Number of Reprint Requests

    • Total Dollar Value

    • Winning Draw Number Winner

    • Claim Status

    • Prize Name

    • Monetary Value

    • Cash Alternative

    • Base Payout

    • Prize Amount (50/50)

    • Revenue Retained by Licensee (50/50)

     

  • Ticket report gives you a list of every single ticket sold individually

    • Counterfoil ID Raffle

    • Ticket Name

    • Draw Number

    • Ticket Price

    • Pack Purchased

    • Purchased At (Date & Time)

    • Number of Reprint Requests

    • Purchaser Name

    • Purchaser Email

    • Purchaser Phone Number

    •  

  • Sales Summary gives you a summary of how many of each kind of ticket package was sold.

    • Ticket Pack ID

    • Ticket Pack Price

    • Number of Tickets in Pack

    • Individual Ticket Price

    • Number of packs sold

    • Number of Individual Tickets Sold

    • Issued Draw Numbers

    • Number of Void Requests

    • Voided Draw Numbers

    • Number of Reprint Requests

    • Total Dollar Value

  • Voided Report contains voided raffle tickets.

    • Counterfoil ID Draw Number

    • Validation Number

    • Voided At (Date & Time)

       

How to export the list of raffle purchasers with their email addresses.

You can run a report of who has bought tickets in order to update them on the raffle progress, upcoming draws, or results. Here's how: