Jump to content

Query clients that don't have Marketing Opt-In and Opt-Out confirmed


Recommended Posts

Hello, I've not still do the Marketing Email Opt-In functionality conversion.

I've sent a mass mail to all clients with both links:


Now, I want to query a list of clients that don't have clicked any of the links (clients with consent history empty??)

How can I filter this clients in the datbase?


Edited by jmginer
Link to comment
Share on other sites

Just received a responde by PM, I post here: for everybody


I was recently asked to write some code to reproduce the generation of the keys used in those links (they were using an external program for the mass mailing), so I can give you some basic SQL queries that may help you...

if a client has opted in, the tblclients.marketing_emails_opt_in value will be 1 and emailoptout is 0; if they have opted out, then those values are reversed.. if they've done nothing, then both should be 0....

tblclients.marketing_emails_opt_in = 0 AND
tblclients.emailoptout = 0;

so, the above code should give you a list of email addresses of clients who have neither opted in or out... the only caveat I will add is that I wrote that after running the marketing converter, so what that does to the database values I don't know... but if you haven't ran it, then just compare your values to those I describe above and spot of there are any differences...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated