Exporting Reports

Export your campaign analytics data for external analysis, reporting, or record-keeping. Smart Cycle Discounts Pro supports multiple export formats. This feature requires Smart Cycle Discounts Pro.

---

Export Options #

Export Formats #

Format	Best For	Opens In
CSV	Spreadsheet analysis	Excel, Google Sheets, Numbers
JSON	Developer integration	Code editors, APIs

---

Exporting from Analytics Dashboard #

1. Go to SC Discounts → Analytics
2. Select your desired date range
3. Click the “Export” button (top right)
4. Choose export format (CSV or JSON)
5. Click “Download”

The export includes all data visible on the current dashboard view.

---

What Gets Exported #

Summary Data #

• Total revenue
• Total conversions
• Total discount amount
• Average order value
• Date range of export

Campaign Data #

Per-campaign breakdown:

• Campaign ID and name
• Status
• Revenue
• Conversions
• Units sold
• Discount amount given
• Start and end dates

Time Series Data #

Daily/weekly/monthly totals (based on chart granularity):

• Date
• Revenue
• Conversions
• Discount amount

---

CSV Export Format #

File Structure #

analytics-export-2025-12-01-to-2025-12-31.csv

Date,Campaign,Revenue,Conversions,Units_Sold,Discount_Given
2025-12-01,Black Friday Sale,1250.00,25,42,312.50
2025-12-01,Weekly Deal,450.00,12,18,67.50
2025-12-02,Black Friday Sale,980.00,19,31,245.00
...

CSV Options #

• Delimiter: Comma (,) by default
• Encoding: UTF-8
• Header row: Included

---

JSON Export Format #

File Structure #

{
  "export_date": "2025-12-31T12:00:00",
  "date_range": {
    "start": "2025-12-01",
    "end": "2025-12-31"
  },
  "summary": {
    "total_revenue": 45000.00,
    "total_conversions": 850,
    "total_discount": 11250.00,
    "avg_order_value": 52.94
  },
  "campaigns": [
    {
      "id": 123,
      "name": "Black Friday Sale",
      "status": "expired",
      "revenue": 25000.00,
      "conversions": 450,
      "units_sold": 680,
      "discount_given": 6250.00
    },
    ...
  ],
  "daily_data": [
    {
      "date": "2025-12-01",
      "revenue": 1700.00,
      "conversions": 37,
      "discount": 380.00
    },
    ...
  ]
}

---

Exporting Specific Campaigns #

Single Campaign Export #

1. Click on a campaign name to open overview panel
2. Click “Export Data” in the panel
3. Choose format and download

Filtered Export #

1. Use campaign filters (status, search)
2. Only filtered campaigns export

---

Using Exported Data #

In Excel/Google Sheets #

1. Open CSV file directly
2. Create pivot tables for analysis
3. Build charts and visualizations
4. Combine with other business data

For Reporting #

• Monthly/quarterly executive summaries
• Marketing performance reports
• Finance reconciliation
• Board presentations

For Integration #

• Import into BI tools (Tableau, Power BI)
• Feed into data warehouses
• Sync with CRM systems
• Build custom dashboards

---

Export Tips #

Best Practices #

1. Export regularly: Weekly or monthly exports create historical records
2. Match date ranges: Export periods that align with business reporting cycles
3. Archive exports: Keep downloaded files organized by date
4. Verify data: Spot-check exported numbers against dashboard

Large Exports #

For very large date ranges:

• Export may take longer to generate
• Consider breaking into smaller periods
• Browser download dialog appears when ready

---

Automation #

Scheduled Reports #

Set up automatic scheduled exports delivered via email. See Scheduled Reports documentation.

REST API #

Pro users can access analytics data via REST API for automated retrieval. See Developer Documentation.

---

Data Included per Export Type #

Data Type	CSV	JSON
Summary totals	✓	✓
Campaign breakdown	✓	✓
Daily/time series	✓	✓
Product details	Optional	✓
Geographic data	Optional	✓
Metadata	Header row	✓

---

Troubleshooting Exports #

Export button not working #

• Check browser pop-up blocker
• Ensure JavaScript is enabled
• Try a different browser

CSV opens incorrectly in Excel #

• Use “Import” instead of “Open” in Excel
• Specify UTF-8 encoding
• Select comma delimiter

Data seems incomplete #

• Verify date range selection
• Check if filters are applied
• Export includes only visible data scope