Export API - Export Your Project's Event Data

 Export all event data for a given project that were uploaded within a specified range of dates. The results are returned as a zipped archive of JSON files, one or multiple files per hour.

In the examples below the parameters are highlighted in purple, and the values in red are what you need to replace with the parameters you are specifically interested in.

Unzipping Instructions:

• Mac: Open the zip file or use the terminal.
• Windows: Use WinRAR or 7zip.

Table of Contents

• Export API Parameters
• Parameters
• Returns
• Example Request

Important Note:

• The specified date range is the time of when the event data was uploaded to Amplitude servers (see server_upload_time). The Export API returns events timestamped in UTC. Data is available to export at a minimum within 2 hours of when our servers received it. For example, data sent between 8-9PM will begin loading at 9PM and will be available via the Export API at 11PM. Note that there is no delay in platform reporting--this delay is only for data you wish to export.
• Export API is not supported for a cross-project view because the view doesn’t own any data. To export all the data in the view, you would need to call the Export API on the underlying projects that actually ingested the data.
• Size limit is 4GB. If an hour's worth of data exceeds 4GB, please reach out to your Customer Success Manager to learn more about the S3 export solution.

Export API Parameters

Authenticate via basic authentication with the credentials YOUR_API_KEY:YOUR_SECRET_KEY. More information on how to find your API and Secret Keys here.

GET https://amplitude.com/api/2/export

Parameters

Returns

The response is a zipped archive of JSON files, with potentially multiple files per hour. Note that events prior to 2014-11-12 will be grouped by day instead of by the hour. If you request data for a time range during which no data has been collected for the project, then you will receive a 404 response from our server.

There is one event JSON object per line in the file, with the following schema:

{
 "server_received_time": UTC ISO-8601 formatted timestamp,
 "app": int,
 "device_carrier": string,
 "$schema":int,
 "city": string,
 "user_id": string,
 "uuid": UUID,
 "event_time": UTC ISO-8601 formatted timestamp,
 "platform": string,
 "os_version": string,
 "amplitude_id": long,
 "processed_time": UTC ISO-8601 formatted timestamp, 
 "user_creation_time": UTC ISO-8601 formatted timestamp,
 "version_name": string,
 "ip_address": string,
 "paying": boolean,
 "dma": string,
 "group_properties": dict,
 "user_properties": dict,
 "client_upload_time": UTC ISO-8601 formatted timestamp,
 "$insert_id": string,
 "event_type": string,
 "library":string,
 "amplitude_attribution_ids": string,
 "device_type": string,
 "device_manufacturer": string,
 "start_version": string,
 "location_lng": float,
 "server_upload_time": UTC ISO-8601 formatted timestamp,
 "event_id": int,
 "location_lat": float,
 "os_name": string,
 "amplitude_event_type": string,
 "device_brand": string,
 "groups": dict,
 "event_properties": dict,
 "data": dict,
 "device_id": string,
 "language": string,
 "device_model": string,
 "country": string,
 "region": string,
 "is_attribution_event": bool,
 "adid": string,
 "session_id": long,
 "device_family": string,
 "sample_rate": null,
 "idfa": string,
 "client_event_time": UTC ISO-8601 formatted timestamp,
}

Example Request

curl -u API_Key:Secret_Key 'https://amplitude.com/api/2/export?start=20150201T5&end=20150203T20' >> yourfilename.zip

You should replace the red values with your project's API Key, Secret Key, the date range you're interested in, and the name of the file you want to export the data to.