MailChimp

Importing to MailChimp

new (Paddle)

1. find the date of last import
   1. go to mailchimp
   2. click "audience" icon on left side (little crowd)
   3. click "all contacts" on left
   4. sort by "Date Added" *descending* (you have to click twice)
   5. under "Source", ignore tny that say "Hosted Signup Form"
   6. scroll down to find the first "List Import from CSV"
   7. make note of that date
2. get data from paddle:
   1. go to paddle
   2. click "reports"
   3. from "select report" pick "transactions"
   4. select date range starting with day of last import, end with today
   5. order status "completed" (leave the rest on "all")
   6. click "execute report"
   7. wait for email or click refresh 'till it's ready
   8. download it
3. import to mailchimp:
   1. go back to mailchimp
   2. audience->all contacts->add contacts->import contacts
   3. click "upload a file"
   4. browse->go to downloads folder->select the CSV file->continue
   5. go thru the wizard
   6. for "Tag your contacts" just enter today's date

old (eSellerate)

1. in email, ensure the mailbox "kJams->kJams Store->Convert" has the correct date range
2. run kJams, debug->mail->file <-- see GeoData.txt on desktop, you can then use this to geocode for map
   1. if you get a -5000 (afpAccessDenied) error you can copy "Convert.mbox" to the desktop, and recompile using the 2nd "CONVERT_PATH" constant
3. go to MailChimp.com->audience->manage audience->import contacts->use settings from last import->browse
4. pick "GeoData.txt"
5. go through every column assigning a column name (god why don't they remember this shit?)
6. finish the import