New PrestaShop customers (last 30 days)
List customers who registered in your PrestaShop store in the last 30 days.
PrestaShop · PostgreSQL
SELECT c.id_customer,
c.firstname,
c.lastname,
c.email,
c.date_add AS registered_at
FROM ps_customer c
WHERE c.date_add >= NOW() - INTERVAL '30 days'
AND c.deleted = 0
ORDER BY c.date_add DESC;How it works
Filters the customer table by registration date. Useful for welcome flows and measuring acquisition.
Run this on your own database
BeQuery mirrors your PrestaShop MySQL database to an isolated PostgreSQL copy, so you can run queries like this one without ever touching production.
Start free No credit card