郵件已讀追蹤 (Email Tracking) 利用 HTML 郵件支援載入外部圖片的特性,在郵件內嵌一張 1x1 像素的透明圖片 (Web Beacon / Tracking Pixel),圖片 src 指向伺服器端腳本並帶入唯一追蹤 ID。當收件人開啟郵件、郵件客戶端載入圖片時,伺服器記錄請求資訊 (IP、時間、User-Agent),即可判定郵件已被閱讀。
<?php
// track.php - 郵件追蹤端點
// 使用方式:郵件 HTML 中嵌入 <img src="https://yourdomain.com/track.php?id=UNIQUE_TRACK_ID" width="1" height="1" alt="">
// 1. 取得追蹤 ID (必要參數)
$track_id = $_GET['id'] ?? '';
if (empty($track_id)) {
// 無 ID 仍回傳圖片避免破圖,但不記錄
outputPixel();
exit;
}
// 2. 取得客戶端資訊
$ip = getClientIP();
$ua = $_SERVER['HTTP_USER_AGENT'] ?? 'Unknown';
$time = time();
$date = date('Y-m-d H:i:s', $time);
$referer = $_SERVER['HTTP_REFERER'] ?? 'Direct';
// 3. 記錄日誌 (生產環境建議寫入資料庫)
$log_entry = sprintf(
"[%s] TrackID: %s | IP: %s | UA: %s | Referer: %s\n",
$date, $track_id, $ip, $ua, $referer
);
file_put_contents(__DIR__ . '/email_track.log', $log_entry, FILE_APPEND | LOCK_EX);
// 4. (進階) 寫入資料庫
// $pdo->prepare("INSERT INTO email_tracks (track_id, ip, user_agent, referer, created_at) VALUES (?, ?, ?, ?, NOW())")
// ->execute([$track_id, $ip, $ua, $referer]);
// 5. 輸出 1x1 透明 GIF
outputPixel();
/** 取得真實客戶端 IP */
function getClientIP() {
$headers = [
'HTTP_CLIENT_IP',
'HTTP_X_FORWARDED_FOR',
'HTTP_X_FORWARDED',
'HTTP_X_CLUSTER_CLIENT_IP',
'HTTP_FORWARDED_FOR',
'HTTP_FORWARDED',
'REMOTE_ADDR'
];
foreach ($headers as $header) {
if (!empty($_SERVER[$header])) {
$ips = explode(',', $_SERVER[$header]);
foreach ($ips as $ip) {
$ip = trim($ip);
if (filter_var($ip, FILTER_VALIDATE_IP, FILTER_FLAG_NO_PRIV_RANGE | FILTER_FLAG_NO_RES_RANGE)) {
return $ip;
}
}
}
}
return $_SERVER['REMOTE_ADDR'] ?? '0.0.0.0';
}
/** 輸出 1x1 透明 GIF (比 JPEG 更小) */
function outputPixel() {
// 1x1 透明 GIF 二進位內容 (43 bytes)
$gif = base64_decode('R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7');
header('Content-Type: image/gif');
header('Content-Length: ' . strlen($gif));
header('Cache-Control: no-store, no-cache, must-revalidate, max-age=0');
header('Pragma: no-cache');
header('Expires: Wed, 11 Jan 1984 05:00:00 GMT'); // 過去時間
echo $gif;
}
<?php
// send_mail.php
require 'PHPMailer/PHPMailer.php';
require 'PHPMailer/SMTP.php';
require 'PHPMailer/Exception.php';
use PHPMailer\PHPMailer\PHPMailer;
function sendTrackedEmail($to_email, $to_name, $subject, $html_content) {
// 生成唯一追蹤 ID (可關聯資料庫記錄)
$track_id = bin2hex(random_bytes(16)); // 32 字元十六進位
// 記錄發送紀錄到資料庫
// $pdo->prepare("INSERT INTO email_campaigns (track_id, recipient, subject, sent_at) VALUES (?, ?, ?, NOW())")
// ->execute([$track_id, $to_email, $subject]);
$mail = new PHPMailer(true);
try {
$mail->isSMTP();
$mail->Host = 'smtp.example.com';
$mail->SMTPAuth = true;
$mail->Username = 'sender@example.com';
$mail->Password = 'your_password';
$mail->SMTPSecure = 'tls';
$mail->Port = 587;
$mail->setFrom('sender@example.com', '系統通知');
$mail->addAddress($to_email, $to_name);
$mail->Subject = $subject;
// 關鍵:在 HTML 內容中插入追蹤圖片
$tracking_pixel = sprintf(
'<img src="https://yourdomain.com/track.php?id=%s" width="1" height="1" alt="" style="display:block;border:none;">',
$track_id
);
$mail->Body = $html_content . $tracking_pixel;
$mail->isHTML(true);
$mail->send();
return ['success' => true, 'track_id' => $track_id];
} catch (Exception $e) {
return ['success' => false, 'error' => $e->getMessage()];
}
}
// 使用範例
$result = sendTrackedEmail(
'user@example.com',
'張三',
'您的帳單已生成',
'<h2>親愛的用戶</h2><p>您的 2024 年 1 月帳單已生成,請查收附件。</p>'
);
CREATE TABLE email_campaigns (
id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
track_id CHAR(32) NOT NULL UNIQUE,
campaign_name VARCHAR(100),
recipient_email VARCHAR(255) NOT NULL,
recipient_name VARCHAR(100),
subject VARCHAR(500),
sent_at DATETIME DEFAULT CURRENT_TIMESTAMP,
first_opened_at DATETIME NULL,
open_count INT UNSIGNED DEFAULT 0,
last_opened_at DATETIME NULL,
ip_address VARBINARY(16), -- IPv6 相容
user_agent TEXT,
INDEX idx_track_id (track_id),
INDEX idx_recipient (recipient_email),
INDEX idx_sent_at (sent_at)
);
<?php
// stats.php - 簡易統計
$pdo = new PDO('mysql:host=localhost;dbname=tracking', 'user', 'pass');
// 總發送數
$total_sent = $pdo->query("SELECT COUNT(*) FROM email_campaigns")->fetchColumn();
// 開啟率
$opened = $pdo->query("SELECT COUNT(*) FROM email_campaigns WHERE first_opened_at IS NOT NULL")->fetchColumn();
$open_rate = $total_sent ? round($opened / $total_sent * 100, 2) : 0;
// 最近 7 天趨勢
$trend = $pdo->query("
SELECT DATE(first_opened_at) as day, COUNT(*) as opens
FROM email_campaigns
WHERE first_opened_at >= DATE_SUB(NOW(), INTERVAL 7 DAY)
GROUP BY day ORDER BY day
")->fetchAll();
echo "發送總數: $total_sent | 開啟數: $opened | 開啟率: $open_rate%";
print_r($trend);
| 限制 | 影響 | 緩解方案 |
|---|---|---|
| 郵件客戶端預設封鎖圖片 | Gmail/Outlook/Apple Mail 預設不載入圖片 | 引導用戶「顯示圖片」、提供純文字版本備選 |
| 代理伺服器預載圖片 | Google Image Proxy 等會預先下載,造成誤判 | 檢查 User-Agent 識別代理、結合點擊追蹤綜合判斷 |
| 防追蹤擴充套件 | 用戶安裝 Ublock/Privacy Badger 封鎖 | 接受無法 100% 追蹤,專注趨勢分析而非個體 |
| 快取機制 | 同一圖片 URL 可能被快取不重複請求 | URL 加入唯一 track_id、設定 no-cache Header |
1px 圖片信標是郵件追蹤的經典技術,實作簡單但面臨諸多客戶端限制與隱私法規挑戰。現代方案建議:追蹤像素 + 連結點擊追蹤 + 發送狀態回調 (Webhook) 多維度綜合判斷,並嚴格遵循隱私合規要求,將追蹤數據用於整體營運優化而非個體監控。