problems with connection to google analytics - Support

Resolved Tusk Review
1 year, 7 months ago

Rank Math free

I have tried multiple ways to get a connection to google analytics for my wordpress site tuskreview.com. I have never been able to get the fields to populate in the site wizard in analytics. I have tried using chrome incognito and safari after I cleared the cache. I have tried recreating tables and then rebuilding indexes in the database tools, and I have confirmed that I am in advanced mode and that my chrome profile accepts all account access checkboxes for rankmath. Any help you might be able to offer would be greatly appreciated!

Thanks

Viewing 3 replies - 1 through 3 (of 3 total)

RankBot
1 year, 7 months ago

Hello,

We apologize for the issue you are facing with the connection to Google Analytics. It sounds like you’ve already taken several steps to troubleshoot the problem, which is great.

To further test the connection, please navigate to Rank Math SEO → General Settings → Analytics and click on the Test Connections option at the top right of the Analytics settings. This will help you validate the existing connections. A green signal indicates a valid connection, while a red signal indicates a glitch in the connection.

If you see a red signal, we recommend reconnecting your Google account by clicking the Reconnect link in the same settings area. Here’s how it looks:

If the issue persists even after reconnecting, please consider sharing the error log with us. You can find it by navigating to Rank Math SEO → Status & Tools → Error Log. This information will help us assist you better.

Thank you for raising this concern, and we hope to resolve it for you soon!

Sources:
Resolving Rank Math Analytics Related Issues » Rank Math
What to Do When Rank Math Analytics Shows Zero Search Traffic » Rank Math

Tusk Review
1 year, 7 months ago

Rank Math free

See the error log below. Thanks for the help, let me know if you have questions.

[12-Aug-2024 20:52:37 UTC] Cron reschedule event error for hook: action_scheduler_run_queue, Error code: invalid_schedule, Error message: Event schedule does not exist., Data: {“schedule”:”every_minute”,”args”:[“WP Cron”],”interval”:60}
[12-Aug-2024 22:19:42 UTC] Cron reschedule event error for hook: action_scheduler_run_queue, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {“schedule”:”every_minute”,”args”:[“WP Cron”],”interval”:60}
[12-Aug-2024 22:19:42 UTC] Cron reschedule event error for hook: wp_update_themes, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {“schedule”:”twicedaily”,”args”:[],”interval”:43200}
[13-Aug-2024 12:29:05 UTC] Cron reschedule event error for hook: action_scheduler_run_queue, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {“schedule”:”every_minute”,”args”:[“WP Cron”],”interval”:60}
[13-Aug-2024 14:24:09 UTC] Cron reschedule event error for hook: action_scheduler_run_queue, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {“schedule”:”every_minute”,”args”:[“WP Cron”],”interval”:60}
[13-Aug-2024 14:36:59 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[13-Aug-2024 14:36:59 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[13-Aug-2024 14:36:59 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[13-Aug-2024 14:37:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[13-Aug-2024 14:37:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[13-Aug-2024 14:37:02 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[13-Aug-2024 14:41:21 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[13-Aug-2024 14:41:21 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[13-Aug-2024 14:41:21 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[18-Aug-2024 20:26:22 UTC] WordPress database error Table ‘u481875880_6NVsV.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN ‘2024-07-13 00:00:00’ AND ‘2024-08-15 23:59:59’ LIMIT 0, 1 made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Admin\Database\Query_Builder->one
[18-Aug-2024 20:26:22 UTC] WordPress database error Table ‘u481875880_6NVsV.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN ‘2024-06-09 00:00:00’ AND ‘2024-07-12 23:59:59’ LIMIT 0, 1 made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Admin\Database\Query_Builder->one
[18-Aug-2024 20:26:22 UTC] WordPress database error Table ‘u481875880_6NVsV.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(query))
FROM wp_rank_math_analytics_gsc
WHERE created BETWEEN ‘2024-07-13 00:00:00’ AND ‘2024-08-15 23:59:59’ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Analytics\Summary->get_keywords_summary
[18-Aug-2024 20:26:22 UTC] WordPress database error Table ‘u481875880_6NVsV.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(query))
FROM wp_rank_math_analytics_gsc
WHERE created BETWEEN ‘2024-06-09 00:00:00’ AND ‘2024-07-12 23:59:59’ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Analytics\Summary->get_keywords_summary
[18-Aug-2024 20:28:34 UTC] WordPress database error Table ‘u481875880_6NVsV.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[18-Aug-2024 20:29:02 UTC] WordPress database error Table ‘u481875880_6NVsV.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[18-Aug-2024 20:52:55 UTC] WordPress database error Table ‘u481875880_6NVsV.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[18-Aug-2024 20:53:20 UTC] WordPress database error Table ‘u481875880_6NVsV.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[18-Aug-2024 21:04:17 UTC] WordPress database error Table ‘u481875880_6NVsV.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[18-Aug-2024 21:04:47 UTC] WordPress database error Table ‘u481875880_6NVsV.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
Great
1 year, 7 months ago
Hello,

Thank you for contacting us and we apologize for any trouble you may have experienced with Rank Math.

To fix the issue, please make sure you have the latest version of the Rank Math plugin installed on your site. You can check the latest version here: https://rankmath.com/changelog/free/

Once you have updated the plugin, please follow these steps to reconnect Rank Math with your Google account and grant all the necessary permissions:
1. First of all, check to make sure that you have a verified Google Search Console and Google Analytics properties, if not follow the attached link to create one. If you already have verified properties and you’re still unable to connect them – then follow these steps
2. Go to your Google account settings and click on Security.
3. Scroll down to the section called Third-party apps with account access and click on Manage third-party access.
4. Find Rank Math in the list of apps and click on it.
5. Click on Remove access and confirm your action.
6. Go back to your WordPress dashboard and navigate to Rank Math > General Settings > Analytics.
7. Click on Deauthorize Account and then click on Authorize again.
8. Follow the instructions to sign in with your Google account and allow Rank Math to access your data.
You can also refer to this guide for more details: https://rankmath.com/kb/analytics-issues/#expired-google-oauth-token

We hope this resolves the issue for you. If you still face any problems or have any questions, please let us know. We’re always here to help.

Thank you for choosing Rank Math!
RankBot
1 year, 6 months ago

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 3 replies - 1 through 3 (of 3 total)

The ticket ‘problems with connection to google analytics’ is closed to new replies.