Help – My WPP Views have ‘dropped’

  • Resolved indyparker

    (@indyparker)


    4 years, 9 months ago

    Hi Hector,

    Whilst using and enjoying the excellent performance of your WPP plugin over the past years, today I have come across a very major issue on my website.

    On the dashboard today, I see that the number of people ‘viewing’ my site dropped from an average of 500 down to 160 and hovering around this number or less even.

    Plus the other thing I note is in the ‘Trending now’ on the dashboard it is only displaying posts I published today and no posts from the past being viewed are being shown. Which were all showing yesterday with no problem.

    The plugin seems to be ‘restricting’ what it is showing on the stats.

    So, to query what was going on, I cleared the ‘cache’ just to see if that would make a difference.

    https://prntscr.com/qzhm5m

    However, I note I lost all my data and it did reset. But the problem above is not fixed.

    I am very concerned now at how this plugin is not showing all the figures because I checked on my Google Analytics – which shows I have many more views than being shown by WPP.

    This is very confusing and concerning.

    Here is an output of the debug screen

    https://prntscr.com/qzhkur

    I would highly appreciate your help with this to determine what is going on.

    PS Difference fro today/yesterday (apart from cache clear), I updated my FVplayer video plugin (I have done this in the past and it has had no effect on WPP).

    Kind Regards,
    Indy Parker

    • This topic was modified 4 years, 9 months ago by indyparker.
Viewing 2 replies - 16 through 17 (of 17 total)
  • Thread Starter indyparker

    (@indyparker)

    Hi Hector,

    I tried the SQL query you stated above to merge the data from the two WPP tables and got an error:

    https://prntscr.com/r2x2by

    Please advise.

    Regards,
    Indy

    Plugin Author Hector Cabrera

    (@hcabrera)

    Hi Indy,

    I tried the SQL query you stated above to merge the data from the two WPP tables and got an error (…)

    Ah, my bad. The problem is the * selector. Try this instead:

    INSERT INTO wp_popularpostssummary (postid, pageviews, view_date, view_datetime) 
SELECT postid, pageviews, view_date, view_datetime 
FROM wp_popularpostssummary2 WHERE view_date >= '2020-02-08 00:00:00';

    Also, do you have a staging/dev version of your website?

Viewing 2 replies - 16 through 17 (of 17 total)
  • The topic ‘Help – My WPP Views have ‘dropped’’ is closed to new replies.

Tags