In a Support thread titled “How to export all user emails,” Sami_Syed asks how to collect user emails for marketing (e.g., Mailchimp) and add an opt-in checkbox or popup during signup. jtbayly replies that no native solution exists, but offers workarounds: manually exporting users, syncing via WordPress SSO, or using a broken webhook plugin with Zapier. jtbayly adds that user consent can be handled via signup checkboxes or T&Cs. bartv suggests using the Data Explorer plugin with a cron job and Zapier, though it requires server access. Sami_Syed asks if exports include only new users and whether Mailchimp deduplicates — no automatic filtering exists, but Mailchimp typically avoids duplicates. They also note they can’t use WordPress sync since Discourse handles logins, and question if the broken plugin is usable — jtbayly confirms it’s currently nonfunctional. Sami_Syed mentions using Communiteq (formerly DiscourseHosting), asking if their team can handle setup. dax advises contacting Communiteq directly. RGJ confirms Data Explorer is installed by default on their hosted forums. codinghorror warns that Data Explorer can expose sensitive data (cookies, password hashes) and recommends restricting access. RGJ acknowledges the risk and notes they’re considering a locked-down version of the plugin.
How do I collect emails of users that sign up and send them to a mailing list (like mailchimp) for email marketing.
And setup something that makes the user agree to subscribe to the emailing list.
Also, is it possible to add a email opt in pop up and field to discourse?
Oh, and as for making the user agree, the first link above discusses how to add a checkbox on user signup, if the mailinglist membership is optional, or simply adding a notice to your signup page and/or your terms and conditions or something like that if it’s not optional.
Alternatively, use the Data Explorer and set up a cron job that posts a JSON feed to Zapier with the information you need. No other plugins required (but you do need to get your hands a little dirty on your server
But lets say I export users today. And get 15 new users tommorow. If I export again, will it export every single user? or will it only choose the ones that are new, is there an option for this? If not, will mailchimp recognize that that email has already been added, and not add it again?
I cant do this because I am letting discourse handle my user logins
I am using Communiteq (formerly DiscourseHosting) and they install all my plugins for me. So what exactly do you mean by get my hands dirty? Will the Communiteq (formerly DiscourseHosting) support team be able to successfully setup this plugin for me?
The Communiteq (formerly DiscourseHosting) guys install the data explorer plugin by default on every forum, so you should be able to use that method if you host your forum with us.
Be careful, because admins can query out cookies and password hashes with this tool. We actually don’t recommend that data explorer be enabled everywhere for that reason. At minimum it should be an “upon request, we will enable it for you” type thing, to reduce your total exploit surface area.
Thanks for the advice.
Since we cannot disable/enable it on a per forum basis on multisite, we were (once) considering building a locked down version that does not support the “sensitive columns”, but we never got to it. Will put it higher on the to-do list