We plan to use Keen as our tracking core, but combining requests and extracting data is a big deal for us.
If we have for example one collection named pageviews, with a user as a property of it (like so : {"name": "pageviews", "properties":{"user":{"id":"4242"},"url":"https://keen.io/"}}), and another collection named purchases with the same user property inside :
How can we get the number of unique users who have visited at least 3 times one url and that have completed one other event "purchases" ?
How can we extract those persons ? Is it possible to do it with the Amazon S3 data replication ? (with Amazon Athena ?). The "extraction" feature does not seem to satisfy our extraction problematic as we can't apply "group by" statements and we can't combine multiple event for the extraction (am I wrong ?).
Our goal is to use Keen not only as a statistic analyser but also as a powerful data support for our segmentation/extraction use.