While doing some maintenance on my site, I accidentally logged a bunch of analytics data for the day.
I’d like to delete everything for the single day from the database, so it doesn’t skew or clutter the overall analytics. I am okay with wiping the entire day to a blank slate, so that instead of there being 19 visits and some 300 actions, it is zero (0).
can anyone advise on the way to go about doing this? eg. SQL queriues (via phpmyAdmin)?
thanks in advance!