At Keen we've always believe that you should have full access to your data. To prove it, one of the very first features we built into our platform was the ability to access your own data. We believe that this access to data via extraction is your right as our data customer.

Below is a step-by-step visual guide on how to retrieve your data in the form of a CSV. Prefer code? To read more about calling the <extraction> API endpoint, see our detailed feature spec here: https://keen.io/docs/api/#extractions

Download your "Raw Events" as a CSV: 

Step 1: Log in to keen.io/home and select your Organization name

Step 2: Select your Project name

Step 3: Select Explorer (upper right hand corner)  

Step 4: For Analysis Type, select "extraction" (see Fig 1 below)
            Select the Collection Name you're interested in viewing data from
            Select the radio button "Bulk CSV Extraction via Email"

Step 5: Enter in your Email Address (required).
             
Note: The max number of events you want to see is an optional field. 

Step 6: Select "Send Email Extraction"

You will receive a confirmation message with a green checkbox acknowledging that your request is being processed. The email will include a link to a downloadable file which may take several minutes to process. Once saved to your local computer, add the .csv extension and you're ready to go!  

Fig 1: Explorer Settings for Extraction


Download your query results as CSV: 

As of Dec 2016, you can now download query results displayed in the “Table” view on the Explorer as a CSV file! 

Step 1: Log in to keen.io/home and select your Organization name

Step 2: Select your Project name

Step 3: Select Explorer (upper right hand corner) 

Step 4: Create a query, and select the visualization type "Table" from the dropdown located in the upper-right corner of the Explorer UI

Step 5: Above the blue "Run Query" button, select the "Download CSV" button

A file will be downloaded to your local computer with the .csv extension. 

Note: If you have saved a name for your query, that saved query naming will be automatically applied to your filename. If your query is unnamed, we’ll provide a randomized filename. 

Did this answer your question?