"Home", "directory-item.php" -> "Listing detail" */ function metrics_page_label(string $file): string { $file = strtolower(trim($file)); static $map = [ 'index.php' => 'Home', 'directory.php' => 'Directory', 'directory-item.php' => 'Listing detail', 'become-member.php' => 'Become a member', 'learn-more.php' => 'Learn more', 'contact.php' => 'Contact', 'blog.php' => 'Blog', 'blog-post.php' => 'Blog post', 'login.php' => 'Login', 'logout.php' => 'Logout', 'forgot.php' => 'Forgot password', 'reset.php' => 'Reset password', 'signup-submit.php' => 'Sign up (submit)', 'claim-listing.php' => 'Claim listing', 'claim-submit.php' => 'Claim listing (submit)', 'newsletter-signup.php' => 'Newsletter signup', 'contact-submit.php' => 'Contact form submit', ]; if (isset($map[$file])) return $map[$file]; // Fallbacks: strip .php and prettify $s = preg_replace('/\.php$/', '', $file); $s = str_replace(['-', '_'], ' ', $s); $s = ucwords($s); return $s !== '' ? $s : $file; } $range = $_GET['range'] ?? '30d'; $range_map = [ '24h' => '1 DAY', '7d' => '7 DAY', '30d' => '30 DAY', '90d' => '90 DAY', ]; $interval = $range_map[$range] ?? $range_map['30d']; $label = ['24h'=>'Last 24 hours','7d'=>'Last 7 days','30d'=>'Last 30 days','90d'=>'Last 90 days'][$range] ?? ''; function range_link($r, $current) { $labels = ['24h'=>'24h','7d'=>'7 days','30d'=>'30 days','90d'=>'90 days']; $cls = $r === $current ? 'on' : ''; return ''.$labels[$r].''; } // ── Overall counters ── try { $total_views = (int)db_value("SELECT COUNT(*) FROM metrics_pageviews WHERE viewed_at >= DATE_SUB(NOW(), INTERVAL $interval)"); $unique_visits = (int)db_value("SELECT COUNT(DISTINCT ip_hash) FROM metrics_pageviews WHERE viewed_at >= DATE_SUB(NOW(), INTERVAL $interval)"); $total_searches= (int)db_value("SELECT COUNT(*) FROM metrics_searches WHERE searched_at >= DATE_SUB(NOW(), INTERVAL $interval)"); $countries_cnt = (int)db_value("SELECT COUNT(DISTINCT country) FROM metrics_pageviews WHERE country IS NOT NULL AND viewed_at >= DATE_SUB(NOW(), INTERVAL $interval)"); } catch (Throwable $e) { $total_views = $unique_visits = $total_searches = $countries_cnt = 0; } // ── Top pages ── try { $top_pages = db_all( "SELECT page, COUNT(*) AS views, COUNT(DISTINCT ip_hash) AS uniques FROM metrics_pageviews WHERE viewed_at >= DATE_SUB(NOW(), INTERVAL $interval) GROUP BY page ORDER BY views DESC LIMIT 15" ); } catch (Throwable $e) { $top_pages = []; } // ── Top listings ── try { $top_listings = db_all( "SELECT l.id, l.name, l.tier, COUNT(pv.id) AS views, COUNT(DISTINCT pv.ip_hash) AS uniques FROM metrics_pageviews pv JOIN listings l ON l.id = pv.listing_id WHERE pv.listing_id IS NOT NULL AND pv.viewed_at >= DATE_SUB(NOW(), INTERVAL $interval) GROUP BY l.id, l.name, l.tier ORDER BY views DESC LIMIT 15" ); } catch (Throwable $e) { $top_listings = []; } // ── Device breakdown ── try { $devices = db_all( "SELECT device_type, COUNT(*) AS c FROM metrics_pageviews WHERE viewed_at >= DATE_SUB(NOW(), INTERVAL $interval) GROUP BY device_type ORDER BY c DESC" ); } catch (Throwable $e) { $devices = []; } // ── Countries ── try { $countries = db_all( "SELECT country, COUNT(*) AS c FROM metrics_pageviews WHERE country IS NOT NULL AND viewed_at >= DATE_SUB(NOW(), INTERVAL $interval) GROUP BY country ORDER BY c DESC LIMIT 12" ); } catch (Throwable $e) { $countries = []; } // ── Top searches ── try { $top_searches = db_all( "SELECT query_text, COUNT(*) AS searches, AVG(result_count) AS avg_results FROM metrics_searches WHERE query_text IS NOT NULL AND query_text != '' AND searched_at >= DATE_SUB(NOW(), INTERVAL $interval) GROUP BY query_text ORDER BY searches DESC LIMIT 15" ); } catch (Throwable $e) { $top_searches = []; } // ── Top filtered categories ── try { $top_categories = db_all( "SELECT s.category_slug, c.name, COUNT(*) AS searches FROM metrics_searches s LEFT JOIN categories c ON c.slug = s.category_slug WHERE s.category_slug IS NOT NULL AND s.searched_at >= DATE_SUB(NOW(), INTERVAL $interval) GROUP BY s.category_slug, c.name ORDER BY searches DESC LIMIT 10" ); } catch (Throwable $e) { $top_categories = []; } // ── Daily timeline (last 14 days, always) ── try { $timeline = db_all( "SELECT DATE(viewed_at) AS day, COUNT(*) AS views FROM metrics_pageviews WHERE viewed_at >= DATE_SUB(CURDATE(), INTERVAL 13 DAY) GROUP BY DATE(viewed_at) ORDER BY day" ); } catch (Throwable $e) { $timeline = []; } $max_day = 0; foreach ($timeline as $d) { if ($d['views'] > $max_day) $max_day = (int)$d['views']; } // Fill missing days with 0 $timeline_filled = []; for ($i = 13; $i >= 0; $i--) { $day = date('Y-m-d', strtotime("-$i days")); $found = 0; foreach ($timeline as $d) if ($d['day'] === $day) { $found = (int)$d['views']; break; } $timeline_filled[] = ['day'=>$day, 'views'=>$found]; } ?>

Metrics

· anonymous, aggregated

Page views

total in period

Unique visitors

distinct sources

Searches

directory queries

Countries

visitor locations

Last 14 days

page views per day

No page view data yet. Traffic will appear here as visitors arrive.
·

Device breakdown

No data.
0 ? round($d['c'] / $total_dev * 100) : 0; ?>
% ()

Top countries

No geo data yet. Lookup happens on first visit from each IP.

Most viewed pages

No page views recorded yet.
PageViewsUniqueShare

Top performing listings

feeds the homepage Top 3 section

No listing views recorded yet.
ListingTierViewsUniqueShare

Top search terms

No searches recorded yet.
QuerySearchesAvg results
""

Category filters used

No category filters used yet.