Analytics - Browser Codes translation

[walter_euyang]

What are browser names for following browser codes (present in SiteCatalyst data feed):

621, 620, 613, 632, 633, 618, 617, 634

Thanks!

-Walter

[AkhilSharma]

Hi Walter,

Excellent question perhaps.

For the browser codes please refer to the lookup files in your manifest file.

Lookup Files
Lookup files do not contain hit data, these are supplemental files that provide the column headers for the hit data, and lookup files to translate the IDs found in the data feed to actual values. For example, a value of "497" in the browser column indicates that the hit came from "Microsoft Internet Explorer 8".

The lookup files are delivered together in a compressed zip named according to the following:

<report_suite_id>_<YYYY-mm-dd>-<HHMMSS>-lookup_data.<compression_suffix>

https://microsite.omniture.com/t2/help/en_US/sc/clickstream/index.html#Data_Feed_Contents

A typical manifest file contains data similar to the following:

Datafeed-Manifest-Version: 1.0
    Lookup-Files: 1
    Data-Files: 1
    Total-Records: 611

    Lookup-File: bugzilla_2012-09-09-lookup_data.tar.gz
    MD5-Digest: af6de42d8b945d4ec1cf28360085308
    File-Size: 63750

    Data-File: 01-bugzilla_2012-09-09.tsv.gz
    MD5-Digest: 9c70bf783cb3d0095a4836904b72c991
    File-Size: 122534
    Record-Count: 611
Every manifest file contains a header, indicating the total number of lookup files, data files, and total number of records in all data files. 

Hope this resolves your query.
Please mark it as solved if it resolves your query.

Thanks and Regards
Akhil

[walter_euyang]

Hi Akhil,

This didn't answer my question; the link you posted does not contain the browser lookup file. Can you please write out the browser names associated with the following browser codes. I do not have access to the data feed.

621

620

613

632

633

618

617

634

Thanks!

-Walter

[Gigazelle · Accepted solution]

Here you are sir:

621: Google Chrome 26.0
620: Google Chrome 25.0
613: Google Chrome 24.0
632: Google Chrome 27.0
633: Google Chrome 28.0
618: Mozilla Firefox 20.0
617: Mozilla Firefox 19.0
634: Google Chrome 29.0

As Akhil mentioned, this data can be obtained by looking at browser.tsv, which is packed with every data feed file.