Table Usage - warwickfoster/qurantools GitHub Wiki

The usage table tracks user activity, including the pages they load, timestamps, and associated metadata. It provides insights into user behavior and system utilization, aiding in feature optimization and user experience improvements.

Analysis of the usage Table

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

Table Name Field Name Description
usage ID A unique identifier for each usage entry, serving as the primary key for indexing and referencing.
usage PAGE LOADED The title or URL of the page that was accessed by the user, representing the action taken or the page viewed within the application.
usage ACTUAL PAGE (Currently empty in the provided data) Intended to store the exact URL or a more detailed path for the page accessed, allowing for precise tracking.
usage CATEGORY (Currently empty in the provided data) Intended to categorize the type of page or action (e.g., Browse, Search, Help), supporting more detailed analytics.
usage USER ID The unique identifier of the user who accessed the page, enabling tracking and analysis of user behavior.
usage DATE AND TIME The timestamp when the page was accessed, providing temporal context for analyzing user activity and engagement trends.

Key Insights

  1. Field Relationships:

    • ID uniquely identifies each usage record, ensuring traceability.
    • USER ID links the action to a specific user, allowing for personalized usage analytics.

  2. Usage Tracking:

    • PAGE LOADED captures the action or page accessed, providing insight into user interactions with the application.
    • DATE AND TIME allows for temporal analysis, such as peak usage times or trends over specific periods.

  3. Potential Enhancements:

    • Populating ACTUAL PAGE and CATEGORY would enable more granular tracking and categorization of user activity, improving analytics.

Example Interpretation of Data:

  • Row 1:

    • ID: 2265
    • PAGE LOADED: /home.php
    • USER ID: 1525
    • DATE AND TIME: 2025-01-01 18:41:33
    • Indicates that user 1525 accessed the home page (/home.php) on January 1, 2025, at 6:41 PM.

  • Row 4:

    • ID: 2268
    • PAGE LOADED: /verse_browser.php?V=1
    • USER ID: 1525
    • DATE AND TIME: 2025-01-04 11:49:47
    • Shows the same user accessed a verse browser for verse 1 on January 4, 2025, at 11:49 AM.

Contextual Significance:

  1. User Behavior Analysis:
    • The PAGE LOADED and DATE AND TIME fields can help identify popular pages or features and analyze user engagement trends over time.
  2. Feature Optimization:
    • Tracking user interactions allows for identifying underused or problematic features that may need enhancement.
  3. Personalized Analytics:
    • By linking actions to USER ID, the table supports creating personalized reports or recommendations for users.

First 10 Rows Example

ID PAGE LOADED ACTUAL PAGE CATEGORY USER ID DATE AND TIME
2265 /home.php nan nan 1525 2025-01-01 18:41:33
2266 /help/welcome-to-quran-tools.php nan nan 1525 2025-01-01 18:41:44
2267 /browse_sura.php nan nan 1525 2025-01-04 11:49:44
2268 /verse_browser.php?V=1 nan nan 1525 2025-01-04 11:49:47
2269 /verse_browser.php?V=1 nan nan 1525 2025-01-04 11:52:45