Forum Discussion

shong88's avatar
shong88
Contributor
2 months ago

The total number of views in bulk data table doesn't match the views display in community,

Hello all, 

I have a question, I search all the action keys of an article from the bulk data API table,

Gives this result:

ACTION_KEYCOUNT(KHO.ACTION_KEY)
moderation.mark-unread1
visits.member-entrance15
moderation.mark-read1
messages.edit1
view57
visits.visit-summary24

total counts is: 99 for all actions, and the view is 57, but the views display 181 in community.

why the number of views in database doesn't match the views display in community, the difference between these two numbers is so significant. any idea?

 

4 Replies

  • Interesting - yes, it definitely wouldn't be a timing issue in that case.  

    Our organization performs a nightly extract of community data using the Bulk Data API (we generally use the processes described here).  We then load that nightly data extract to a SQL database and query from there in our local system.  I'm not sure what your process is, so I suppose it's hard to say why there's a disconnect.  This system works well for us, because we're pretty sure there aren't gaps in our data coverage.

  • shong88's avatar
    shong88
    Contributor
    2 months ago

    jonesannak​ Thanks for your quick reply. the post was created at Jun 12, 2025 9:18:57 AM, it's not a new post. Where we can check from the bulk data?

  • shong88​ I checked a couple posts in our community, and the number of views seems to be matching in the bulk data and on the interface.  How recently was the post created?  If it is a new post with a lot of views in the past day, I think you'll find that there's a 24 hour delay in the bulk data.