Export raw data points
simpleanalytics_export_datapointsRead-only
Raw, unsampled page views or events of one website for a date range, as rows with only the fields asked for. The reply is capped at max_rows (default 100, max 1000) rows and 2 MB; "truncated" says more exist, so narrow the range. Rows are cut to about 40 000 characters of JSON. Dates: YYYY-MM-DD, or YYYY-MM-DDTHH for one hour (start and end the same day). Robots are left out unless asked. Needs the user id too. Export API: GET /api/export/datapoints.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end | Yes | End date, inclusive. | |
| type | No | Page views (default) or events. | |
| start | Yes | Start date (see description). | |
| fields | No | Fields to export (default added_iso, path, country_code, device_type, document_referrer). All: added_date, added_iso, added_unix, browser_name, browser_version, country_code, datapoint, device_type, document_referrer, duration_seconds, hostname, hostname_original, is_robot, is_unique, lang_language, lang_region, os_name, os_version, path, path_and_query, query, referrer_hostname, referrer_path, screen_height, screen_width, scrolled_percentage, session_id, user_agent, utm_campaign, utm_content, utm_medium, utm_source, utm_term, uuid, viewport_height, viewport_width, metadata.<key>_<text|int|bool|date>. datapoint is for events only; duration_seconds, is_unique and scrolled_percentage for pageviews only. | |
| hostname | Yes | Website hostname as shown in Simple Analytics, e.g. example.com (from simpleanalytics_list_websites). | |
| max_rows | No | Maximum rows returned (default 100). | |
| timezone | No | IANA time zone, e.g. Europe/Amsterdam. Default: the website setting. | |
| include_robots | No | Include robot/crawler traffic (default false). |