Data Takeout & Export

Your data belongs to you — including the right to take it with you. HitKeep supports full export on demand: every hit, every event, every user record, in open formats any tool can read. No support ticket. No export quota. No vendor gatekeeping.

This is what data ownership means in practice.

Site Export

Export the complete analytics history for a site:

# Parquet — most efficient for large datasets, compatible with DuckDB, Spark, Pandas, BigQuery
curl -L "https://your-hitkeep.example/api/sites/{site_id}/takeout?format=parquet" \
  -b "hk_token=YOUR_SESSION_COOKIE" \
  -o site_data.parquet

# CSV — compatible with Excel, Google Sheets, any data pipeline
curl -L "https://your-hitkeep.example/api/sites/{site_id}/takeout?format=csv" \
  -b "hk_token=YOUR_SESSION_COOKIE" \
  -o site_data.csv

# JSON — for programmatic processing
curl -L "https://your-hitkeep.example/api/sites/{site_id}/takeout?format=json" \
  -b "hk_token=YOUR_SESSION_COOKIE" \
  -o site_data.json

Export your own account data — every personal record HitKeep holds about your user account. This fulfills the right to data portability under GDPR Article 20:

curl -L "https://your-hitkeep.example/api/user/takeout" \
  -b "hk_token=YOUR_SESSION_COOKIE" \
  -o my_data.xlsx

Supported Formats

Format	Best for
`parquet`	Long-term archiving, DuckDB, Apache Spark, Pandas, data warehouse import
`csv`	Excel, Google Sheets, any tabular tool
`json`	Programmatic processing, API pipelines
`xlsx`	Default for user takeout — opens directly in spreadsheet apps

Exports land in the archive directory you configured on the instance.

What’s Included

Site exports contain every stored hit record with all fields: URL, referrer, country, device type, browser, OS, UTM parameters, and custom event data. Nothing is omitted or sampled. No artificial row limits.

User exports contain your account profile, site memberships, preferences, and API client records.

Querying Your Export

The Parquet format can be queried locally without importing it anywhere:

# Query directly with DuckDB CLI (free, open source)
duckdb -c "
  SELECT
    date_trunc('week', timestamp) AS week,
    referrer_domain,
    count(*) AS hits
  FROM 'site_data.parquet'
  GROUP BY 1, 2
  ORDER BY 1 DESC, 3 DESC
  LIMIT 20;
"

Migrating to Another Platform

Export → import workflow if you ever move your analytics to a different tool or data warehouse:

# 1. Export full history
curl -L ".../api/sites/{site_id}/takeout?format=parquet" \
  -b "hk_token=..." -o full_history.parquet

# 2. Import to BigQuery, Redshift, Snowflake, or any Parquet-compatible store
bq load --source_format=PARQUET my_project.analytics full_history.parquet

Your data stays yours — before, during, and after any platform switch.

HitKeep Cloud provides automated scheduled exports and encrypted backups, alongside the same self-service on-demand takeout. Your data stays portable regardless of where it’s hosted. Join the waitlist →