I want the Campaign Loader to reflect our real end-of-term journey and use bespoke WhatsApp scripts for each stage, instead of the current generic wording.

Please do the following in app/templates/dashboard.html:

1. In the <script> block at the bottom of the file, at the very top (before any existing function definitions), add this constant for our demo campaigns:

  const DEMO_CAMPAIGNS = [
    {
      campaign_id: "demo_eot_18",
      template_key: "eot_18",
      name: "18 Month Heads-Up",
      type: "renewals",
      status: "live",
      starts_on: "2025-11-01",
      ends_on: null,
      target_segment: "Customers around 18 months from the end of their agreement",
      notes: "Early check-in to understand usage, mileage and future plans. No pressure, purely relationship and planning."
    },
    {
      campaign_id: "demo_eot_12",
      template_key: "eot_12",
      name: "End of Term – 12 Month Review",
      type: "renewals",
      status: "live",
      starts_on: "2025-11-01",
      ends_on: null,
      target_segment: "Customers around 12 months from the end of their agreement",
      notes: "First formal end-of-term review. Introduce the idea of options and protecting equity/position."
    },
    {
      campaign_id: "demo_eot_9",
      template_key: "eot_9",
      name: "End of Term – 9 Month Options",
      type: "renewals",
      status: "live",
      starts_on: "2025-12-01",
      ends_on: null,
      target_segment: "Customers around 9 months from the end of their agreement",
      notes: "Move towards a more detailed options conversation and potential test drive."
    },
    {
      campaign_id: "demo_eot_6",
      template_key: "eot_6",
      name: "End of Term – 6 Month Priority",
      type: "renewals",
      status: "live",
      starts_on: "2026-01-01",
      ends_on: null,
      target_segment: "Customers around 6 months from the end of their agreement",
      notes: "Priority review window. Ideal time to order the next Audi and secure pricing/lead times."
    },
    {
      campaign_id: "demo_eot_3",
      template_key: "eot_3",
      name: "End of Term – 3 Month Last Window",
      type: "renewals",
      status: "live",
      starts_on: "2026-02-01",
      ends_on: null,
      target_segment: "Customers around 3 months from the end of their agreement",
      notes: "Final proactive window to change before handback, part-ex or refinance."
    },
    {
      campaign_id: "demo_welcome_12",
      template_key: "welcome_12",
      name: "12 Month Ownership Check-In",
      type: "welcome",
      status: "live",
      starts_on: "2025-11-01",
      ends_on: null,
      target_segment: "Customers around 12 months into ownership (first year anniversary)",
      notes: "Ownership and experience check-in. Confirm mileage vs plan and ensure servicing/finance are set correctly."
    }
  ];

2. Still near the top of the <script> block (just under DEMO_CAMPAIGNS), add a helper function to build the WhatsApp script for a campaign. Use these exact word tracks:

  function buildWhatsAppScript(campaign) {
    const centre = "Lincoln Audi";
    const customerName = "[Customer Name]";
    const advisorName = "[Your Name]";
    const stage = campaign.template_key || campaign.type || "";

    switch (stage) {
      case "eot_18":
        return `Hi ${customerName}, it’s ${advisorName} from ${centre}.\n\nI’ve been reviewing our customers who are around 18 months from the end of their agreement and yours is in that group. This isn’t about changing your car today – it’s a quick check-in to make sure your Audi still suits your mileage and day-to-day use, and to see how you’d like us to support you as you move towards the end of the plan.\n\nIf you’d like me to keep an eye on suitable offers and protect your position as the market moves, reply YES and I’ll do the rest.\n\nThanks,\n${advisorName}\n${centre}`;

      case "eot_12":
        return `Hi ${customerName}, it’s ${advisorName} from ${centre}.\n\nYou’re now around 12 months from the end of your current agreement, which is the first key review point. From this stage there can be options to change your Audi, protect any equity and keep your monthly payment sensible.\n\nIf you’d like me to prepare a short, no-obligation end-of-term review tailored to your mileage and how you use the car, reply YES and I’ll send you a summary of your best options.\n\nThanks,\n${advisorName}\n${centre}`;

      case "eot_9":
        return `Hi ${customerName}, it’s ${advisorName} from ${centre}.\n\nYou’re roughly 9 months from the end of your agreement, so it’s a great time to look at your options in a bit more detail. Depending on how your mileage and equity look, we may be able to move you into your next Audi with a similar or sensible change to your monthly payment.\n\nWould you like me to put together a quick options review for you and, if it helps, arrange a test drive in something suitable? If so, reply YES and I’ll come back with a plan.\n\nThanks,\n${advisorName}\n${centre}`;

      case "eot_6":
        return `Hi ${customerName}, it’s ${advisorName} from ${centre}.\n\nYou’re now around 6 months from the end of your agreement, which is the ideal time to make a decision about your next steps. Ordering your next Audi now can help secure the right car, pricing and delivery timings, while keeping your budget under control.\n\nIf you’d like me to prioritise an end-of-term review and talk you through the options – whether that’s changing, keeping or handing the car back – reply YES and I’ll get everything lined up for you.\n\nThanks,\n${advisorName}\n${centre}`;

      case "eot_3":
        return `Hi ${customerName}, it’s ${advisorName} from ${centre}.\n\nYou’re in the final few months of your agreement, so this is the last proactive window to look at your options before the contract ends. Depending on how the numbers look, there may be a chance to change your Audi, protect any equity or set up a smooth handover plan.\n\nIf you’d like a clear view of your options so you can decide what’s best, reply YES and I’ll send you a simple summary and next steps.\n\nThanks,\n${advisorName}\n${centre}`;

      case "welcome_12":
        return `Hi ${customerName}, it’s ${advisorName} from ${centre}.\n\nYou’ve had your Audi for around 12 months now, so I just wanted to check in and make sure everything is working as it should – from the car itself through to your mileage, servicing and finance plan.\n\nIf you’d like, I can put together a quick ownership review to confirm you’re on the right track and highlight anything that might need tweaking for the future.\n\nReply YES if you’d like me to do that and I’ll send you a short summary.\n\nThanks,\n${advisorName}\n${centre}`;

      default: {
        const segment = campaign.target_segment || "customers nearing the end of their agreement";
        return `Hi ${customerName}, it’s ${advisorName} from ${centre}.\n\nI’ve been reviewing our ${segment} and there may be options to update your Audi with a sensible change to your monthly budget.\n\nIf you’d like me to prepare a quick, no-obligation review of your options, just reply YES and I’ll send you a summary.\n\nThanks,\n${advisorName}\n${centre}`;
      }
    }
  }

3. In the loadCampaigns() function, we already fetch "/api/campaigns". After we parse the JSON, make sure we fall back to DEMO_CAMPAIGNS when the database returns no rows. Replace the existing lines that set the "campaigns" variable with:

      const payload = await res.json();
      let campaigns = payload.data || [];

      // If there are no campaigns in the database yet, fall back to our core end-of-term journey
      if (!campaigns.length) {
        campaigns = DEMO_CAMPAIGNS;
      }

4. In the openDetail() function inside loadCampaigns(), we currently build the WhatsApp script inline. Replace that logic so instead we call buildWhatsAppScript(c) to set the textarea.

   Specifically, find where we set "waEl.value = ..." and replace the entire template text with:

          waEl.value = buildWhatsAppScript(c);
          waEl.scrollTop = 0;

5. Leave the rest of the Campaign Loader logic unchanged (the cards, live vs upcoming split, the WhatsApp stub call, etc).

6. Run the app. In the Campaigns tab, with an empty /api/campaigns response, it should now show six campaigns:
   - 18 Month Heads-Up
   - End of Term – 12 Month Review
   - End of Term – 9 Month Options
   - End of Term – 6 Month Priority
   - End of Term – 3 Month Last Window
   - 12 Month Ownership Check-In

   When you click each one, the WhatsApp Script Preview should show the corresponding bespoke script from buildWhatsAppScript(), NOT the old generic 12-9-6 wording.