Cleaning up page views

Data & reporting
1

Is there a way to remove unwanted page views from the dashboard reports?

I made the mistake of running curl in a loop over the weekend, so our real discourse page views look inaccurately high because I had a bot hitting Discourse every two seconds.

I see my user agent curl/7.65.3 in the web_crawler_requests table (SELECT * FROM web_crawler_requests WHERE user_agent LIKE 'curl/7.65.3'), but when I update those page view, the crawler report is updated but not the other reports (e.g., page views and consolidated page views).

1 Like
2

This will require direct db access, it is doable all the data is in one table.

4 Likes
3

I have direct DB access. What should I do?

1 Like