New to the community? Start here

[Hustle] How to delete old Hustle stats?

How do you delete old stats in Hustle. There doesn't seem to be must of a benefit in the current release to keep the stats for long term?

Sun, 8 Jul 2018 17:30:36
More Hustle Pro discussions
Hustle Pro
  • Adam
    • Support Gorilla

    Hello Sean

    I hope you're fine today and thank you for your question!

    I believe you're referring to the tracking stats – views, conversions – of popups, slide-ins etc, right?

    Currently, that would require dealing directly with the database. You would want to access your site's database via phpMyAdmin (or similar tool available on your server) and find the

    wp_hustle_modules_meta

    table there. Please note: I used "wp_" prefix in a table name but on your site the prefix might be different. The "core" name of the table, however, would be "prefix_hustle_modules_meta"

    Next step is to find the popup/slide in ID. Let me focus on the popup as an example: go to the "Hustle -> Pop-ups" page and on the list find the one you want to reset stats for. When you edit the "Edit Pop-Up" option from there, look at the browser address bar, there'll be a part of the URL like this:

    ?page-hustle_popup&id=22

    In this case ID is 22.

    Knowing that ID, get back to the database and go to "Search" tab. You'll need to perform two searches on it. In both cases value for "module_id" would be that ID that you just got (22 in our example)

    1) search for "meta_key" of value:

    popup_view

    and remove all the rows

    2) search for "meta_key" of value

    post_conversion

    and remove all the rows.

    As stated above, for both these searches the "module_id" must be set to the popup ID.

    [attachments are only viewable by logged-in members]

    [attachments are only viewable by logged-in members]

    [attachments are only viewable by logged-in members]

    Please make sure that you took a full backup of the database before performing any operations on it. Dealing directly with the database is a risky thing and without backup it might cause irreversible damage to the site if anything goes wrong.

    I hope that helps. If you got any additional questions, let me know, please.

    Best regards,

    Adam