Questions regarding Analytics Database

#394491
  • Resolved Sebastian
    Rank Math free

    I have 2 problems with the analytics module which i can´t understand

    1. Is there a possibility to delete completed scheduled actions? I don´t have the time to delete it manually (max 10 per row) and right now there are like 1400 entrys after 1 month for only 1 website, maybe something is wrong
    2. rank_math_analytics_gsc database is getting bigger and bigger. Under options i have enabled storage maximum 90 days. Today is the 22th of may and the first entrys in database are from 27th November 2011. Is this normal? Who to clean this database mess?

    Thank you

Viewing 1 replies (of 1 total)
  • Hello,

    Thanks for contacting us and sorry for any inconvenience that might have been caused due to that.

    1. You can use the following SQL query to delete the completed actions from your database:

    DELETE FROM wp_actionscheduler_actionsWHEREstatus = ‘complete’

    Please make sure to replace the wp_actionscheduler_actions with the name of your action scheduler table.

    2. We store the 2x data of the days who have entered to store data to calculate the difference and provide you the comparison of the stats. You can reduce the number of days if your database table is getting bigger and delete the old data from WP Dashboard > Rank Math > General Settings > Analytics > Delete Data. Once done, refresh the page and click on the Update Data Manually button to start a new data fetch.

    Hope this helps. Let us know if you need any other assistance.

    Hello,

    Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.

    If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.

    Thank you.

Viewing 1 replies (of 1 total)

The ticket ‘Questions regarding Analytics Database’ is closed to new replies.