0, 'push_subscribers' => 0, 'repeat_customers' => 0]; $analytics = ['delivered' => 0, 'opened' => 0, 'ctr' => 0, 'sales' => 0, 'revenue' => 0, 'campaigns' => 0]; $recommend = ['day' => 'Friday', 'time' => '7:45 PM', 'expected_opens' => 0, 'expected_clicks' => 0, 'expected_purchases' => 0]; $limits = ['daily' => 1, 'used' => 0, 'remaining' => 1]; $campaigns = []; $automations = []; $templates = sg_commerce_push_templates(); $audiences = sg_commerce_push_audiences(); $push_ok = sg_web_push_is_configured(); if ($conn) { sg_commerce_push_bootstrap($conn); sg_commerce_push_ensure_automations($conn, (int)$seller_id); $audience = sg_commerce_push_audience_stats($conn, (int)$seller_id); $analytics = sg_commerce_push_analytics_summary($conn, (int)$seller_id); $recommend = sg_commerce_push_recommend_send_time($conn, (int)$seller_id); $plan = (string)($seller_plan ?? $_SESSION['seller_plan'] ?? 'trial'); if (isset($seller) && is_array($seller) && !empty($seller['plan'])) { $plan = (string)$seller['plan']; } else { $pr = @$conn->query('SELECT plan FROM sellers WHERE id = ' . (int)$seller_id . ' LIMIT 1'); if ($pr && ($prow = $pr->fetch_assoc())) { $plan = (string)$prow['plan']; } } $limits['daily'] = sg_commerce_push_daily_limit($plan); $limits['used'] = sg_commerce_push_campaigns_sent_today($conn, (int)$seller_id); $limits['remaining'] = max(0, $limits['daily'] - $limits['used']); $sid = (int)$seller_id; $cr = @$conn->query( "SELECT id, title, message, audience, status, sent_at, delivered_count, opened_count, clicked_count, sales_count, revenue_ghs, source, created_at FROM store_push_campaigns WHERE seller_id = $sid ORDER BY id DESC LIMIT 30" ); if ($cr) { while ($row = $cr->fetch_assoc()) { $campaigns[] = $row; } } $ar = @$conn->query( "SELECT id, automation_type, enabled, title_tpl, message_tpl, delay_minutes, audience, last_run_at FROM store_push_automations WHERE seller_id = $sid ORDER BY id ASC" ); if ($ar) { while ($row = $ar->fetch_assoc()) { $automations[] = $row; } } $conn->close(); } $store_public = ''; if (function_exists('sg_seller_resolve_store_urls')) { $urls = sg_seller_resolve_store_urls((string)$seller_slug, null, (int)$seller_id); $store_public = (string)($urls['public'] ?? ''); } require_once __DIR__ . '/header.php'; ?>

Marketing Notifications

Followers

Push Subscribers

Repeat Customers

Campaign Performance

Delivered

Opened

%CTR

Sales

GH₵Revenue

AI Send Time

Recommended send time based on opens, clicks, and purchase patterns.

Expected opens

Expected clicks

Expected purchases

Create Campaign

of campaigns left today

Template Title Message Image URL (optional) Destination URL Audience Schedule (optional)

Weekend Sale

Jordan 4 now 25% OFF. Today only.

Shop Now

AI Marketing Automation

Your AI employee sends these automatically when customers need a nudge.

'Cart Abandonment', 'wishlist' => 'Wishlist Reminder', 'price_drop' => 'Price Drop', 'back_in_stock' => 'Back in Stock', 'new_arrival' => 'New Arrival', 'flash_sale' => 'Flash Sale', 'order_update' => 'Order Updates', ]; foreach ($automations as $auto): $type = (string)$auto['automation_type']; $label = $autoLabels[$type] ?? ucwords(str_replace('_', ' ', $type)); ?>

—

>

Recent Campaigns

No campaigns yet. Create your first notification above.

· · · AI

sent opens clicks