New Magento customers (last 30 days)
List Magento customers created in the last 30 days from customer_entity.
Magento · PostgreSQL
SELECT ce.entity_id,
ce.firstname,
ce.lastname,
ce.email,
ce.created_at
FROM customer_entity ce
WHERE ce.created_at >= NOW() - INTERVAL '30 days'
ORDER BY ce.created_at DESC;How it works
Filters the customer_entity table by created_at — a quick acquisition snapshot.
Run this on your own database
BeQuery mirrors your Magento MySQL database to an isolated PostgreSQL copy, so you can run queries like this one without ever touching production.
Start free No credit card