Where Do Scores and Participant Data Go?

Published · Updated

Every game produces a record: what the guest typed into the input form, their score, their time and, if any, the time of the privacy consent (GDPR). This record is stored on the device, goes to the cloud when there is internet, and meets you in three places: in the Session → Scores tab (to manage), on the Scoreboard screen the guest sees (for ranking) 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.


i
In short
  1. The score is saved the moment the game ends. An abandoned game does not enter the board.
  2. In the Session → Scores tab you remove a record from the guest board with Hide; there is no delete, it comes back with Show.
  3. The scoreboard is event-wide: the games of all devices using the same event are ranked in a single list.
  4. 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 touches the welcome screen, a new record is opened. An event must be selected for this; without an event the game is played but the score 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 game ends, the score and the game time are written, the record is completed and sent to the cloud. This is the moment it enters the board.
  • 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 game is still saved; it appears on the board without a name.

If the input form is asked after the game (Session → Survey → When to Show Survey → After Capture), the score is written first, and the name and answers are added to the same record afterwards.

The operator list


Session → Scores

Under the Leaderboard entries heading, all of the event's completed games are listed; the games from the other devices are here too. The list is read once when the tab opens; the Refresh button brings the current state.

ColumnContent
RankThe rank on the guest board
NameThe name from the form; if there is no name, "Guest · 4F2A" (four characters derived from the record's ID)
TimeThe game time, minutes:seconds; a dash if unknown
ScoreThe game's score
ButtonHide or Show

The ranking is the same as on the guest screen: higher score at the top, shorter time at the top on equal scores, unknown time at the very bottom.

Hide removes a trial game or an inappropriate name from the guest table. The row stays in the list faded, and Show brings it back. There is no deletion; the note at the bottom of the tab says so: Hidden entries stay in the records and sync; they just do not appear on the guest screen. Hiding also goes to the other devices using the same event. If there is no game yet, it reads No scores yet for this event.

There is no export of scores or form answers inside the app; for CSV or Excel, see the web panel section below.

The guest board


Scoreboard screen

The guest reaches the table in three ways: the View scores button on the Thank You screen, the trophy icon on the Thank You screen and the trophy icon on the Welcome screen (without starting a game).

  • The first three players stand on the podium; the first in the middle and highest. The podium shows rank, name and score.
  • From fourth place on comes the table: #, Player, Time, Score. The table is paged by 10; the Previous / Next buttons only appear if there is more than one page, and turning a page restarts the inactivity counter.
  • The game the guest just played is shown in the table with a colored row and the you marker. The marker is in the table rows; it is not shown on the podium.
  • If the game's record did not land in the list (for example if no event is selected), the guest's score is still placed in its own rank and shown.
  • If no name was collected, the row reads "Guest · 4F2A".
  • If there are no games at all, No scores yet and Be the first to play. are shown.
  • Back returns to the welcome screen. The inactivity timeout runs on this screen.

The board's texts and column names are changed in the Game Screens → Scoreboard tab. Details: the article How to Set the Screen Texts and Buttons?

Multiple devices and internet


Multiple devices in the same event

If you run the same event on several devices, every device sends its own games to the cloud and pulls the others' games. The scoreboard and the Scores tab show all of them together. A game finished on another device appears on this device within half a minute at most; if two stands are side by side, you may notice this short delay. A record you hide on one device is hidden on the others too.

Without internet

The record is first written to the device; if there is no internet, it waits and is sent when the connection returns. The games played on this device appear on the board right away; the other devices' games do not arrive until the connection returns. When you close the app, only a few seconds are allowed for pending sends; to avoid losing the last game's score, wait for the connection to return before closing. If there was no connection at all when the event was created, the event has not been introduced to the cloud; the games on that device do not reach the other devices or the web panel. It is enough to open the event once while you have internet.

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 Counter Reflex Game.

In the file, each game is one row. The columns come if they exist in the data:

ColumnContent
SessionIdThe game's record number
Form fieldsOne column per field; the heading is the label you wrote in Session → Survey, the cell is the guest's answer
ScoreThe game's score: the total points of all rounds
Duration (s)The game time, in seconds (one decimal)
Date (UTC)The moment the game started
Consent (UTC)The moment the consent checkbox was checked; empty if consent was not asked

Only games where the input form was on and submitted enter the file: if Session → Survey is off or the guest skipped the form with Skip for now, that game is not in Excel; its score is still on the scoreboard. Games played before this update of the app do not appear in the list.

!
Common mistakes

Looking for an abandoned game on the board: only finished games are saved.

Looking for a delete button in the Scores tab: there is no delete, use Hide.

Opening the game without selecting an event: the game is played but the score 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, games do not enter the file.

Was this article helpful?

Not sure where to start? We can help.

Tell us about your project. Our team will help with the next step.

By submitting, you agree to our Terms and Privacy Policy.