Data dictionary: Hopper sync
This document contains the column names and descriptions for data synced from VoteAmericaPlus to Hopper by Community Tech Alliance.
The Hopper team can work with you to transform this data into a format that suits your destination tool. Learn more here about the Hopper sync.
Data for all VoteAmericaPlus tools are pushed to Hopper as part of a unified schema. Because different tools collect different information, some columns will have NULL values for tools where they do not apply. The table below includes a column to indicate which VoteAmericaPlus tools collect the data.
| Column title | Description | Tools collecting this data |
|---|---|---|
| tool | The VoteAmericaPlus tool where this action occurred. Options: absentee, futurevoter, locate, pledge, register, remind, upcoming, verify | All |
| subscriber_slug | An identifier for the subscriber / customer | All |
| uuid | The ID we store internally for the action | All |
| subscriber_name | The name of the subscriber (i.e. your customer name) | All |
| subscriber_id | VoteAmerica’s internal identifier for the subscriber / customer | All |
| created_at | The date and time when data for this action was first submitted, in UTC | All |
| updated_at | The date and time when this action’s data was last updated, in UTC | All |
| first_name | The user’s first name | absentee, futurevoter, pledge, register, remind, verify |
| last_name | The user’s last name | absentee, pledge, register, remind, verify |
| date_of_birth | The user’s date of birth | absentee, futurevoter, pledge, register, remind, verify |
| The user’s email address | absentee, locate, pledge, register, remind, upcoming, verify | |
| phone | The user’s phone number | absentee, locate, pledge, register, remind, upcoming, verify |
| address1 | The user’s address1 | absentee, locate, pledge, register, remind, upcoming, verify |
| address2 | The user’s address2 | absentee, locate, pledge, register, remind, upcoming, verify |
| city | The user’s city | absentee, locate, pledge, register, remind, upcoming, verify |
| zipcode | The user’s zipcode | All |
| state_id | The 2-letter code for the user’s state | All |
| sms_opt_in_subscriber | True/False if the user opted into the subscriber’s SMS list | absentee, locate, pledge, register, remind, upcoming, verify |
| source | The ?source= query param | All |
| utm_source | The ?utm_source= query param | All |
| utm_medium | The ?utm_medium= query param | All |
| utm_campaign | The ?utm_campaign= query param | All |
| utm_content | The ?utm_content= query param | All |
| utm_term | The ?utm_term= query param | All |
| embed_url | The URL of the page where the tool was embedded | All |
| session_id | The ID of a user’s session. For tracking users across multiple tools or visits. | All |
| status | (DEPRECATED) Indicator of an action’s status for multi-step flows | All |
| finished | For tools that involve submitting data to an election office, this indicates the user has (1) clicked a link to visit a state site where they can complete the task, (2) emailed themselves a paper form to complete the task and downloaded it at least once, or (3) (DEPRECATED) had their PDF submitted by VoteAmerica to their Local Election Official | absentee, register, futurevoter |
| self_print | If the user has emailed themselves a printable customized ballot request form (for absentee tool) or registration form (for futurevoter or register tool) | absentee, register, futurevoter |
| finished_external_service | If the user clicked a link to visit their state’s ballot request portal (for absentee tool) or online voter registration portal (for futurevoter or register tool) | absentee, register, futurevoter |
| leo_message_sent | (DEPRECATED) If VoteAmerica’s toolset directly submitted the ballot request (for absentee tool) or registration form (for register tool) to the user’s Local Election Official | absentee, register, futurevoter |
| total_downloads | For users who have emailed themselves a ballot request or registration form, the number of times they clicked “download” in their email | absentee, register, futurevoter |
| referring_tool | For users who were linked to this tool by another tool, the name of that referring tool | absentee, register, futurevoter |
| registered | For verify actions, whether VoteAmerica’s data provider indicated that the user has an active registration | verify |
| unstructured_address | The full, unstructured address provided by the user | locate |
| register_confirmed | If a futurevoter user has confirmed that they are registered to vote after receiving a reminder that they are now old enough to do so | futurevoter |
| last_preregistration_message | The date and time when a futurevoter user last received an SMS message indicating they are now old enough to pre-register to vote | futurevoter |
| last_drip_message | The date and time when a futurevoter user last received an SMS message reminding them to check their registration now that they have turned 18 | futurevoter |