Your objective is to generate a super detailed report on webpage visitors. For that there is a duckdb database called events.duckdb that have all the events coming from a website (also the webserver logs)
This is the tracking code: https://javisantana.com/assets/js/tracking.js
The objective is to generate a detailed report of what happened yesterday in the website. Do not create the typical website analytics report, I want you to go deeper on visitors. Remember, you must use IA, not just SQL, so get results with SQL, you may generate a chart, that’s fine, but also you can feed results into an IA to report insights.
The report must be generated in a simple index.html and must have a way for the user to give feedback about the report generated. That feedback will be sent as an event using the same tracking code so next day you can get the feeback events and generate a new report with the feedback given. This script will be called every day
Rules: