In this article, you'll find an overview of the different lists and reports you can export from your edrone system.
Most of these lists are available in Customers > Contacts > Export customer lists. Some other reports have their own export button right on their source page — for example Wish List, Segments and Billing.
NOTE: All lists and reports are exported as a CSV file.
Every export now runs in the background: you'll get a notification when it starts, and the file downloads automatically once it's ready. Track its status in the Recent exports panel or on the full Exports page, under your account menu — export history is kept for 30 days, and files stay available for download for 7 days. What you see in the export history depends on your user permissions.
All Customers
This is a list of all customers in your database. The generated CSV file will contain the following data:
First name
Last name
Email address
Phone
Gender
Birthdate
Country
City
Tags
IP
Creation date
First visit date
Last visit date
Number of visits
Last add to cart date
Last order date
Number of orders
Total order value
Last email open date
Last email click date
Other segments available in the export menu
Besides "All customers", the Export customer lists menu offers other ready-made cuts of your database:
Low spend / Medium spend / High spend: customers segmented by total amount spent, based on their order history.
Newsletters and automations — at least one channel: customers subscribed to receive newsletters and/or automations on at least one channel (email, SMS or WhatsApp).
Unsubscribed — all channels: customers who unsubscribed from every channel and no longer receive newsletters or automations.
Automations only: customers subscribed only to automations, not newsletters.
Invalid phone number: contacts with an invalid phone number format.
Invalid email: contacts with an invalid email format.
Suppressed
A list of customers whose emails were returned (hard bounce) or who marked your messages as spam. They're automatically excluded from campaigns to protect your sender reputation. This export has its own "Export CSV" button, right on the Suppressed card on the Contacts page — it's not part of the Export customer lists menu.
Wishlist Subscribers
This is a list of the customers who have added products to their wishlists. This export is done directly from the Wish List page — it's not part of the Contacts export menu. The generated CSV file will contain the following data:
Product ID
Creation date
Email address
Engagements Report
This report no longer lives under Customers > Contacts. To analyze the performance of newsletters and automations (sends, opens, clicks, OR, CTR, CTOR) over a period — including daily and per-channel breakdowns — go to Reports > Newsletters or Reports > Automations — each one has its own "Export CSV" / "Export PDF" button.
Attribution Report
This report has moved: it now lives under Reports > Orders. Click "Export CSV" and choose the "Attribution Report" option. It shows the orders attributed to edrone engagements within a specific period of time. The generated CSV file will contain the following data:
Order ID
Order value
Order date
Attribution date (the moment when the attribution was established by the edrone system)
Engagement type
Campaign name
Attribution reason (OPEN, CLICK or OPEN/CLICK)
Email open date
Email click date
Email click URL
Need more help?
If you have any further questions about exporting lists and reports in edrone, please do not hesitate to contact us at hello@edrone.me or via chat