var CONFIG = {
  EMAIL_TO:       'e.ghasimi@gmail.com',
  LOOKBACK_DAYS:  30,
  BRAND_NAME:     'webinew.com',
  SCRIPT_NAME:    'webinew.com - Monthly Hourly & Budget Pacing Report',
};

var FONT_STACK = "'Estedad','Vazirmatn',Tahoma,Arial,sans-serif";
var FONT_LINK  = '<link rel="preconnect" href="https://fonts.googleapis.com">'+
                 '<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>'+
                 '<link href="https://fonts.googleapis.com/css2?family=Estedad:wght@400;500;600;700&display=swap" rel="stylesheet">';

function main() {
  var tz        = AdsApp.currentAccount().getTimeZone();
  var today     = new Date();
  var yesterday = new Date(today);
  yesterday.setDate(today.getDate() - 1);
  var startDate = new Date(today);
  startDate.setDate(today.getDate() - CONFIG.LOOKBACK_DAYS);

  var fmt = function(d) { return Utilities.formatDate(d, tz, 'yyyy-MM-dd'); };
  var sdate = fmt(startDate);
  var edate = fmt(yesterday);

  // ── 1) Hourly + Daily performance — for budget exhaust per day ─────
  var hourlyQuery =
    'SELECT segments.date, segments.hour, campaign.name, campaign_budget.amount_micros, '+
    '  metrics.clicks, metrics.impressions, metrics.cost_micros, metrics.conversions '+
    'FROM campaign '+
    'WHERE segments.date BETWEEN \''+sdate+'\' AND \''+edate+'\' '+
    '  AND campaign.status = \'ENABLED\'';

  Logger.log('Query: ' + hourlyQuery);
  var hourly = AdsApp.search(hourlyQuery);

  var hours = {};
  for (var h = 0; h < 24; h++) hours[h] = {clicks:0, cost:0, conv:0, impr:0};

  // ساختار per-day per-campaign per-hour برای محاسبه exhaust
  // campaigns[name] = {budget, totalCost, totalConv, totalClicks, days: {date: {hourCosts: {h: cost}}}}
  var campaigns = {};
  var totalDays = {};

  while (hourly.hasNext()) {
    var row    = hourly.next();
    var date   = row.segments.date;
    var hr     = parseInt(row.segments.hour) || 0;
    var name   = row.campaign.name;
    var budget = (parseFloat(row.campaignBudget.amountMicros) || 0) / 1000000;
    var clicks = parseInt(row.metrics.clicks) || 0;
    var impr   = parseInt(row.metrics.impressions) || 0;
    var cost   = (parseFloat(row.metrics.costMicros) || 0) / 1000000;
    var convs  = parseFloat(row.metrics.conversions) || 0;

    hours[hr].clicks += clicks; hours[hr].cost += cost; hours[hr].conv += convs; hours[hr].impr += impr;
    totalDays[date] = true;

    if (!campaigns[name]) {
      campaigns[name] = {budget:budget, totalCost:0, totalConv:0, totalClicks:0, days:{}};
    }
    // به‌روزرسانی budget با آخرین مقدار دیده‌شده
    if (budget > 0) campaigns[name].budget = budget;
    campaigns[name].totalCost   += cost;
    campaigns[name].totalConv   += convs;
    campaigns[name].totalClicks += clicks;

    if (!campaigns[name].days[date]) campaigns[name].days[date] = {};
    campaigns[name].days[date][hr] = (campaigns[name].days[date][hr] || 0) + cost;
  }

  var dayCount = Object.keys(totalDays).length || 1;
  Logger.log('Days analyzed: ' + dayCount);

  // ── محاسبه exhaust hour میانگین برای هر کمپین ─────────────
  var campList = [];
  for (var cn in campaigns) {
    var d = campaigns[cn];
    var exhTimes = [];
    var daysExhausted = 0;
    var daysAnalyzed  = 0;

    for (var dt in d.days) {
      daysAnalyzed++;
      var dayCum = 0, dayExh = null;
      var dayHours = d.days[dt];
      for (var ch = 0; ch < 24; ch++) {
        var prev = dayCum;
        dayCum += (dayHours[ch] || 0);
        if (d.budget > 0 && dayCum >= d.budget && dayExh === null) {
          var need = d.budget - prev;
          var min = dayHours[ch] > 0 ? Math.round((need / dayHours[ch]) * 60) : 0;
          dayExh = ch + (min / 60);
        }
      }
      if (dayExh !== null) {
        exhTimes.push(dayExh);
        daysExhausted++;
      }
    }

    var avgExh = null;
    if (exhTimes.length > 0) {
      var sum = 0;
      for (var et = 0; et < exhTimes.length; et++) sum += exhTimes[et];
      avgExh = sum / exhTimes.length;
    }

    var avgDailySpend = daysAnalyzed > 0 ? d.totalCost / daysAnalyzed : 0;
    var avgUtil = d.budget > 0 ? (avgDailySpend / d.budget * 100) : 0;

    campList.push({
      name: cn,
      budget: d.budget,
      totalCost: d.totalCost,
      avgDailySpend: avgDailySpend,
      totalConv: d.totalConv,
      avgExhaust: avgExh,
      daysExhausted: daysExhausted,
      daysAnalyzed: daysAnalyzed,
      avgUtil: avgUtil
    });
  }
  campList.sort(function(a,b){ return b.totalCost - a.totalCost; });

  // ── 2) Day of week pattern (همان ۳۰ روز) ───────────────────
  var dowQuery =
    'SELECT segments.day_of_week, metrics.clicks, metrics.cost_micros, metrics.conversions '+
    'FROM campaign '+
    'WHERE segments.date BETWEEN \''+sdate+'\' AND \''+edate+'\' '+
    '  AND campaign.status = \'ENABLED\'';

  var dowRes = AdsApp.search(dowQuery);
  var dows = {};
  var dowOrder = ['SATURDAY','SUNDAY','MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY'];
  var dowFa    = {SATURDAY:'شنبه', SUNDAY:'یک‌شنبه', MONDAY:'دوشنبه', TUESDAY:'سه‌شنبه',
                  WEDNESDAY:'چهارشنبه', THURSDAY:'پنج‌شنبه', FRIDAY:'جمعه'};

  for (var dk = 0; dk < dowOrder.length; dk++) dows[dowOrder[dk]] = {clicks:0, cost:0, conv:0};

  while (dowRes.hasNext()) {
    var dr = dowRes.next();
    var dow = dr.segments.dayOfWeek;
    if (!dows[dow]) dows[dow] = {clicks:0, cost:0, conv:0};
    dows[dow].clicks += parseInt(dr.metrics.clicks) || 0;
    dows[dow].cost   += (parseFloat(dr.metrics.costMicros) || 0) / 1000000;
    dows[dow].conv   += parseFloat(dr.metrics.conversions) || 0;
  }

  // ── 3) آمار کلی و پیشنهادات bid adjustment ────────────────
  var tClicks=0, tConv=0, tCost=0;
  for (var hk = 0; hk < 24; hk++) { tClicks+=hours[hk].clicks; tConv+=hours[hk].conv; tCost+=hours[hk].cost; }
  var avgConvRate = tClicks > 0 ? tConv / tClicks : 0;
  var avgCpa      = tConv   > 0 ? tCost / tConv   : 0;

  var hourSugs = [];
  var maxHourCost = 0;
  for (var hi = 0; hi < 24; hi++) if (hours[hi].cost > maxHourCost) maxHourCost = hours[hi].cost;

  for (var ho = 0; ho < 24; ho++) {
    var hd = hours[ho];
    var cr = hd.clicks > 0 ? hd.conv / hd.clicks : 0;
    var sug='', adj=0, color='#6B7280', bg='#F9FAFB';

    if (hd.clicks < 5) {
      sug = 'داده کم'; color = '#9CA3AF'; bg = '#F9FAFB';
    } else if (cr > avgConvRate * 1.5 && hd.conv > 0) {
      sug = '⬆ افزایش +25%'; adj = 25; color = '#16A34A'; bg = '#DCFCE7';
    } else if (cr > avgConvRate * 1.2 && hd.conv > 0) {
      sug = '⬆ افزایش +15%'; adj = 15; color = '#16A34A'; bg = '#ECFCCB';
    } else if (hd.clicks > 10 && hd.conv === 0) {
      sug = '⬇ کاهش −30%'; adj = -30; color = '#DC2626'; bg = '#FEE2E2';
    } else if (cr < avgConvRate * 0.5 && hd.clicks > 5) {
      sug = '⬇ کاهش −15%'; adj = -15; color = '#D97706'; bg = '#FEF3C7';
    } else {
      sug = '— نرمال'; color = '#6B7280'; bg = '#F9FAFB';
    }

    hourSugs.push({
      hour: ho, clicks: hd.clicks, cost: hd.cost, conv: hd.conv, impr: hd.impr,
      convRate: cr, sug: sug, adj: adj, color: color, bg: bg
    });
  }

  var html = buildEmail(hourSugs, campList, dows, dowOrder, dowFa, startDate, yesterday, tz,
                        tCost, tClicks, tConv, avgConvRate, avgCpa, maxHourCost, dayCount);

  MailApp.sendEmail({
    to:       CONFIG.EMAIL_TO,
    subject:  CONFIG.BRAND_NAME + ' | Monthly Report | ' + Utilities.formatDate(yesterday, tz, 'dd MMM yyyy'),
    htmlBody: html,
  });
  Logger.log('✅ Email sent');
}

function buildEmail(hourSugs, campList, dows, dowOrder, dowFa, sd, ed, tz, tCost, tClicks, tConv, avgConvRate, avgCpa, maxHourCost, dayCount) {
  var fDate = function(d){ return Utilities.formatDate(d, tz, 'dd MMM yyyy'); };
  var fAED  = function(n){ return 'AED ' + n.toFixed(2); };
  var fmtHour = function(h) {
    var hh = Math.floor(h);
    var mm = Math.round((h - hh) * 60);
    return (hh < 10 ? '0'+hh : hh) + ':' + (mm < 10 ? '0'+mm : mm);
  };

  var bestHour = null, worstHour = null;
  for (var bi = 0; bi < hourSugs.length; bi++) {
    if (hourSugs[bi].adj > 0 && (bestHour === null || hourSugs[bi].convRate > bestHour.convRate)) bestHour = hourSugs[bi];
    if (hourSugs[bi].adj < 0 && (worstHour === null || hourSugs[bi].cost > worstHour.cost)) worstHour = hourSugs[bi];
  }

  var cards = [
    ['کل هزینه ماه',     fAED(tCost),                          '#1D4ED8'],
    ['میانگین روزانه',   fAED(tCost / dayCount),               '#0EA5E9'],
    ['کل کلیک',           tClicks+'',                           '#374151'],
    ['Conversions',       tConv.toFixed(1),                     '#16A34A'],
    ['میانگین Conv Rate', (avgConvRate*100).toFixed(1)+'%',    '#7C3AED'],
    ['میانگین CPA',       avgCpa > 0 ? fAED(avgCpa) : '—',     '#DC2626'],
  ];
  var cardHtml='';
  for(var c=0;c<cards.length;c++){
    cardHtml+='<td style="padding:0 3px;text-align:center"><div style="background:#F9FAFB;border:1px solid #E5E7EB;border-radius:8px;padding:11px 10px;min-width:80px"><div style="font-size:10px;color:#6B7280;margin-bottom:3px;font-family:'+FONT_STACK+'">'+cards[c][0]+'</div><div style="font-size:14px;font-weight:700;color:'+cards[c][2]+';font-family:'+FONT_STACK+'">'+cards[c][1]+'</div></div></td>';
  }

  // Hourly rows
  var hRows='';
  for (var hi = 0; hi < hourSugs.length; hi++) {
    var hs = hourSugs[hi];
    var barW = maxHourCost > 0 ? Math.round((hs.cost / maxHourCost) * 100) : 0;
    var barColor = hs.adj > 0 ? '#16A34A' : hs.adj < 0 ? '#DC2626' : '#9CA3AF';
    var rowBg = hi % 2 === 0 ? '#FFFFFF' : '#F9FAFB';
    var avgClicks = (hs.clicks / dayCount).toFixed(1);

    hRows+='<tr style="background:'+rowBg+'">'+
      '<td style="padding:8px 10px;border-bottom:1px solid #F3F4F6;text-align:center;font-weight:600;color:#374151" dir="ltr">'+(hs.hour<10?'0'+hs.hour:hs.hour)+':00</td>'+
      '<td style="padding:8px 10px;border-bottom:1px solid #F3F4F6;text-align:center;color:#374151">'+hs.clicks+'</td>'+
      '<td style="padding:8px 10px;border-bottom:1px solid #F3F4F6;text-align:center;color:#6B7280;font-size:11px">'+avgClicks+'</td>'+
      '<td style="padding:8px 10px;border-bottom:1px solid #F3F4F6">'+
        '<div style="display:flex;align-items:center;gap:6px"><div style="flex:1;background:#F3F4F6;border-radius:3px;height:6px;min-width:60px"><div style="width:'+barW+'%;background:'+barColor+';height:6px;border-radius:3px"></div></div><span style="color:#1D4ED8;font-weight:600;min-width:55px;text-align:left" dir="ltr">'+fAED(hs.cost)+'</span></div>'+
      '</td>'+
      '<td style="padding:8px 10px;border-bottom:1px solid #F3F4F6;text-align:center"><span style="background:'+(hs.conv>0?'#DCFCE7':'#F3F4F6')+';color:'+(hs.conv>0?'#16A34A':'#9CA3AF')+';padding:2px 8px;border-radius:10px;font-weight:600">'+hs.conv.toFixed(1)+'</span></td>'+
      '<td style="padding:8px 10px;border-bottom:1px solid #F3F4F6;text-align:center;color:#6B7280;font-size:11px">'+(hs.convRate*100).toFixed(1)+'%</td>'+
      '<td style="padding:8px 10px;border-bottom:1px solid #F3F4F6;text-align:center"><span style="background:'+hs.bg+';color:'+hs.color+';padding:3px 9px;border-radius:10px;font-size:11px;font-weight:600">'+hs.sug+'</span></td>'+
    '</tr>';
  }

  // Budget rows
  var bRows='';
  for (var bk = 0; bk < campList.length; bk++) {
    var cs = campList[bk];
    var exhText, exhColor;
    if (cs.avgExhaust !== null) {
      exhText = '⏰ ' + fmtHour(cs.avgExhaust);
      exhColor = cs.avgExhaust < 18 ? '#DC2626' : '#D97706';
    } else if (cs.avgUtil >= 95) {
      exhText = '~۲۳:۵۹';
      exhColor = '#D97706';
    } else {
      exhText = 'تموم نمی‌شه';
      exhColor = '#16A34A';
    }

    var exhPct = cs.daysAnalyzed > 0 ? Math.round((cs.daysExhausted / cs.daysAnalyzed) * 100) : 0;
    var utilBarW = Math.min(cs.avgUtil, 100);
    var utilColor = cs.avgUtil >= 100 ? '#DC2626' : cs.avgUtil >= 80 ? '#D97706' : '#16A34A';

    bRows+='<tr style="background:'+(bk%2===0?'#FFFFFF':'#F9FAFB')+'">'+
      '<td style="padding:10px;border-bottom:1px solid #F3F4F6;font-weight:500;color:#111827;font-size:13px;direction:ltr;text-align:left">'+cs.name+'</td>'+
      '<td style="padding:10px;border-bottom:1px solid #F3F4F6;text-align:center;color:#1D4ED8;font-weight:600" dir="ltr">'+fAED(cs.budget)+'</td>'+
      '<td style="padding:10px;border-bottom:1px solid #F3F4F6;text-align:center;font-weight:600" dir="ltr">'+fAED(cs.avgDailySpend)+'</td>'+
      '<td style="padding:10px;border-bottom:1px solid #F3F4F6">'+
        '<div style="display:flex;align-items:center;gap:6px"><div style="flex:1;background:#F3F4F6;border-radius:3px;height:6px;min-width:60px"><div style="width:'+utilBarW+'%;background:'+utilColor+';height:6px;border-radius:3px"></div></div><span style="color:'+utilColor+';font-weight:600;min-width:45px;text-align:left">'+cs.avgUtil.toFixed(0)+'%</span></div>'+
      '</td>'+
      '<td style="padding:10px;border-bottom:1px solid #F3F4F6;text-align:center;color:'+exhColor+';font-weight:600;font-size:12px" dir="ltr">'+exhText+'</td>'+
      '<td style="padding:10px;border-bottom:1px solid #F3F4F6;text-align:center;color:#6B7280;font-size:11px">'+cs.daysExhausted+'/'+cs.daysAnalyzed+' ('+exhPct+'%)</td>'+
      '<td style="padding:10px;border-bottom:1px solid #F3F4F6;text-align:center"><span style="background:'+(cs.totalConv>0?'#DCFCE7':'#F3F4F6')+';color:'+(cs.totalConv>0?'#16A34A':'#9CA3AF')+';padding:2px 8px;border-radius:10px;font-weight:600">'+cs.totalConv.toFixed(1)+'</span></td>'+
    '</tr>';
  }

  // DOW rows
  var dowRows = '';
  var maxDowConv = 0;
  for (var dn = 0; dn < dowOrder.length; dn++) {
    if (dows[dowOrder[dn]] && dows[dowOrder[dn]].conv > maxDowConv) maxDowConv = dows[dowOrder[dn]].conv;
  }
  for (var dx = 0; dx < dowOrder.length; dx++) {
    var dk2 = dowOrder[dx];
    var dd = dows[dk2] || {clicks:0, cost:0, conv:0};
    var cr2 = dd.clicks > 0 ? dd.conv / dd.clicks : 0;
    var cpa2 = dd.conv > 0 ? dd.cost / dd.conv : 0;
    var convBarW = maxDowConv > 0 ? Math.round((dd.conv / maxDowConv) * 100) : 0;

    var dowSug = '— نرمال', dowColor = '#6B7280', dowBg = '#F9FAFB';
    if (cr2 > avgConvRate * 1.3 && dd.conv > 0) { dowSug = '⬆ افزایش'; dowColor = '#16A34A'; dowBg = '#DCFCE7'; }
    else if (cr2 < avgConvRate * 0.5 && dd.clicks > 5) { dowSug = '⬇ کاهش'; dowColor = '#DC2626'; dowBg = '#FEE2E2'; }

    dowRows+='<tr style="background:'+(dx%2===0?'#FFFFFF':'#F9FAFB')+'">'+
      '<td style="padding:9px 10px;border-bottom:1px solid #F3F4F6;font-weight:600;color:#111827">'+dowFa[dk2]+'</td>'+
      '<td style="padding:9px 10px;border-bottom:1px solid #F3F4F6;text-align:center">'+dd.clicks+'</td>'+
      '<td style="padding:9px 10px;border-bottom:1px solid #F3F4F6;text-align:center;color:#1D4ED8;font-weight:600" dir="ltr">'+fAED(dd.cost)+'</td>'+
      '<td style="padding:9px 10px;border-bottom:1px solid #F3F4F6">'+
        '<div style="display:flex;align-items:center;gap:6px"><div style="flex:1;background:#F3F4F6;border-radius:3px;height:6px;min-width:50px"><div style="width:'+convBarW+'%;background:#16A34A;height:6px;border-radius:3px"></div></div><span style="color:#16A34A;font-weight:600;min-width:35px;text-align:left">'+dd.conv.toFixed(1)+'</span></div>'+
      '</td>'+
      '<td style="padding:9px 10px;border-bottom:1px solid #F3F4F6;text-align:center;color:#6B7280;font-size:11px">'+(cr2*100).toFixed(1)+'%</td>'+
      '<td style="padding:9px 10px;border-bottom:1px solid #F3F4F6;text-align:center;color:#6B7280;font-size:11px" dir="ltr">'+(cpa2 > 0 ? fAED(cpa2) : '—')+'</td>'+
      '<td style="padding:9px 10px;border-bottom:1px solid #F3F4F6;text-align:center"><span style="background:'+dowBg+';color:'+dowColor+';padding:3px 9px;border-radius:10px;font-size:11px;font-weight:600">'+dowSug+'</span></td>'+
    '</tr>';
  }

  // Top recommendations
  var topActions = '<div style="background:#EEF2FF;border:1px solid #C7D2FE;border-radius:8px;padding:14px 16px;margin-bottom:16px"><div style="font-size:13px;font-weight:700;color:#3730A3;margin-bottom:8px">🎯 توصیه‌های کلیدی (تحلیل ۳۰ روزه)</div><ul style="margin:0;padding-right:18px;font-size:12px;color:#1E3A8A;line-height:1.8">';
  if (bestHour) topActions += '<li>بهترین ساعت ماه: <b dir="ltr" style="unicode-bidi:isolate">'+ (bestHour.hour<10?'0'+bestHour.hour:bestHour.hour) +':00</b> با Conv Rate <b>'+(bestHour.convRate*100).toFixed(1)+'%</b> — پیشنهاد bid adjustment: <b style="color:#16A34A">+'+bestHour.adj+'%</b></li>';
  if (worstHour) topActions += '<li>پرهزینه‌ترین ساعت کم‌بازده: <b dir="ltr" style="unicode-bidi:isolate">'+ (worstHour.hour<10?'0'+worstHour.hour:worstHour.hour) +':00</b> با هزینه کل <b dir="ltr" style="unicode-bidi:isolate">'+fAED(worstHour.cost)+'</b> — پیشنهاد: <b style="color:#DC2626">'+worstHour.adj+'%</b></li>';
  var earlyExhaust = null;
  for (var ec = 0; ec < campList.length; ec++) if (campList[ec].avgExhaust !== null && campList[ec].avgExhaust < 18 && campList[ec].daysExhausted >= dayCount * 0.5) { earlyExhaust = campList[ec]; break; }
  if (earlyExhaust) topActions += '<li>کمپین <b dir="ltr" style="unicode-bidi:isolate">'+earlyExhaust.name+'</b> به‌طور میانگین ساعت <b dir="ltr" style="unicode-bidi:isolate">'+fmtHour(earlyExhaust.avgExhaust)+'</b> بودجه‌اش تموم می‌شه (در '+earlyExhaust.daysExhausted+' روز از '+earlyExhaust.daysAnalyzed+' روز) — <b>افزایش بودجه</b> توصیه می‌شه.</li>';

  // بهترین روز هفته
  var bestDow = null, bestDowKey = null;
  for (var bd = 0; bd < dowOrder.length; bd++) {
    var ddd = dows[dowOrder[bd]];
    if (ddd && ddd.clicks > 5) {
      var bdcr = ddd.conv / ddd.clicks;
      if (bestDow === null || bdcr > bestDow.cr) { bestDow = {cr: bdcr, conv: ddd.conv}; bestDowKey = dowOrder[bd]; }
    }
  }
  if (bestDow && bestDowKey) topActions += '<li>بهترین روز هفته: <b>'+dowFa[bestDowKey]+'</b> با Conv Rate <b>'+(bestDow.cr*100).toFixed(1)+'%</b> — برای این روز bid adjustment مثبت بذار.</li>';

  topActions += '</ul></div>';

  var scriptInfo = '<div style="font-size:11px;color:#6B7280;margin-top:14px;padding:10px 12px;background:#F3F4F6;border-radius:6px;direction:rtl;text-align:right">'+
    '<b>📋 اطلاعات این گزارش:</b><br>'+
    'این گزارش توسط اسکریپت <b>«'+CONFIG.SCRIPT_NAME+'»</b> در Google Ads تولید شده است.<br>'+
    'بازه تحلیل: <b><span dir="ltr" style="unicode-bidi:isolate">'+fDate(sd)+' تا '+fDate(ed)+'</span></b> ('+dayCount+' روز) | داده‌های ساعتی و روزانه: جمع کل بازه'+
    '</div>';

  return '<!DOCTYPE html><html><head><meta charset="UTF-8">'+FONT_LINK+
  '<style>body,table,td,th,div,span,p,b,li,ul{font-family:'+FONT_STACK+' !important}</style></head>'+
  '<body style="margin:0;padding:0;background:#F3F4F6;font-family:'+FONT_STACK+';direction:rtl">'+
  '<table width="100%" cellpadding="0" cellspacing="0"><tr><td style="padding:24px 12px">'+
  '<table width="840" align="center" cellpadding="0" cellspacing="0" style="max-width:840px;margin:auto">'+

  '<tr><td style="background:linear-gradient(135deg,#1E3A8A,#1D4ED8);border-radius:12px 12px 0 0;padding:22px 28px">'+
  '<table width="100%"><tr>'+
  '<td><div style="font-size:20px;font-weight:700;color:#fff">🚗 '+CONFIG.BRAND_NAME+' — گزارش ماهانه</div>'+
  '<div style="font-size:12px;color:#BFDBFE;margin-top:3px">تحلیل ساعتی، روز هفته و بودجه — ۳۰ روز گذشته</div></td>'+
  '<td align="left"><div style="font-size:12px;color:#93C5FD;text-align:left"><span dir="ltr" style="unicode-bidi:isolate;display:inline-block">'+fDate(sd)+' – '+fDate(ed)+'</span></div>'+
  '<div style="font-size:11px;color:#6B91D4;margin-top:2px;text-align:left">'+dayCount+' روز</div></td>'+
  '</tr></table></td></tr>'+

  '<tr><td style="background:#fff;padding:18px 20px"><table><tr>'+cardHtml+'</tr></table></td></tr>'+

  '<tr><td style="background:#fff;padding:0 28px 28px">'+

  topActions +

  '<div style="font-size:14px;font-weight:700;color:#111827;margin:18px 0 10px">⏰ تحلیل ساعتی — جمع ۳۰ روز</div>'+
  '<table width="100%" cellpadding="0" cellspacing="0" style="border:1px solid #E5E7EB;border-radius:8px;overflow:hidden">'+
  '<tr style="background:#1E3A8A">'+
  '<th style="padding:9px 8px;text-align:center;font-size:11px;color:#93C5FD">ساعت</th>'+
  '<th style="padding:9px 8px;text-align:center;font-size:11px;color:#93C5FD">کل کلیک</th>'+
  '<th style="padding:9px 8px;text-align:center;font-size:11px;color:#93C5FD">میانگین روزانه</th>'+
  '<th style="padding:9px 8px;text-align:right;font-size:11px;color:#93C5FD">کل هزینه</th>'+
  '<th style="padding:9px 8px;text-align:center;font-size:11px;color:#93C5FD">Conv</th>'+
  '<th style="padding:9px 8px;text-align:center;font-size:11px;color:#93C5FD">Conv Rate</th>'+
  '<th style="padding:9px 8px;text-align:center;font-size:11px;color:#FDE68A">پیشنهاد</th>'+
  '</tr>'+hRows+
  '</table>'+

  '<div style="font-size:14px;font-weight:700;color:#111827;margin:24px 0 10px">💰 الگوی بودجه — به‌طور میانگین کی تموم می‌شه؟</div>'+
  '<table width="100%" cellpadding="0" cellspacing="0" style="border:1px solid #E5E7EB;border-radius:8px;overflow:hidden">'+
  '<tr style="background:#1E3A8A">'+
  '<th style="padding:10px;text-align:right;font-size:11px;color:#93C5FD">Campaign</th>'+
  '<th style="padding:10px;text-align:center;font-size:11px;color:#93C5FD">بودجه روزانه</th>'+
  '<th style="padding:10px;text-align:center;font-size:11px;color:#93C5FD">میانگین خرج روزانه</th>'+
  '<th style="padding:10px;text-align:right;font-size:11px;color:#93C5FD">مصرف میانگین</th>'+
  '<th style="padding:10px;text-align:center;font-size:11px;color:#FDE68A">میانگین ساعت پایان بودجه</th>'+
  '<th style="padding:10px;text-align:center;font-size:11px;color:#93C5FD">روزهای تموم‌شده</th>'+
  '<th style="padding:10px;text-align:center;font-size:11px;color:#93C5FD">Conv</th>'+
  '</tr>'+bRows+
  '</table>'+

  '<div style="font-size:14px;font-weight:700;color:#111827;margin:24px 0 10px">📅 الگوی روز هفته</div>'+
  '<table width="100%" cellpadding="0" cellspacing="0" style="border:1px solid #E5E7EB;border-radius:8px;overflow:hidden">'+
  '<tr style="background:#1E3A8A">'+
  '<th style="padding:9px 10px;text-align:right;font-size:11px;color:#93C5FD">روز</th>'+
  '<th style="padding:9px 10px;text-align:center;font-size:11px;color:#93C5FD">کلیک</th>'+
  '<th style="padding:9px 10px;text-align:center;font-size:11px;color:#93C5FD">هزینه</th>'+
  '<th style="padding:9px 10px;text-align:right;font-size:11px;color:#93C5FD">Conversions</th>'+
  '<th style="padding:9px 10px;text-align:center;font-size:11px;color:#93C5FD">Conv Rate</th>'+
  '<th style="padding:9px 10px;text-align:center;font-size:11px;color:#93C5FD">CPA</th>'+
  '<th style="padding:9px 10px;text-align:center;font-size:11px;color:#FDE68A">پیشنهاد</th>'+
  '</tr>'+dowRows+
  '</table>'+

  scriptInfo +

  '</td></tr>'+

  '<tr><td style="background:#1E3A8A;border-radius:0 0 12px 12px;padding:14px 28px;text-align:center">'+
  '<div style="font-size:11px;color:#93C5FD">گزارش خودکار Google Ads Script | Powered by Webinew</div>'+
  '</td></tr>'+

  '</table></td></tr></table></body></html>';
}