Recipients List that open email

  • Jupa

    (@jupa)


    9 years, 8 months ago

    Hello Alessandro,

    there is an archive in which they are registered recipients that open the email I send?

    If there is I want to know what it’s called and what Mysql folder is located.

    take care

    —

    Buongiorno Alessandro,

    esiste un archivio in cui vengono registrati i destinatari che aprono la email che invio?

    Se esiste vorrei sapere come si chiama ed in quale cartella di Mysql si trova.

    Stammi bene

    https://wordpress.org/plugins/alo-easymail/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author eventualo

    (@eventualo)

    9 years, 5 months ago

    Hi, this is a query to have all recipient viewed (and not clicked links of) a specific newsletter. To have everyone viewed and clicked, remove the 4th line.

    [Italian] Ciao, questa è la query per avere chi ha aperto la newsletter (ma non ha cliccato link nella newsletter). Per avere tutti coloro che hanno visto o cliccato, rimuovi la 4a riga.

    SELECT r.email, r.user_id FROM wp_easymail_stats s
LEFT JOIN wp_easymail_recipients r ON r.ID = s.recipient
WHERE s.newsletter = 9999 # <= the newsletter ID
AND s.request = '' # <= only who viewed and didn't click
GROUP BY recipient
    Thread Starter Jupa

    (@jupa)

    9 years, 5 months ago

    Good morning,

    I read the directions and thank you.

    I apologize but I do not know how and where to launch the query.

    Where can I read a helpful guide?

    Thanks so much.

    [Italian]

    Buongiorno,

    ho letto le indicazioni e ringrazio.

    Chiedo scusa ma non so in che modo e dove lanciare la query.

    Dove posso leggere una guida utile?

    Grazie mille.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Recipients List that open email’ is closed to new replies.