Mautic Community Forums

How to Export Leads by List

This is a feature that isn’t yet available in Mautic, but there is a simple workaround for anyone needing to export leads from a specific list. Simply go into you’re web host’s cPanel, open phpMyAdmin, and enter the following SQL query (being sure to reformat these table names / list numbers according to your personal data):



SELECT mauticsf_leads.id, mauticsf_leads.date_added, mauticsf_leads.firstname, mauticsf_leads.email, mauticsf_lead_lists_leads.leadlist_id

FROM mauticsf_leads, mauticsf_lead_lists_leads

WHERE mauticsf_leads.id = mauticsf_lead_lists_leads.lead_id

AND mauticsf_lead_lists_leads.leadlist_id =3

LIMIT 0 , 10000



You can increase the Limit as high as you need depending on how many leads are on your list.

This is a feature that isn’t yet available in Mautic, but there is a simple workaround for anyone needing to export leads from a specific list. Simply go into you’re web host’s cPanel, open phpMyAdmin, and enter the following SQL query (being sure to reformat these table names / list numbers according to your personal data):

SELECT mauticsf_leads.id, mauticsf_leads.date_added, mauticsf_leads.firstname, mauticsf_leads.email, mauticsf_lead_lists_leads.leadlist_id
FROM mauticsf_leads, mauticsf_lead_lists_leads
WHERE mauticsf_leads.id = mauticsf_lead_lists_leads.lead_id
AND mauticsf_lead_lists_leads.leadlist_id =3
LIMIT 0 , 10000

You can increase the Limit as high as you need depending on how many leads are on your list.

Here is discussion about the same question: https://www.mautic.org/community/index.php/735-export-leads/0

I have the same question how to export the leads in a list to csv?

Hello guys, I have 20K contacts from my old mail marketing provider, but the native import toll is not working fine on Mautic.
Please could you share a query to insert contacts onto may Mautic DB?

Thanks.

@edsonmoreira why you said is not working? in my end is working like a BOSS you have check your CSV file.

How do i export subscriber only?

When i export my contacts it exports ALL subscribers (subscribed and unsubscribed)

How do i only export the subscribed contacts?

Thanks in advance
David

@ninjoan I have a list greater than 20K contacts. The Mautic’s import toll does not support that… It crashes and/or get stucked. I think would be easier if we can insert directly into the DB by SQL command.