> ## Documentation Index
> Fetch the complete documentation index at: https://docs.tracklysms.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Exports

> Export report data for external analysis

Export data from Trackly SMS for use in spreadsheets, BI tools, or custom analysis.

<Info>
  Exports are available via the reporting API and as scheduled reports. The `report_generator_job` runs every 15 minutes, generating CSV files uploaded to cloud storage with email notifications to recipients.

  ## Export Formats

  | Format | Extension | Use Case                        |
  | ------ | --------- | ------------------------------- |
  | CSV    | .csv      | Excel, Google Sheets, databases |
  | Excel  | .xlsx     | Microsoft Excel                 |

  ## Exporting Reports

  ### Performance Report

  1. Go to **Reports > Performance**
  2. Configure your report (dimension, date range)
  3. Click **Export**
  4. Choose format
  5. Download file

  ### LTV Report

  1. Go to **Reports > LTV Cohorts**
  2. Set cohort parameters
  3. Click **Export**
  4. Download

  ### Campaign Report

  1. Go to **Schedules**
  2. Click on a campaign
  3. Click **Export**
  4. Download performance data

  ## Export Contents

  ### Performance Export

  | Column     | Description        |
  | ---------- | ------------------ |
  | Dimension  | Selected breakdown |
  | Sends      | Message count      |
  | Delivered  | Delivery count     |
  | Clicks     | Click count        |
  | Click Rate | Percentage         |
  | Revenue    | Dollar amount      |

  ### Message Export

  | Column     | Description       |
  | ---------- | ----------------- |
  | Message ID | Unique identifier |
  | To         | Recipient number  |
  | Sent At    | Timestamp         |
  | Status     | Delivery status   |
  | Clicked    | Yes/No            |
  | Revenue    | Attributed amount |

  ## Scheduled Exports

  Future support for:

  * Daily email reports
  * Webhook data delivery
  * S3 export
</Info>

## Data Retention

Export data is available for:

* Last 365 days: Full detail via API query
* Older: Aggregated only

Create a support ticket from your dashboard (**Support > New Ticket**) for historical data needs.

## Large Exports

For exports over 100,000 rows:

1. Export runs in background
2. You receive notification when ready
3. Download link expires in 24 hours

## API Access

<Info>
  Reporting API endpoints are coming soon.
</Info>

Future programmatic access to:

* Performance data
* Real-time metrics
* Custom queries

## Best Practices

<AccordionGroup>
  <Accordion title="Export regularly">
    Don't rely solely on Trackly for data retention. Export periodically for backup.
  </Accordion>

  <Accordion title="Use appropriate granularity">
    Daily data for trends, hourly only when needed. More granular = larger files.
  </Accordion>

  <Accordion title="Protect exported data">
    Exports may contain sensitive info. Store securely.
  </Accordion>
</AccordionGroup>

## Next Steps

<CardGroup cols={2}>
  <Card title="Metrics" icon="chart-bar" href="/guides/reporting/metrics">
    Understand the data
  </Card>

  <Card title="Dashboard" icon="gauge" href="/guides/reporting/overview">
    Real-time views
  </Card>
</CardGroup>