Arena GOTV Shift & Packet Report
|GOTV Shift & Packet Report is a document that will help your campaign stay on track hour by hour throughout GOTV. This document will help you track volunteers and your packets and distrbute resources effectively. |
This document interacts with data entered by Staging Location Directors and Field Organizers via a Google Form to track shifts and packets from each staging location.
|This report tracks shifts day by day at the staging location level. Each staging location will be responsible for entering their numbers at the start of every shift.|
|This report also takes data that you track in VAN's MyCampaign adds it to the report so that you can compare the number of expected shifts throughout the day to judge whether a Staging Location is on track to walk or call all its packets.|
For more information on how to track GOTV shifts see our GOTV shift tracking guide.
Guidance on how organizers and volunteers can use the form to report on shifts & packets
Here is an example form you can link to this report.
|On the GOTV Setup tab, enter in your dates for GOTV, shift times, name of staging locations, and organizers assigned to each Staging Location. |
On the GOTV Report Detailed tab in columns I-J, enter the number of packets for canvassing and calling available at each Staging Location.
Export VAN shift data from MyCampaign into VAN Shift Export tab.
Customize Google Form, and connect form data to the Form Responses Tab.
See this guide for more details on editing Google form.
Linking your form to this report
After you copy and save this spreadsheet to your drive
|Create your Form|
Open a form in Google Forms.
- At the top, click Responses.
|- Below, click More|
- Click Select response destination
- Choose from the following option:
- Select existing spreadsheet: Choose from your existing spreadsheets in Google Sheets to store responses
|- Click Select|
Copying This Workbook
<Rename & select your personal Google Drive
Navigating Cells in This Workbook
|Use all enter in your dates for GOTV, shift times, number of packets, name of staging locations, and organizers assigned to each staging location.|
|Enter the current day of GOTV on GOTV Report Detail tab to get up to date shift information by staging locations|
|Grey cells should not be edited. These cells contain formulas to calculate the state of the race. |
Navigating Tabs in This Workbook
|GOTV Setup||Enter in your Shift times, GOTV Staging Locations, and the Organizers assigned to each location. |
This tab will also show day by day cumulative totals for walk and call packets out the door.
GOTV Report Detail
|This displays GOTV shift, scheduled, and packet data by staging location for the current day of GOTV. |
The report also shows which Staging Locations are opened, and who are submitted reports for a given shift time.
On this tab in columns I & J, you will entered the number of packets for Walk and Phone calls by staging location. This infromation will help estimate doors that have been and remain to be walked.
GOTV Shift Summary
|Shift Totals for the selected GOTV day for Walk, Phone, and Text data that has been schedule and reported.|
GOTV Daily Summary
|Daily totals for each day of GOTV for Walk, Phone, and Text data that has been scheduled and reported.|
|Form Responses||Shift data reported from Staging Locations by Organizers or Staging Location Directors.|
|VAN Shift Export||Scheduled volunteer data by shifts scheduled in VAN's MyCampaign Calendar.|
Paste exported csv into this tab
Helpful Tips in the Doc
|Where you see the "+" sign you are able to expand rows vertically and horizontally to show more data or helpful tips about the doc.|