ARENA Progress to Goal Report - GOOGLE FORM + VAN
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGH
1
2
ARENA PROGRESS TO GOAL REPORT
3
4
5
Throughout any campaign, it is important to set out a strategy with concrete goals for holding quality conversations with voters. It is equally important to measure the progress to goals to ensure the campaign stays on track and adjusts as needed. This template will help your campaign integrate your goals and outreach in one place where campaign leadership can monitor progress.
6
7
8
9
This report tracks volunteer recruitment, persuasion, turnout, and voter registration metrics. Your program may only focus on a few of these metrics, but the report is meant to be flexible enough for you to customize to your campaign.
10
11
12
To get the most out of this report, we recommend using the Arena Organizing Goals Calculating and tracking voter contact in VAN's MyVoters and volunteer engagement in VAN's MyCampaign or some type of CRM. A number of the data sheets in this tool are designed with VAN's Votebuilder in mind. If you are using a different system to track voter contact and volunteer recruitment, further customization may be necessary.


13
14
15
16
For more information on how to track your GOTV volunteers in MyCampaign please see our guide.
17
18
Copying This Workbook
19
20
< File
21
<Make copy
22
<Rename & select your personal Google Drive
23
<Select OK
24
25
Report Setup
26
27
Use this step by step guide to setup and customize your report
28
29
Copy this Google Form template to record volunteer recruitment data
30
31
Navigating Cells in This Workbook
32
Edit yellow cells to enter in your regions and assign organizers.

33
34
35
36
Edit blue cells to select your metrics and assign goals to your organizers on 'Report Setup tab' and change report view via dropdown to This Week, Last Week, and Next Week on PTG tabs.
37
38
39
40
Grey cells should not be edited. These cells contain formulas to calculate goals for each metric by organizer.
41
42
43
44
Grey cells should not be edited. These cells contain formulas to calculate metrics for This Week, Next Week, and Last Week.
45
46
47
48
Navigating Tabs in This Workbook
49
50
Report SetupContact your regions and organizers, select your metrics for volunteer recruitment, persuasion, turnout, and voter registration. Then allocate your goals to organiers.
51
52
53
54
GoalsPaste in your goals from your Arena Organizing Goals Calculator - 'Goals Export' tab here.
55
56
57
58
PTG Vol Recruitment
View the progress to your recuritment goals here This Week and Total. In use the drop down to look back at goals for last week and ahead to next week's goals.

This tab will display three precent to goal pie charts for your top three metrics and show contact rates for phonesrecuritment.
59
60
61
62
63
64
PTG PersuasionView the progress to your recuritment goals here This Week and Total. In use the drop down to look back at goals for last week and ahead to next week's goals.

This tab will display three precent to goal pie charts for your top three metrics and show contact rates for phones and doors.
65
66
67
68
69
70
PTG TurnoutView the progress to your recuritment goals here This Week and Total. In use the drop down to look back at goals for last week and ahead to next week's goals.

This tab will display three precent to goal pie charts for your top three metrics and show contact rates for phones and doors.
71
72
73
74
75
76
PTG Voter Registration
View the progress to your recuritment goals here This Week and Total. In use the drop down to look back at goals for last week and ahead to next week's goals.

This tab will display two precent to goal pie charts for your top three metrics and show voter registration collected per volunteer shift.
77
78
79
80
81
GFORM_DATAThis tabe takes data from the Form Responses tab and preps it for the rest of the report document. Column A in this sheet classifies responses as either This Week or Last Week.

Cells B2 through AB2 contain an Array Formula that graps data from the Form Responses tab. We do this to allow users to sync their own form to this report without having to recreate formula in column A or the Name Data Ranges that are used in formulas on PTG tabs.
82
83
84
85
86
87
88
89
VOLREC_VAN_DATA
Color coded blue , this is where you can paste exported canvass results data from VAN's My Campaign.
90
91
92
93
94
95
PERS_VAN_DATAColor coded red, this is where you can paste exported canvass results data that has been narrowed to your persuasion universe in VAN's My Voters.
96
97
98
99
100
Loading...
Main menu