DocsUse CasesCreator GuideIntegration Guide

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","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"
    }
]