Export raw view data

Raw view exports give you every view FastPix captured, as a CSV file you can load into your own database or data warehouse. FastPix generates one export per UTC day, containing every view that completed on that date, and returns a time-limited URL to download it. Use raw exports when you want to run your own analysis, join view data with other datasets, or archive it beyond the dashboard.

Choose an export method

FastPix delivers raw view data three ways. All three carry the same per-view fields, so pick the one that matches how you consume the data.

• Daily CSV export, described on this page. One file per UTC day, pulled on your own schedule. Best for batch loads and archival.
• Amazon Kinesis, a streaming export that writes each view to a Kinesis data stream in your AWS account in near real time.
• Google Cloud Pub/Sub, a streaming export that publishes each view to a Pub/Sub topic in your Google Cloud project in near real time.

The two streaming methods deliver a byte-for-byte identical record envelope, so a pipeline you build for one keeps working if you switch clouds.

Here is how the daily CSV and the streaming methods compare:

The methods are independent. Run one, the other, or both. The CSV covers the same views whether or not streaming is on, which is why it is the fallback if a streaming destination stops.

Before you begin

Make sure you have the following:

• A FastPix account on a paid plan. Raw view exports aren’t available on the free plan.
• Your Access Token ID and Secret Key for the FastPix API. See Activate your account.

How raw view exports work

• One file per day. A scheduled job runs once a day and produces a single CSV covering the whole previous UTC day, including views that completed earlier that day.
• Retained for 7 days. Each export is available for 7 days, then the file is deleted and its download URL stops working.
• Enabled two ways. Turn on daily CSV exports from Data Exports > CSV exports in your dashboard, or call the list endpoint, since the first call enables exports automatically. That first request returns an empty list and a message naming the date your first file will cover; your first file is produced by the next scheduled run.
• No backfill. Only dates on or after the day you enabled exports are available. Earlier dates are never generated.

To turn exports on from the dashboard, go to Data Exports > CSV exports and switch on Daily CSV exports.

Once enabled, a banner confirms the date your first file will cover and the daily run time.

List available exports

Call the List raw view exports endpoint to see which daily exports are ready and get a download URL for each.

curl "https://api.fastpix.com/v1/data/exports/rawViews?timespan[]=7:days" \
  -u "$ACCESS_TOKEN:$SECRET_KEY"

The timespan[] query parameter accepts a duration string from 1:days to 7:days. Because exports are retained for 7 days, that’s the widest window available. If you omit it, the full 7-day window is returned.

The key fields in each export record are:

Example response

{
  "success": true,
  "data": {
    "timeFrame": [
      1788348969,
      1788953769
    ],
    "totalRowCount": 7,
    "data": [
      {
        "files": [
          {
            "type": "csv",
            "downloadUrl": "https://storage.fastpix.net/exports/{workspaceId}/v1/views_2026-09-08.csv.gz?X-Amz-Algorithm=AWS4-HMAC-SHA256&…&X-Amz-Signature=…",
            "version": "v1",
            "rowCount": 1,
            "downloadUrlExpiresAt": "2026-09-16T04:01:27.960077Z"
          }
        ],
        "exportDate": "2026-09-08",
        "status": "COMPLETED"
      },
      {
        "files": [
          {
            "type": "csv",
            "downloadUrl": "https://storage.fastpix.net/exports/{workspaceId}/v1/views_2026-09-07.csv.gz?X-Amz-Algorithm=AWS4-HMAC-SHA256&…&X-Amz-Signature=…",
            "version": "v1",
            "rowCount": 0,
            "downloadUrlExpiresAt": "2026-09-15T04:01:20.729056Z"
          }
        ],
        "exportDate": "2026-09-07",
        "status": "EMPTY"
      },
      {
        "files": [
          {
            "type": "csv",
            "downloadUrl": "https://storage.fastpix.net/exports/{workspaceId}/v1/views_2026-09-04.csv.gz?X-Amz-Algorithm=AWS4-HMAC-SHA256&…&X-Amz-Signature=…",
            "version": "v1",
            "rowCount": 7,
            "downloadUrlExpiresAt": "2026-09-12T04:01:28.647078Z"
          }
        ],
        "exportDate": "2026-09-04",
        "status": "COMPLETED"
      }
    ]
  }
}

An export with status EMPTY still returns a valid file whose rowCount is 0 (the CSV contains only the header row). This example is truncated to three days; a full response lists every day in the requested window, most recent first.

Example response (first request)

On the first request that enables exports for your workspace, the data array is empty and a message names the date your first file will cover.

{
  "success": true,
  "data": {
    "timeFrame": [
      1788351436,
      1788956236
    ],
    "totalRowCount": 0,
    "message": "Exports are now enabled for this workspace. Your first CSV covers today (UTC) and will be generated by the scheduled job at 04:00 UTC. Dates before today are not exported.",
    "data": []
  }
}

Download an export

The download is a plain CSV saved as views_{date}.csv. Most HTTP clients, including Python requests and httpx and JavaScript fetch, handle it automatically.

The file is compressed in transit to save bandwidth. Clients that don’t request compression, such as curl, wget, and Java’s HttpClient, receive the compressed bytes instead of the CSV. With curl, ask for decompression explicitly:

curl --compressed -o views_2026-08-16.csv "<downloadUrl>"

Exports can be large. A busy day of roughly 200,000 views produces several hundred megabytes of CSV, so stream the file to disk and parse it row by row rather than loading it into memory, and use a database or data warehouse rather than a spreadsheet on high-volume days.

What’s in the export

Each row is one view, and each column is a field FastPix captured for that view, such as asnId, avgBitrate, browserName, country, viewStart, and watchTime. New columns are appended over time, so parse by column name, never by position. For the full field reference, see What Video Data do we capture.

The export includes the following columns, one per captured field, listed in the order they appear in the CSV.

Fields in the export

To see the format before you integrate, download a sample export:

• Download a sample raw view export (CSV)

Best practices

• Parse by column name, not position. New columns are appended over time.
• Replace by date, don’t append. If you download the same date more than once, replace that date’s rows rather than adding duplicates.
• Handle EMPTY days. A day with no views returns EMPTY with a rowCount of 0 and a valid file containing only the header row. This is a success, not an error, and needs no retry.
• Don’t store or share download URLs. Each one grants direct access to your view data and stays valid until the file expires. Fetch a fresh URL from the list endpoint when you need to download again.

If your plan changes

Moving to a free plan stops daily CSV exports. Existing files stay downloadable until they expire, and returning to a paid plan resumes generation with nothing to set up again.

What’s next

• What Video Data do we capture for the full field reference.
• Analyze viewer drop-off with ClickHouse to load exports into a warehouse and query them.
• List raw view exports API reference.