Let me delete Visitors from Visitor Log (and undo it) #3385

Open
anonymous-piwik-user opened this Issue Sep 18, 2012 · 42 comments

Comments

Projects
None yet
@anonymous-piwik-user

REQUESTED FEATURE
Within the visitor log and the visitor log widget it would be great to have a delete button to delete a specific log entry.

BACKGROUND
In the detailed visitor log, I sometimes find that I have browsed my owm website from a different PC where I didn't have the opt-out cookie set.

I would like to delete single visits in case I recognize it was myself.

FORUM ENTRY
http://forum.piwik.org/read.php?3,76148,93880
Keywords: Delete, Visitor, Log

@mattab

This comment has been minimized.

Show comment
Hide comment
@mattab

mattab Sep 19, 2012

Member

Thanks for the suggestion. I agree it would be useful to have for debug purposes. On clicking delete, we could say "ALso delete other visits from this IP address?" and possibility to delete all tests data.

Also, we would need to call API CoreAdminHome.invalidateArchivedReports to force next archive script to re-run the archiving.

Member

mattab commented Sep 19, 2012

Thanks for the suggestion. I agree it would be useful to have for debug purposes. On clicking delete, we could say "ALso delete other visits from this IP address?" and possibility to delete all tests data.

Also, we would need to call API CoreAdminHome.invalidateArchivedReports to force next archive script to re-run the archiving.

@anonymous-piwik-user

This comment has been minimized.

Show comment
Hide comment
@anonymous-piwik-user

anonymous-piwik-user Sep 19, 2012

I would suggest to actually have 2 Delete-Buttons with different functions:

DELETE BUTTON #1 (Graphic: Standard red X) - Function: Delete this single entry from database (with NO confirmation message required).

DELETE BUTTON #2 (Graphic: Red X with integrated "IP"-Letters ) - Function: Delete all visits from this IP-address (WITH confirmation-message)

What do you guys think?

I would suggest to actually have 2 Delete-Buttons with different functions:

DELETE BUTTON #1 (Graphic: Standard red X) - Function: Delete this single entry from database (with NO confirmation message required).

DELETE BUTTON #2 (Graphic: Red X with integrated "IP"-Letters ) - Function: Delete all visits from this IP-address (WITH confirmation-message)

What do you guys think?

@julienmoumne

This comment has been minimized.

Show comment
Hide comment
@julienmoumne

julienmoumne Sep 19, 2012

Member

I vote for always using a confirmation message.

Fingers can get quite slippery after a beer&burger.

If it is decided to go forward without a confirmation message, I'd suggest an undo button.

Member

julienmoumne commented Sep 19, 2012

I vote for always using a confirmation message.

Fingers can get quite slippery after a beer&burger.

If it is decided to go forward without a confirmation message, I'd suggest an undo button.

@mattab

This comment has been minimized.

Show comment
Hide comment
@mattab

mattab Sep 19, 2012

Member

Yes we'll definitely keep the confirmation message, this is a "UI Pattern" in Piwik that we will continue respect (ask for confirmation before deleting anything)... :)

Member

mattab commented Sep 19, 2012

Yes we'll definitely keep the confirmation message, this is a "UI Pattern" in Piwik that we will continue respect (ask for confirmation before deleting anything)... :)

@mattab

This comment has been minimized.

Show comment
Hide comment
@mattab

mattab Oct 27, 2012

Member

it was suggested in #3756 to be able to delete goal conversions as well, but it's non trivial since needs to update the log_visit table to remove the goal counter etc

Member

mattab commented Oct 27, 2012

it was suggested in #3756 to be able to delete goal conversions as well, but it's non trivial since needs to update the log_visit table to remove the goal counter etc

@feluxe

This comment has been minimized.

Show comment
Hide comment
@feluxe

feluxe Nov 6, 2014

I think it's a pity Piwik misses that feature. There are many ways to trash the stats by accident when developing. Just forget to turn off tracking once and do some cross browser testing for a week "et voila" stats are f...d and customers confused about the graphs. I have seen this and similar several times. It is sad to imagine a customer and his team looking at the graph of their project knowing that the peak of the entire curve is a mistake made by a developer. And when ever they look at it the future the false peak shall be there and nothing can be done... argh!

feluxe commented Nov 6, 2014

I think it's a pity Piwik misses that feature. There are many ways to trash the stats by accident when developing. Just forget to turn off tracking once and do some cross browser testing for a week "et voila" stats are f...d and customers confused about the graphs. I have seen this and similar several times. It is sad to imagine a customer and his team looking at the graph of their project knowing that the peak of the entire curve is a mistake made by a developer. And when ever they look at it the future the false peak shall be there and nothing can be done... argh!

@Trance-Man

This comment has been minimized.

Show comment
Hide comment
@Trance-Man

Trance-Man Nov 6, 2014

Big +1 for this request to be implemented. I have developers from around the globe sometimes logging in and testing my site, blows my stats out of the water and I can't always catch them on time, really this is badly needed as for me right now Piwik is useless due to this problem. We need to be able to open a particular date, check off items (visitors or IP's) to delete and delete them. Also an option to undo would be very smart in case of a mishap. Thank you very much for this consideration team Piwik. :) Other then this, great work thus far.

Big +1 for this request to be implemented. I have developers from around the globe sometimes logging in and testing my site, blows my stats out of the water and I can't always catch them on time, really this is badly needed as for me right now Piwik is useless due to this problem. We need to be able to open a particular date, check off items (visitors or IP's) to delete and delete them. Also an option to undo would be very smart in case of a mishap. Thank you very much for this consideration team Piwik. :) Other then this, great work thus far.

@asafyish

This comment has been minimized.

Show comment
Hide comment

+1

@reiherm

This comment has been minimized.

Show comment
Hide comment

reiherm commented Nov 17, 2014

+1

@typesetting

This comment has been minimized.

Show comment
Hide comment

+1

@mattab mattab changed the title from Delete Visitors from Visitor Log to Let me delete Visitors from Visitor Log (and undo it) Dec 3, 2014

@Trance-Man

This comment has been minimized.

Show comment
Hide comment
@Trance-Man

Trance-Man Jan 12, 2015

I have a serious need for the deletion of many bad hits to my site, still need this implemented, my database is destroyed with bad porno site contamination from our recent discussion this past week, and no-one seems to have a solution or an answer on how I can remove the bad website. It's terrible, pointless using Piwik now as my stats are destroyed 100%.

I have a serious need for the deletion of many bad hits to my site, still need this implemented, my database is destroyed with bad porno site contamination from our recent discussion this past week, and no-one seems to have a solution or an answer on how I can remove the bad website. It's terrible, pointless using Piwik now as my stats are destroyed 100%.

@mattab

This comment has been minimized.

Show comment
Hide comment
@mattab

mattab Jan 14, 2015

Member

Hi @Trance-Man you can delete data in this way:

  • Take a backup of your log_* tables
  • DELETE log_visit, log_link_visit_action FROM piwik_log_visit AS log_visit LEFT JOIN piwik_log_link_visit_action as log_link_visit_action ON log_visit.idvisit = log_link_visit_action.idvisit LEFT JOIN piwik_log_action as log_action ON log_action.idaction = log_link_visit_action.idaction_url WHERE log_action.name LIKE '%PORN%' should delete all visits and pageviews where the Page URL contains PORN
  • then do the two steps in this page: https://piwik.org/faq/how-to/faq_59/ (delete archive data + run core:archive command)

Then it should have cleared all visitors from your stats... let me know if you have a problem as I didn't test instructions yet

Member

mattab commented Jan 14, 2015

Hi @Trance-Man you can delete data in this way:

  • Take a backup of your log_* tables
  • DELETE log_visit, log_link_visit_action FROM piwik_log_visit AS log_visit LEFT JOIN piwik_log_link_visit_action as log_link_visit_action ON log_visit.idvisit = log_link_visit_action.idvisit LEFT JOIN piwik_log_action as log_action ON log_action.idaction = log_link_visit_action.idaction_url WHERE log_action.name LIKE '%PORN%' should delete all visits and pageviews where the Page URL contains PORN
  • then do the two steps in this page: https://piwik.org/faq/how-to/faq_59/ (delete archive data + run core:archive command)

Then it should have cleared all visitors from your stats... let me know if you have a problem as I didn't test instructions yet

@Trance-Man

This comment has been minimized.

Show comment
Hide comment
@Trance-Man

Trance-Man Jan 23, 2015

Mattab

OMG for such a big platform (Piwik) this is WAY TO complicated, can Piwik do this for me, JEES!
We need a 'Delete' option on logs, why the hell do we not have such a function yet in visitor logs?

There has to be an easier way! Anyone?

Mattab

OMG for such a big platform (Piwik) this is WAY TO complicated, can Piwik do this for me, JEES!
We need a 'Delete' option on logs, why the hell do we not have such a function yet in visitor logs?

There has to be an easier way! Anyone?

@DannyCork

This comment has been minimized.

Show comment
Hide comment
@DannyCork

DannyCork Jan 29, 2015

It sure would be nice.

It sure would be nice.

@titanic-fanatic

This comment has been minimized.

Show comment
Hide comment
@titanic-fanatic

titanic-fanatic Feb 13, 2015

+1 from me for this feature too. I also feel there should always be a warning message ;-)

+1 from me for this feature too. I also feel there should always be a warning message ;-)

@Kovah

This comment has been minimized.

Show comment
Hide comment

Kovah commented Apr 3, 2015

+1

@mattab mattab added the Major label Apr 7, 2015

@Trance-Man

This comment has been minimized.

Show comment
Hide comment
@Trance-Man

Trance-Man Apr 22, 2015

This is still... an ongoing hassle for me, does anyone have an easy way to delete a visitor yet? I need to delete visits that are repeats in a certain situation, so the first visit is ok but the 2nd, 3rd, 4th I do not want in my database of that visitor. I need to remove the 2nd, 3rd, 4th visit of this visitor or the 2nd, 3rd, 4th time this IP is showing up. Anyone? Jees. :)

This is still... an ongoing hassle for me, does anyone have an easy way to delete a visitor yet? I need to delete visits that are repeats in a certain situation, so the first visit is ok but the 2nd, 3rd, 4th I do not want in my database of that visitor. I need to remove the 2nd, 3rd, 4th visit of this visitor or the 2nd, 3rd, 4th time this IP is showing up. Anyone? Jees. :)

@vikatskhay

This comment has been minimized.

Show comment
Hide comment

+1

@DannyCork

This comment has been minimized.

Show comment
Hide comment
@DannyCork

DannyCork May 4, 2015

a lot of +1 for this item !!!!!

a lot of +1 for this item !!!!!

@Trance-Man

This comment has been minimized.

Show comment
Hide comment

+1

@Sija

This comment has been minimized.

Show comment
Hide comment
@Sija

Sija May 6, 2015

Contributor

+1

Contributor

Sija commented May 6, 2015

+1

@tomnuss

This comment has been minimized.

Show comment
Hide comment
@tomnuss

tomnuss May 13, 2015

+1

Would be really nice feature

tomnuss commented May 13, 2015

+1

Would be really nice feature

@WilliamIsted

This comment has been minimized.

Show comment
Hide comment
@WilliamIsted

WilliamIsted Jun 7, 2015

+1 with dynamic IP's this is very difficult to keep excluding your own IP. A way to clean up false data is needed.

+1 with dynamic IP's this is very difficult to keep excluding your own IP. A way to clean up false data is needed.

@sgiehl

This comment has been minimized.

Show comment
Hide comment
@sgiehl

sgiehl Jun 7, 2015

Member

@WilliamIsted for excluding your dynamic IP try the ExcludeByDDNS plugin

Member

sgiehl commented Jun 7, 2015

@WilliamIsted for excluding your dynamic IP try the ExcludeByDDNS plugin

@WilliamIsted

This comment has been minimized.

Show comment
Hide comment
@WilliamIsted

WilliamIsted Jun 7, 2015

@sgiehl I'll try that out, cheers

@sgiehl I'll try that out, cheers

@larnold

This comment has been minimized.

Show comment
Hide comment

larnold commented Jun 12, 2015

+1

@Toraih

This comment has been minimized.

Show comment
Hide comment
@Toraih

Toraih Jul 10, 2015

+1
based on my piwik-installs: +34

Toraih commented Jul 10, 2015

+1
based on my piwik-installs: +34

@hpvd

This comment has been minimized.

Show comment
Hide comment
@hpvd

hpvd Nov 7, 2015

to help keeping numbers of buttons low and standardise look & feel and also the technical processes in background, there is a new ticket where this function is within the first 3 items. See #9182

hpvd commented Nov 7, 2015

to help keeping numbers of buttons low and standardise look & feel and also the technical processes in background, there is a new ticket where this function is within the first 3 items. See #9182

@hpvd hpvd referenced this issue Nov 7, 2015

Closed

Release Piwik 3.0 #6074

@hpvd

This comment has been minimized.

Show comment
Hide comment
@hpvd

hpvd Nov 8, 2015

integrating this feature as part of a "centralized list to store visits to ignore" #9184,
would promise some advantages:
standardized undo processes, better maintaining, staistics of deletion processes etc.

hpvd commented Nov 8, 2015

integrating this feature as part of a "centralized list to store visits to ignore" #9184,
would promise some advantages:
standardized undo processes, better maintaining, staistics of deletion processes etc.

@hpvd

This comment has been minimized.

Show comment
Hide comment
@hpvd

hpvd Nov 12, 2015

a general approach for giving the possibility to have an "undo function" is described here #9205
With this the action "deleting" is only a change of type from "standard" to "deleted".
And undo is simply changing type from "deleted" back to "standard".

hpvd commented Nov 12, 2015

a general approach for giving the possibility to have an "undo function" is described here #9205
With this the action "deleting" is only a change of type from "standard" to "deleted".
And undo is simply changing type from "deleted" back to "standard".

@MrTrick

This comment has been minimized.

Show comment
Hide comment
@MrTrick

MrTrick Aug 9, 2016

Rather than deleting visitors (and all the potential for "oh no, I didn't mean to!" drama) what about a mechanism to archive them instead? Yes, very similar to the "delete", "undo" functionality.

  1. Any "archived" visitors are not shown in any of the regular views or reports, only in a new view off the visitors log that allows mistaken records to be "unarchived".
  2. If there are backwards-compatibility concerns for plugins etc, the records could be moved to and from shadow tables.

MrTrick commented Aug 9, 2016

Rather than deleting visitors (and all the potential for "oh no, I didn't mean to!" drama) what about a mechanism to archive them instead? Yes, very similar to the "delete", "undo" functionality.

  1. Any "archived" visitors are not shown in any of the regular views or reports, only in a new view off the visitors log that allows mistaken records to be "unarchived".
  2. If there are backwards-compatibility concerns for plugins etc, the records could be moved to and from shadow tables.

@mattab mattab added duplicate and removed Major labels Dec 5, 2016

@mattab mattab modified the milestones: Long term, Mid term Dec 5, 2016

@mattab mattab removed the duplicate label Dec 5, 2016

@araviel

This comment has been minimized.

Show comment
Hide comment
@araviel

araviel Jan 13, 2017

+1 too, please...

araviel commented Jan 13, 2017

+1 too, please...

@IgitBuh

This comment has been minimized.

Show comment
Hide comment
@IgitBuh

IgitBuh Jan 23, 2017

+1, pretty please

IgitBuh commented Jan 23, 2017

+1, pretty please

@justynspooner

This comment has been minimized.

Show comment
Hide comment
@iliassk

This comment has been minimized.

Show comment
Hide comment

iliassk commented Mar 13, 2017

+1

@dimdaze

This comment has been minimized.

Show comment
Hide comment
@dimdaze

dimdaze Dec 17, 2017

+1 here too. A few days ago one IP address accessed some of the pages on my new website several thousand times (note to self: why didn't Wordfence block it??) and with average site accesses of only about 50 a day this has completely messed up the stats - and those cute little graphs in Visits Overview.

dimdaze commented Dec 17, 2017

+1 here too. A few days ago one IP address accessed some of the pages on my new website several thousand times (note to self: why didn't Wordfence block it??) and with average site accesses of only about 50 a day this has completely messed up the stats - and those cute little graphs in Visits Overview.

@JLDavenport

This comment has been minimized.

Show comment
Hide comment
@JLDavenport

JLDavenport Dec 30, 2017

I agree I run a small site and got hit with several thousand accesses in the course of an hour. This is a needed feature.

I agree I run a small site and got hit with several thousand accesses in the course of an hour. This is a needed feature.

@matomoto

This comment has been minimized.

Show comment
Hide comment
@matomoto

matomoto Jan 15, 2018

Hello Matomos!
Are there any people here who can test something?
It is apparently possible to delete visitors via the visitorid and to adjust the stored data (visitors, pageviews).
The deletion of the visitor data via the visitorid works via a PHP script. Renewing the (unique) "visitors" and (unique) "pageviews" is possible with an existing plugin. https://github.com/innocraft/plugin-InvalidateReports
Unfortunately, I do not have the opportunity to test everything and I do not know what has to be considered.
My Delete Visitor Script is also in strong development (raw). An undo is not built-in. It would be possible for an undo to write the "deleted" data in a new database table. From there they could be written back.
Who can help and test it?

matomoto commented Jan 15, 2018

Hello Matomos!
Are there any people here who can test something?
It is apparently possible to delete visitors via the visitorid and to adjust the stored data (visitors, pageviews).
The deletion of the visitor data via the visitorid works via a PHP script. Renewing the (unique) "visitors" and (unique) "pageviews" is possible with an existing plugin. https://github.com/innocraft/plugin-InvalidateReports
Unfortunately, I do not have the opportunity to test everything and I do not know what has to be considered.
My Delete Visitor Script is also in strong development (raw). An undo is not built-in. It would be possible for an undo to write the "deleted" data in a new database table. From there they could be written back.
Who can help and test it?

@matomoto matomoto referenced this issue in innocraft/plugin-InvalidateReports Jan 17, 2018

Closed

Database changes in the current month #6

@webbr

This comment has been minimized.

Show comment
Hide comment
@webbr

webbr Feb 5, 2018

+1 - this is a long awaited feature... someone shoud set up a donnation button!

webbr commented Feb 5, 2018

+1 - this is a long awaited feature... someone shoud set up a donnation button!

@mattab

This comment has been minimized.

Show comment
Hide comment
@mattab

mattab Apr 24, 2018

Member

FYI with the GDPR we have implemented the new feature to delete visits in #12596 (comment)

However there isn't yet a button in the Visitor Log to provide a shortcut, but this could (should?) be done!
It will be available in 3.5.0-b2 due in a few hours

Member

mattab commented Apr 24, 2018

FYI with the GDPR we have implemented the new feature to delete visits in #12596 (comment)

However there isn't yet a button in the Visitor Log to provide a shortcut, but this could (should?) be done!
It will be available in 3.5.0-b2 due in a few hours

@DannyCork

This comment has been minimized.

Show comment
Hide comment
@DannyCork

DannyCork Apr 24, 2018

Hallelujah.
Bit of a shame it took the pressure of GDPR and 6 years of waiting for this to get done :(

I may sound ungrateful but thanks though.

DannyCork commented Apr 24, 2018

Hallelujah.
Bit of a shame it took the pressure of GDPR and 6 years of waiting for this to get done :(

I may sound ungrateful but thanks though.

@webbr

This comment has been minimized.

Show comment
Hide comment
@webbr

webbr Apr 24, 2018

How ever long it took... THANK YOU! <3

webbr commented Apr 24, 2018

How ever long it took... THANK YOU! <3

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