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

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","john.doe@example.com"
"8eaf7fab-7ee3-416e-ab13-1501d1b52717","250","RWC Competition Form","2023-11-07T11:30:00Z","6f508617-0a4f-4953-9e2d-925c10ffec67","92","Yes","Jane","Smith","jane.smith@example.com"
"27e21f6c-0b8e-4e89-bc22-6e499f61142c","420","RWC Competition Form","2023-11-07T12:45:00Z","8c6e1a86-581e-4fa5-92e7-905c61a4efb6","78","Yes","Michael","Johnson","michael.johnson@example.com"
"d3291944-1d88-4686-8f16-7d0de6bb17d8","165","RWC Competition Form","2023-11-07T14:00:00Z","e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb","70","Yes","Sarah","Williams","sarah.williams@example.com"
"6f508617-0a4f-4953-9e2d-925c10ffec67","303","RWC Competition Form","2023-11-07T15:15:00Z","27e21f6c-0b8e-4e89-bc22-6e499f61142c","88","Yes","David","Anderson","david.anderson@example.com"

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": "john.doe@example.com"
    },
    {
        "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": "jane.smith@example.com"
    }
]