> ## Documentation Index
> Fetch the complete documentation index at: https://docs.trendteller.com.br/llms.txt
> Use this file to discover all available pages before exploring further.
# Data Exports
> Exporting and integrating your Trendteller data
## Overview
Trendteller provides multiple ways to export your e-commerce data for analysis in external tools, integration with other systems, or archival purposes.
## Export Methods
Export raw data to CSV for Excel, Google Sheets, or other tools
Generate formatted PDF reports with charts and visualizations
Programmatic access via GraphQL API for custom integrations
Automated email delivery on a schedule
## CSV Exports
### Exporting from Dashboard
Select the data you want to export:
* Date range
* Brand(s)
* Product categories
* Other filters
Click the "Export" button and select "CSV Export"
Choose which columns to include in your export:
* All fields
* Custom field selection
* Predefined templates
File is generated and downloaded automatically:
* Format: UTF-8 encoded CSV
* Filename: `trendteller_export_YYYY-MM-DD.csv`
### Available Data Sets
**Fields:**
* Order ID, Date, Time
* Brand, Customer ID
* Total amount, Discount, Tax
* Shipping method, Status
* Payment method
* Items (expandable)
**Fields:**
* Product ID, SKU
* Name, Description
* Category, Brand
* Price, Cost, Margin
* Stock quantity, Location
* Sales metrics
**Fields:**
* Customer ID, Name
* Email, Phone
* Address, City, State
* Registration date
* Total orders, Total spent
* Lifetime value
**Aggregated metrics:**
* Daily/weekly/monthly summaries
* Brand performance
* Category analytics
* Custom date ranges
Large exports (>100K rows) are processed in the background and emailed when ready.
## PDF Reports
### Report Types
High-level overview with key metrics:
* Revenue and growth
* Top products and categories
* Customer insights
* AI forecasts and recommendations
**Pages**: 2-3 pages
**Best for**: Weekly/monthly leadership updates
Comprehensive analysis with charts:
* All major metrics with trends
* Product performance tables
* Customer segmentation
* Comparative analysis
**Pages**: 10-15 pages
**Best for**: Deep dives and strategy sessions
Multi-brand comparative report:
* Side-by-side brand metrics
* Performance rankings
* Market share analysis
* Portfolio insights
**Pages**: 5-8 pages
**Best for**: Portfolio management
Build your own report:
* Choose metrics and charts
* Add custom text sections
* Include/exclude brands
* Save as template
**Pages**: Variable
**Best for**: Specific business needs
### Generating PDF Reports
```bash theme={null}
1. Navigate to Reports section
2. Select report type
3. Configure parameters (dates, brands, etc.)
4. Click "Generate PDF"
5. Download when processing completes (~30 seconds)
```
## API Access
### GraphQL API
Access all your data programmatically via GraphQL:
```graphql theme={null}
query ExportOrders {
orders(
where: {
created_at: { _gte: "2024-01-01" }
brand_id: { _eq: "brand-123" }
}
order_by: { created_at: desc }
limit: 1000
) {
id
total
status
customer {
name
email
}
items {
product {
name
sku
}
quantity
price
}
}
}
```
See the [API Reference](/api-reference/introduction) for complete documentation on available queries and authentication.
### Pagination
For large datasets, use pagination:
```graphql theme={null}
query ExportOrdersPaginated {
orders(
limit: 100
offset: 0
order_by: { created_at: desc }
) {
id
total
created_at
}
}
```
### Rate Limits
API rate limits depend on your plan:
| Plan | Requests/Hour | Concurrent |
| ---------- | ------------- | ---------- |
| Free | 100 | 2 |
| Pro | 1,000 | 10 |
| Enterprise | Custom | Custom |
## Scheduled Reports
### Setting Up Automated Reports
Design your report with desired filters and layout
Choose frequency:
* Daily (specific time)
* Weekly (day and time)
* Monthly (date and time)
* Custom (cron expression)
Add email addresses:
* Multiple recipients supported
* CC and BCC options
* Custom subject and message
Enable the scheduled report. You'll receive the first report at the next scheduled time.
### Report Formats
Scheduled reports can be sent as:
PDF report attached to email with summary in body
Raw data as CSV attachment for analysis
Email with link to interactive dashboard view
Post to Slack or Microsoft Teams channels
## Data Integration
### Webhooks
Receive real-time data updates via webhooks:
```json theme={null}
{
"event": "order.created",
"timestamp": "2024-01-15T10:30:00Z",
"data": {
"order_id": "ord_123",
"brand_id": "brand_456",
"total": 150.00,
"items": [...]
}
}
```
**Available Events:**
* `order.created`, `order.updated`, `order.cancelled`
* `product.created`, `product.updated`, `product.deleted`
* `inventory.updated`, `inventory.low_stock`
* `forecast.generated`, `insight.created`
### Third-Party Integrations
Export data directly to other platforms:
Automatic sync to Google Sheets:
* Real-time or scheduled updates
* Choose specific data tables
* Maintains formatting
Export to your data warehouse:
* Snowflake
* Redshift
* BigQuery (native)
* Azure Synapse
Connect directly to BI platforms:
* Tableau
* Power BI
* Looker
* Metabase
## Data Retention
**Export Data Retention:**
* CSV exports: Stored for 7 days
* PDF reports: Stored for 90 days
* API access: Real-time, no storage
* Scheduled reports: Last 30 reports stored
## Best Practices
Export data regularly for backup:
* Weekly full data export
* Daily incremental exports
* Store in secure location
Apply filters to reduce file size:
* Export only necessary date ranges
* Select specific brands or categories
* Choose relevant fields only
Use scheduled reports instead of manual exports:
* Consistent timing
* No manual effort
* Reliable delivery
## Next Steps
Learn about API-based data access
Write custom GraphQL queries
Set up real-time data webhooks
Best practices for integrations