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

[jmginer]

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:

{$email_marketing_optin_url}
and
{$email_marketing_optout_url}

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?

Thanks!

Edited May 21, 2018 by jmginer

[jmginer]

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....

SELECT
tblclients.email
FROM
tblclients
WHERE
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...