Table Usage Verses Searches - warwickfoster/qurantools GitHub Wiki

This table logs searches performed by users for specific verses or queries, capturing metadata like referring pages and timestamps. It provides an audit trail of search behavior, useful for understanding user needs and refining search algorithms.

Analysis of the usage-verses-searches Table

Below is the detailed analysis and description of each field in the usage-verses-searches table, with the table name included as a left-hand column.

Table Name Field Name Description
usage-verses-searches ID A unique identifier for each entry in the table, serving as the primary key for indexing and referencing.
usage-verses-searches VERSES OR SEARCH Specifies whether the action involved a verse lookup (V) or a search query, indicating the type of user interaction.
usage-verses-searches LOOKED UP The specific verse or search term that was looked up by the user, providing the content of the query or action.
usage-verses-searches REFERRING PAGE The page from which the action was initiated, offering context for the user's navigation path within the application.
usage-verses-searches USER ID The unique identifier of the user who performed the action, enabling personalized or aggregate usage analysis.
usage-verses-searches Institution ID Identifies the institution associated with the user, if applicable. A NULL value indicates no institutional affiliation is recorded for the action.
usage-verses-searches DATE AND TIME The timestamp when the action occurred, providing temporal context for analyzing trends and user activity patterns.

Key Insights

  1. Field Relationships:

    • ID uniquely identifies each user action, ensuring data traceability.
    • USER ID and Institution ID link the action to individual users or institutions, allowing for user-specific or group-specific analytics.

  2. Action Context:

    • VERSES OR SEARCH and LOOKED UP specify the type of action and the exact content of the lookup, helping analyze user intent and preferences.
    • REFERRING PAGE indicates the navigation flow, providing insight into how users interact with the application.

  3. Applications:

    • Tracks user interactions with verse lookups or searches, enabling insights into popular verses or search trends.
    • Supports optimization of navigation paths and search functionality based on usage patterns.

Example Interpretation of Data:

  • Row 1:

    • ID: 37
    • VERSES OR SEARCH: V
    • LOOKED UP: 1
    • REFERRING PAGE: /browse_sura.php
    • USER ID: 1525
    • Institution ID: NULL
    • DATE AND TIME: 2025-01-04 11:49:47
    • Indicates that user 1525 looked up verse 1 from the page /browse_sura.php on January 4, 2025, at 11:49 AM.

  • Row 2:

    • ID: 38
    • VERSES OR SEARCH: V
    • LOOKED UP: 1
    • REFERRING PAGE: /browse_sura.php
    • USER ID: 1525
    • Institution ID: NULL
    • DATE AND TIME: 2025-01-04 11:52:45
    • Shows another verse lookup action for verse 1 by the same user shortly after the previous action.

Contextual Significance:

  1. Usage Tracking:
    • Helps identify frequently looked-up verses or common search queries, guiding content prioritization or application enhancements.
  2. Navigation Flow Analysis:
    • By analyzing REFERRING PAGE, developers can optimize navigation paths to improve user experience.
  3. Temporal Insights:
    • The DATE AND TIME field allows for identifying peak usage times or monitoring patterns of user engagement over time.

First 10 Rows Example

ID VERSES OR SEARCH LOOKED UP REFERRING PAGE USER ID Institution ID DATE AND TIME
37 V 1 /browse_sura.php 1525 nan 2025-01-04 11:49:47
38 V 1 /browse_sura.php 1525 nan 2025-01-04 11:52:45