Executive Dashboard

Live statistics and platform performance
🐘 PostgreSQL: telegram
🛡️ Super Admin
Total Registered Users 👥
0
Meals & Recipes 🍲
0
Meal Cooking Logs 🍳
0
Community Ratings ⭐
0

⚡ Platform Services Health

All Services Active
🤖

Telegram Bot Service

Polling Active (@MyMenuBuddy_bot)

Online
🌐

Customer Web Server

Express.js on Port 3000

Online
🗄️

SQLite Main Database

mymenubuddy.db (272 KB)

Connected
📁

Media & Photos Storage

Telegram/public/uploads + DO Spaces

Ready

👤 User Personas

Audience breakdown

🌐 Language Preferences

Primary languages

🥗 Dietary Preferences

Veg vs Non-Veg vs Others

👥 Recently Registered Users

User Role / Persona Language Diet Action

🍳 Recent Meal Cooking Events

⭐

Latest User Feedback (Loved It & Good)

Recent user ratings and reviews submitted through Telegram Bot
User Recipe / Dish Feedback Rating User Review / Notes Time
🔍
User Profile Telegram Account Persona / Role Region & Language Diet Preference Activity Action
🔍

📢 Send Instant Telegram Broadcast

Directly messages registered users via @MyMenuBuddy_bot

You can use <b>bold</b>, <i>italic</i>, emojis, and line breaks.

📱 Telegram Preview

🤖
MyMenuBuddy Bot bot
📢 MyMenuBuddy Announcement
Type a message on the left to see the live Telegram preview here...

💬 Telegram & Web Chat Conversations

Users chatting with MyMenuBuddy Bot. Click "View Chat" to see the full conversation.

User / Chef Telegram Account Total Messages Last Message Snippet Last Sender Last Active Action

🍽️ User Cooking History & Logs

Dishes cooked by users logged in PostgreSQL meal_history table

Log ID User / Chef Dish Cooked Photo / Media Portions Rating Notes Cooked At Action
🔍
ID User Details Recipe / Dish Feedback Rating User Review / Notes Submitted Date Actions

🤖 Telegram Bot Configuration

🗄️ Database & Environment

💾 SQLite Full Database Backup (Offline .db File)

📦 1,340 Records Backed Up

Complete snapshot of all PostgreSQL tables (users, meals, recipes, history, messages, feedback) exported directly to standalone SQLite .db files both inside the admin folder and in the root directory.

Inside Admin Pathadmin-website/mymenubuddy_backup.db
Outside Root Pathbot-website/mymenubuddy_backup.db
Storage EngineSQLite 3 (11 Tables Copied: users, meals, messages, feedback, etc.)
📥 Download SQLite .db Backup
📊

Daily Active Users & Bot Usage Analytics

Track how many users use MyMenuBuddy per day (ஒரு நாளைக்கு எத்தனை பயனர்கள் பயன்படுத்தியுள்ளனர்), traffic volume, and date-wise breakdown.

ACTIVE USERS ON DATE
13 👥 Active
Unique users interacting on this date
BOT MESSAGES
20 💬 Exchanges
Recipe queries & chat messages
MEALS COOKED
3 🍳 Kitchen Logs
Recipes prepared by users
USER SATISFACTION
100% ❤️ Positive
3 Feedbacks submitted
Showing: 📊 Bar Chart (Sep 30, 2026)
📅 Selected Date: Today (Sep 30, 2026)

👥 Users Active on Sep 30, 2026

Showing only users who interacted on this date (antha date-la use panna users mattum)
Active Date
User Profile Role / Persona Language & Diet Bot Messages Meals Cooked Feedback Last Active Action