Source Link: https://help.lob.com/print-and-mail/getting-data-and-results/exporting-mail-data # Exporting mail data
Lob captures data for each mailpiece created and provides an easy way to export it as a CSV file. Exporting data allows for in-depth performance analysis, auditing, or other purposes, but we strongly recommend customers do this on a regular cadence for record-keeping and maintenance.
{% hint style="warning" %}
Lob’s will retain customer mailpiece data for a total period of ninety (90) days. See our [data retention policy](../../../resources/security-and-privacy#data-retention-policy) for further information.
{% endhint %}
## Data available for download
Mailpiece details
ID, Description, URL, Color, Double Sided, Address Placement, Return Envelope, Perforated Page, Extra Service, Expected Delivery Date, Tracking Number, Mail Type, Size, Metadata, Date Created, Send Date, Merge Variables
Regular Mail: Mailed, In Transit, In Local Area, Processed for Delivery, Re-Routed, Returned to Sender
Certified Mail: Mailed (Certified), In Transit (Certified), In Local Area (Certified), Processed for Delivery (Certified), Re-Routed (Certified), Returned to Sender (Certified), Delivered (Certified), Pickup Available (Certified), Issue (Certified)
## Exporting your data from the Lob dashboard
1. [Log in](https://dashboard.lob.com/login) to your Lob dashboard.
2. In the left side menu of your dashboard, navigate to the appropriate mail format for which you'd like to download your data (e.g., "Postcards.")
3\. Select the [environment](../../../account-management/api-keys#test-vs-live-environment-keys-2) (Live or Test) from which to download your data. In our example below, "Test" environment is selected.
{% hint style="info" %}
Recall that physical mail is only sent when requests are made in the Live Environment.
{% endhint %}
4\. Filter for the date range you want mailing details.
This search is inclusive, i.e., the first date that will have information retrieved will be the Start Date from 00:00 UTC, and the last day of information returned will be the End Date up until 23:59 UTC.
{% hint style="info" %}
If you are retrieving multiple years' worth of data, we recommend that you download one year at a time, as larger requests will require more time to generate.
**Note that we have a limit of 250K rows per export at this point in time.**
{% endhint %}
5\. Once you have your filters selected, click "Apply" to filter on the range being displayed.
6\. From this newly filtered view, select the "Export" button.
* **Export Tracking events:** If you are exporting Live environment requests, and there are tracking events associated with them, a pop-up will appear to "Select Tracking Events." If you choose Yes, you will receive a second export of tracking events. You will have the option to include all events or a specific subset of events. Click "Submit."
* A pop-up will show your data selections for the **Product, Mode**, and **Date Range** parameters. If you have selected to receive an additional CSV of tracking events, this will be noted. Once you are satisfied with your data selections, hit the “Confirm” option on the bottom right. Examples:
| Test data export - no tracking events | Live data export - with tracking events |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| | |
7\. You will be emailed an export link to the report that you just requested. (This will be emailed to the user who is logged into the Lob dashboard making the request.)
Data export examples
Email examples
Test environment data export with no tracking events
Live environment data export with tracking events
## **Video walkthrough**
{% embed url="https://lob.wistia.com/medias/ybxnsi18lt" %}
If you have any questions regarding exporting your data, reach out to your Customer Success Manager or to [support@lob.com](mailto:support@lob.com).
| 
|
7\. You will be emailed an export link to the report that you just requested. (This will be emailed to the user who is logged into the Lob dashboard making the request.)
