• v7.1.1
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
PREVIOUS
Custom alerts for 404 errors
NEXT
Get the usage share of operating systems

Searching data / Working in the search window / Use case: eCommerce behavior analysis / Step 2. Operating system ranking

Download as PDF

Step 2. Operating system ranking

Apache logs can provide information about the operating systems used to access our website. This data can be extracted from the userAgent column.

To extract the operating systems from the userAgent column, follow these steps:

  1. Access the demo.ecommerce.data table and click the Create column icon from the query window toolbar.
  2. Select User Agent OS Family (uaosfamily) as the operation, which will parse the user agent values and retrieve the corresponding operating system. Then click New argument and select the userAgent column. Enter a meaningful name for the new column (for example, operatingSystems).


  3. Click Create column. The new column will be added to the right of the table. Select its header and drag it next to the userAgent column.

Download as PDF

PREVIOUS
Custom alerts for 404 errors
NEXT
Get the usage share of operating systems

Export

See what Devo can do for you. Request a demo!
Discover what's new (Release notes)
  • v7.1.1
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
  • +1 888 6830910 (USA)
  • +34 900 838 880 (Spain)
Copyright © 2019 Legal Terms Privacy Policy Cookies Policy

Powered by Confluence and Scroll Viewport