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

# CSV Exports

> Export your Trakkr visibility data to CSV files for offline analysis and custom reporting

<Info>
  CSV Exports are available on all paid plans (Growth and Scale). [Upgrade to access](/plans)
</Info>

## Overview

CSV Exports let you download your Trakkr data in flexible formats for offline analysis, custom reporting, or integration with other tools. Choose from three export types depending on your needs.

### When to Use CSV Exports

CSV Exports are ideal for:

* **One-time analysis** - Download data when you need it, not on a schedule
* **Offline work** - Analyze data in Excel, R, Python, or other offline tools
* **Custom date ranges** - Export specific time periods for reports
* **Flexibility** - Mix and match export types for different needs
* **No automation needed** - Manual exports when you need them

### Consider These Alternatives

<CardGroup cols={2}>
  <Card title="Google Sheets" icon="table" color="#0e9373" href="/google-sheets">
    **Better for**: Daily auto-sync, team collaboration, always-current data
  </Card>

  <Card title="API" icon="code" color="#0e9373" href="/api">
    **Better for**: Automated workflows, custom integrations, real-time access
  </Card>
</CardGroup>

## Export Types

### Top-Level

**Best for**: Executive dashboards, trend analysis, and high-level reporting

A comprehensive overview of brand performance over time, ideal for executive dashboards and trend analysis.

**Columns included**:

* **Date**: Daily timestamp
* **Brand**: Your brand name
* **Visibility**: Daily visibility score
* **Presence**: Daily presence score

This export provides a clean, aggregated view perfect for building charts and graphs that show performance trends over time.

### Detailed

**Best for**: In-depth analysis, prompt-level optimization, and content strategy

Focused analysis of your primary brand's ranking performance across different prompts and models.

**Columns included**:

* **Date**: Daily timestamp
* **Prompt**: The specific prompt tracked
* **Tag**: Prompt category/tag (if enabled)
* **Model**: AI model that generated the response
* **Rank**: Your brand's ranking position

This export shows individual prompt-model pairings, allowing you to identify which prompts perform well and which need optimization.

### Raw Data

**Best for**: Competitive intelligence, market analysis, and comprehensive data science projects

Complete competitive intelligence with full rankings from every AI response.

**Columns included**:

* **Date**: Daily timestamp
* **Prompt**: The specific prompt tracked
* **Tag**: Prompt category/tag (if enabled)
* **Model**: AI model that generated the response
* **Rank1** through **Rank10**: Brands ranked in positions 1-10

This export provides the most comprehensive data, showing not just your performance but the complete competitive landscape for every prompt and model.

## Creating an Export

<Steps>
  <Step title="Navigate to CSV Exports">
    Go to **Integrations** → **CSV Exports**.
  </Step>

  <Step title="Choose your export type">
    Select **Top-Level**, **Detailed**, or **Raw Data** based on your needs.
  </Step>

  <Step title="Review columns">
    See which columns will be included in your export to ensure it matches your requirements.

    <img src="https://mintcdn.com/trakkr/QBrKIHiICzhlgzzT/images/Screenshot2025-11-06at19.45.54.png?fit=max&auto=format&n=QBrKIHiICzhlgzzT&q=85&s=815bdaa9e7b49b3c610a75cc85f442ff" alt="Screenshot2025 11 06at19 45 54 Pn" width="1420" height="776" data-path="images/Screenshot2025-11-06at19.45.54.png" />
  </Step>

  <Step title="Start the export">
    Click **Start Export**. The export typically completes within 30 seconds.
  </Step>
</Steps>

## Managing Exports

### Viewing Previous Exports

All your generated exports appear in the **\[Brand]'s exports** section below the creation form.

<img src="https://mintcdn.com/trakkr/2os7ytZDDpu4oRid/images/Screenshot2025-11-06at19.46.49.png?fit=max&auto=format&n=2os7ytZDDpu4oRid&q=85&s=d5550710fcc3b8dadb7ffbb96a0f9ced" alt="Screenshot2025 11 06at19 46 49 Pn" width="1420" height="526" data-path="images/Screenshot2025-11-06at19.46.49.png" />

For each export, you can:

* **Download**: Save the CSV file to your computer
* **Copy Link**: Get a shareable link to the export file
* **Delete**: Remove the export from your account

<Note>
  Export files are automatically deleted after 30 days. Download important exports for long-term storage.
</Note>

### Export Retention

* **Storage period**: 30 days from creation
* **File format**: Standard CSV (comma-separated values)
* **Naming**: Exports are labeled by type and creation date

## Use Cases

<AccordionGroup>
  <Accordion title="Executive Reporting">
    Use **Top-Level** exports to create executive dashboards in Excel, Tableau, or PowerPoint. Show visibility and presence trends over time with clean, aggregated data.
  </Accordion>

  <Accordion title="Content Optimization">
    Use **Detailed** exports to identify which prompts need improvement. Filter by tag to analyze category performance and prioritize content updates.
  </Accordion>

  <Accordion title="Competitive Analysis">
    Use **Raw Data** exports to understand the complete competitive landscape. Identify which competitors consistently outrank you and on which prompts.
  </Accordion>

  <Accordion title="Data Science Projects">
    Use **Raw Data** exports for machine learning or statistical analysis. The comprehensive dataset includes all competitors and historical performance.
  </Accordion>

  <Accordion title="Client Reporting">
    Agencies can use **Top-Level** exports to create client reports showing performance improvements over time. Combine with competitive data from **Raw Data** exports.
  </Accordion>
</AccordionGroup>

## Tips for Working with CSV Exports

### Data Analysis

* **Pivot tables**: Use Excel or Google Sheets pivot tables to aggregate and analyze data
* **Charts**: Create time-series charts to visualize visibility and presence trends
* **Filtering**: Filter by date range, prompt, or model to focus on specific insights

### Combining Export Types

Consider using multiple export types for comprehensive analysis:

1. **Top-Level** for overall trend visualization
2. **Detailed** for prompt-specific optimization
3. **Raw Data** for competitive intelligence

### Automation

For automated data pipelines, consider using the [API](/api) or [Google Sheets sync](/google-sheets) instead of manual CSV exports.

## Troubleshooting

### Export Taking Too Long

Exports typically complete within 30 seconds. If an export takes longer:

* Check your internet connection
* Refresh the page to see if the export has completed
* Try creating a new export if the first attempt fails

### Missing Data

If your export appears incomplete:

* Ensure you have tracking data for the selected time period
* Verify that prompts are active and running
* Check that you're on a paid plan (required for exports)

### File Format Issues

If you encounter issues opening CSV files:

* Ensure you're using a compatible application (Excel, Google Sheets, etc.)
* Check that the file extension is `.csv`
* Try opening with a text editor to verify the file structure

## Related Integrations

<CardGroup cols={2}>
  <Card title="Google Sheets" icon="table" color="#0e9373" href="/google-sheets">
    Automate data exports with daily Google Sheets sync
  </Card>

  <Card title="API" icon="code" color="#0e9373" href="/api">
    Build custom integrations with programmatic API access
  </Card>

  <Card title="Looker Studio" icon="chart-mixed" color="#0e9373" href="/looker-studio">
    Create interactive dashboards with Looker Studio
  </Card>
</CardGroup>