SAVI Web Stats Reporting
Introduction
Exploring user behavior, preferences and interactions can empower stakeholders with actionable insights to drive strategic decisions and optimize their platform’s performance. SAVI Web Stats Reporting project combines Google Analytics data with Looker Studio’s visualization capabilities to gain a better understanding of user interactions, preferences and engagement levels on the Polis GA4 properties.
Objective
To develop a comprehensive dashboard for Polis GA4 properties, enabling users to access all their statistics in one place.
Methodology
Data Connection
Connected the dashboard to the Polis Google Analytics platform and added multiple data properties for analysis.
Chart Creation
Added charts showcasing metrics and dimensions relevant to the different fields (e.g., sessions, users, engagement rate) present in the data.
Data Blending
Performed comparisons across five properties by combining data using an “inner join” on the “DATE” and “YEARMONTH” fields for consistency and accuracy.
Interactivity
Created filters (e.g., age, gender, city) and incorporated data controls such as a date range selector to enable dynamic exploration of data.
Design Consistency
Ensured dashboard uniformity by using a single cohesive color theme for a professional appearance.
Results
Key Findings
Looker Studio: Introduced to this visualization platform for the first time and it offered a highly user-friendly interface. However, some challenges were observed in distinguishing between quick filters and chart-specific filters.
Data Integration: Multiple datasets were successfully combined to enable comparative analysis and provide a consolidated view of all key metrics.
Visualization Insights:
- Maps and Treemaps: Used for city and region-wise analysis, offering geographical insights.
- Funnel Chart: Implemented to assess user engagement rates by event, providing a clear view of engagement stages.
- Line Charts: Used to track metric performance over time and identify trends.
- Data Cards: Displayed key numbers for quick reference and a snapshot of performance.
Engagement Analysis: Timing parameters were utilized to assess user engagement at different times of the day, identifying trends and peak activity periods.
Finally, the project emphasizes the creation of interactive reports and dashboards to highlight key performance metrics and drive data-driven decision-making.
Summary
This project successfully integrated SAVI website data into Looker Studio, creating dynamic dashboards that offer actionable insights. Metrics like sessions, user engagement, event counts, and geographic data were effectively visualized.
Team Members
- • Lead Data Analyst: Hasaranga Dilshan Jayathilake, Supraja Pericherla
- • Data Analyst: Bhushan Sitaram Shelke, Hari Shivani Gudi, Soumya Shanigarapu
- • UI/UX Researcher: Sridharan Murugesan
- • Project Manager: Vahini Matlakunta