The Kickstarter backer data is personally identifiable information. Treat it like medical radioactives. It's necessary, but don't leave it lying around. Under no circumstances is it to be uploaded to OneDrive, Google Drive, or other LLM feeders. Private, paid Dropbox accounts are acceptable.
Look at the backer survey
Find out which backers didn’t fill out the survey. (They will be grouped at the bottom.)
Ignore backers who don’t have to fill out a survey because they chose to back with no reward.
You’re left with a list of people who backed the kickstarter for a reward but didn’t fill out the survey. Email those people using kickstarter’s system. Search for them one by one by name, and then send them the following email.
It’s Alex here, Michael’s DAD (Director of Analog Distribution). We noticed that you haven’t filled out your kickstarter survey yet. We need you to fill it out so we can send you your book. Kickstarter itself doesn’t share your information with us, so the only way we can get it is for you to fill out the survey you received. Please fill it out today. Thanks!
If the backer doesn't respond to the kickstarter message, use gmail to try emailing them one last time.
If a backer can’t update their survey, but they message their address to you, you can add it manually. Go the backer’s name on the survey, click the hamburger menu, and click “manually update address.”
To mail books we must verify:
Update backer responses manually if needed.
Go through all of the backers one by one. Verify all the addresses as complete, especially international ones, and make sure they include phone numbers.
Once all surveys are in, (with the exception of those who ignored the messages asking them to fill out the survey) then you can download the report. It will be a CSV file. Change it to an excel spreadsheet so it will be easier to work with.