I hope Iām not too late to the party, but hereās my info-
-What do you offer that requires tracking?
I send personalized letters from one of my webcomic characters every month to everyone in my $5 and higher tiers. US patrons who pledged before a past cutoff date get their letters by snail mail, and international and/or new patrons get it by email. $10+ patrons also get a quarterly original sketch along with their letter.
-What is the process that you use to make sure your patrons get what youāve offered?
I work off the patron manager .csv, reformat it to fit my needs, import it as Photoshop variables, and double check my snail mail patronsā addresses against my mail merge envelope file in Word. I use a gmail mail merge add-on to send the email letters. After the letters are mailed/emailed, I post a notification to my Patreon feed and ask people to notify me if they havenāt received their letters after a certain time. If a letter is returned to me in the mail, I contact the patron. Otherwise, I donāt really know what letters arrive safely.
-How well (or alternatively, poorly) does this process work for you?
Itās manageable thanks to my two mail merge apps and the Photoshop variables/scripts that automate the personalization, but other areas could be streamlined. The biggest time-suck is sorting and correcting the raw .csv before importing it into my other programs. I wish there was a way for me to permanently mark which patrons get emails and which get snail mail, but I have to sort this manually every month. Also, some patrons havenāt included their full legal name in their pledge info (without it, especially the last name, the post office wonāt forward their mail if they move), but theyāve told me through PMs, so I have to manually add their last names to the CSV every month. Also, some want to be called by a different name than their legal name on their personalized letter (one name on the envelope, another on the letter), so I have to change these manually every month too. If there was a way for me to save this info so itās downloaded in the CSV, or even override their info, itād solve all my problems.
-How do you think about pricing your tiers in order to make the process worth it to you?
I just considered the cost of supplies and time, and the perceived value of the reward, and the percent of profit I wanted. I created these rewards early on, never believing my Patreon would be as successful as it turned out to be. (oops.) So as time went by, I had to research better ways to automate and streamline my process, and itās been fine overall. Some generous patrons have independently decided to add $0.50 or a dollar to their pledge to cover shipping, but this isnāt the norm, and Iāve never suggested this to any of them.
-If you could wave a magic wand and get any feature built for you to help make this easier to do, what would you wish for?
As mentioned above, being able to add, change, or override patronsā details in a way that you only have to do it once and itās automatically downloaded with each monthās CSV.
Iād also like a way to divide up my $5+ patrons between email and snail mail delivery, and not have to manually sort them every month. This could be just an extra customized field in the CSV, or it could be a new system where you could have āsub-tiersā within a tier so a patron can choose between multiple equal-value rewards.