Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

If segmented by goal other goal conversations don't show up #8854

Open
Akuukis opened this issue Sep 25, 2015 · 10 comments
Open

If segmented by goal other goal conversations don't show up #8854

Akuukis opened this issue Sep 25, 2015 · 10 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. c: Data Integrity & Accuracy

Comments

@Akuukis
Copy link

Akuukis commented Sep 25, 2015

Problem: When I segment by "Visit converted a specific goal ID";"is";2 then all other goals show up as converted 0 times, despites that in visitor log I can see that visitors convert multiple goals.

Context: I have a lot of goals and people usually convert several per visit. So I want to see what other goals they convert if they have converted goal ID 2.

@sidazhou
Copy link

I'm troubled with the same issue. Have you gotten any further yet?

@Akuukis
Copy link
Author

Akuukis commented Oct 31, 2015

No :(

@mattab mattab added the Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. label Nov 26, 2015
@mattab mattab added this to the Mid term milestone Nov 26, 2015
@mattab
Copy link
Member

mattab commented Nov 26, 2015

Thanks for the report!

@mattab mattab added Bug For errors / faults / flaws / inconsistencies etc. and removed Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. labels Nov 26, 2015
@ghost
Copy link

ghost commented Nov 24, 2016

@mattab I encountered exactly the same issue recently.

It seems to be caused by the fact that segment is filtered 'per-goal' not 'per-visit'. Meaning if the condition is set to goalId=7, it will show only conversion where goalId was 7 (not all goals from the visit, where at least one goal id was = 7).

Such behavior seems to be a result of limitation of how segments are created. In reports for each goal there is a SQL query that has part idgoal=<id of a goal>. While browsing segment, another idgoal part is added, so we get for example idgoal=20 AND idgoal=7, which never will be true.

Do you have an idea how can it be fixed?

Especially that use case described in the issue's description (I have a lot of goals and people usually convert several per visit. So I want to see what other goals they convert if they have converted goal ID 2.) is very common, so would be nice to have it fixed soon.

Regards,
Tomasz

@tsteur
Copy link
Member

tsteur commented Nov 24, 2016

I'm not sure if I created an issue for it a while ago or not. It is definitely a general bug that also applies to action segments etc and explains why often "no data" appears in reports when segmenting depending on whether an action, visit or goal segment is applied to a specific report. We could fix it by adjusting the segmentation queries but it's a bit of work, especially to make sure it still works afterwards

@ghost
Copy link

ghost commented Nov 30, 2016

@tsteur @mattab Do you have any idea if it can be fixed in the near future, or is it rather long term topic for you at this moment? I am aware that it requires a lot of work, however, it's a bug in one of the critical functionalities on the other hand.

@tsteur
Copy link
Member

tsteur commented Nov 30, 2016

Yes It is critical functionality and it would be good to fix the segmentation. It's right now not a priority unless someone wants to sponsor it because it is 1) complex 2) we need big database to test it as it may 3) lower performance of segments because it may result in more joins or subqueries. Ideally we would want to find a way to not regress performance for segments.

@mattab
Copy link
Member

mattab commented Dec 5, 2016

Hi @tomasztomik as @tsteur explained it is a must-fix bug we can and would like to solve, it would likely take one day or two to fix so haven't take the time yet. Increasing priority of the issue

@mattab mattab modified the milestones: 3.0.0, Long term Dec 5, 2016
@tsteur
Copy link
Member

tsteur commented Dec 5, 2016

@mattab I'm not sure if you are talking about only fixing this issue or the general segmenting issue. It already took me 2 days to refactor just some parts of the segmenting logic and changing the segmenting to make them work proerply might be more like 3-5 days with ensuring everything still works, keeping the queries fast somehow, writing plenty of new tests etc.

@mattab
Copy link
Member

mattab commented Dec 6, 2016

@tsteur was referring to fixing this specific issue with the segment Visit converted a specific goal ID in one or maybe two days, would be good first step

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. c: Data Integrity & Accuracy
Projects
None yet
Development

No branches or pull requests

4 participants