URLs for Translated HTML

[bianca_writer]

I have an HTML user guide that is available in multiple languages; you can select your language from the Language Selector icon. When you select a language, the URL changes to include the language. For example, this would be the new URL when you select Japanese (ja):

UseGuideTitle/ja/Content/Intro/Overview.htm

I want to know how many Page Views the translated pages get. My initial approach was to pull the total Page Views of all HTML guides, and then use the COUNTIF function to count how many page URLs have the language indicator (ja, zh-chn, etc). I did this, but the numbers seem low. Also, only some of the page URLs include en-us; shouldn't they all include this? Is there a more accurate way to pull data for all pages that have been translated?

Thanks,
Bianca