We convene, train, and support the next generation
of candidates and campaign staff.
Arena Snapshot Quick Guide
|The Snapshot spreadsheet is a dynamic tool designed to synthesize all available data related to a campaign. This information can include, but is not limited to the current number of registered voters, past and future (modeled) turnout levels, partisan support breakdown, and previous election results in a given political geography.|
|The Snapshot calculates what would happen if the election were held today and estimates how far you are from achieving 51% of the vote in a district.|
|In addition to understanding how many votes stand between you and victory, the Snapshot allows you to simulate the effects of a targeted, programmatic campaign on the electorate.|
For more information on how to use a snapshot see our guide.
|How It Works|
|The data in this template is just example data. Upload data from your VAN or voterfile to the Arena Snapshot PivotTable Excel (link below) sheet to update this template with information for the desired district.|
Once your update the Arena Snapshot PivotTable Excel doc use the numbers from this document to update the District Overview tab of this Google Sheets document.
Links below go into detail about how to update this document with your own data.
How-to Build Your Own Snapshot
Pivot Excel Workbook
Copying This Workbook
< Sign into your Google account
<Rename & select your personal Google Drive
Navigating Cells in This Workbook
|Light Blue cells should be edited to create pathway to victory scenarios.|
|Blue cells can be edited to update registration, turnout, and polling data from the Arena Snapshot Pivot Excel document. Or, you can update the District_Overview tab manually, using election results from the Secretary of State.|
|Grey cells should not be edited. These cells contain formulas to calculate the state of the race.|
Navigating Tabs in This Workbook
|Pathway_to_Victory||Shows current voterfile for the district, population counts based on demographics, past voter registration numbers, and modeled or polling averages. Enter data from the pivot table excel workbook into light blue cells. . Formulas in the grey cells calculate pathway to victory and program numbers.|
|District_Overview||Contains key dates related to your election, past elections results for the district, as well as related elections results, which can provide helpful insights as you create a pathway to victory for your campaign.|
Helpful Tips in the Doc
|On the Pathway_to_Victory Tab rows 7, 19, and 27 have helpful language to remind you which fields to update and where that data may come from. You may have to unhide these rows if they are hidden from view.|