Publish a CSV to the web and use it for New/Mode custom targeting
Custom targetting allows your supporters to contact decision-makers who are not included in New/Mode's location-based datasets. Using a Custom Spreadsheet allows you to easily upload a large list of targets, or, have users select targets from a dropdown menu by categories such as name, jurisdiction, and party.
Create your CSV and Publish to Web
Here's how to use a CSV spreadsheet to upload custom target data:
Step 1: Make a copy of this Google Sheet Template and save it to your Google Drive.
Step 2: Fill out the names and at least one piece of contact information for the targets you want your supporters to contact.
- Keep the columns where they are!
- Fill the 'jurisdiction' and 'full_name' columns along with one piece of contact information (email, phone number, or fax number).
- You can leave other columns blank, (just don't delete them!)
- Make sure that each cell in the 'jurisdiction' column has a unique value.
Step 3: (Optional) Add additional columns for lookup values that your supporters can search to see targets most relevant to them.
Step 4: Click on the Share button on the top right, and set the sheet so that 'Anyone with the link' can view it.
Step 5: Find the Publish to Web link under the File tab, and select Comma-separated values (.csv) on the Publish to Web form before clicking the Publish button. Copy the provided link and you're on your way!
Step 6: Return to the Custom Targets section of your campaign tool's Basic Configuration page, and link your spreadsheet to your campaign tool with the URL you just copied. Once copied, click outside the URL for Custom CSV Data Source textbox to import the CSV. Once done, you've imported your CSV:
Pro Tip: If you receive an error message after importing your CSV, ensure that all necessary columns are filled out (Name, Jurisdiction, and Target Method), and that you have copied the Published Web URL, not the standard webpage URL.
Advanced options for Custom Targets
After importing, you'll see some new options appear:
Automatically Update CSV Checkbox
This box should be checked when you are importing a CSV for a new tool. If you ever update or replace the CSV on an existing tool, this box should be checked before you click Save on the Basic Configuration page. When this box is checked, an old CSV will be updated to include any new lookup columns or entries. Similarly, if you want to add a new custom CSV URL, it will replace the old CSV when this box is checked.
Provide a Search Bar: The display of this option depends on how many columns you choose in the Search By field.
-If multiple columns are chosen, we will automatically create a search bar on your tool that allows your supporters you search based on the lookup values you've included in your CSV.
-If only one column is chosen, the search bar will include a dropdown, so your supporters can scroll through the values in that column of your CSV. We highly recommend using this option.
Display All Results: This option will create a list of all the contacts in your CSV on the campaign tool. This might be useful if you just have a few targets in there, but don't use it for a long list!
This is a list of the lookup columns that you created in your spreadsheet. Select the ones that you would like your supporters to be able to search by. For example, "jurisdiction," "last name," or "university." In the tool, supporters will now see a search bar (or a dropdown, if only one column was selected) that allows them to look up their representatives or relevant organization/institution.
Step 6: Click Save & Next, the go to the View tab to see your new Search bar/dropdown IRL. So beautiful:
In the future, any changes that you make to your CSV data will automatically update to your campaign tool within 24 hours (if you want changes to be reflected immediately, tick the Automatically Update CSV checkbox and Save your Basic Configuration page), so once you're done setting this up, you can control lists of targets and target data from the published spreadsheet. Easy peasy!