- Streams
- Compute
- Overview
- Saved Queries
- Data Explorer Guide
- Group By Ranges & Buckets
- Video Completion Funnel
- Compute Pricing Guide
- Custom Ad Performance
- Session Timing Metrics
- Cohort Analysis
- Retention Analysis
- Funnel Analysis
- Creating a Funnel with an OR Condition
- Stripe Revenue Queries
- Create a Email Nightly Report
- Query Tuning
- Cached Queries
- Cached Datasets
- Paid Session Metrics
- User Engagement
- Visualize
Bulk Loading Guide
Import historical events from CSV or JSON
Import historical events from CSV or JSON via command line with keen-cli.
Installation instructions:
- Follow the instructions in the keen-cli README.md.
- Once you upload your data, verify if it was successful by viewing the Streams Manager in your Keen project console.
Here’s an example command that adds events from a CSV file into a Keen collection called “signups”.
$ keen events:add --collection signups --file events.csv --csv
Load Historical Data Programmatically
There are a few options for loading your historical event data programatically:
- Use the
publish_batch
method in the Keen Ruby Client - Use the
add_events
method in the Keen Python Client
Tips for bulk loading:
- Make sure you set the keen.timestamp property to your historical event’s timestamp. Otherwise Keen will assume your event happened at the time you posted it.
- We recommend posting in batches of 5,000 events or smaller.
Once the API acknowledges that your event has been stored, it may take up to 10 seconds before it will appear in query results.