query("SELECT COUNT(*) FROM banners")->fetchColumn(); $totalOwners = (int)$pdo->query("SELECT COUNT(*) FROM owners WHERE is_active = 1")->fetchColumn(); $totalTags = (int)$pdo->query("SELECT COUNT(*) FROM tags")->fetchColumn(); $today = date('Y-m-d'); $todayStatsStmt = $pdo->prepare("SELECT COALESCE(SUM(impressions), 0) AS impressions, COALESCE(SUM(clicks), 0) AS clicks, COALESCE(SUM(views), 0) AS views FROM banner_stats_daily WHERE stat_date = ?"); $todayStatsStmt->execute([$today]); $todayStats = $todayStatsStmt->fetch(); $todayImpressions = (int)($todayStats['impressions'] ?? 0); $todayClicks = (int)($todayStats['clicks'] ?? 0); $todayViews = (int)($todayStats['views'] ?? 0); $todayCtr = $todayImpressions > 0 ? round(($todayClicks / $todayImpressions) * 100, 2) : 0; $recentBannersStmt = $pdo->query("SELECT b.name, b.created_at, o.company_name FROM banners b LEFT JOIN owners o ON o.id = b.owner_id ORDER BY b.created_at DESC LIMIT 5"); $recentBanners = $recentBannersStmt->fetchAll(); $topDomainsStmt = $pdo->query("SELECT domain, COALESCE(SUM(impressions), 0) AS impressions, COALESCE(SUM(clicks), 0) AS clicks FROM banner_stats_domain GROUP BY domain ORDER BY impressions DESC, clicks DESC LIMIT 5"); $topDomains = $topDomainsStmt->fetchAll(); ?> <?php echo APP_NAME; ?>
Banner management platform

Smart rotation, owner management, analytics, and adblocker-aware delivery from one dashboard.

Superadmin Login Owner Login

Dashboard Overview

Live platform summary for banners, owners, traffic, and performance.

Open Superadmin Open Owner Area
Today Impressions
Today Views
Today Clicks
Today CTR %
Total Banners
All uploaded creative assets
Active Owners
Accounts currently enabled
Available Tags
Themes and categorization labels

Recent Uploads

No banners uploaded yet.

Top Domains

impressions
clicks
No domain analytics recorded yet.