3

We have Sitecore 8.2. In the Sitecore_reporting database in SQL server, there is this Fact_PageViewsByLanguage table with these columns:

  • SiteNameId
  • LanguageId
  • Views
  • Visits
  • Value

Is there a document where I can find information about these columns. I am looking for the following info:
1. What is the difference between the Views & the Visits column.
2. For few records, the value for Visits is 0, but there are some Views for it. How come?
3. If I need to get the popular pages, I need to be looking at SUM(Views)& not Visits. Am I right?
4. What does the Value column contain.
5. The SiteNameId and LanguageId has values which are not GUIDs like - (-1811310475, -1743424285). How can I map them to the required Sitename or language.

Thank you.

4

The documentation for this table can be found here https://doc.sitecore.net/sitecore_experience_platform/setting_up__maintaining/xdb/platform/reporting_database_reference

It's not totally clear from the descriptions but:

Views The total number of times the page was viewed.

Visits The number of interactions which included a view of the page.

I would presume that the interaction refers to a registered xDB interaction. See: https://doc.sitecore.net/sitecore_experience_platform/developing/marketing_operations/interactions/register_interactions_using_the_interaction_registry

An interaction is the exchange of communication and commitment between a contact and an organization that takes place through one or more channels. The interaction registry is a service that enables you to register or create an interaction that you have tracked in Sitecore or in a non-Sitecore environment in the Experience Database (xDB).

So I deduce that you can record "something happening" which leads to a View being recorded. So if you're not capturing all of the possible interactions that can trigger a View - you'd expect these values to be different.

I think you're correct in your assumption for question 3 - Views is what you're after here.

Question 4 is also answered in the doc:

Value The amount of engagement value accumulated for interactions which included a view of this page.

The "LanguageId" and "SiteNameId" refer to other tables in the reporting database (check the foreign keys to see the link). Languages and SiteNames respectfully. Both have an ID and a varchar name column. Check the values you're recording in these tables and that should help answer your final question.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.