WordPress User Activity Dashboard

I want to see at a glance how people actually use my WordPress site, so I need a Looker Studio (formerly Google Data Studio) dashboard that pulls real-time user activity directly from the WordPress database or an appropriate plugin/API.

The focus is on three metrics:
- time duration per session that a user logs in (session start/end time). Or if not possible, then total amount of time that a user uses the site, across all times that they’ve logged in.
- page view (yes/no) - this will allow us to see which module they got to, and how far within that module.
- file downloads

Please visualise the trends with simple bar or line charts and pair them with clean, sortable data tables for quick exporting. A date-range selector and user search filter should sit at the top so I can drill down without editing the report. Responsive layout is important because I will view it on both desktop and tablet.

Deliverables
1. Reliable data connection from WordPress to Looker Studio (native connector, BigQuery, or a lightweight middleware—whatever you recommend and set up).
2. One-page dashboard containing the charts and tables described above, styled to match my site colours.
3. Brief hand-over note explaining how to refresh data sources and add additional metrics later.

I will supply admin access to WordPress and a Google account for Looker Studio as soon as we agree on the approach.