Difference in Views WPP vs GA

Hi @indyparker,

Can’t really say why GA numbers are different from what WPP reports. There are just too many things that can affect the statistics gathered by one tool vs the other (as I explain here in more detail: Popular Posts View Count Different than Jetpack?

Seeing that what WPP reports is similar to what your server logs tracked seem to indicate that there’s maybe something messing with the GA tracking script. You’ll need to do some more research / debugging and figure out if there’s anything that may be preventing the GA script from tracking your pageviews sometimes (which would explain why it has lower numbers.) Or it could simply be that GA hasn’t just updated its numbers yet. Again, hard to say what’s going on.

You could also try reaching out to the GA team and have them look into this for you.

Hi Hector,

Thanks for your reply.

I’m still trying to understand this discrepancy. Is there a way I can see all the posts viewed for a specific day to understand how there is this surge in views?

If I try your tools, it only shows the top 10?

Because it looks like maybe our language subdomains may be driving traffic which is not captured by GA.

So, by looking at all of the posts viewed that day of the spike, could help us understand this better.

Please advise.

Thanks
Indy

Yes, there is:

1. Go to Settings > WordPress Popular Posts.
2. To view more than the top 10 popular posts click on the small cog icon that’s floating on the top left of the Stats screen, then set a higher Limit (eg. 50) and click on Apply to save changes.
3. Click on the Custom link (right next to the 30d one).
4. Click on Date Range.
5. Click on Select a date… to pick your desired date, then click on Apply.

• This reply was modified 3 years, 9 months ago by Hector Cabrera. Reason: Changed actions order for accuracy

Hi Hector,

Thanks for your reply.

This is what I want to achieve from a report or output:

I want to know all of the articles which were viewed for a specific date range – a list, views and the total.

If you can give me the SQL query for this it will be very helpful. I need to produce an output report for management.

Thanks in advance.

Indy

• This reply was modified 3 years, 9 months ago by indyparker.

You can follow the same steps and you’ll get the result you want, except this time you’ll be selecting a date range and not a single date.

Hi Hector,

But it does not give me all the posts read. It is limited by the LIMIT set.

If you can send me the SQL, that will really be helpful.

Thanks
Indy

You can set a very high limit (eg. 9999) and that should fetch you all of the posts (unless you have more than 9999 posts & pages, in that case you’ll want to use a higher limit.)

If you can send me the SQL, that will really be helpful.

The scope of support I provide here is limited to what the plugin offers out of the box, bug fixes, answering questions related to the plugin, and feature requests. Custom work -like writing a custom query as you requested- completely falls outside that scope. You’ll need to hire a developer if this is something you can’t do yourself and/or you don’t have the time for it.

Hi Hector,

The man reason for the query request is that I am trying to still find out why there is such a huge discrepancy between GA and WPP.

It is difficult from your tool, to determine this, even setting the LIMIT to 9999 gives me pages and pages. I just want to perform the query in a database tool to output the report to a file.

I need to work out which stories are being read to cause the spike in WPP.

Therefore, if you cannot provide the query then can you tell me which tables I should be querying for such a report?

Also, if I am using a language plugin which produces a version of my article but in a different language, will this be counted on WPP as well or not?

Please advise.

Regards,
Indy

can you tell me which tables I should be querying for such a report?

Yep. WPP stores its data in two separate database tables:

• wp_popularpostsdata, holds the “All-Time” (total) views data of your posts & pages.
• wp_popularpostssummary, holds the Time Range related views data (last 24 hours, last 7 days, etc.)

if I am using a language plugin which produces a version of my article but in a different language, will this be counted on WPP as well or not?

WPP adds the views count data to the original post as it considers translations to be another version of the same content and so it treats them as the same entity.