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

Add segment conditions "Does not Start with" and "Does not end with" #18009

Open
tomper00 opened this issue Sep 15, 2021 · 3 comments
Open

Add segment conditions "Does not Start with" and "Does not end with" #18009

tomper00 opened this issue Sep 15, 2021 · 3 comments
Labels
c: Consistent Reports & Analytics UX For bugs and features that make Analytics reporting UI behave more consistently. c: Performance For when we could improve the performance / speed of Matomo. c: Platform For Matomo platform changes that aren't impacting any of our APIs but improve the core itself. c: Segments Segmentation and Segment editor related improvements and fixes. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Milestone
5.x.0 - Priority ...

Comments

@tomper00
Copy link

We have learnt the hard way that segments for URLs that use the citeras Contains and Does not contain has a very negative effect on the archiving performance, since both of them will generate MYSQL queries towards the visitor log that will not use an index.

Our solution was to rewrite a lot of these segments to use "Starts with" instead and this had a very good impact om our archiving in general.

We still have a few segments that use the "Does not contain" filer and fore these we do not really have a solution in place.

Adding the "Does not Start with" condition would really help our here.
@tomper00 tomper00 added the Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. label Sep 15, 2021
@sgiehl
Copy link
Member

sgiehl commented Sep 15, 2021

Hi @tomper00
Thanks for creating this suggestion. Yes, segments using a contain might impact the archiving performance significant.
I don't think we will have time to implement additional segment operators in the near future, but if you have some free capacities a Pull Request would be very welcome.

@tsteur tsteur added this to the Priority Backlog (Help wanted) milestone Sep 15, 2021
@tomper00
Copy link
Author

Ok will see what we can do!

@atom-box
Copy link

A user notes:

Could you please add a feature to create segments for URL pages
1 which does'nt begin with
2 which does'nt end with

Thanks a lot for the good job.

@mattab mattab added c: Platform For Matomo platform changes that aren't impacting any of our APIs but improve the core itself. c: Consistent Reports & Analytics UX For bugs and features that make Analytics reporting UI behave more consistently. c: Segments Segmentation and Segment editor related improvements and fixes. labels Dec 11, 2023
@mattab mattab changed the title Add segment condition "Does not Start with" Add segment conditions "Does not Start with" and "Does not end with" Dec 11, 2023
@mattab mattab added the c: Performance For when we could improve the performance / speed of Matomo. label Dec 11, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
c: Consistent Reports & Analytics UX For bugs and features that make Analytics reporting UI behave more consistently. c: Performance For when we could improve the performance / speed of Matomo. c: Platform For Matomo platform changes that aren't impacting any of our APIs but improve the core itself. c: Segments Segmentation and Segment editor related improvements and fixes. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Projects
None yet
Milestone
5.x.0 - Priority issues
Development

No branches or pull requests
5 participants
@tsteur @tomper00 @mattab @sgiehl @atom-box