Skip to content
Browse documentation

Exports

Every way to get data out of TrackCrown — CSV downloads from reports and logs, billing and tax files, scheduled e-mails, the REST API and raw data export.

Last updated 3 min read

On this page

All panel exports are UTF-8 CSV files with a byte-order mark, so Excel opens them with the right encoding. Every export is scoped to the signed-in user: partners and advertisers only ever export their own rows with their own restricted columns.

Report and log exports#

WhatWhereRowsWho
Report builder viewReports → Export CSVEvery row of the view, up to 200,000, in the view's order (the hint says "Download the first 200,000 of N rows" when larger)Staff, partners, advertisers
Raw clicksClicks → CSV exportUp to 100,000 clicks matching the filters and search, streamed from the click storeStaff only
ConversionsConversions → CSV exportUp to 100,000 conversions matching the filters; audited as conversions.exportStaff (conversions read), partners, advertisers

The report export repeats the current date range, time zone, grouping, filters, metric filters, metrics, currency and sort. Columns are the visible metrics and dimensions with their labels.

Table exports#

Most other tables in the panel (offers, partners, access rows, audit log, adjustments…) have an Export CSV button in their toolbar. It downloads the rows currently loaded in the table — after filters and sorting, with the visible columns and the totals row when there is one. For large lists, page through or narrow the filters first.

Billing and tax exports#

WhatWhereNotes
Invoices CSVBilling → Invoices exportnumber, advertiser, advertiser_email, period_start, period_end, status, currency, amount, adjustments, total, due_date, paid_at, created_at
Payouts CSVBilling → Payouts export, or Export selectedMass-payment friendly: payout_id, affiliate_id, affiliate_code, affiliate_name, email, method, details, amount, amount_exact, currency, period_start, period_end, status, reference, paid_at
QuickBooks Online / XeroAccounting menu on both listsImport files, one row per line. See Accounting export.
PDFPDF button on an invoice or statementPrintable document with your invoice details.
1099-NECBilling → Tax formsContains full taxpayer IDs; admins/owners only, audited. See Tax forms.

Other CSV downloads#

WhatWhere
Terms acceptance logPartners → Partner program → Terms → Export CSV
CouponsPartners → Coupons → Export CSV (the page also imports coupons from CSV)

Scheduled e-mail exports#

Any saved report view can be e-mailed as a CSV attachment every day, week or month (up to 50,000 rows). See Scheduled reports.

API#

Everything in the report builder is available from the REST API with an API key:

Shell
curl -sS 'https://app.trackcrown.com/api/v1/reports?from=2026-10-01&to=2026-10-11&tz=UTC&group_by=offer,affiliate&metrics=clicks,conversions,revenue,payout&format=csv' \
  -H 'Authorization: Bearer atk_YOUR_API_KEY' -o report.csv

Use API request in the report builder to get the exact call for a view. Clicks and conversions have their own endpoints (/api/v1/clicks, /api/v1/conversions). See API overview.

Raw data export to your storage#

For a complete feed of clicks and conversions into your own data warehouse, configure Tracking → Integrations → Data export: the worker uploads every completed hour as gzip JSONL or CSV to S3-compatible storage. See Raw data export. SFTP and Pub/Sub destinations are not available.

Limits at a glance#

ExportMaximum
Report CSV200,000 rows
Clicks CSV100,000 clicks
Conversions CSV100,000 conversions
Scheduled report e-mail50,000 rows (longer reports are truncated with a note)
Report API page10,000 rows (paginate with limit/offset)
Report window400 days; clicks are kept 13 months

Related#

Something unclear or missing in this article?Tell us