---
title: "HitKeep Analytics Exports and Data Takeout | HitKeep"
description: "Export HitKeep analytics data in CSV, Parquet, JSON, NDJSON, or XLSX for audits, warehouse imports, GDPR portability, and vendor exit plans."
canonical: "https://hitkeep.com/guides/data/takeout/"
---

# HitKeep Analytics Exports and Data Takeout

HitKeep gives teams an open export path for analytics data. You can export site data, filtered hit data, Web Vitals samples, AI fetch records, AI chatbot events, saved Opportunities, and personal account data in formats that work with DuckDB, spreadsheets, scripts, and warehouses.

Use this guide when your search is “web analytics with open exports”, “analytics data portability”, or “how do I get raw analytics out of the product before choosing a vendor”.

## Export paths

| Export path | What it is for | Formats | Auth surface |
| --- | --- | --- | --- |
| Site takeout | Full site data package for portability or audit review | xlsx, csv, parquet, json, ndjson | Dashboard session |
| Filtered hits export | Raw hit export for a selected date range or filter | csv, xlsx, parquet, json, ndjson | Dashboard session, bearer token, or API key |
| AI fetch export | Server-side AI crawler records for a site and date range | csv, xlsx, parquet, json, ndjson | Dashboard session, bearer token, or API key |
| AI chatbot export | On-site assistant instrumentation events | csv, xlsx, parquet, json, ndjson | Dashboard session, bearer token, or API key |
| User takeout | Personal account data for GDPR portability | xlsx, csv, parquet, json, ndjson | Dashboard session |

Takeout endpoints default to `xlsx`. Hits exports default to `csv`. Set `format=parquet`, `format=json`, or `format=ndjson` when the export is headed to a data pipeline.

Hit rows in site takeout and filtered hit exports include the derived IP metadata columns HitKeep stores for analytics: region, city, provider, ASN, and ASN organization. HitKeep does not export raw visitor IP addresses.

Site takeout includes Web Vitals rows as `record_type = web_vital` when samples exist. Those rows contain metric name, value, server-derived rating, normalized path, navigation type, timestamp, tracker source, and tracker version.

Site takeout also includes saved Opportunities and safe AI run metadata when those records exist. Exported Opportunities keep localization keys, interpolation params, cited evidence IDs, detector metadata, status, and the final customer-visible output boundary. Takeout excludes provider secrets, raw prompts, raw provider responses, raw external error bodies, and unrestricted AI tool payloads.

For the generation model and API field contract, see [Opportunity Recommendations](https://hitkeep.com/guides/analytics/opportunities/).

## Site takeout

Export a complete site package from the generated API reference:

- [Export a site takeout](https://hitkeep.com/api/operations/apisitesidtakeout/)

The endpoint is session-authenticated. It is meant for signed-in operators who can access the site in the dashboard.

For warehouse work, request Parquet explicitly:

```
/api/sites/{site_id}/takeout?format=parquet
```

For spreadsheet review, use the default `xlsx` output:

```
/api/sites/{site_id}/takeout
```

## Filtered raw hit exports

When you only need a slice of traffic, use the hit export endpoint instead of a full takeout:

- [Export site hits](https://hitkeep.com/api/operations/apisitesidhitsexport/)

This endpoint accepts date range and filter parameters from the API reference. It is the better fit for recurring jobs that extract one campaign, one hostname, one referrer, or one investigation window.

Example export targets:

```
/api/sites/{site_id}/hits/export?from=2026-04-01T00:00:00Z&to=2026-04-30T23:59:59Z&format=csv
/api/sites/{site_id}/hits/export?filter=utm_source:newsletter&format=parquet
```

Use a scoped [API client](https://hitkeep.com/guides/security/api-clients/) for scheduled scripts so access can be revoked without changing a user password.

## Supported Formats

| Format | Best for |
| --- | --- |
| parquet | DuckDB, Apache Spark, Pandas, warehouse import, long-term analytical storage |
| csv | Simple tabular imports and scripts that expect text files |
| json | Programmatic processing where nested fields are easier to preserve |
| ndjson | Streaming pipelines and line-oriented processing |
| xlsx | Manual review in spreadsheet apps and user-facing takeout packages |

Retention archives and backup snapshots also use open files. See [Data Retention and Archiving](https://hitkeep.com/guides/data/retention/) for Parquet archives and [Backups and Restore](https://hitkeep.com/guides/data/backups-and-restore/) for full database snapshots.

For current runtime, storage, export, and non-replacement facts, see [Facts and Limits](https://hitkeep.com/reference/facts-and-limits/).

## Query a Parquet export

Parquet exports can be queried locally with DuckDB without importing them into another service:

```
duckdb -c "
  SELECT
    date_trunc('week', timestamp) AS week,
    referrer_domain,
    count(*) AS hits
  FROM 'site_hits.parquet'
  GROUP BY 1, 2
  ORDER BY 1 DESC, 3 DESC
  LIMIT 20;
"
```

This is useful for audits, support investigations, and migrations where you need to inspect the raw exported file before loading it elsewhere.

## Export AI visibility data

HitKeep’s AI reports are exportable through dedicated endpoints:

- [Export AI fetch records](https://hitkeep.com/api/operations/apisitesidai-fetchexport/)
- [Export AI chatbot events](https://hitkeep.com/api/operations/apisitesidai-chatbotsexport/)

Use these when you want server-side AI crawler analytics or assistant instrumentation outside the dashboard. For setup and interpretation, see [AI Visibility Analytics](https://hitkeep.com/guides/analytics/ai-visibility/) and [AI Chatbot Analytics](https://hitkeep.com/guides/analytics/ai-chatbot-analytics/).

## Export Web Vitals

Web Vitals are included in full site and user takeout as `record_type = web_vital`. Use those rows when you need to audit p75 changes outside HitKeep, join performance evidence to deployment windows, or preserve a vendor-neutral archive of opt-in performance samples.

For dashboard reporting and aggregate API access, see [Web Vitals Analytics](https://hitkeep.com/guides/analytics/web-vitals/).

## Export Opportunities

Opportunities are part of the full site takeout. They are recommendation records, not raw prompt transcripts.

Included fields are safe for customer review:

- translation keys such as `title_key`, `summary_key`, and `action_key`
- `copy_params` and route params used by localized dashboard copy
- cited evidence IDs and evidence labels/values
- detector version, impact, confidence, score, and status
- safe AI run metadata such as provider label, model label, template version, hashes, token counts, status, and error category

Excluded fields stay unavailable because they can contain secrets, prompt internals, provider payloads, or visitor-level data.

## User takeout and GDPR portability

Users can export their own account data through the user takeout endpoint:

- [Export your user takeout](https://hitkeep.com/api/operations/apiusertakeout/)

This supports GDPR Article 20 data portability workflows. For compliance context, see [GDPR for HitKeep](https://hitkeep.com/compliance/gdpr/).

## Migration workflow

A practical vendor-exit workflow looks like this:

1. Export the site via [the site takeout endpoint](https://hitkeep.com/api/operations/apisitesidtakeout/).
2. Export high-volume hit slices through [the filtered hits export endpoint](https://hitkeep.com/api/operations/apisitesidhitsexport/) if you need smaller files.
3. Query a Parquet sample with DuckDB to verify date ranges and field coverage.
4. Import the resulting Parquet, CSV, JSON, or NDJSON files into your warehouse or next analytics stack.

If you are replacing Google Analytics, pair this page with the [self-hosted GA4 alternative guide](https://hitkeep.com/use-cases/self-hosted-ga4-alternative/) and the [Google Analytics comparison](https://hitkeep.com/vs/google-analytics/).

## Self-hosted or managed

Self-hosted HitKeep keeps exports inside infrastructure you control. Configure paths and storage targets in the [Configuration Reference](https://hitkeep.com/reference/configuration/#data-management), then decide whether exports stay on local disk or move to S3-compatible storage through [S3 Backups](https://hitkeep.com/guides/data/s3-backups/).

Use [HitKeep Cloud](https://hitkeep.com/pricing/) when you want managed hosting, updates, and encrypted backups while still keeping self-service export paths available.

## Related

- [Data Retention and Archiving](https://hitkeep.com/guides/data/retention/)
- [Backups and Restore](https://hitkeep.com/guides/data/backups-and-restore/)
- [Facts and Limits](https://hitkeep.com/reference/facts-and-limits/)
- [API Clients](https://hitkeep.com/guides/security/api-clients/)
- [Opportunity Recommendations](https://hitkeep.com/guides/analytics/opportunities/)
- [Web Vitals Analytics](https://hitkeep.com/guides/analytics/web-vitals/)
- [AI Visibility Analytics](https://hitkeep.com/use-cases/ai-visibility-analytics/)
- [Self-Hosted GA4 Alternative](https://hitkeep.com/use-cases/self-hosted-ga4-alternative/)
- [REST API Reference](https://hitkeep.com/api/)

[Previous Disaster recovery](https://hitkeep.com/guides/data/disaster-recovery/)[Next Teams and data isolation](https://hitkeep.com/guides/admin/teams/)