The name, email, phone and other answers players type into the Input Form are saved together with the match and downloaded as Excel from the web panel in your activationking.com account. This article explains where the information goes, when it reaches the cloud, where the Excel is downloaded from, which columns it contains and what happens without internet.
- The moment a player presses I'm ready, their answers are written to the device; with internet, they reach the cloud within seconds.
- There is no Excel or CSV download inside the app. Exporting is done from the activationking.com web panel.
- In the web panel, Events → event → More → Export leads downloads an Excel file. Each player is a separate row.
- The Excel contains your form fields, score, match duration, date and the privacy consent (GDPR) time. Dates are UTC.
Where the information goes
Form answers
You decide which information is asked in the Session → Survey tab; both players fill in the same form. When a player presses I'm ready on their card, that player's answers are written to the device immediately. The two players sit separately inside the same match record; one's answers are not written over the other's.
Each answer is stored under the visible name you gave the field. If you typed Your email address for the field in the Survey tab, the column heading in Excel is also Your email address. A field left empty is not saved.
For a player who presses Skip for now, no answer is written; that player does not appear in Excel. This button only appears when the form has no required field at all. When Cancel is pressed, the match is cancelled, but the answers of a player who already said I'm ready stay in the record and come into Excel; the score and duration cells are empty.
Details: the article How to Collect Names and Consent from Players?
Going to the cloud
If the device is connected to the internet, sending is triggered right after every record; the answers and the match result are in the cloud within seconds. The web panel only shows records that have reached the cloud. The event itself must also have gone to the cloud at least once; the matches of an event created without internet and never connected do not match the event and do not appear in the export. Create the event while you have internet.
If you use the same event on several devices, the players of all devices are gathered in a single Excel.
Privacy consent (GDPR)
While Disclaimer is on, each player card has a consent checkbox, and I'm ready does not work until the box is checked. The moment the box is checked is recorded and appears in Excel in the Consent (UTC) column. The consent time is a single value per match: since both players consent, the record holds the moment of the last consent given, so the same time is written in both players' rows.
When consent is given, the text itself is not saved. If you change the Disclaimer text during the event, the record cannot tell which consent was given to which text; note down yourself when you changed the text. If Disclaimer is off, consent is not asked and this column stays empty. Since the consent checkbox is inside the form, consent is not asked while Survey is off either.
Is there an export inside the app
No. The only place in the app that shows player information is the Session → Matches tab; names and scores are visible there, and a match can be hidden from the guest screen, but no file can be downloaded. Excel only downloads from the web panel. Hiding a match with Hide does not remove it from Excel; the players of a hidden match are also in the file. Details: the article How to Manage the Match List?
Downloading Excel from the web panel
Steps
- Open activationking.com in a browser and sign in with the account you use in the app.
- Go to the Events page from the left menu. The page's description reads Events you've created in the apps. Since game events have no photos, the media count on the card looks empty; this is normal.
- Click the event's card; the event page opens.
- Open the More menu at the top right and click Export leads. The Excel file downloads. The file name starts with leads_ and carries the event ID and the date; the sheet inside is named Leads.
If no player has reached the cloud yet, no file downloads and the note No lead data captured for this event yet. appears on the page; this is not an error. If the file cannot be produced, the warning Could not export lead data. Please try again. appears; try again after a while.
The structure of the Excel
Each player is a separate row; the two players of a match come one below the other. The columns in order:
| Column | Content |
|---|---|
| SessionId | The match ID. The two players of the same match carry the same value; you match up matches by it |
| Player | 1 = Player 1 (X), 2 = Player 2 (O) |
| Your form fields | One column with the name you gave in the Survey tab. An answer left empty is an empty cell. Multiple-choice answers are separated with commas |
| Score | The number of rounds that player won. 0 is a real score |
| Duration (s) | The duration of the match, in seconds. Same for both players |
| Date (UTC) | The moment the match started |
| Consent (UTC) | The moment of the privacy consent. Same for both players |
What you need to know:
- The SessionId, Player, Score, Duration (s), Date (UTC) and Consent (UTC) headings are in English and fixed; they do not change with the web panel's language. The form columns are the labels you wrote.
- The Player, Score, Duration (s) and Consent (UTC) columns only come if they exist in the data. In an event where no consent was ever collected, there is no Consent (UTC) column.
- The date and consent times are UTC. Add your own time zone offset (for example, 3 hours for Türkiye). In Excel you can select the column and change the time format; the value comes as a date.
- In a game cancelled before the match ended, a player who said I'm ready appears in a row, with the Score and Duration (s) cells empty.
- If you change a form label in the middle of the event, the old and new labels become two separate columns. If you give two fields the same label, the answers merge into one column. Decide on the labels before the event starts.
- The file is a snapshot. Download it again for new players; the old file does not update by itself.
Games before the update
Games played before this app update do not appear in Excel; the previous version did not mark the match as "has a form", and the export does not pick up those records. Every match played after the update comes into the file. In records from the old version, the Consent (UTC) column is also empty.
Without internet
The game is played without internet; the form answers and scores pile up on the device. When the connection returns, the piled-up records are sent in order; even if the app closes and reopens in between, sending continues where it left off. These records only enter Excel after the cloud has received them. So if there is no internet during the event, do the export a few minutes after the connection returns. When you close the stand, wait a few seconds with internet connected before closing the app, so that the last match goes through.
The app does not show how many records are waiting. If you compare the number of players in Excel with the number of matches in the Session → Matches tab, you can tell whether anything is missing: each match gives at most two rows.
Looking for an Excel or CSV button in the app: there is none. The export is in the web panel.
Turning off Session → Survey and expecting information: the form does not appear, not even the name is asked, and the players of those matches are not in Excel.
Making no field required: the Skip for now button appears and the player who skips does not appear in Excel. Leave at least the name field required.
Changing a form label in the middle of the event: the same information is split into two columns.
Taking the times in Excel for local time: they are UTC; add your own time zone offset.
Closing the stand without internet: the players of the last matches cannot go to the cloud and are missing from Excel. They are completed if the app is opened when the connection returns.
Looking for old players: games before the update do not come into the file.
