AdTech-арбитраж в Алматы: как выжать CPC до 450 ₸ через Prebid.js и Ad Manager

interface PrebidAdUnit {
  code: string;
  mediaTypes: {
    banner: {
      sizes: number[][];
    };
  };
  bids: Array<{
    bidder: string;
    params: Record<string, unknown>;
  }>;
}

declare global {
  interface Window {
    pbjs: {
      que: Array<() => void>;
      addAdUnits: (units: PrebidAdUnit[]) => void;
      requestBids: (options: {
        timeout: number;
        bidsBackHandler: () => void;
      }) => void;
      setTargetingForGPTAsync: () => void;
    };
    googletag: {
      cmd: Array<() => void>;
      defineSlot: (path: string, sizes: number[][], divId: string) => any;
      pubads: () => any;
      enableServices: () => void;
      display: (divId: string) => void;
    };
  }
}

export function initHeaderBiddingAuction(slotId: string, adUnitPath: string): void {
  window.pbjs = window.pbjs || { que: [] };
  window.googletag = window.googletag || { cmd: [] };

  const PREBID_TIMEOUT_MS = 650;

  const adUnits: PrebidAdUnit[] = [
    {
      code: slotId,
      mediaTypes: {
        banner: {
          sizes: [[300, 250], [336, 280], [300, 600]]
        }
      },
      bids: [
        {
          bidder: 'yandex',
          params: {
            pageId: 1984210,
            impId: 1,
            currency: 'KZT'
          }
        },
        {
          bidder: 'rubicon',
          params: {
            accountId: '18492',
            siteId: '394812',
            zoneId: '2109482'
          }
        }
      ]
    }
  ];

  window.pbjs.que.push(() => {
    window.pbjs.addAdUnits(adUnits);
    window.pbjs.requestBids({
      timeout: PREBID_TIMEOUT_MS,
      bidsBackHandler: () => {
        window.googletag.cmd.push(() => {
          window.pbjs.setTargetingForGPTAsync();
          window.googletag.pubads().refresh();
        });
      }
    });
  });

  window.googletag.cmd.push(() => {
    window.googletag
      .defineSlot(adUnitPath, [[300, 250], [336, 280]], slotId)
      .addService(window.googletag.pubads());

    window.googletag.pubads().enableSingleRequest();
    window.googletag.pubads().collapseEmptyDivs();
    window.googletag.pubads().setCentering(true);
    window.googletag.enableServices();
  });
}

import express, { Request, Response } from 'express';
import compression from 'compression';

const app = express();
const PORT = process.env.PORT || 8080;

interface GeoAdFloorPolicy {
  minFloorUSD: number;
  currency: string;
  preferredBidders: string[];
}

const KAZAKHSTAN_GEO_FLOORS: Record<string, GeoAdFloorPolicy> = {
  'Almaty': { minFloorUSD: 0.85, currency: 'USD', preferredBidders: ['yandex', 'rubicon', 'criteo'] },
  'Astana': { minFloorUSD: 0.75, currency: 'USD', preferredBidders: ['yandex', 'rubicon'] },
  'Shymkent': { minFloorUSD: 0.50, currency: 'USD', preferredBidders: ['yandex'] },
  'Default': { minFloorUSD: 0.40, currency: 'USD', preferredBidders: ['yandex'] }
};

app.use(compression());

app.get('/api/adtech/auction-config', (req: Request, res: Response) => {
  const cityHeader = (req.headers['x-client-city'] as string) || 'Default';
  const policy = KAZAKHSTAN_GEO_FLOORS[cityHeader] || KAZAKHSTAN_GEO_FLOORS['Default'];

  res.setHeader('Cache-Control', 'public, max-age=60, s-maxage=300');
  res.setHeader('Content-Type', 'application/json');

  res.json({
    timeoutMs: 650,
    geoCity: cityHeader,
    floorPriceCpm: policy.minFloorUSD,
    currency: policy.currency,
    bidders: policy.preferredBidders,
    priceGranularity: {
      buckets: [
        { max: 5.0, increment: 0.05 },
        { max: 15.0, increment: 0.25 },
        { max: 30.0, increment: 1.00 }
      ]
    }
  });
});

app.listen(PORT, () => {
  console.log(`AdTech Edge Gateway active on port ${PORT}`);
});

SELECT
  DATE(event_timestamp) AS auction_date,
  traffic_source,
  geo_city,
  COUNT(1) AS total_ad_impressions,
  ROUND(AVG(winning_bid_usd) * 1000, 2) AS calculated_ecpm_usd,
  ROUND(AVG(cpc_value_kzt), 1) AS avg_cpc_kzt,
  ROUND(SUM(CASE WHEN winning_bidder = 'google_dynamic_allocation' THEN 1 ELSE 0 END) * 100.0 / COUNT(1), 1) AS google_win_share_pct,
  ROUND(SUM(CASE WHEN winning_bidder = 'yandex_rsya' THEN 1 ELSE 0 END) * 100.0 / COUNT(1), 1) AS yandex_win_share_pct,
  ROUND(SUM(estimated_revenue_usd) * 500.0, 0) AS total_daily_revenue_kzt
FROM
  `ozat-open-datasets.ozat_cloud_knowledge_hub.adtech_auction_events`
WHERE
  event_timestamp >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 30 DAY)
  AND country_code = 'KZ'
GROUP BY
  auction_date,
  traffic_source,
  geo_city
ORDER BY
  auction_date DESC,
  total_daily_revenue_kzt DESC;