Skip to content

Latest commit

 

History

History
91 lines (59 loc) · 2.79 KB

File metadata and controls

91 lines (59 loc) · 2.79 KB

📊 Countly — User Analytics Dashboard

A minimalist analytics dashboard built with Google AppSheet and Google Sheets.
Visualize user signups, analyze growth trends, and explore your data in real time — without writing a single line of code.


🚀 Overview

Countly connects directly to Google Sheets to turn raw user data into a live analytics dashboard.
It features a database view for detailed information and an interactive chart that updates automatically as new data is added.

🧠 Designed for developers, teams, and students who want to explore no-code data visualization.


✨ Key Features

  • 📅 Track daily user signups
  • 📈 Visualize growth with interactive charts
  • 🔄 Real-time sync with Google Sheets
  • 🧮 Filter by custom date ranges
  • 🌙 Clean dark-mode UI
  • 🖥 Works seamlessly on both desktop and mobile

📸 Screenshots

🧾 User Database View

Displays the full list of users, including names, IDs, and signup timestamps.
User Database

📊 User Count Chart

Shows user signup activity and cumulative growth across time.
User Count Chart

🔍 Filtered Chart View

Allows narrowing down the results by date range.
Filtered Chart


🧾 Sample Data

Example dataset used in this project:
App sheet e-tablo - gorev1.csv (AI-generated demo data)

user_name user_id simulation_name signup_datetime
Ahmet 35675 Arabam.com: Son Sürat Büyüme 2023-12-10 14:21:53
Burak 84329 L'Oréal: Content Dilemma 2023-11-29 22:36:45
Cemre 46259 Arabam.com: Son Sürat Büyüme 2023-11-15 05:45:12

🌐 Live Demo

🔗 Open Countly App (Browser)
🔗 View Google Sheets (Read Only)

⚠️ Note: All shared links are view-only and contain no personal or sensitive data.


🛠️ Tech Stack

Tool Purpose
Google AppSheet App creation & interface
Google Sheets Data storage & synchronization
QUERY / FILTER formulas Data aggregation logic
GitHub Documentation & open sharing

👩‍💻 Author

Developed by: Gözde Şavkın

Built as a no-code data visualization project combining design, analytics, and creativity.


🪪 License

This project is licensed under the MIT License — feel free to use, modify, and share with attribution.