np-report

Production usage reports from a D1 database are generated by executing SQL queries to aggregate conversation counts, user counts, and weekly trends. The Skill references a queries.md file to extract and compose analytics data into a structured report for ongoing monitoring.

Chatbot usage analytics include conversation counts, active user counts, weekly trend transitions, engagement distributions, topic analysis, and notable topics. These metrics are aggregated over all-time or specified periods to monitor chat volume and active user engagement.

Yes, you can filter production database analytics by a specific time period. The Skill executes period-specified SQL queries from the query reference to generate customized reports for weekly trends and topic distributions within your desired timeframe.

The best way to monitor active users and chat volume trends is using SQL-based aggregation on a production database. This approach extracts weekly trend data and engagement distributions, composing them into a comprehensive report for ongoing operational monitoring.

SQL knowledge is helpful but not strictly required, as the Skill references predefined SQL queries in a queries.md file. It automatically executes the necessary data extraction and aggregation logic to produce topic analysis and notable topics sections.

Usage reporting via SQL queries is limited to the data structures and tables available in the D1 production database. Analysis scope depends on the predefined queries in the references, meaning custom metrics outside this reference may require manual query modification.