{"id":25,"date":"2024-11-01T03:41:08","date_gmt":"2024-11-01T03:41:08","guid":{"rendered":"https:\/\/smtprelay.monster\/blog\/?p=25"},"modified":"2026-04-09T12:55:25","modified_gmt":"2026-04-09T12:55:25","slug":"a-complete-guide-to-setting-up-mail-tracking-in-coldemailingjet","status":"publish","type":"post","link":"https:\/\/smtprelay.monster\/blog\/a-complete-guide-to-setting-up-mail-tracking-in-coldemailingjet\/","title":{"rendered":"A Complete Guide to Setting Up Mail Tracking in ColdEmailingJet"},"content":{"rendered":"\n

<\/h1>\n\n\n\n

Mail tracking is a vital component of cold emailing, providing valuable insights into recipient engagement. ColdEmailingJet gives you the tools to embed tracking information into your emails, but you are responsible for setting up your own tracking infrastructure. This guide walks you through the entire process.<\/p>\n\n\n\n

\n\n\n\n

How Mail Tracking Works<\/h2>\n\n\n\n

ColdEmailingJet does not<\/strong> host tracking infrastructure. Instead, it embeds tracking data (like recipient email addresses) into your email links. You set up your own tracking server (Cloudflare Worker + D1 database) to capture and log recipient interactions.<\/p>\n\n\n\n

The Complete Flow<\/h3>\n\n\n\n
1. You set up Cloudflare Worker + D1 Database\n2. ColdEmailingJet inserts {email.email} tag into your tracking links\n3. Email sent \u2192 Recipient clicks link \u2192 Request hits YOUR Worker\n4. Worker logs data (email, IP, country, user agent) to D1 database\n5. Worker serves age verification page (bot detection)\n6. Human passes verification \u2192 Redirected to final offer page<\/code><\/pre>\n\n\n\n
\n\n\n\n
Part 1: Setting Up Cloudflare Worker & D1 Database<\/h2>\n\n\n\n
Step 1: Create a D1 Database<\/h3>\n\n\n\n
    \n
  1. Log into your Cloudflare Dashboard<\/strong><\/li>\n\n\n\n
  2. Navigate to Workers & Pages<\/strong> \u2192 D1<\/strong><\/li>\n\n\n\n
  3. Click Create Database<\/strong><\/li>\n\n\n\n
  4. Name it (e.g., tracking_db<\/code>)<\/li>\n\n\n\n
  5. Click Create<\/strong><\/li>\n<\/ol>\n\n\n\n
    Step 2: Create the Database Table<\/h3>\n\n\n\n
    Run this SQL in your D1 console:<\/p>\n\n\n\n
    CREATE TABLE email_events (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    email TEXT,\n    ip TEXT,\n    country TEXT,\n    user_agent TEXT,\n    language TEXT,\n    created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n);<\/code><\/pre>\n\n\n\n
    Step 3: Create a Cloudflare Worker<\/h3>\n\n\n\n
      \n
    1. Go to Workers & Pages<\/strong> \u2192 Create Application<\/strong> \u2192 Create Worker<\/strong><\/li>\n\n\n\n
    2. Name your worker (e.g., tracking-worker<\/code>)<\/li>\n\n\n\n
    3. Click Deploy<\/strong> then Edit Code<\/strong><\/li>\n<\/ol>\n\n\n\n
      Step 4: Worker Code<\/h3>\n\n\n\n
      Here’s a complete worker that:<\/p>\n\n\n\n
        \n
      • Captures email from URL parameters<\/li>\n\n\n\n
      • Logs IP, country, user agent, and language<\/li>\n\n\n\n
      • Serves an age verification page<\/li>\n\n\n\n
      • Detects bots before redirecting<\/li>\n<\/ul>\n\n\n\n
        export default {\n  async fetch(request, env, ctx) {\n    try {\n      const url = new URL(request.url);\n      const pathname = url.pathname;\n\n      if (request.method !== \"GET\") {\n        return new Response(\"Method not allowed\", { status: 405 });\n      }\n\n      \/\/ Extract email from URL parameters\n      const email = url.searchParams.get(\"email\") || \n                    url.searchParams.get(\"addr\") || \n                    url.searchParams.get(\"mail\") || \n                    \"no_email\";\n\n      \/\/ Tracking endpoint - logs data and redirects\n      if (pathname === \"\/track\") {\n        if (isValidEmail(email)) {\n          const ip = request.headers.get(\"CF-Connecting-IP\") ||\n                     request.headers.get(\"x-forwarded-for\") || \"unknown\";\n          const userAgent = request.headers.get(\"user-agent\") || \"unknown\";\n          const country = request.headers.get(\"CF-IPCountry\") || \"unknown\";\n          const language = request.headers.get(\"Accept-Language\")?.split(',')[0] || \"unknown\";\n\n          \/\/ Save to D1 database (async, don't block redirect)\n          ctx.waitUntil(\n            env.DB.prepare(\n              `INSERT INTO email_events (email, ip, country, user_agent, language)\n               VALUES (?, ?, ?, ?, ?)`\n            ).bind(email, ip, country, userAgent, language).run()\n          );\n        }\n\n        \/\/ Redirect to final destination\n        return Response.redirect(\"https:\/\/your-final-offer-page.com\", 302);\n      }\n\n      \/\/ Age verification landing page\n      const object = await env.R2html.get(\"landing_page.html\");\n      if (!object) {\n        return new Response(\"Page not found\", { status: 404 });\n      }\n\n      let html = await object.text();\n      html = html.replace(\/{{EMAIL}}\/g, escapeHtml(email));\n\n      return new Response(html, {\n        headers: { \"Content-Type\": \"text\/html; charset=utf-8\" }\n      });\n\n    } catch (err) {\n      return new Response(\"Error: \" + err.message, { status: 500 });\n    }\n  }\n};\n\nfunction isValidEmail(email) {\n  return \/^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$\/.test(email);\n}\n\nfunction escapeHtml(str) {\n  return str.replace(\/[&<>]\/g, function(m) {\n    if (m === '&') return '&amp;';\n    if (m === '<') return '&lt;';\n    if (m === '>') return '&gt;';\n    return m;\n  });\n}<\/code><\/pre>\n\n\n\n
        Step 5: Bind D1 Database to Worker<\/h3>\n\n\n\n
          \n
        1. Go to your Worker \u2192 Settings<\/strong> \u2192 Variables<\/strong><\/li>\n\n\n\n
        2. Under D1 Database Bindings<\/strong>, click Add binding<\/strong><\/li>\n\n\n\n
        3. Variable name: DB<\/code><\/li>\n\n\n\n
        4. Select your D1 database<\/li>\n\n\n\n
        5. Click Save<\/strong><\/li>\n<\/ol>\n\n\n\n
          Step 6: Upload HTML Landing Page to R2<\/h3>\n\n\n\n
            \n
          1. Create an R2 bucket (e.g., tracking-assets<\/code>)<\/li>\n\n\n\n
          2. Upload your landing_page.html<\/code> file<\/li>\n\n\n\n
          3. Bind R2 to your Worker as R2html<\/code><\/li>\n<\/ol>\n\n\n\n
            \n\n\n\n
            Part 2: Bot Detection on Landing Page<\/h2>\n\n\n\n
            Your HTML landing page should verify the user is human before redirecting. Here’s the key logic:<\/p>\n\n\n\n
            Bot Detection Techniques<\/h3>\n\n\n\n
            Technique<\/th>How It Works<\/th><\/tr><\/thead>
            Mouse Movement Detection<\/strong><\/td>Button only enables after mouse\/touch interaction<\/td><\/tr>
            Countdown Timer<\/strong><\/td>Forces a 3-5 second wait (bots rarely wait)<\/td><\/tr>
            Hidden Trap Link<\/strong><\/td>Bot that crawls all links gets caught<\/td><\/tr>
            Shadow DOM<\/strong><\/td>Hides verification logic from simple scrapers<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
            Sample Landing Page Structure<\/h3>\n\n\n\n
            <!DOCTYPE html>\n<html>\n<head>\n    <title>Age Verification<\/title>\n<\/head>\n<body>\n    <img id=\"previewImage\">\n    <h1>You must be 18+ to enter<\/h1>\n    <div id=\"buttonContainer\"><\/div>\n    <a href=\"\/trap\" style=\"display:none\">Hidden trap for bots<\/a>\n\n    <script>\n        const email = \"{{EMAIL}}\";\n        let humanDetected = false;\n        let countdownFinished = false;\n\n        \/\/ Detect human interaction\n        window.addEventListener(\"mousemove\", () => markHuman(), { once: true });\n        window.addEventListener(\"touchstart\", () => markHuman(), { once: true });\n        window.addEventListener(\"keydown\", () => markHuman(), { once: true });\n\n        function markHuman() {\n            humanDetected = true;\n            enableButtonIfReady();\n        }\n\n        \/\/ Countdown timer\n        let countdown = 3;\n        const interval = setInterval(() => {\n            countdown--;\n            if (countdown <= 0) {\n                clearInterval(interval);\n                countdownFinished = true;\n                enableButtonIfReady();\n            }\n            button.textContent = `Wait ${countdown}s`;\n        }, 1000);\n\n        function enableButtonIfReady() {\n            if (humanDetected && countdownFinished) {\n                button.disabled = false;\n                button.textContent = \"ENTER\";\n                button.onclick = () => {\n                    window.location.href = `\/track?email=${encodeURIComponent(email)}`;\n                };\n            }\n        }\n    <\/script>\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n
            \n\n\n\n
            Part 3: Configuring Tracking Links in ColdEmailingJet<\/h2>\n\n\n\n
            Step 1: Create Your Tracking Link Template<\/h3>\n\n\n\n
            In your email content, insert tracking links using the {email.email}<\/code> tag:<\/p>\n\n\n\n
            https://your-worker.yourdomain.com\/track?email={email.email}<\/code><\/pre>\n\n\n\n
            Step 2: Using Different URL Parameters<\/h3>\n\n\n\n
            ColdEmailingJet supports multiple parameter names:<\/p>\n\n\n\n
            Parameter<\/th>Usage<\/th><\/tr><\/thead>
            ?email=<\/code><\/td>Standard email parameter<\/td><\/tr>
            ?addr=<\/code><\/td>Alternative parameter name<\/td><\/tr>
            ?mail=<\/code><\/td>Another alternative<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
            Example:<\/p>\n\n\n\n
            https://your-worker.com\/track?addr={email.email}<\/code><\/pre>\n\n\n\n
            Step 3: Adding Custom Fields<\/h3>\n\n\n\n
            You can also include custom fields from your contact list:<\/p>\n\n\n\n
            https://your-worker.com\/track?email={email.email}&name={email.FirstName}&campaign=camp_123<\/code><\/pre>\n\n\n\n
            Step 4: Where to Put the Tracking Link<\/h3>\n\n\n\n
            Place the tracking link in your email content:<\/p>\n\n\n\n
            HTML Email Example:<\/strong><\/p>\n\n\n\n
            <a href=\"https:\/\/your-worker.com\/track?email={email.email}\">\n    Click Here to Claim Your Offer\n<\/a><\/code><\/pre>\n\n\n\n
            Text Email Example:<\/strong><\/p>\n\n\n\n
            Claim your offer: https:\/\/your-worker.com\/track?email={email.email}<\/code><\/pre>\n\n\n\n
            \n\n\n\n
            Part 4: Testing Your Setup<\/h2>\n\n\n\n
            Test the Complete Flow<\/h3>\n\n\n\n
              \n
            1. Send a test email<\/strong> to yourself<\/li>\n\n\n\n
            2. Click the tracking link<\/strong> in the email<\/li>\n\n\n\n
            3. Verify the database record<\/strong> appears in your D1 database:<\/li>\n<\/ol>\n\n\n\n
              SELECT * FROM email_events ORDER BY created_at DESC LIMIT 10;<\/code><\/pre>\n\n\n\n
              Expected Results<\/h3>\n\n\n\n
              Step<\/th>Expected Behavior<\/th><\/tr><\/thead>
              Link click<\/td>Worker logs IP, email, country to D1<\/td><\/tr>
              Landing page<\/td>Shows age verification with countdown<\/td><\/tr>
              Human verification<\/td>Button enables after mouse move + timer<\/td><\/tr>
              Final click<\/td>Redirects to your offer page<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
              \n\n\n\n
              Summary Checklist<\/h2>\n\n\n\n
              Task<\/th>Done<\/th><\/tr><\/thead>
              Create Cloudflare D1 database<\/td>\u2610<\/td><\/tr>
              Create database table<\/td>\u2610<\/td><\/tr>
              Create Cloudflare Worker<\/td>\u2610<\/td><\/tr>
              Deploy worker code<\/td>\u2610<\/td><\/tr>
              Bind D1 to worker<\/td>\u2610<\/td><\/tr>
              Upload landing page to R2<\/td>\u2610<\/td><\/tr>
              Bind R2 to worker<\/td>\u2610<\/td><\/tr>
              Add bot detection to landing page<\/td>\u2610<\/td><\/tr>
              Insert {email.email}<\/code> tag in ColdEmailingJet links<\/td>\u2610<\/td><\/tr>
              Test with real email<\/td>\u2610<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
              \n\n\n\n
              Key Takeaways<\/h2>\n\n\n\n