The following table describes the fields in the Experience Audience Export.
Column | Description |
---|---|
experience_name | The name of the experience |
experience_code | The experience code |
player_id | A unique Player ID (participant ID) |
first_name | A participant's first name |
last_name | A participant's last name |
A participant's email address | |
email_marketing_consent | "1" if a participant opted in to marketing; otherwise "0". This field is due to change to just marketing_consent. |
team_id | A participant's team ID |
team_name | A participant's team name |
team_score | The total score of a participant's team |
player_score | The participant's individual score |
answer_count | The number of engagements a participant has made (i.e. votes and answers). |
logged_in_at | The time a participant first joined the experience |
first_answer_at | The time of a participant's first engagement |
last_answer_at | The time of a participant's last engagement |