Intro

Why this project?

This project exists to reach two main objectives:
  1. Get more eyes on Vote Smart data before people vote in 2020 (this is the goal you’ll talk about most publically)
  2. Create interest in Vote Smart such that special interest groups, media organizations, and corporations are interested in paying for our data in the future.

What we are offering

Most of this is covered in the "Initial Guidelines" document A few notes:

Vocabulary


History of Project


Workflow


Here’s an outline of what it looks like from beginning to end with a group to give you an idea of the workflow.


Explanation of Documents


All the documents used for this are kept on Google Drive. Some are saved as “backups” on the network drive, but that should not be the document you are editing and updating, because that may be confusing for other people using the same version of the document.

All of this (except contracts) are in Google Drive, under DevComm>Corporate Outreach.


Contact Sheets


This is a series of spreadsheets to track all the conversations I’ve had with different groups. I don’t make a contact sheet unless the group has responded to one of our contacts. Here’s a breakdown of the info on a contact sheet:

VS Merges


This folder has everything used for the merges made for the physical mailing, emails, phone script, and follow-up phone call. The documents that were created are in folders sorted by groups. The documents in “SIG Templates” are the templates that were used for groups 1-6. The documents with names beginning with “Media” were used to reach out to groups 7-9.

Corporate Outreach Contacts


This document. A description of the fields. I color-coded in a way that made sense to me, but it can be changed however you like:

Project Calendar


Good place to see when things were sent out/calls made, etc.

Contracts


Doing the Merge


In order to make the letters, email pdf attachments (same as mailed letters), emails, and phone scripts, I use a Google plug-in called autocrat. You could also do this merge on Microsoft Office, I simply didn’t since I don’t have Office. Currently, this does not work with @votesmart.org emails, however Jacob is working on making that possible--you can talk with him about that.

In order to work around this, I generate documents using my personal account. To do this, share the “VS merges” folder with this email. When it is time to do a merge:
  1. Open up a Google Chrome incognito window. This allows you to access your @votesmart.org and @gmail.com accounts simultaneously. Log in to your @gmail account on incognito.
  2. Make sure the Google document template is ready to go and says what you want it to say.
  3. Make sure the folder you want the documents to end up in is ready to go. Currently, each group has its own folder.
  4. Copy and paste the most recent version of the group you will be merging from the “corporate outreach contacts” spreadsheet into the “Contact SS” within “VS Merges”
    • For example, if you are working on group 9 emails, you would copy all group 9 contacts from the Corporate Outreach Contacts spreadsheet into the “Group 9” tap on Contact SS
  5. Select Add-ons from the top tool, Autocrat, then “launch” or “open”
  6. Step one: Name your merge job Create a New Job, name it whatever you are doing (“Group 9 emails”). Note: you can also make general jobs “Emails”/”Phone Scripts”/”Letters” then tweak them each time for a new group. Click next.
  7. Step two: Choose template select to choose your template “From Drive.” Find your template, saved in VS Merges. Click next
  8. Step three: Map source data to template
    • Merge tab=whatever group you are working on
    • Header row=1
    • First data row=2
    • Make sure all the tags match what column should fill them in
  9. Step four: File settings
    • If creating phone scripts, emails, envelopes, or letters
      • File name=”Group X Item”
        • For example, group 10 emails
      • Type=Google Docs
      • Output as=single output mode
      • Add page breaks between data rows: yes
    • If creating email attachments:
      • Name this (tag for organization abbreviation)—Vote Smart Outreach
        • You can name it anything, but if you want their name in the title just make sure to directly copy the header from the spreadsheet you are merging from.
      • Type=Google Docs
      • Output as=Multiple output mode
  10. Step five: Choose destination folder(s)
    • Select “VS Merges”
    • Select the relevant group
    • If doing PDFs, select the “PDF” folder within
  11. Step six: Add dynamic folder reference I skip this step, not really sure what it is
  12. Step seven: set merge condition “add condition” then:
    • For snail mail letters and envelopes: Column Address equals NOT NULL
    • For emails: Column Email equals NOT NULL
    • For attachments: don’t add any condition
    • For phone scripts: Column Phone equals NOT NULL
    • For follow up emails: Column Status equals NULL
  13. Step eight: Share docs & send emails
    • Select “no.” If you are ever interested in sending emails automatically through Autocrat, this is where you would do it.
  14. Step nine: Add/remove job triggers. Leave these on “no”
  15. Save the job, then press the triangle “play” button next to it
  16. The document will be generated and can be found in the destination folder designated in step 10.
  17. If you need to redo the merge for any reason, delete the new columns Autocrat would have created in the Contact SS document and the document it created the first time

Working with groups/answering questions


Phone calls

When you have a scheduled phone call with a group be prepared by knowing:

Every phone call is different but be prepared to explain
Examples of our offerings

This document tracks all API users.

Some notable examples:

Who to go to at Vote Smart with questions


Here’s a brief outline on the issues each person handles for when you need help with a problem. You can find contact info for all of them at http://wiki.votesmart.org/PhoneList

Board Member Adelaide Kimball
Good for questions about:
National Director Walker McKusick
Good for questions about:
DevComm Director Jacob Petterson
Good for questions about:
Officials Research Director Annie Peterson
Good for questions about:
Elections Research Director James Wypych
Good for questions about:

Setting Up API


There are no comments on this page.
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki