Improve the "Statistics" panel to increase retention

Hi everyone,

To support Mannie in improving the UX and UI, I’ve worked today on proposing enhancements to the statistics panel of the dashboard. These improvements are aimed at increasing retention by showcasing and reminding our clients of all the benefits they gain from the service.

1. Core Business Indicators (Reputation)
   KPI → Why it's useful | Recommended Display

• Total number of reviews (cumulative & period) → Shows the traction created by the system. | Counter + weekly/monthly/quarterly/annual sparkline
• Review growth rate → Highlights acceleration vs previous period. | Percentage + green/orange/red arrow
• Weighted average rating (by channel + all channels) → Global reputation barometer. | Semi-circular gauge
• Star distribution (histogram) → Highlights the proportion of 1-3 vs 4-5 stars. | Stacked bar chart
• Internal Recommendation Score (Simulated NPS) → Simple metric for the board (Promoters – Detractors). | Thermometric card
• Weekly/monthly/quarterly rolling trend → Smooths peaks, shows underlying trends. | Line chart + confidence interval
• Evolution of the number of reviews and average rating of 10 competitors defined by the user → Monitor and maintain competitive advantage. | Table

Note:
Several empirical analyses confirm that these three variables directly influence the ranking of a Google Business Profile (GBP) in the Local Pack.

1. Effect of the number of reviews
   • Geolid Study 2024-25: Regression analysis on 280,000 profiles shows that reviews published in the last 30 days significantly explain ranking variance (high R²); the more recent reviews a profile gathers, the higher it ranks → https://www.journaldunet.com/seo/1540093-etude-les-avis-de-moins-de-30-jours-particulierement-importants-pour-le-classement-des-fiches-google-business-profile/

• Semrush Analysis: The most notable effectiveness threshold is observed beyond 100 reviews, especially when paired with a rating ≥ 4.5/5 → https://localranker.fr/combien-avis-google-augmenter-note/

2. Effect of the average rating
   • The same Geolid study establishes an almost linear correlation: the closer the average rating gets to 5, the higher the profile ranks; the curve "sticks" to the 1st position from 4.7/5 → https://www.journaldunet.com/seo/1540093-etude-les-avis-de-moins-de-30-jours-particulierement-importants-pour-le-classement-des-fiches-google-business-profile/

• Data compiled by Localranker/Semrush indicates that a rating ≥ 4.2/5 is the minimum threshold for Google to interpret the brand as "trustworthy" and prioritize its display → https://localranker.fr/combien-avis-google-augmenter-note/

3. Effect of responding to reviews
   • Geolid observes that profiles where owners consistently respond to reviews (positive or negative) rank higher, suggesting that the algorithm values quick user interaction → https://www.journaldunet.com/seo/1540093-etude-les-avis-de-moins-de-30-jours-particulierement-importants-pour-le-classement-des-fiches-google-business-profile/

2. Collection Funnel Indicators
   • Conversion Rate Request → Review (global & by channel: Email, SMS, QR code, direct link).

   • Formula: Published reviews ÷ Requests sent.

• QR Code Performance

• Scans, clicks, reviews generated, scan→review ratio.

• Ranking by servers/sellers/locations/services.

• Emailing/SMS Statistics

• Open rate, click rate, review rate.

• Heatmap “day-hour” to identify the best times to send invitations and follow-ups by channel.

3. Online Visibility Indicators
   KPI → Data Source | Client Benefit
   • Widget views (number of views) → JS Script | Shows the audience exposed to positive reviews.

4. Operational Efficiency Indicators
   Objective: Prove time saved and cost reduction.

• Reviews generated by AI (total & percentage of reviews)

• Response mode breakdown: manual / semi-auto / full-auto

• Average manual management time vs AI

  • Estimate: t_manual ≈ 4 min, t_approval ≈ 30 s.

  • Time saved = (#AI * 3.5 min).

• Financial savings

  • € saved = Time saved × Hourly cost (entered by client or agency).

• Average response time to reviews.

5. Quality & Insights Indicators

• Recurring themes: word cloud + top 5 pain points

• Evolution over the defined period vs previous period
  • Divergent bars.
  • Period selector.
  • Toggle “Raw frequency / Normalized frequency” (to avoid overall volume effects).
  • Threshold filter (≥ 5 reviews) to hide noise.
  • Carousel displaying review examples to highlight the issue.

6. Predictive & Advanced Indicators

Calculator and Goal: The user sets their target average rating, and the calculator shows how many additional 5-star reviews are needed today to reach the goal. Small daily encouragement or congratulatory messages depending on goal achievement.

Note:
Studies and empirical analyses show that a high average rating acts as a quality signal to consumers and positively influences several financial indicators.

• Research in sectors like hospitality and dining suggests that improving by one star on review platforms can translate to a 5-9% revenue increase → https://www.bdc.ca/fr/articles-outils/argent-finance/gerer-finances/4-ratios-financiers-evaluer-votre-entreprise

• Moreover, a good rating not only increases traffic (via better visibility in Google’s Local Pack) but also strengthens trust, leading to improved customer conversion rates and, consequently, higher profit margins → https://www.compta-facile.com/ratios-financiers-calculs-et-explications/

• Beyond revenue, a strong online reputation (measured by the average rating) can help reduce customer acquisition costs and optimize overall profitability, effects notably measured through financial ratios that integrate performance and profitability indicators → https://www.vie-publique.fr/fiches/270247-les-indicateurs-de-performance-de-lentreprise

The average rating of an establishment is a significant lever to influence demand, customer trust, and thus revenue and other key financial indicators.

7. Benefit-Oriented Approach (Time, Money, Growth)

A) Time

• Widget "Minutes saved this month" (real-time counter).

B) Money

• Convert these minutes into avoided salary costs.

• Project incremental revenue from rating improvement (TripAdvisor studies: +1 ⭐ = +9-15% basket increase).

C) Growth / Reassurance

• Number of prospects who viewed ≥1 review (widget + GMB).

• Equivalent Ads budget: impressions × average Google Ads CPC (earned media value).

Note:
A study on over 1,300 hotels demonstrated that a one-star increase in customer rating is associated with a 3.7 to 5.3% revenue increase.

8. F

   

   ormatting Recommendations

• Main Dashboard = 3 “Value” Tiles

• ⭐ Current average rating

• ⏱ Time saved this month

• 💶 Estimated value generated
  • Drill-down sections by funnel (Collection ➜ Response ➜ Visibility ➜ ROI).
  • Smart Alerts

• Spike in ≤3-star reviews, email conversion drop, widget offline, etc.
  • PDF + email + API exports for board reports.

9. Display a carousel showing the last 12 reviews and their responses.

10. UX/UI

• Users would have the ability to rearrange the sections in the order that suits them and to show/hide each section by default.

• These preferences will be retained on smartphones, where buttons will allow users to expand/collapse each section.

• A short name as the title for each section. On smartphones, this title would be placed inside a button. Colors to differentiate each section/button.