我如何获得 Mailchimp 列表 +外部数据库列表状态同步？
我是 MailChimp 和自定义 API 集成领域的新手，所以 请耐心听我说。我也是一名互联网营销人员（不是开发人员），
所以请多多包容我；）
情况：
我们有一个包含用户帐户、数据等的平台。目前这个 平台利用定制的平台新闻通讯系统和列表 管理。这个平台上的系统根本不起作用...:(。因此，
我们将整个系统迁移到 MailChimp。
问题：
我们需要确保我们的时事通讯列表在我们的 站点（LAMP 堆栈）和 MailChimp。
本质上，我们希望发生以下情况：
- 如果用户订阅/取消订阅/更新他们的时事通讯 从他们在我们平台上的个人资料中进行订阅，MailChimp 则会收到此信息
- 如果有人订阅/取消订阅/更新他们的 MailChimp， 从电子邮件或自托管表单项中的合并标签订阅， 这些信息被推回我们的数据库。
简单地说，两个列表将保持相同、独立和更新。
我们有 3 种新闻通讯类型，每种类型有 3 种语言。为了创造 对于每个新闻通讯的过滤器，我们将 1) 创建三个组 2) 根据用户在每个组中创建细分 语言偏好，来自我们的数据库。我们使用 Zoho CRM
导入 MailChimp
问题：
我们该如何做？ （开玩笑……） 我们需要进行哪些必要的 API 调用来确保 我们可以同步我们平台的与列表相关的 MySQL 列 使用 MailChimp 进行管理？
在 MailChimp 上向用户提供表单元素的最佳方式是什么 可以用来从我们的内部管理他们的订阅状态 平台。 （我们有三种新闻通讯类型，一旦用户 更新我们网站上的某些内容，我们希望不仅 1) 转到 mailchimp（简单的部分），但是 2) 返回我们的网站并更新 我们自己的 MySQL 数据库列。
最无缝、最不麻烦的制作方式是什么 确保我们能够及时更新 Zoho CRM、我们的网站和 MailChimp 最新的订阅数据。我在想：
- 从我们的网站导出到 Zoho
- 从 Zoho 导入到 MailChimp
- 将数据从 MailChimp 拉回到我们的网站（只是新闻通讯订阅的状态）
我的想法是我们每周左右迭代此过程。这样可以吗 或者只是偏离目标？
预先非常感谢，我很乐意澄清任何事情。
I'm new to the world of MailChimp and custom API integrations so
please bear with me. I'm also an internet marketer (not a developer),
so please bear with me even more ;)
The Situation:
We have a platform with user accounts, data etc. Currently this
platform utilizes custom, on-platform newsletter system and list
management. This on-platform system doesn't work...at all :(. So,
we're migrating the whole system to MailChimp.
The Problem:
We need to make sure that our newsletter list is updated both on our
site (LAMP stack) and MailChimp.
Essentially, we want the following to happen:
- If a user subscribes/unsubscribes/updates their newsletter
subscription from within their profile on our platform, that MailChimp
receives this information - If someone subscribes/unsubscribes/updates their MailChimp
Subscription from merge tags in emails or self-hosted form items, that
this information gets pushed back to our database
Simply, both lists would remain equal, independent, and updated.
We have 3 newsletter types in 3 languages each. In order to create
filters for each of these newsletters we will 1) create three groups
and 2) create segments within each of these groups based on user
language preferences, which come from our database. We use Zoho CRM to
import into MailChimp
The Question:
How do we do it? (Kidding...)
What are the necessary API calls that we need to make to ensure that
we can synchronize our platform's MySQL columns that pertain to list
management with MailChimp?
What is the best way to provide form elements on MailChimp that users
can use to administer their subscription statuses from within our
platform. (We have three newsletter types, and as soon as a user
updates something on our site, we want that not only to 1) go to
mailchimp (the easy part), but 2) come back to our website and update
our own MySQL database columns.
What would be the most seamless and least-hair-pulling way to make
sure that we can keep Zoho CRM, our site and MailChimp updated with
the most recent subscription data. I was thinking:
- Export from our site into Zoho
- Import from Zoho Into MailChimp
- Pull data from MailChimp back into our website (just the status of newsletter subscriptions)
My idea is that we would iterate this process weekly or so. Is this ok
or just way off the mark?
Many, many thanks in advance and I'm happy to clarify anything.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
首先，我认为你需要一个开发人员。
其次，我不了解 Zoho，但是，这是我所知道的...
MailChimp API 提供您需要的一切。使用网络挂钩也将有助于保持同步。过去我遇到过类似的情况：
当用户订阅（列表或选择加入/退出组）时，MailChimp 列表上的信息将使用 listSubscribe API 调用，其中 double_optin=False 且 update_existing=True。我们在我们这边进行了双重选择，并且 update_existing 允许订阅和更新组。
设置了一个网络挂钩来捕获订阅、取消订阅和个人资料更新并更新我们的数据库。我这样做的方法是在网络挂钩中使用 listMemberInfo确保我也获得了选择加入的 IP 和时间。
我有一个每周一次的 cron 来运行所有用户并同步它们，以防万一 MailChimp 在用户订阅或其他类似情况时出现故障。稍微安心一点。
话虽这么说，我最近花了整个周末重新编码我们这边的软件，以便不再需要维护冗余数据。 MailChimp 有订阅状态、期限。我们仅在我们端存储电子邮件地址、最后已知状态、选择时间和选择 IP。每当用户在我们的网站上进行更改时，更改都会立即发送到 MailChimp，并且每当我们查询用户的订阅状态时，更改都会来自 MailChimp。
例如，我们的“电子邮件设置”表单是通过调用 listMemberInfo 然后表单处理程序通过调用 listUpdateMember 或 listSubscribe。 MailChimp API 甚至会传递用于组的表单字段类型（复选框、选择、单选）。
First, I think you need a developer.
Second, I don't know Zoho, but, here's what I do know...
The MailChimp API provides everything you need. The use of web hooks will also help maintain that sync. In the past I have had a similar situation in which:
When a user subscribes (to the list or opts in/out of groups) the information on the MailChimp list is updated using the listSubscribe API call with double_optin=False and update_existing=True. We were doing the double-optin on our side and the update_existing allows both subscriptions and updating the group.
A web hook was setup to capture subscribes, unsubscribes, and profile updates and update our database. The way I was doing this, is using listMemberInfo in the web hook to make sure I got the opt-in IP and time as well.
I had a weekly cron that ran through all our users and synced them up just in case MailChimp was down when a user subscribed or something else along those lines. A little extra peace of mind.
All that being said, I recently spent an entire weekend re-coding the software on our end to not longer need to maintain the redundant data. MailChimp has the subscription status, period. We only store the email address, last known status, optin time, and optin IP on our end. Any time the user makes a change on our site, it is immediately sent to MailChimp and anytime we query the user's subscription status it comes from MailChimp.
For example, our "email settings" form is loaded by a call to listMemberInfo and then the form handler saves the information to MailChimp with a call to listUpdateMember or listSubscribe. The MailChimp API will even pass what types of form fields to use for the groups (checkbox, select, radio).