Funnel creation problem on keen.io where actorProperty has different type of events
I am trying to set up a funnel. The problem is that "actorProperty" is stored as an integer in the first event and stored as a string in the second.
Below is an example of JSON stored in sharp (look in the "app_id" field):
Event 1
{
"keen": {
"timestamp": "2014-10-17T12:28:35.000Z",
"created_at": "2014-10-17T12:28:35.805Z",
"id": "510b7481961a5ad07165"
},
"app_id": 861,
"old_plan": "Trial"
},
Event 2:
{
"keen": {
...
},
"metadata": {
"plan": "Premium",
"app_id": "861"
}
}
The funnel visualization does not work for the second event, it has no effect ... Below is the code to generate the sequence:
var funnel = new Keen.Query('funnel', {
steps: [
{
eventCollection: "Event 1",
actorProperty: "app_id"
},
{
eventCollection: "Event 2",
actorProperty: "metadata.app_id"
}
],
timeframe: "this_month"
});
Do you have any recommendations on how to proceed in this case?
source to share
The best way to promote is to basically correct the data you entered into Keene. Keen does not provide updates to existing records, but has a nice way to export and then re-import the data after cleaning it up.
Have a look at the keen-cli gem that lets you get the CSV of all events:
keen queries:run --collection "Event 2" --analysis-type extraction --email your@emailaddress.com
Once you clear the CSV (strip those quotes), you can re-import it:
keen events:add --file fixed_events.csv --csv
If you need to delete entries there, take a look at the command keen collections:delete
.
source to share