Find/Export Email List

  • Resolved aldithings

    (@aldithings)


    4 years, 6 months ago

    How do I find or export a list of all the email addresses that have submitted reviews? I know I can go into each review and find the email address there but I have not found any way to bulk export the email addresses to add to my email list.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter aldithings

    (@aldithings)

    4 years, 6 months ago

    I should add that I have tried the standard WordPress export feature that lets me export the reviews but that exports as XML so it is still difficult to find all the email addresses. If we could export as a CVS or similar file it wouldn’t be bad to manually pull the emails. Would be even better if we could send the emails directly to an email list software.

    Plugin Author Gemini Labs

    (@geminilabs)

    4 years, 6 months ago

    To export the name and emails to CSV, you could use the Database Browser plugin:

    1. Install the Database Browser plugin
    2. Go to the “Tools > Database Browser” page
    3. Click the “Select table” button (it doesn’t matter which table is selected)
    4. Copy the table prefix of your tables (for example, if the table is wp_posts, the prefix is the first part with the underscore wp_).
    4. Click the “Edit query” button
    5. Paste the following SQL query, replacing wp_ in wp_glsr_ratings with your table prefix:

    SELECT name, email, COUNT(*) reviews 
FROM wp_glsr_ratings 
WHERE email != ''
GROUP BY email, name
ORDER BY email ASC

    6. Click the “Run query” button
    7. Click the “CSV” button to download the results

    To send the name and email automatically to your email list software, you can use the site-reviews/review/created hook:

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

The topic ‘Find/Export Email List’ is closed to new replies.

Tags