WordPress User Activity Dashboard
Employer not named by the sourceRemote
Frontier is not the employer and does not collect applications.
About this role
PHP, WordPress, Software Architecture, MySQL, Data Visualization, Data Analysis, Database Management, API Integration, Google Data Studio, Looker Studio · 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