Skip to main content

​
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

CSV Export

Export raw data to CSV for Excel, Google Sheets, or other tools

PDF Reports

Generate formatted PDF reports with charts and visualizations

API Access

Programmatic access via GraphQL API for custom integrations

Scheduled Reports

Automated email delivery on a schedule

​
CSV Exports

​
Exporting from Dashboard

1

Apply Filters

Select the data you want to export:
  • Date range
  • Brand(s)
  • Product categories
  • Other filters
2

Choose Export

Click the “Export” button and select “CSV Export”
3

Select Fields

Choose which columns to include in your export:
  • All fields
  • Custom field selection
  • Predefined templates
4

Download

File is generated and downloaded automatically:
  • Format: UTF-8 encoded CSV
  • Filename: trendteller_export_YYYY-MM-DD.csv

​
Available Data Sets

  • Orders
  • Products
  • Customers
  • Analytics
Fields:
  • Order ID, Date, Time
  • Brand, Customer ID
  • Total amount, Discount, Tax
  • Shipping method, Status
  • Payment method
  • Items (expandable)
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

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: 
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 for complete documentation on available queries and authentication.

​
Pagination

For large datasets, use pagination: 
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:
PlanRequests/HourConcurrent
Free1002
Pro1,00010
EnterpriseCustomCustom

​
Scheduled Reports

​
Setting Up Automated Reports

1

Create Report

Design your report with desired filters and layout
2

Set Schedule

Choose frequency:
  • Daily (specific time)
  • Weekly (day and time)
  • Monthly (date and time)
  • Custom (cron expression)
3

Configure Recipients

Add email addresses:
  • Multiple recipients supported
  • CC and BCC options
  • Custom subject and message
4

Activate

Enable the scheduled report. You’ll receive the first report at the next scheduled time.

​
Report Formats

Scheduled reports can be sent as:

Email with PDF

PDF report attached to email with summary in body

CSV Attachment

Raw data as CSV attachment for analysis

Dashboard Link

Email with link to interactive dashboard view

Slack/Teams

Post to Slack or Microsoft Teams channels

​
Data Integration

​
Webhooks

Receive real-time data updates via webhooks: 
{
  "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:
  • Google Sheets
  • Data Warehouses
  • BI Tools
Automatic sync to Google Sheets:
  • Real-time or scheduled updates
  • Choose specific data tables
  • Maintains formatting

​
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

API Reference

Learn about API-based data access

GraphQL Queries

Write custom GraphQL queries

Webhooks

Set up real-time data webhooks

Integration Guide

Best practices for integrations