I’m continuing on in this discussion even though I have not heard a response. There was a comment on my first report of this issue on github mentioning that there might be a conflict with another previous google analytics js might on the site. gtag.js, or googleanalytics.js After using a google analytics debugger, I confirm that there is indeed another tracking code. However I have checked all of my plug-ins and theme and cannot discover where it is coming from.
I also have received php errors in logs everyday:
[13-Oct-2020 10:52:29 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘traffic AS (
SELECT t1.page as page, COALESCE( t1.pageviews, 0 ) as pagev’ at line 1 for query WITH traffic AS (
SELECT t1.page as page, COALESCE( t1.pageviews, 0 ) as pageviews, COALESCE( t2.pageviews – t1.pageviews, 0 ) as difference
FROM
( SELECT page, SUM(pageviews) as pageviews FROM pecomrank_math_analytics_ga WHERE 1=1 AND created BETWEEN ‘2020-09-05 00:00:01’ AND ‘2020-10-10 23:59:59’ GROUP BY page ) as t1
LEFT JOIN
( SELECT page, SUM(pageviews) as pageviews FROM pecomrank_math_analytics_ga WHERE 1=1 AND created BETWEEN ‘2020-07-31 00:00:01’ AND ‘2020-09-04 23:59:59’ GROUP BY page ) as t2
ON t1.page = t2.page
)
SELECT SQL_CALC_FOUND_ROWS o.*, COALESCE( t.pageviews, 0 ) as pageviews, COALESCE( t.difference, 0 ) as difference
FROM pecomrank_math_analytics_objects as o
LEFT JOIN traffic as t ON o.page = t.page
ORDER BY pageviews DESC
LIMIT 0, 25 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, RankMath\Analytics\Posts->get_posts_rows_by_pageviews, RankMath\Analytics\Pageviews->get_pageviews_with_object
Hello
Thank you for contacting the support and sorry for any inconvenience that might have been caused due to that.
We went ahead and did these things:
1. Replaced the plugin files with the following version:
https://i.rankmath.com/aGxNMQ (this is yet to be released but includes improvements for the Analytics module)
2. Disconnected your Google conenctions.
3. Deleted all the older Analytics data from Rank Math, so, you will need to fetch the fresh data.
4. Rebuilt your posts index for Rank Math by using the following option:
5. Then we checked the error log and noticed that the errors are from 23rd June and are not latest. But the error log might have updated.
6. Please reconnect your Google account again with the Rank Math plugin and fetch the data.
Also, for the future, we recommend to use the below plugin to generate a temporary login URL to your website and share that with us instead:
https://wordpress.org/plugins/temporary-login-without-password/
You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):
https://wordpress.org/plugins/wp-security-audit-log/
With that said, if your Analytics is already receiving the data even before you updated the Rank Math plugin, we recommend to avoid installing the Google Analytics code using the Rank Math plugin. That will mess your Analytics data up. You can only connect your account and fetch the data.
Please let us know if that helps. We are here to assist.
Hello,
I have updated the sensitive data as requested. Can you please check further?
Thank you.
Thanks so much. The site is currently fetching data. I have not clicked the “install analytics code” button. I will update on what data comes through.
I have also updated the sensitive data for a URL login.
I will monitor the PHP error log. Thanks.
Thanks for your help,
Hello,
Sure. Please keep us informed about the status of the disconnection.
Looking forward to helping you. Thank you.
Fetching complete.
Unfortunately, data still seems to be quite off.
Search traffic is 0, and total keywords is only 1 which does match the “keyword positions graph saying that I have 20 in the top 3.
Hello,
The Analytics module might not be returning any value because we have hit the allowed API limit due to the sheer number of users using the latest version.
Google allows applying for an increase in the quota limit only when someone hits at least an 80% API limit, which happened after we released the final version and everyone started to mass-import their data.
With that said, we have applied for an increase in the quota limit and as soon as that happens, the Google Analytics part will start working again.
Hope that clears the confusion with the mismatch in the data.
Please allow us some time while we get this sorted with Google.
We will make an announcement once that issue is fixed.
Thank you.
Cool sounds good. Thanks for your help
Hello,
Glad that helped and appreciate your understanding.
Please feel free to reach out to us again if you need any other assistance.
We are here to help.
Thank you.
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.
