Thinking about sites which use eg Content Profile to decide which members go in which lists.

We have a site with ~50K users and a content profile field "Tell me about comps". 12K users have this checked.

I want to do cron updates (for performance) but don't want to make the list REQUIRED (MC will charge me extra for having the additional 38K subscribers who I don't mail).

If there was a hook I could use to calculate if a list member was subscribed to a list, then I could set this list subscription type to CALCULATED (or whatever) and then derive whether the user was subscribed or not during the cron run (and use the standard queue of current, pending etc for updates).

Thoughts?

Related: #840996: Handle user updates for lists being set as compulsory, before it dawned on me that we don't have a local storage of whether the user is subscribed to drive a cron update from.

Comments

xurizaemon’s picture

xurizaemon
he/him
Location Ōtepoti, Aotearoa 🏝
CreditAttribution: xurizaemon commented
Issue tags: +bribe

Oh - if you let me have this I'll include a patch to make content_profile user data fields mergeable :)

smoothify’s picture

smoothify CreditAttribution: smoothify commented

I would suggest the easiest way to achieve this is to export a csv of the 12K people you want on the list from your db. Then import that into mailchimp via their admin.

As long as you also include any fields you need over there as well as the email it should work fine from then on.

However, i would also like for their to be a local copy of subscribed status and also a cron updating process for non-required lists.

levelos’s picture

levelos CreditAttribution: levelos commented
Status: Active » Closed (fixed)

Local storage of a user's list status will be coming in a major new release early next year. We'll likely do this using MailChimp's web hooks, which can notify the Drupal site when a user's status has change. Previously, we had no way of knowing when would unsubscribe so always to use the MCAPI to find out.

Stay tuned to the new work on the 7.x branch.