The client had traffic and reservations but lacked visibility on their digital performance. Data was scattered across different tools, making it impossible to measure the ROI of their local SEO efforts or understand user behavior.
The Solution
I designed a centralized decision-making tool using Google Analytics 4 and Looker Studio.
Data Integration, merged streams from GA4 and Google Search Console.
Data Cleaning, filtered out internal traffic and irrelevant queries to ensure accuracy.
Custom Visualization, created a 3-page interactive report (Acquisition, Behavior, Conversion).
Key Insights & Results
he dashboard revealed critical business insights:
Mobile First, 64.3% of users visit via mobile, highlighting an urgent need for mobile UX optimization.
Local Authority, Strong local visibility with 27k+ impressions on keywords like “Restaurant Poligny”.
Seasonal Gap, Identified a discrepancy between peak traffic (Summer) and peak revenue (Winter/Spring), allowing for better ad spend allocation.
Tech Stack
Google Analytics 4 Looker Studio .Google Search Console. Data Visualization