Skip to main content
Export data from Trackly SMS for use in spreadsheets, BI tools, or custom analysis.
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

FormatExtensionUse Case
CSV.csvExcel, Google Sheets, databases
Excel.xlsxMicrosoft 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

ColumnDescription
DimensionSelected breakdown
SendsMessage count
DeliveredDelivery count
ClicksClick count
Click RatePercentage
RevenueDollar amount

Message Export

ColumnDescription
Message IDUnique identifier
ToRecipient number
Sent AtTimestamp
StatusDelivery status
ClickedYes/No
RevenueAttributed amount

Scheduled Exports

Future support for:
  • Daily email reports
  • Webhook data delivery
  • S3 export

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

Reporting API endpoints are coming soon.
Future programmatic access to:
  • Performance data
  • Real-time metrics
  • Custom queries

Best Practices

Don’t rely solely on Trackly for data retention. Export periodically for backup.
Daily data for trends, hourly only when needed. More granular = larger files.
Exports may contain sensitive info. Store securely.

Next Steps

Metrics

Understand the data

Dashboard

Real-time views