Form entries dataset
Holds all user entries to competition forms/sweepstakes
Table name: customer_schema.silver_form_entries
Data source: Monterosa Forms
Update method: Batch
Update frequency: TBD
See Monterosa Identifiers for details of the IDs used in this dataset
Column | Type | Description | Example |
project_id | string | Unique Project identifier | [uuid] |
form_id | string | ID of form in Studio | 153 |
form_name | string | Label of form in Studio | Sweepstakes_20231028 |
entry_datetime | timestamp | Timestamp of the form entry | 2023-10-27 21:39:00.000 |
user_id | string | Monterosa User identifier Can be matched with silver_users table for users in the same project | [uuid] |
user_score | string | Points scored in previous Experience, where relevant | 5 |
agree_terms | string | User has agreed to terms and conditions | Yes |
[first_name] | string | Additional PII fields depending on form configuration | |
[last_name] | string | Additional PII fields depending on form configuration | |
[email_address] | string | Additional PII fields depending on form configuration |
Sample CSV data:
Sample JSON data: