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

Jump to bottom

segment counts more conversion than All visits segment #9194

Closed
sidazhou opened this issue Nov 10, 2015 · 4 comments
Closed

segment counts more conversion than All visits segment #9194

sidazhou opened this issue Nov 10, 2015 · 4 comments
Assignees
@tsteur
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Milestone
2.16.0

Comments

@sidazhou
Copy link

Piwik 2.15
Please see screen shots below. (1st one is the segmented one, 2nd is the all visits)

My understanding is that a Segment is a subset of your Analytics data.

In piwik dashboard, I go to "Goals" -> "Overview"
I notice that when I use "All visits (default)", it has LESS conversions than if I use some setting on Segment (which supposed to be a subset of All visits) In this case, the segment I used was "Page URL" "contains" "......."

How is this possible?

I've checked http://forum.piwik.org/read.php?2,129751,129751#msg-129751
which is solved by upgrading prototype, however I'm not using prototype nor custom variables.

link to forum:
http://forum.piwik.org/t/page-url-segment-counts-more-than-all-visits-segment/16621

segemented_visit
all_visits
@mattab
Copy link
Member

mattab commented Nov 18, 2015

Thanks for the report @sidazhou

I could reproduce this bug on the demo:

@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Nov 18, 2015
@mattab mattab added this to the 2.15.1 milestone Nov 18, 2015
@mattab mattab added the Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. label Nov 18, 2015
@tsteur
Copy link
Member

tsteur commented Dec 13, 2015

I reckon this one could be similar to #9367 and it might show more conversions etc due do the fact that it goes over any idaction_url. So if we tracked the same idaction_url for events as for pageviews then it might find the same conversion multiple times. I will try to have a look at the database.

@tsteur
Copy link
Member

tsteur commented Dec 14, 2015

Problem is when segmenting we seem to not respect the setting "goal can be only converted once per visit" see

image

Eg with query

SELECT
            log_link_visit_action.*
            FROM
                piwik_log_conversion AS log_conversion
                LEFT JOIN piwik_log_link_visit_action AS log_link_visit_action ON log_conversion.idvisit = log_link_visit_action.idvisit
            WHERE
                ( log_conversion.server_time >= '2015-01-25 11:00:00'
                AND log_conversion.server_time <= '2015-01-26 10:59:59'
                AND log_conversion.idsite IN (1) )
                AND
                ( ( log_link_visit_action.idaction_url IN (SELECT idaction FROM piwik_log_action WHERE ( name LIKE CONCAT('%', '/', '%')  AND type = 1 )) ) )
                AND log_conversion.idgoal = 4

Here I get 49 results, but it should be 22 results which I get when I do eg SELECT distinct log_link_visit_action.idvisit

tsteur added a commit that referenced this issue Dec 15, 2015
@tsteur
fixes #9194 fix "goal can be only converted once per visit" is not re…
98514db 
…spected when segmenting goals with a log_link_visit_action segment
@tsteur tsteur mentioned this issue Dec 15, 2015
Merged
@tsteur tsteur self-assigned this Dec 15, 2015
@xpader
Copy link

xpader commented Nov 26, 2019

This happeing again in 3.12.0...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@tsteur tsteur

Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Milestone
2.16.0
Development

No branches or pull requests
4 participants
@tsteur @mattab @xpader @sidazhou