← back to Ventura Corridor

public/signals.html

406 lines

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>Ventura Blvd · ad signals</title>
<script>(function(){try{var t=localStorage.getItem('vc-theme');document.documentElement.dataset.theme=(t==='light'||t==='dark')?t:'dark';}catch(e){document.documentElement.dataset.theme='dark';}})();</script>
<link rel="stylesheet" href="/theme.css">
<script src="/theme.js" defer></script>
<style>
  :root {
    --noir: #0a0a0c; --noir-rise: #131316; --noir-deep: #07070a;
    --rule: #2a2724; --rule-hot: #3a342c;
    --ink: #f4f1ea; --ink-soft: #d8d2c5; --ink-mute: #8b857a;
    --metal: #b89968; --metal-glow: #d4b683;
    --hot: #d96a3a;
    --serif: "Cormorant Garamond", Georgia, serif;
    --sans: -apple-system, "SF Pro Text", system-ui, sans-serif;
    --mono: "SFMono-Regular", Menlo, Consolas, monospace;
  }
  * { box-sizing: border-box; }
  html, body { margin: 0; background: var(--noir); color: var(--ink); font-family: var(--sans); font-weight: 300; }
  /* ─── Header ─── */
  header {
    padding: 28px 40px 20px;
    border-bottom: 1px solid var(--rule);
    display: grid; grid-template-columns: 1fr auto; gap: 20px; align-items: end;
    position: sticky; top: 0; z-index: 50;
    background: linear-gradient(180deg, rgba(10,10,12,.97) 70%, rgba(10,10,12,0));
    backdrop-filter: blur(10px);
  }
  header h1 {
    font-family: var(--serif); font-weight: 300; font-size: clamp(28px, 3.4vw, 44px);
    margin: 0; letter-spacing: -0.012em; line-height: 1;
  }
  header h1 em { font-style: italic; color: var(--metal); }
  header .sub { font-size: 11px; letter-spacing: .22em; text-transform: uppercase; color: var(--ink-mute); margin-top: 8px; font-weight: 400; }
  nav.tabs { display: flex; gap: 0; align-self: end; }
  nav.tabs a {
    padding: 10px 18px; border: 1px solid var(--rule); color: var(--ink-mute);
    text-decoration: none; font-size: 10px; letter-spacing: .24em; text-transform: uppercase;
    border-right: 0;
  }
  nav.tabs a:last-child { border-right: 1px solid var(--rule); }
  nav.tabs a.active { color: var(--metal); border-color: var(--metal); background: rgba(184,153,104,0.05); }
  nav.tabs a:hover { color: var(--metal-glow); }
  /* ─── Filter rail ─── */
  .rail {
    padding: 22px 40px; border-bottom: 1px solid var(--rule);
    display: grid; grid-template-columns: repeat(auto-fit, minmax(220px, 1fr));
    gap: 32px; align-items: start;
  }
  .ctrl { display: flex; flex-direction: column; gap: 10px; }
  .ctrl-label { font-size: 10px; letter-spacing: .26em; text-transform: uppercase; color: var(--ink-mute); display: flex; justify-content: space-between; }
  .ctrl-label b { color: var(--metal); font-family: var(--serif); font-style: italic; font-weight: 400; font-size: 14px; letter-spacing: 0; font-variant-numeric: tabular-nums; }
  /* Slider — Figma-bold range */
  input[type="range"] {
    -webkit-appearance: none; appearance: none; width: 100%; background: transparent; cursor: pointer; margin: 0;
  }
  input[type="range"]::-webkit-slider-runnable-track {
    height: 2px; background: var(--rule-hot);
  }
  input[type="range"]::-webkit-slider-thumb {
    -webkit-appearance: none; appearance: none;
    width: 16px; height: 16px; border-radius: 0; background: var(--metal);
    margin-top: -7px; border: 1px solid var(--ink); transition: background 200ms ease;
  }
  input[type="range"]::-webkit-slider-thumb:hover { background: var(--metal-glow); }
  /* Pixel toggle pills */
  .pills { display: flex; flex-wrap: wrap; gap: 6px; }
  .pill {
    padding: 6px 12px; border: 1px solid var(--rule); background: var(--noir-rise);
    color: var(--ink-mute); font-size: 10px; letter-spacing: .14em; text-transform: uppercase;
    cursor: pointer; user-select: none; transition: all 180ms ease;
    font-family: var(--sans); font-weight: 500;
  }
  .pill.on { color: var(--metal); border-color: var(--metal); background: rgba(184,153,104,0.08); }
  .pill:hover { color: var(--metal-glow); border-color: var(--metal-glow); }
  /* Search input */
  input[type="search"] {
    padding: 10px 14px; background: var(--noir-rise); border: 1px solid var(--rule);
    color: var(--ink); font-family: var(--sans); font-size: 13px; outline: none; width: 100%;
  }
  input[type="search"]::placeholder { color: var(--ink-mute); font-style: italic; font-family: var(--serif); }
  input[type="search"]:focus { border-color: var(--metal); }
  /* ─── Stats strip ─── */
  .stats { padding: 16px 40px; border-bottom: 1px solid var(--rule); display: flex; gap: 40px; flex-wrap: wrap; font-size: 11px; letter-spacing: .12em; color: var(--ink-mute); text-transform: uppercase; }
  .stats b { color: var(--metal); font-family: var(--serif); font-style: italic; font-size: 18px; font-weight: 400; letter-spacing: 0; margin-right: 8px; font-variant-numeric: tabular-nums; }
  /* ─── Grid ─── */
  main { padding: 28px 40px 80px; }
  .grid {
    display: grid; grid-template-columns: repeat(auto-fill, minmax(280px, 1fr));
    gap: 1px; background: var(--rule); border: 1px solid var(--rule);
  }
  .card {
    background: var(--noir-rise); padding: 20px 22px 22px; min-height: 190px;
    display: flex; flex-direction: column; gap: 10px; position: relative;
    transition: background 180ms ease;
  }
  .card:hover { background: var(--noir); }
  .card .cat {
    font-size: 9px; letter-spacing: .26em; text-transform: uppercase; color: var(--ink-mute);
  }
  .card .name {
    font-family: var(--serif); font-weight: 400; font-size: 22px; line-height: 1.1; color: var(--ink);
    margin: 0; letter-spacing: -0.01em;
  }
  .card .name em { color: var(--metal); font-style: italic; }
  .card .addr { font-size: 11px; color: var(--ink-mute); line-height: 1.4; }
  .card .pixels { display: flex; flex-wrap: wrap; gap: 4px; margin-top: 8px; }
  .card .px {
    font-size: 9px; letter-spacing: .14em; text-transform: uppercase; padding: 3px 8px;
    border: 1px solid var(--rule); color: var(--ink-mute);
    font-family: var(--mono); font-weight: 500;
  }
  .card .px.hot { color: var(--hot); border-color: var(--hot); }
  .card .px.metal { color: var(--metal); border-color: var(--metal); }
  .card .px.warn { color: var(--ink-mute); border-color: rgba(216,210,197,0.18); border-style: dashed; }
  .card .socials { display: flex; flex-wrap: wrap; gap: 6px; margin-top: 6px; }
  .card .soc { font-size: 9px; letter-spacing: .14em; text-transform: uppercase; padding: 3px 8px; border: 1px solid rgba(216,210,197,0.18); color: var(--ink-soft); text-decoration: none; font-family: var(--mono); font-weight: 500; }
  .card .soc:hover { color: var(--metal-glow); border-color: var(--metal-glow); }
  .card .footer-row {
    margin-top: auto; padding-top: 12px; border-top: 1px solid var(--rule);
    display: flex; justify-content: space-between; align-items: baseline;
    font-size: 11px; color: var(--ink-mute);
  }
  .card .score { color: var(--metal); font-family: var(--serif); font-style: italic; font-size: 16px; font-weight: 400; }
  .card .score em { font-style: normal; font-size: 9px; letter-spacing: .2em; margin-left: 6px; color: var(--ink-mute); text-transform: uppercase; }
  .card a.dom { color: var(--metal); font-family: var(--mono); font-size: 10px; text-decoration: none; word-break: break-all; }
  .card a.dom:hover { color: var(--metal-glow); }
  .empty { padding: 80px 32px; text-align: center; font-family: var(--serif); font-style: italic; color: var(--ink-mute); font-size: 18px; }
  /* ─── Top Advertisers leaderboard ─── */
  .leader {
    padding: 22px 40px 28px; border-bottom: 1px solid var(--rule);
    background: linear-gradient(180deg, rgba(184,153,104,0.04), transparent 80%);
  }
  .leader-hd { display: flex; align-items: baseline; justify-content: space-between; margin-bottom: 14px; }
  .leader-hd h2 {
    font-family: var(--serif); font-weight: 400; font-style: italic; font-size: 22px;
    margin: 0; color: var(--ink); letter-spacing: -0.01em;
  }
  .leader-hd h2 em { font-style: normal; color: var(--metal); margin-right: 8px; font-size: 11px; letter-spacing: .26em; text-transform: uppercase; vertical-align: middle; }
  .leader-hd .meta { font-size: 10px; letter-spacing: .26em; text-transform: uppercase; color: var(--ink-mute); }
  .leader-grid { display: grid; grid-template-columns: repeat(auto-fill, minmax(280px, 1fr)); gap: 1px; background: var(--rule); border: 1px solid var(--rule); }
  .leader-row {
    background: var(--noir-rise); padding: 12px 16px; display: grid;
    grid-template-columns: 28px 1fr auto; align-items: baseline; gap: 12px;
    transition: background 180ms ease;
  }
  .leader-row:hover { background: var(--noir); }
  .leader-row .rk { font-family: var(--serif); font-style: italic; color: var(--metal); font-size: 18px; font-variant-numeric: tabular-nums; }
  .leader-row .nm { font-size: 13px; color: var(--ink); overflow: hidden; text-overflow: ellipsis; white-space: nowrap; }
  .leader-row .nm small { display: block; color: var(--ink-mute); font-size: 9px; letter-spacing: .18em; text-transform: uppercase; margin-top: 2px; }
  .leader-row .ct { color: var(--metal); font-family: var(--serif); font-style: italic; font-size: 18px; font-variant-numeric: tabular-nums; text-align: right; }
  .leader-row .ct em { display: block; font-style: normal; font-size: 9px; letter-spacing: .2em; text-transform: uppercase; color: var(--ink-mute); margin-top: 2px; }
  .leader-row .gtm { display: inline-block; margin-left: 6px; font-size: 8px; letter-spacing: .2em; padding: 1px 5px; border: 1px solid var(--metal); color: var(--metal); vertical-align: middle; }
  /* card extras: live ads, chamber badges */
  .card .live-ads-row { margin: 8px 0 4px; }
  .card .live-ads { display: inline-block; padding: 4px 10px; border: 1px solid var(--metal); color: var(--metal); font-family: var(--serif); font-style: italic; font-size: 16px; font-variant-numeric: tabular-nums; background: rgba(184,153,104,0.06); }
  .card .live-ads em { font-style: normal; font-family: var(--sans); font-size: 9px; letter-spacing: .2em; text-transform: uppercase; margin-left: 6px; color: var(--ink-mute); }
  .card .chambers { display: flex; flex-wrap: wrap; gap: 4px; margin: 6px 0; }
  .card .chamber { font-size: 8px; letter-spacing: .2em; text-transform: uppercase; padding: 2px 6px; border: 1px solid var(--rule-hot); color: var(--ink-mute); }
  footer {
    padding: 24px 40px; border-top: 1px solid var(--rule);
    font-family: var(--serif); font-style: italic; color: var(--ink-mute); font-size: 12px; text-align: center;
  }
</style>
</head>
<body>

<header>
  <div>
    <h1>Ventura <em>Boulevard</em> · ad signals</h1>
    <div class="sub">tracking-pixel fingerprints — who's paying to advertise</div>
  </div>
  <nav class="tabs" aria-label="Surface navigation">
    <a href="/">2D map</a>
    <a href="/3d.html">3D corridor</a>
    <a href="/wall.html">Wall</a>
    <a href="/signals.html" class="active" aria-current="page">Ad signals</a>
    <a href="/dw-radar.html">DW radar</a>
    <a href="/timeline.html">Timeline</a>
    <a href="/pantone.html">Pantone</a>
    <a href="/headlines.html">Voices</a>
    <a href="/tongues.html">Tongues</a>
    <a href="/chains.html">Chains</a>
    <a href="/atlas.html">Atlas</a>
    <a href="/eulogy.html">Eulogy</a>
    <a href="/api/export.csv?paid_only=1" download style="border-color:var(--metal);color:var(--metal)">Export CSV ↓</a>
    <span class="theme-toggle-host" style="display:inline-flex;align-items:center;margin-left:6px"></span>
  </nav>
</header>

<div class="stats" id="stats">
  <span><b id="s-total">—</b> with signals</span>
  <span><b id="s-paid">—</b> paying for ads</span>
  <span><b id="s-google">—</b> Google Ads</span>
  <span><b id="s-meta">—</b> Meta Pixel</span>
  <span><b id="s-ga">—</b> measurement only (GA4)</span>
</div>

<section class="leader" id="leader" style="display:none">
  <div class="leader-hd">
    <h2><em>Top advertisers</em>by live Google creatives</h2>
    <span class="meta" id="leader-meta">—</span>
  </div>
  <div class="leader-grid" id="leader-grid"></div>
</section>

<section class="rail">
  <div class="ctrl">
    <div class="ctrl-label">Search <b id="lbl-q">all</b></div>
    <input type="search" id="q" placeholder="name, category, city…" autocomplete="off">
  </div>
  <div class="ctrl">
    <div class="ctrl-label">Min SEO score <b id="lbl-score">0</b></div>
    <input type="range" id="r-score" min="0" max="100" value="0" step="1">
  </div>
  <div class="ctrl">
    <div class="ctrl-label">Min paid platforms <b id="lbl-paid">0</b></div>
    <input type="range" id="r-paid" min="0" max="8" value="0" step="1">
  </div>
  <div class="ctrl">
    <div class="ctrl-label">Required platforms</div>
    <div class="pills" id="px-pills">
      <span class="pill" data-px="google_ads">Google Ads</span>
      <span class="pill" data-px="meta_pixel">Meta</span>
      <span class="pill" data-px="tiktok_pixel">TikTok</span>
      <span class="pill" data-px="pinterest_tag">Pinterest</span>
      <span class="pill" data-px="linkedin_insight">LinkedIn</span>
      <span class="pill" data-px="twitter_pixel">Twitter</span>
      <span class="pill" data-px="reddit_pixel">Reddit</span>
      <span class="pill" data-px="bing_uet">Bing</span>
      <span class="pill" data-px="snap_pixel">Snap</span>
    </div>
  </div>
</section>

<main>
  <div class="grid" id="grid"></div>
  <div class="empty" id="empty" style="display:none">No matches.</div>
</main>

<footer>Ad-tracker fingerprints from the public front-page HTML. Binary signal — does not represent ad spend dollars. Directory only.</footer>

<script>
let DATA = [];
const PILLS = new Set();

function escapeHtml(s) {
  return String(s ?? '').replace(/[&<>"']/g, c => ({ '&': '&amp;', '<': '&lt;', '>': '&gt;', '"': '&quot;', "'": '&#39;' }[c]));
}
function hostOnly(url) {
  try { return new URL(/^https?:/.test(url) ? url : 'https://' + url).hostname.replace(/^www\./, ''); }
  catch { return ''; }
}
const PIXEL_LABELS = {
  google_ads: 'Google Ads', meta_pixel: 'Meta', tiktok_pixel: 'TikTok',
  pinterest_tag: 'Pinterest', linkedin_insight: 'LinkedIn', twitter_pixel: 'Twitter',
  reddit_pixel: 'Reddit', bing_uet: 'Bing', snap_pixel: 'Snap', google_analytics: 'GA4',
  gtm_container: 'GTM ⚠',
};
const PAID = ['google_ads','meta_pixel','tiktok_pixel','pinterest_tag','twitter_pixel','reddit_pixel','bing_uet','snap_pixel'];

function render() {
  const q = (document.getElementById('q').value || '').trim().toLowerCase();
  const minScore = +document.getElementById('r-score').value;
  const minPaid = +document.getElementById('r-paid').value;
  document.getElementById('lbl-q').textContent = q || 'all';
  document.getElementById('lbl-score').textContent = minScore;
  document.getElementById('lbl-paid').textContent = minPaid;

  let rows = DATA.filter(r => {
    const sig = r.ad_signals || {};
    const paidCount = sig.paid_ads_count || 0;
    if (paidCount < minPaid) return false;
    if ((r.seo_score || 0) < minScore) return false;
    for (const px of PILLS) if (!sig[px]) return false;
    if (q) {
      const hay = [r.name, r.category, r.city, r.address].filter(Boolean).join(' ').toLowerCase();
      if (!hay.includes(q)) return false;
    }
    return true;
  });

  const grid = document.getElementById('grid');
  const empty = document.getElementById('empty');
  if (!rows.length) { grid.innerHTML = ''; empty.style.display = 'block'; return; }
  empty.style.display = 'none';

  grid.innerHTML = rows.slice(0, 600).map(r => {
    const sig = r.ad_signals || {};
    const px = Object.keys(PIXEL_LABELS)
      .filter(k => sig[k])
      .map(k => {
        const cls = k === 'google_ads' ? 'hot' : (PAID.includes(k) ? 'metal' : (k === 'gtm_container' ? 'warn' : ''));
        const title = k === 'gtm_container' ? 'title="GTM detected — additional pixels may load indirectly"' : '';
        return `<span class="px ${cls}" ${title}>${PIXEL_LABELS[k]}</span>`;
      }).join('');
    const dom = r.website ? hostOnly(r.website) : '';
    const contacts = r.contacts || [];
    const SOC_LABEL = { instagram: 'IG', facebook: 'FB', twitter: 'X', tiktok: 'TT', bluesky: 'BSKY', linkedin: 'LI' };
    const seenSoc = new Set();
    const socials = contacts
      .filter(c => c.role === 'social_handle' && c.notes && SOC_LABEL[c.notes])
      .filter(c => { const k = c.notes; if (seenSoc.has(k)) return false; seenSoc.add(k); return true; })
      .map(c => `<a class="soc" href="${c.source_url}" target="_blank" rel="noopener">${SOC_LABEL[c.notes]} ${escapeHtml(c.person_name || '')}</a>`)
      .join('');
    const liCount = contacts.filter(c => c.role === 'linkedin_company').length;
    const liUrl = contacts.find(c => c.role === 'linkedin_company')?.person_linkedin;
    const liChip = liUrl ? `<a class="soc" href="${liUrl}" target="_blank" rel="noopener">LinkedIn</a>` : '';
    const liveAds = sig.transparency?.ad_count;
    const liveAdsBadge = (typeof liveAds === 'number' && liveAds > 0)
      ? `<span class="live-ads" title="Confirmed live Google ads (Ads Transparency Center)">${fmtCount(liveAds)} <em>live ads</em></span>`
      : '';
    const chambers = r.chamber_memberships ? Object.keys(r.chamber_memberships) : [];
    const chamberBadges = chambers.length
      ? `<div class="chambers">${chambers.map(c => `<span class="chamber" title="Chamber of Commerce member">${escapeHtml(c.replace(/_/g, ' '))}</span>`).join('')}</div>`
      : '';
    return `
      <article class="card">
        <div class="cat">${escapeHtml(r.category || '')}</div>
        <h3 class="name">${escapeHtml(r.name)}</h3>
        <div class="addr">${escapeHtml([r.address, r.city].filter(Boolean).join(' · '))}</div>
        <div class="pixels">${px || '<span class="px">no signals</span>'}</div>
        ${liveAdsBadge ? `<div class="live-ads-row">${liveAdsBadge}</div>` : ''}
        ${chamberBadges}
        ${(socials || liChip) ? `<div class="socials">${socials}${liChip}</div>` : ''}
        <div class="footer-row">
          <span class="score">${r.seo_score || '—'}<em>${r.seo_tier || ''}</em></span>
          ${dom ? `<a class="dom" href="${r.website}" target="_blank" rel="noopener">${escapeHtml(dom)}</a>` : '<span></span>'}
        </div>
      </article>`;
  }).join('');
}

function updateStats() {
  const total = DATA.length;
  const paid = DATA.filter(r => (r.ad_signals?.paid_ads_count || 0) > 0).length;
  const g = DATA.filter(r => r.ad_signals?.google_ads).length;
  const m = DATA.filter(r => r.ad_signals?.meta_pixel).length;
  const ga = DATA.filter(r => r.ad_signals?.google_analytics).length;
  document.getElementById('s-total').textContent = total;
  document.getElementById('s-paid').textContent = paid;
  document.getElementById('s-google').textContent = g;
  document.getElementById('s-meta').textContent = m;
  document.getElementById('s-ga').textContent = ga;
}

function fmtCount(n) {
  if (n >= 1_000_000) return (n / 1_000_000).toFixed(1).replace(/\.0$/, '') + 'M';
  if (n >= 1_000) return (n / 1_000).toFixed(1).replace(/\.0$/, '') + 'K';
  return String(n);
}

async function loadLeaderboard() {
  try {
    const r = await fetch('/api/leaderboard?limit=20').then(r => r.json());
    const rows = r.rows || [];
    if (!rows.length) return;
    const sec = document.getElementById('leader');
    const grid = document.getElementById('leader-grid');
    const meta = document.getElementById('leader-meta');
    const total = rows.reduce((s, x) => s + (x.live_ads || 0), 0);
    meta.textContent = `${rows.length} confirmed · ${fmtCount(total)} live creatives`;
    grid.innerHTML = rows.map((x, i) => {
      const host = (x.website || '').replace(/^https?:\/\/(www\.)?/, '').split('/')[0];
      return `
        <div class="leader-row">
          <div class="rk">${i + 1}</div>
          <div class="nm" title="${escapeHtml(x.name)}">
            ${escapeHtml(x.name)}${x.via_gtm ? '<span class="gtm">GTM</span>' : ''}
            <small>${escapeHtml(x.category || '—')} · ${escapeHtml(host)}</small>
          </div>
          <div class="ct">${fmtCount(x.live_ads)}<em>live ads</em></div>
        </div>`;
    }).join('');
    sec.style.display = '';
  } catch {}
}

async function load() {
  const r = await fetch('/api/signals?limit=5000').then(r => r.json());
  DATA = r.rows || [];
  updateStats();
  render();
  loadLeaderboard();
}

document.getElementById('q').addEventListener('input', () => { clearTimeout(window._t); window._t = setTimeout(render, 120); });
document.getElementById('r-score').addEventListener('input', render);
document.getElementById('r-paid').addEventListener('input', render);
document.querySelectorAll('.pill').forEach(p => {
  p.addEventListener('click', () => {
    const k = p.dataset.px;
    if (PILLS.has(k)) { PILLS.delete(k); p.classList.remove('on'); }
    else { PILLS.add(k); p.classList.add('on'); }
    render();
  });
});

load();
</script>
</body>
</html>