Differences

This shows you the differences between two versions of the page.

--- kickstarter_backer_report_and_analysis [2026/04/27 14:57] – alex
+++ kickstarter_backer_report_and_analysis [2026/05/29 11:33] (current) – alex
@@ Line 1: / Line 1: @@
 //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.//
-I'm now setting a 30-day drop dead timeline for users to fill out their survey. I post KS updates saying "please fill out your survey" immediately, 1 week, 2 week, 3 week and last day.
+===== One Month Before Shipping =====
-Kickstarter does not allow updating the backer report in KS. We need to have a control spreadsheet.
+Look at the backer survey
+Find out which backers didn’t fill out the survey. (They will be grouped at the bottom.)
-To mail books we must verify:
+Ignore backers who don’t have to fill out a survey because they chose to back with no reward.
-  * Backer Name (full first name, and last name: Customs won't let initials like "AB Backer" out of the country)
-  * Backer Phone Number (including country code) -- As stated in the KS description, we need a phone number to ship books. US shippers will not accept overseas packages without destination phone numbers. Shippers check for fakes like 555-555-1212 or 1-234-567-8900, so those will not work. Many European and Asian customs agencies expect to text notifications to recipients. Even USPS is requiring phone numbers for about half of Priority Mail packages within the US.
-  * Backer Shipping Address -- Kickstarter might have backer addresses, but they do not pass that information to us. Yes, that's daft. If backers want a book, we need the backer to give us a shipping address. Also, people move. Shipping within the US is expensive, non-US shipping is outrageous. We need backers' current address, even if they provided it in the last campaign. (Also, now and then people forget and put a fake address to receive books. If the address looks bogus, check it.)
+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.
-Go to the KS campaign-> Backer Report. Click "Download Full Backer Report."
+**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!**
-First download becomes our control spreadsheet. Updates get added to it.
+If the backer doesn't respond to the kickstarter message, use gmail to try emailing them one last time.
-Sort by rewards. Verify info for physical rewards.
+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:
+  * Backer Name (full first name, and last name: Customs won't let initials like "AB Backer" out of the country)
+  * Backer Phone Number (including country code) -- As stated in the KS description, we need a phone number to ship books. US shippers will not accept overseas packages without destination phone numbers. Shippers check for fakes like 555-555-1212 or 1-234-567-8900, so those will not work. Many European and Asian customs agencies expect to text notifications to recipients. Even USPS is requiring phone numbers for about half of Priority Mail packages within the US.
+  * Backer Shipping Address -- Kickstarter might have backer addresses, but they do not pass that information to us. Yes, that's daft. If backers want a book, we need the backer to give us a shipping address. Also, people move. Shipping within the US is expensive, non-US shipping is outrageous. We need backers' current address, even if they provided it in the last campaign. (Also, now and then people forget and put a fake address to receive books. If the address looks bogus, check it.)
-If information is missing, contact backer via KS messages. Include the explanation for why we need it.
-[Insert form letter here]
+Update backer responses manually if needed.
-Update the control spreadsheet with backer responses. (//Idea: color manual responses red so I have an idea how many backers can follow instructions?//)
+===== 2-3 Weeks Before Shipping =====
-Get a new backer report twice a week. Copy entries that have been added since the last download to the control spreadsheet. Check those entries.
+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.
-After the thirty days survey period expires, give a couple days for stragglers to respond. Because people.