My case is show user use an app retention rate in last 30 day.
value = app opened count / total installed app count
How to do this by using Kibana?
The user schema is as follow, means who installed the app. The "created_on" can be the date when install the app.
{
"created_on" : {
"type" : "date"
},
"dob" : {
"type" : "date"
},
"email" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"fullname" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"id" : {
"type" : "long"
},
...
}
app usage schema is as follow:
{
"appid" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"user_id" : {
"type" : "long"
},
"duration" : {
"type" : "long"
},
"end_time" : {
"type" : "date"
},
"id" : {
"type" : "long"
},
"start_time" : {
"type" : "date"
}
}
So last 30 day app retention rate should be unique count of user who open the app (based on "start_time") divide by the total user who installed the app