For teams that run on Mailchimp
Mailchimp donor giving history in fields
Fundraising emails work better when they know the last gift and when it was. That history lives in the giving records or a spreadsheet, and Mailchimp gets it only when someone exports, cleans and imports it again.
How it goes today
- Export the gifts from the donor records.
- Work out the last gift and the yearly total per donor in a spreadsheet.
- Import the result into fields in Mailchimp.
- Build the lapsed donor segment again before each appeal.
How it can go
Write to donors with their giving in mind.
Each night the last gift date, last amount, number of gifts and total for this year come from your giving records into fields on each donor in Mailchimp. Donors who gave last year and not yet this year get a lapsed tag, and lose it when they give. Your appeal can use the fields and the tag.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Mailchimp key in the portal, never in the chat.
With Hypamoon, each night, put the last gift date, last gift amount, number of gifts and total this year for each donor from our giving records into fields in Mailchimp. Give donors who gave last year but not yet this year a lapsed tag, and remove it when they give again. Send me the donors we could not match to a contact.
You create the Mailchimp API key yourself under your profile, Extras, API keys. A key made since June 2026 works for a year, after which you create a new one. It stays yours.
More for teams on Mailchimp
- I want to archive contacts who stopped opening, so I stop paying for them.
- Bots keep signing up to my list and I delete them one by one.
- I want people who stop opening to get my re-engagement emails without tagging them by hand.
- My sponsors want their numbers and I make screenshots of each report.
- I download my campaign reports one by one to make a monthly overview.
- I export my list and import it into Mailchimp by hand every time something changes.
- I want a copy of my contacts, campaigns and images outside Mailchimp.
- I want our past newsletters on a page on our own website.
- I want to be notified when a tag is added, not send an email to the contact.
- I want the unsubscribe reasons over a whole year, not per campaign.
- I want to remove a tag from a pasted list of contacts at once.
- I segment my audience by language and make a campaign for each one, and it takes ages.
- I have a list of 500 unique codes and each new subscriber needs the next one.
- I want an email to clients 90 days after their last booking, and Mailchimp only counts days before a date.
- My renewal series pulls in people who do not expire for another year.
- Someone asks for proof of consent and I dig through export columns to find it.
- Our webshop has no Mailchimp connection, so abandoned cart emails do nothing.
- I want the birthday email on the first day of the birthday month, and I can only pick the birthday itself.
- I need to see per contact which emails were sent, when, and whether they opened.
- I want to ask for a review after a customer has had three services, without counting gift cards.
- I want to keep track of which events people attended, so I can write to them in context later.
- Someone wants to be forgotten and I have to check every audience one by one.
- Do I have to archive a subscriber once their implied consent window has passed?
- Siblings share an email address, so I can only target one of the children.
- I tag subscribers by source and cannot report on how that group performs.
- The tracking number is not sent with the shipping confirmation.
- Timewarp relies on geolocation and I keep a country field of my own.
- I manage about 30 client accounts and need their numbers in one place.
- The client says the email looks good, then disputes it after the send.
- People change their RSVP and I cannot keep the list up to date.
- I want every contact tagged with the company they work for, based on the domain.
- The address is stored as a single field and I need it split for mailing labels.
- Everything for Mailchimp