Every spin produces a record: what the guest wrote in the input form, the prize they won, the prize's code and, if there is one, the time of the privacy consent. This record is stored on the device, goes to the cloud when there is internet, and shows up in two places: in the Winners tab of Session (to see who won what) and on the event page in your activationking.com account (to download as Excel). This article explains when the record is created, where it appears and how it is exported.
- The record is completed the moment the wheel stops and the prize is determined. A round that is abandoned does not enter the list.
- In the Winners tab of Session you remove a record from the list with Hide; there is no delete, and it comes back with Show. Hiding does not put the prize back into stock.
- The list is event-wide: the winners of all devices using the same event are in a single list.
- The form answers are not shown in the app. For Excel, open the event on activationking.com, More → Export leads.
When the record is created
A game's record chain
- When the guest presses the button on the Welcome screen, a new record is opened. An event must be selected for this; when there is no event the wheel spins but the winner is written nowhere.
- When Continue is pressed on the input form, the answers are written into the record. If the consent checkbox is asked, the moment consent was given (UTC) is also saved.
- When the wheel stops, the prize won and its code are written, the record is completed and sent to the cloud. This is the moment it enters the list.
- If the guest presses Cancel, the inactivity timeout runs out, or the guest walks away, the record is closed as cancelled and does not appear in any list.
- If the app closes in the middle of a game, the unfinished record counts as cancelled at the next launch.
- If the guest skips the form with Skip for now, the wheel is still spun; the winner appears in the list without a name.
If the input form is asked after the wheel (Session → Survey → When to Show Survey → After Capture), the prize is written first and the name and answers are added to the same record afterwards.
The operator list
Session → Winners
This tab lists everyone who won a prize at the event, newest first; the winners on other devices are here too. The list is read once when the tab opens; the Refresh button brings the current state.
| Column | Content |
|---|---|
| Name | The name from the form; if there is no name, Guest · 4F2A (four characters derived from the record's ID) |
| Prize | The name of the prize won |
| Code | The prize's code; a dash if there is no code |
| Won at | The moment the wheel stopped, in the device's local time |
| Button | Hide or Show |
Sorting is by time: the latest winner is at the top.
Hide removes a test spin or an inappropriate name from the list. The row stays faded in the list and comes back with Show. There is no delete, and hiding does not put the prize back into stock; to undo the stock deduction of test spins, use Reset counter in the Prizes tab of Session. Hiding is passed on to the other devices using the same event. If there are no winners yet, it says No prizes have been won yet.
There is no export of the winners list or form answers inside the app; for CSV or Excel see the web dashboard section below.
Multiple devices and internet
Multiple devices in the same event
If you run the same event on several devices, each device sends its own records to the cloud and pulls the others'. The Winners tab shows them all together, and the prize quantities are counted jointly for all devices. A prize won on another device shows up on this device in about half a minute; because of this delay two devices can give out the last prize at the same time and the quantity can be exceeded by one or two. A record you hide on one device is hidden on the others too.
Without internet
The record is written to the device first; if there is no internet it waits and is sent when the connection returns. The winners on this device appear in the list immediately; those of other devices do not arrive until the connection returns, and the prize quantities are not updated between devices. Without internet the QR may not appear on the prize panel; the code is still shown as text. When the app is closed it allows only a few seconds for pending uploads; to avoid losing the last record, wait for the connection before closing. If there was no connection at all when you created the event, the event has not been introduced to the cloud; the records on that device do not reach the other devices or the web dashboard. It is enough to open the event once while online.
The web panel and Excel
Export leads
The form answers are not listed on any screen in the app; you download them from the web panel. Sign in to activationking.com with the account from the app, open the event from the Events page, click Export leads in the More menu at the top right. An Excel file downloads. If no form has been submitted in this event yet, the note No lead data captured for this event yet. appears instead of the file. Download Media on the same page is for photos; there is no media in Spin Wheel.
Every spin is a row in the file. The columns come if they are in the data:
| Column | Content |
|---|---|
| SessionId | The game's record number |
| Form fields | One column per field; the heading is the label you wrote in Session → Survey, the cell is the guest's answer |
| _prize | The name of the prize won |
| _prizeCode | The prize's code; empty for a prize without a code |
| _prizeId, _stockEpoch | The app's internal records; ignore them |
| Duration (s) | The wheel's spin time, in seconds |
| Date (UTC) | The moment the game started |
| Consent (UTC) | The moment the consent checkbox was checked; empty if consent was not asked |
Only spins where the input form was on and the form was submitted go into the file: if Session → Survey is off, or the guest skipped the form with Skip for now, that spin is not in the Excel; the winner is still in the Winners list. Spins made before this update of the app do not appear in the file.
Looking for an abandoned round in the list: only rounds where the wheel stopped are recorded.
Looking for a delete button in the Winners tab: there is no delete, use Hide.
Opening the game without selecting an event: the wheel spins but the winner is written nowhere.
Looking for the form answers in the app: the answers are only in the Excel file in the web panel.
Turning off the survey and expecting rows in Excel: while the survey is off, spins do not go into the file.
Thinking that Hide puts the prize back into stock: it does not. To get the stock back: Session → Prizes → Reset counter.
Related topics
How to Get Spin Wheel Ready for an Event? What Does the Guest See? One Game from Start to Finish How to Collect the Guest's Name and Consent? How to Set the Screen Texts and Buttons? How to Set Up the Event Settings? PIN, Timeout, Language and Multiple Devices Common Problems and Their Solutions
