Exports & reporting

Click and conversion exports, CSV downloads, pivot reports, cohorts, LTV and real-time views — via dashboard, REST and MCP.

Updated 2026-09-02

REST exports#

EndpointReturns
GET /api/v1/clicks?limit=1000&since=…&gclid=…Click facts, newest first (max 1000 per call; page with since)
GET /api/v1/conversions?limit=1000Conversions
GET /api/dashboard/export?type=clicks|conversions|pivotCSV (dashboard session)
GET /api/protect/export?days=30Invalid-click evidence CSV (dashboard session)
Paginate clicks by time
curl -s "https://app.whichclick.is/api/v1/clicks?limit=1000&since=2026-09-01T00:00:00Z" -H "Authorization: Bearer wc_live_…"

Reports in the dashboard#

  • Overview — range picker (1 / 7 / 30 / 90 days), funnel (clicks → valid → installs → conversions), geo map, networks, campaign table with CPI / ROAS.
  • Real-time — last 15 minutes, live click stream.
  • Reports — pivot by campaign, network, device, OS, country, keyword, match type, creative or day; CSV export.
  • Cohorts & LTV — weekly install cohorts with D1 / D3 / D7 / D14 / D30 retention; LTV, CPI and ROAS per campaign.
  • Protect — invalid rate, reasons, top IPs, incidents, install fraud, CTIT histogram.

Daily rollups (StatDaily, refreshed by pnpm rollup) back the overview so large accounts stay fast; detail pages query raw clicks.

The same data for agents#

The MCP server exposes get_overview, get_pivot_report, get_metric_timeseries, get_cohorts, get_protection_stats, list_clicks and list_conversions with identical semantics — see MCP server. The in-dashboard assistant uses the same tools.

Retention#

Raw clicks are kept for the retention period configured per organization (default 13 months; EU region default 13 months, minimum 3). Rollups are kept indefinitely. The scheduler's retention purge runs nightly.