class TestFunnel(ClickhouseTestMixin,
funnel_test_factory(ClickhouseFunnel, _create_event,
_create_person)): # type: ignore
maxDiff = None
def _get_people_at_step(self, filter, funnel_step, breakdown_value=None):
person_filter = filter.with_data({
"funnel_step":
funnel_step,
"funnel_step_breakdown":
breakdown_value
})
result = ClickhouseFunnelPersons(person_filter,
self.team)._exec_query()
return [row[0] for row in result]
def test_basic_funnel_default_funnel_days(self):
filters = {
"events": [
{
"id": "user signed up",
"type": "events",
"order": 0
},
{
"id": "paid",
"type": "events",
"order": 1
},
],
"insight":
INSIGHT_FUNNELS,
"date_from":
"2020-01-01",
"date_to":
"2020-01-14",
}
filter = Filter(data=filters)
funnel = ClickhouseFunnel(filter, self.team)
# event
_create_person(distinct_ids=["user_1"], team_id=self.team.pk)
_create_event(
team=self.team,
event="user signed up",
distinct_id="user_1",
timestamp="2020-01-02T14:00:00Z",
)
_create_event(
team=self.team,
event="paid",
distinct_id="user_1",
timestamp="2020-01-10T14:00:00Z",
)
with self.assertNumQueries(1):
result = funnel.run()
self.assertEqual(result[0]["name"], "user signed up")
self.assertEqual(result[0]["count"], 1)
self.assertEqual(len(result[0]["people"]), 1)
self.assertEqual(result[1]["name"], "paid")
self.assertEqual(result[1]["count"], 1)
self.assertEqual(len(result[1]["people"]), 1)
def test_basic_funnel_with_repeat_steps(self):
filters = {
"events": [
{
"id": "user signed up",
"type": "events",
"order": 0
},
{
"id": "user signed up",
"type": "events",
"order": 1
},
],
"insight":
INSIGHT_FUNNELS,
"funnel_window_days":
14,
}
filter = Filter(data=filters)
funnel = ClickhouseFunnel(filter, self.team)
# event
person1_stopped_after_two_signups = _create_person(
distinct_ids=["stopped_after_signup1"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_signup1")
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_signup1")
person2_stopped_after_signup = _create_person(
distinct_ids=["stopped_after_signup2"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_signup2")
result = funnel.run()
self.assertEqual(result[0]["name"], "user signed up")
self.assertEqual(result[0]["count"], 2)
self.assertEqual(len(result[0]["people"]), 2)
self.assertEqual(result[1]["count"], 1)
self.assertEqual(len(result[1]["people"]), 1)
self.assertCountEqual(
self._get_people_at_step(filter, 1),
[
person1_stopped_after_two_signups.uuid,
person2_stopped_after_signup.uuid
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 2),
[person1_stopped_after_two_signups.uuid],
)
def test_advanced_funnel_with_repeat_steps(self):
filters = {
"events": [
{
"id": "user signed up",
"type": "events",
"order": 0
},
{
"id": "$pageview",
"type": "events",
"order": 1
},
{
"id": "$pageview",
"type": "events",
"order": 2
},
{
"id": "$pageview",
"type": "events",
"order": 3
},
{
"id": "$pageview",
"type": "events",
"order": 4
},
],
"insight":
INSIGHT_FUNNELS,
}
filter = Filter(data=filters)
funnel = ClickhouseFunnel(filter, self.team)
# event
person1_stopped_after_signup = _create_person(
distinct_ids=["stopped_after_signup1"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_signup1")
person2_stopped_after_one_pageview = _create_person(
distinct_ids=["stopped_after_pageview1"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview1")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview1")
person3_stopped_after_two_pageview = _create_person(
distinct_ids=["stopped_after_pageview2"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview2")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview2")
_create_event(team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview2")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview2")
person4_stopped_after_three_pageview = _create_person(
distinct_ids=["stopped_after_pageview3"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview3")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview3")
_create_event(team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview3")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview3")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview3")
_create_event(team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview3")
person5_stopped_after_many_pageview = _create_person(
distinct_ids=["stopped_after_pageview4"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview4")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4")
result = funnel.run()
self.assertEqual(result[0]["name"], "user signed up")
self.assertEqual(result[1]["name"], "$pageview")
self.assertEqual(result[4]["name"], "$pageview")
self.assertEqual(result[0]["count"], 5)
self.assertEqual(len(result[0]["people"]), 5)
self.assertEqual(result[1]["count"], 4)
self.assertEqual(len(result[1]["people"]), 4)
self.assertEqual(result[2]["count"], 3)
self.assertEqual(len(result[2]["people"]), 3)
self.assertEqual(result[3]["count"], 2)
self.assertEqual(len(result[3]["people"]), 2)
self.assertEqual(result[4]["count"], 1)
self.assertEqual(len(result[4]["people"]), 1)
# check ordering of people in every step
self.assertCountEqual(
self._get_people_at_step(filter, 1),
[
person1_stopped_after_signup.uuid,
person2_stopped_after_one_pageview.uuid,
person3_stopped_after_two_pageview.uuid,
person4_stopped_after_three_pageview.uuid,
person5_stopped_after_many_pageview.uuid,
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 2),
[
person2_stopped_after_one_pageview.uuid,
person3_stopped_after_two_pageview.uuid,
person4_stopped_after_three_pageview.uuid,
person5_stopped_after_many_pageview.uuid,
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 3),
[
person3_stopped_after_two_pageview.uuid,
person4_stopped_after_three_pageview.uuid,
person5_stopped_after_many_pageview.uuid,
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 4),
[
person4_stopped_after_three_pageview.uuid,
person5_stopped_after_many_pageview.uuid
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 5),
[person5_stopped_after_many_pageview.uuid],
)
def test_advanced_funnel_with_repeat_steps_out_of_order_events(self):
filters = {
"events": [
{
"id": "user signed up",
"type": "events",
"order": 0
},
{
"id": "$pageview",
"type": "events",
"order": 1
},
{
"id": "$pageview",
"type": "events",
"order": 2
},
{
"id": "$pageview",
"type": "events",
"order": 3
},
{
"id": "$pageview",
"type": "events",
"order": 4
},
],
"insight":
INSIGHT_FUNNELS,
"funnel_window_days":
14,
}
filter = Filter(data=filters)
funnel = ClickhouseFunnel(filter, self.team)
# event
person1_stopped_after_signup = _create_person(
distinct_ids=["random", "stopped_after_signup1"],
team_id=self.team.pk)
_create_event(team=self.team, event="$pageview", distinct_id="random")
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_signup1")
person2_stopped_after_one_pageview = _create_person(
distinct_ids=["stopped_after_pageview1"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview1")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview1")
person3_stopped_after_two_pageview = _create_person(
distinct_ids=["stopped_after_pageview2"], team_id=self.team.pk)
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview2")
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview2")
_create_event(team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview2")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview2")
person4_stopped_after_three_pageview = _create_person(
distinct_ids=["stopped_after_pageview3"], team_id=self.team.pk)
_create_event(team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview3")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview3")
_create_event(team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview3")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview3")
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview3")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview3")
person5_stopped_after_many_pageview = _create_person(
distinct_ids=["stopped_after_pageview4"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview4")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4")
_create_event(team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview4")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4")
person6_stopped_after_many_pageview_without_signup = _create_person(
distinct_ids=["stopped_after_pageview5"], team_id=self.team.pk)
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview5")
_create_event(team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview5")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview5")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview5")
_create_event(team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview5")
result = funnel.run()
self.assertEqual(result[0]["name"], "user signed up")
self.assertEqual(result[1]["name"], "$pageview")
self.assertEqual(result[4]["name"], "$pageview")
self.assertEqual(result[0]["count"], 5)
self.assertEqual(len(result[0]["people"]), 5)
self.assertEqual(result[1]["count"], 4)
self.assertEqual(len(result[1]["people"]), 4)
self.assertEqual(result[2]["count"], 1)
self.assertEqual(len(result[2]["people"]), 1)
self.assertEqual(result[3]["count"], 1)
self.assertEqual(len(result[3]["people"]), 1)
self.assertEqual(result[4]["count"], 1)
self.assertEqual(len(result[4]["people"]), 1)
# check ordering of people in every step
self.assertCountEqual(
self._get_people_at_step(filter, 1),
[
person1_stopped_after_signup.uuid,
person2_stopped_after_one_pageview.uuid,
person3_stopped_after_two_pageview.uuid,
person4_stopped_after_three_pageview.uuid,
person5_stopped_after_many_pageview.uuid,
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 2),
[
person2_stopped_after_one_pageview.uuid,
person3_stopped_after_two_pageview.uuid,
person4_stopped_after_three_pageview.uuid,
person5_stopped_after_many_pageview.uuid,
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 3),
[person5_stopped_after_many_pageview.uuid],
)
self.assertCountEqual(
self._get_people_at_step(filter, 4),
[person5_stopped_after_many_pageview.uuid],
)
self.assertCountEqual(
self._get_people_at_step(filter, 5),
[person5_stopped_after_many_pageview.uuid],
)
def test_funnel_with_actions(self):
sign_up_action = _create_action(
name="sign up",
team=self.team,
properties=[{
"key": "key",
"type": "event",
"value": ["val"],
"operator": "exact"
}],
)
filters = {
"actions": [
{
"id": sign_up_action.id,
"math": "dau",
"order": 0
},
{
"id": sign_up_action.id,
"math": "wau",
"order": 1
},
],
"insight":
INSIGHT_FUNNELS,
}
filter = Filter(data=filters)
funnel = ClickhouseFunnel(filter, self.team)
# event
person1_stopped_after_two_signups = _create_person(
distinct_ids=["stopped_after_signup1"], team_id=self.team.pk)
_create_event(team=self.team,
event="sign up",
distinct_id="stopped_after_signup1",
properties={"key": "val"})
_create_event(team=self.team,
event="sign up",
distinct_id="stopped_after_signup1",
properties={"key": "val"})
person2_stopped_after_signup = _create_person(
distinct_ids=["stopped_after_signup2"], team_id=self.team.pk)
_create_event(team=self.team,
event="sign up",
distinct_id="stopped_after_signup2",
properties={"key": "val"})
result = funnel.run()
self.assertEqual(result[0]["name"], "sign up")
self.assertEqual(result[0]["count"], 2)
self.assertEqual(len(result[0]["people"]), 2)
self.assertEqual(result[1]["count"], 1)
self.assertEqual(len(result[1]["people"]), 1)
# check ordering of people in first step
self.assertCountEqual(
self._get_people_at_step(filter, 1),
[
person1_stopped_after_two_signups.uuid,
person2_stopped_after_signup.uuid
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 2),
[person1_stopped_after_two_signups.uuid],
)
def test_funnel_with_actions_and_events(self):
sign_up_action = _create_action(
name="sign up",
team=self.team,
properties=[{
"key": "key",
"type": "event",
"value": ["val"],
"operator": "exact"
}],
)
filters = {
"events": [
{
"id": "user signed up",
"type": "events",
"order": 0
},
{
"id": "user signed up",
"type": "events",
"order": 1
},
],
"actions": [
{
"id": sign_up_action.id,
"math": "dau",
"order": 2
},
{
"id": sign_up_action.id,
"math": "wau",
"order": 3
},
],
"insight":
INSIGHT_FUNNELS,
"funnel_window_days":
14,
}
filter = Filter(data=filters)
funnel = ClickhouseFunnel(filter, self.team)
# event
person1_stopped_after_two_signups = _create_person(
distinct_ids=["stopped_after_signup1"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_signup1")
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_signup1")
_create_event(team=self.team,
event="sign up",
distinct_id="stopped_after_signup1",
properties={"key": "val"})
_create_event(team=self.team,
event="sign up",
distinct_id="stopped_after_signup1",
properties={"key": "val"})
person2_stopped_after_signup = _create_person(
distinct_ids=["stopped_after_signup2"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_signup2")
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_signup2")
_create_event(team=self.team,
event="sign up",
distinct_id="stopped_after_signup2",
properties={"key": "val"})
person3 = _create_person(distinct_ids=["person3"],
team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="person3")
_create_event(team=self.team,
event="sign up",
distinct_id="person3",
properties={"key": "val"})
_create_event(team=self.team,
event="user signed up",
distinct_id="person3")
_create_event(team=self.team,
event="sign up",
distinct_id="person3",
properties={"key": "val"})
person4 = _create_person(distinct_ids=["person4"],
team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="person4")
_create_event(team=self.team,
event="sign up",
distinct_id="person4",
properties={"key": "val"})
_create_event(team=self.team,
event="user signed up",
distinct_id="person4")
person5 = _create_person(distinct_ids=["person5"],
team_id=self.team.pk)
_create_event(team=self.team,
event="sign up",
distinct_id="person5",
properties={"key": "val"})
result = funnel.run()
self.assertEqual(result[0]["name"], "user signed up")
self.assertEqual(result[0]["count"], 4)
self.assertEqual(result[1]["count"], 4)
self.assertEqual(result[2]["count"], 3)
self.assertEqual(result[3]["count"], 1)
# check ordering of people in steps
self.assertCountEqual(
self._get_people_at_step(filter, 1),
[
person1_stopped_after_two_signups.uuid,
person2_stopped_after_signup.uuid, person3.uuid, person4.uuid
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 2),
[
person1_stopped_after_two_signups.uuid,
person2_stopped_after_signup.uuid, person3.uuid, person4.uuid
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 3),
[
person1_stopped_after_two_signups.uuid,
person2_stopped_after_signup.uuid,
person3.uuid,
],
)
self.assertCountEqual(self._get_people_at_step(filter, 4), [
person1_stopped_after_two_signups.uuid,
])
def test_funnel_with_matching_properties(self):
filters = {
"events": [
{
"id": "user signed up",
"order": 0
},
{
"id": "$pageview",
"order": 1,
"properties": {
"$current_url": "aloha.com"
}
},
{
"id": "$pageview",
"order": 2,
"properties": {
"$current_url": "aloha2.com"
},
}, # different event to above
{
"id": "$pageview",
"order": 3,
"properties": {
"$current_url": "aloha2.com"
}
},
{
"id": "$pageview",
"order": 4,
},
],
"insight":
INSIGHT_FUNNELS,
"funnel_window_days":
14,
}
filter = Filter(data=filters)
funnel = ClickhouseFunnel(filter, self.team)
# event
person1_stopped_after_signup = _create_person(
distinct_ids=["stopped_after_signup1"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_signup1")
person2_stopped_after_one_pageview = _create_person(
distinct_ids=["stopped_after_pageview1"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview1")
_create_event(
team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview1",
properties={"$current_url": "aloha.com"},
)
person3_stopped_after_two_pageview = _create_person(
distinct_ids=["stopped_after_pageview2"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview2")
_create_event(
team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview2",
properties={"$current_url": "aloha.com"},
)
_create_event(
team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview2",
properties={"$current_url": "aloha.com"},
)
_create_event(
team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview2",
properties={"$current_url": "aloha2.com"},
)
person4_stopped_after_three_pageview = _create_person(
distinct_ids=["stopped_after_pageview3"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview3")
_create_event(
team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview3",
properties={"$current_url": "aloha.com"},
)
_create_event(team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview3")
_create_event(
team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview3",
properties={"$current_url": "aloha2.com"},
)
_create_event(
team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview3",
properties={"$current_url": "aloha2.com"},
)
_create_event(team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview3")
person5_stopped_after_many_pageview = _create_person(
distinct_ids=["stopped_after_pageview4"], team_id=self.team.pk)
_create_event(team=self.team,
event="user signed up",
distinct_id="stopped_after_pageview4")
_create_event(
team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4",
properties={"$current_url": "aloha.com"},
)
_create_event(team=self.team,
event="blaah blaa",
distinct_id="stopped_after_pageview4")
_create_event(
team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4",
properties={"$current_url": "aloha2.com"},
)
_create_event(
team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4",
properties={"$current_url": "aloha.com"},
)
_create_event(
team=self.team,
event="$pageview",
distinct_id="stopped_after_pageview4",
properties={"$current_url": "aloha2.com"},
)
result = funnel.run()
self.assertEqual(result[0]["name"], "user signed up")
self.assertEqual(result[1]["name"], "$pageview")
self.assertEqual(result[4]["name"], "$pageview")
self.assertEqual(result[0]["count"], 5)
self.assertEqual(result[1]["count"], 4)
self.assertEqual(result[2]["count"], 3)
self.assertEqual(result[3]["count"], 2)
self.assertEqual(result[4]["count"], 0)
# check ordering of people in every step
self.assertCountEqual(
self._get_people_at_step(filter, 1),
[
person1_stopped_after_signup.uuid,
person2_stopped_after_one_pageview.uuid,
person3_stopped_after_two_pageview.uuid,
person4_stopped_after_three_pageview.uuid,
person5_stopped_after_many_pageview.uuid,
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 2),
[
person2_stopped_after_one_pageview.uuid,
person3_stopped_after_two_pageview.uuid,
person4_stopped_after_three_pageview.uuid,
person5_stopped_after_many_pageview.uuid,
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 3),
[
person3_stopped_after_two_pageview.uuid,
person4_stopped_after_three_pageview.uuid,
person5_stopped_after_many_pageview.uuid,
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 4),
[
person4_stopped_after_three_pageview.uuid,
person5_stopped_after_many_pageview.uuid
],
)
self.assertCountEqual(
self._get_people_at_step(filter, 5),
[],
)
def test_funnel_conversion_window(self):
ids_to_compare = []
for i in range(10):
person = _create_person(distinct_ids=[f"user_{i}"], team=self.team)
ids_to_compare.append(str(person.uuid))
_create_event(event="step one",
distinct_id=f"user_{i}",
team=self.team,
timestamp="2021-05-01 00:00:00")
_create_event(event="step two",
distinct_id=f"user_{i}",
team=self.team,
timestamp="2021-05-02 00:00:00")
for i in range(10, 25):
_create_person(distinct_ids=[f"user_{i}"], team=self.team)
_create_event(event="step one",
distinct_id=f"user_{i}",
team=self.team,
timestamp="2021-05-01 00:00:00")
_create_event(event="step two",
distinct_id=f"user_{i}",
team=self.team,
timestamp="2021-05-10 00:00:00")
data = {
"insight":
INSIGHT_FUNNELS,
"interval":
"day",
"date_from":
"2021-05-01 00:00:00",
"date_to":
"2021-05-14 00:00:00",
"funnel_window_days":
7,
"events": [
{
"id": "step one",
"order": 0
},
{
"id": "step two",
"order": 1
},
{
"id": "step three",
"order": 2
},
],
}
filter = Filter(data={**data})
results = ClickhouseFunnel(filter, self.team).run()
self.assertEqual(results[0]["count"], 25)
self.assertEqual(results[1]["count"], 10)
self.assertEqual(results[2]["count"], 0)
self.assertCountEqual(
[str(id) for id in self._get_people_at_step(filter, 2)],
ids_to_compare)
def test_funnel_step_conversion_times(self):
filters = {
"events": [
{
"id": "sign up",
"order": 0
},
{
"id": "play movie",
"order": 1
},
{
"id": "buy",
"order": 2
},
],
"insight":
INSIGHT_FUNNELS,
"date_from":
"2020-01-01",
"date_to":
"2020-01-08",
"funnel_window_days":
7,
}
filter = Filter(data=filters)
funnel = ClickhouseFunnel(filter, self.team)
# event
person1 = _create_person(distinct_ids=["person1"],
team_id=self.team.pk)
_create_event(
team=self.team,
event="sign up",
distinct_id="person1",
properties={"key": "val"},
timestamp="2020-01-01T12:00:00Z",
)
_create_event(
team=self.team,
event="play movie",
distinct_id="person1",
properties={"key": "val"},
timestamp="2020-01-01T13:00:00Z",
)
_create_event(
team=self.team,
event="buy",
distinct_id="person1",
properties={"key": "val"},
timestamp="2020-01-01T15:00:00Z",
)
person2 = _create_person(distinct_ids=["person2"],
team_id=self.team.pk)
_create_event(
team=self.team,
event="sign up",
distinct_id="person2",
properties={"key": "val"},
timestamp="2020-01-02T14:00:00Z",
)
_create_event(
team=self.team,
event="play movie",
distinct_id="person2",
properties={"key": "val"},
timestamp="2020-01-02T16:00:00Z",
)
person3 = _create_person(distinct_ids=["person3"],
team_id=self.team.pk)
_create_event(
team=self.team,
event="sign up",
distinct_id="person3",
properties={"key": "val"},
timestamp="2020-01-02T14:00:00Z",
)
_create_event(
team=self.team,
event="play movie",
distinct_id="person3",
properties={"key": "val"},
timestamp="2020-01-02T16:00:00Z",
)
_create_event(
team=self.team,
event="buy",
distinct_id="person3",
properties={"key": "val"},
timestamp="2020-01-02T17:00:00Z",
)
result = funnel.run()
self.assertEqual(result[0]["average_conversion_time"], None)
self.assertEqual(result[1]["average_conversion_time"], 6000)
self.assertEqual(result[2]["average_conversion_time"], 5400)
class TestClickhouseFunnel(ClickhouseTestMixin,
funnel_test_factory(ClickhouseFunnel, _create_event,
_create_person)
): # type: ignore
pass