Setting Up Redshift With BallotReady

Setup

In order to set up your BallotReady / Redshift integration, you will need to first allow-list an IP address. In the initial sync table(s) will be created in the specified schema. 

If you are a Civis user, contact support@civisanalytics.com with your static IP. Support at Civis will need to take the following steps to enable your setup of a BallotReady sync:

  1. Allow-list the IP address provided to you by BallotReady in your Redshift cluster. 

  2. Create a Redshift user with permissions to read, write, and create tables in the destination schema.

    1. For tighter security, you can use a specific schema for this data and only give permissions to that schema. If you do, make sure to send the schema name along with permissions.

  3. Use a onetimesecret to securely share the username, password, and cluster connection string (JDBC URL) with BallotReady.

    1. By default the data will be written to the public schema. If you would like the table to be created somewhere else, provide the destination schema to BallotReady.

Usage

How often will the data sync?

The data will sync to Redshift hourly.

What should I expect to see in Redshift?

This sync will create two tables, one of user data and one with user actions. Depending on the BallotReady integrations you set up, this sync may include a third table with related IDs.

The events captured from BallotReady depend on the customized flow you have set up. Events will be added as BallotReady releases new features. Check here to see the most up to date list of events included as a part of this integration.

The three tables you will see in Redshift are outlined below:

Person data

Field

Description

Sample value

person_id

Maps to person_id in the event table

773985ac-a492-4a4e-8147-9a92a89adf6f

ballot_id

Unique ID assigned by BallotReady

6870051

first_name

First name

Anna

last_name

Last name

Smith

address_line1

address

411 N 114th St

address_line2

address

Omaha, NE 68154

city

city

Omaha

state 

state

NE

zip

zipcode

68154

phone

phone number 

14105678989

email

email

anna@gmail.com

Events data

Field

Description

Sample Value

event_id

Unique event ID

97c451ab-cc7f-492d-b74d-f09bae90304a

person_id

Maps to person_id in the person table

773985ac-a492-4a4e-8147-9a92a89adf6f

event_tag

BallotReady event 

VoteByMail - Complete - Signed

properties

This field may include IDs from Targetsmart or properties that further define the event

{"voter_id": “12323606”, "voterbase_id": "AA-19786660", "accepts_digital_signature":true}

created_at_utc

Timestamp of the event 

2020-08-17T15:09:43.513439

url

The event took place on this page

https://www.ballotready.org/ec/pledge

browser_name

Browser name

chrome

browser_os

Browser information

Mac OS

browser_version

Browser information

84.0.4147

initial_url

URL the user arrived from

ballotready.org

utm_source

UTM data

facebook

utm_medium

UTM data

cpc

utm_campaign

UTM data

nationalregistrationday

utm_term

UTM data

vote+registration

utm_content

UTM data

flag

screen_height

Height in px

768

viewport_width

Width in px

2049

viewport_height

Height in px

985

External IDs 

Field

Description

Sample value

person_id

Matches lookup_id

773985ac-a492-4a4e-8147-9a92a89adf6f

source

The source of the ID

VAN:myCampaign

identifier

The ID

1238929



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.