@gauripadbidri opened this Issue on June 25th 2021

I am invoking 2 Matomo API to display Total Views on a POST Page and Top Views for the week on every page in the sidebar. However, I observed that the Total Count for a Post and Top Views for the same Post are different.

Note: This has started to happen after I have re-processed my data (Invalidate entire data and trigger re-process)
Same code works (meaning top views and total Views for a post are same) well for other sites for which re-processing is NOT triggered.

Following are my queries :
I am trying to show top stories of the week based of Top Views. For which my query is as follows:
Eg : Startdate = 14th June End Date = 21st June

module=API&method=Actions.getPageUrls&filter_sort_column=nb_hits&filter_sort_order=desc&idSite=’ . $idSite . ‘&period=range&date=’ . $params[‘start-date’] . ‘,’ . $params[‘end-date’] . ‘&format=json&token_auth=’ . $this->auth_token

Total Views :
‘module=API&method=Actions.getPageUrl&pageUrl=’ . $pageUrl . ‘&idSite=’ . $idSite . ‘&period=range&date=’ . $atts[‘start_date’] . ‘,’ . $atts[‘end_date’] . ‘&format=json&token_auth=’ . $auth_token;

I have done following steps :

Reference URL - https://matomo.org/faq/troubleshooting/faq_141/

DB Snapshot / Backup that way we can revert when needed.

Update Matomo Version - Done

Re-Process Data - Ref URL : https://matomo.org/faq/how-to/faq_59/
a. Invalidate Historical Reports for a Site (with LOW Traffic) using Invalidte Reports Plugin (Al Historical Data) OR via
Console (https://matomo.org/faq/how-to/faq_155/)
Console path - var/www/matomo

b. Re-Process Data using Console - https://matomo.org/faq/how-to/faq_59/
./console core:archive --force-idsites=1,3,5 --url=https://analytics.sophiamedia.com/
Helpful Command for Console - cd /var/www/matomo > ./console help core:archive

Setup auto archiving for your reports - Done in Crontab already

What could have gone wrong in the processing ? Anything else remains in triggering re-processing ?

@diosmosis commented on June 27th 2021 Member

Hi @gauripadbidri, can you provide the URLs for the API requests above with parameters filled out (except token auth) and the API results?

@gauripadbidri commented on June 30th 2021

https://analytics.sophiamedia.com/?module=API&method=Actions.getPageUrl&pageUrl=https://medicalkidnap.com/2014/12/08/medically-kidnapped-teenager-in-canada-pleads-to-be-returned-to-his-family/&idSite=6&period=range&date=2014-12-08,2021-06-24&format=json&token_auth=some_token

In above API Call; the Start Date is the Post Publish Date
Whereas; GA has around 70K Views
Response : 
[{"label": "/2014/12/08/medically-kidnapped-teenager-in-canada-pleads-to-be-returned-to-his-family/index","nb_visits": 39013,"nb_hits": 41874,"sum_time_spent": 1754441,"nb_hits_with_time_generation": 197,"entry_nb_visits": 38568,"entry_nb_actions": 44422,"entry_sum_visit_length": 1709857,"entry_bounce_count": 35246,"exit_nb_visits": 38328,"sum_daily_nb_uniq_visitors": 22,"sum_daily_entry_nb_uniq_visitors": 20,"sum_daily_exit_nb_uniq_visitors": 16,"min_time_generation": null,"max_time_generation": false,"avg_time_on_page": 42,"bounce_rate": "91%","exit_rate": "98%","avg_time_generation": 476.305,"url": "http://medicalkidnap.com/2014/12/08/medically-kidnapped-teenager-in-canada-pleads-to-be-returned-to-his-family/"}]
Also there are many URL's for which View Count = 0
Best Regards,Gauri Sanil

On Monday, June 28, 2021, 05:29:59 AM GMT+5:30, dizzy ***@***.***> wrote:  

Hi @gauripadbidri, can you provide the URLs for the API requests above with parameters filled out (except token auth) and the API results?


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or unsubscribe.

@sgiehl commented on June 30th 2021 Member

Hi @gauripadbidri
I'm not sure if I understood your issue correctly. So the same report changes it's numbers after invalidating and reprocessing it?
You also mentioned something of an Matomo update? Did you update the Matomo version somewhere before reprocessing the data?

Powered by GitHub Issue Mirror