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:

"project_id","form_id","form_name","entry_datetime","user_id","user_score","agree_terms","first_name","last_name","email_address"
"e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb","398","RWC Competition Form","2023-11-07T10:15:00Z","30e560e7-4528-4c4c-8725-657bec61a6e1","85","Yes","John","Doe","[email protected]"
"8eaf7fab-7ee3-416e-ab13-1501d1b52717","250","RWC Competition Form","2023-11-07T11:30:00Z","6f508617-0a4f-4953-9e2d-925c10ffec67","92","Yes","Jane","Smith","[email protected]"
"27e21f6c-0b8e-4e89-bc22-6e499f61142c","420","RWC Competition Form","2023-11-07T12:45:00Z","8c6e1a86-581e-4fa5-92e7-905c61a4efb6","78","Yes","Michael","Johnson","[email protected]"
"d3291944-1d88-4686-8f16-7d0de6bb17d8","165","RWC Competition Form","2023-11-07T14:00:00Z","e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb","70","Yes","Sarah","Williams","[email protected]"
"6f508617-0a4f-4953-9e2d-925c10ffec67","303","RWC Competition Form","2023-11-07T15:15:00Z","27e21f6c-0b8e-4e89-bc22-6e499f61142c","88","Yes","David","Anderson","[email protected]"

Sample JSON data:

[
    {
        "project_id": "e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb",
        "form_id": "398",
        "form_name": "RWC Competition Form",
        "entry_datetime": "2023-11-07T10:15:00Z",
        "user_id": "30e560e7-4528-4c4c-8725-657bec61a6e1",
        "user_score": "85",
        "agree_terms": "Yes",
        "first_name": "John",
        "last_name": "Doe",
        "email_address": "[email protected]"
    },
    {
        "project_id": "8eaf7fab-7ee3-416e-ab13-1501d1b52717",
        "form_id": "250",
        "form_name": "RWC Competition Form",
        "entry_datetime": "2023-11-07T11:30:00Z",
        "user_id": "6f508617-0a4f-4953-9e2d-925c10ffec67",
        "user_score": "92",
        "agree_terms": "Yes",
        "first_name": "Jane",
        "last_name": "Smith",
        "email_address": "[email protected]"
    }
]