Magnite CTV

The Magnite CTV Connector provides access to ad, auction, bid, deal, and floor reports.

Note that this connector was formerly known as Telaria and “telaria” is still supported as an alias for SBS scripts.

Prerequisites

To configure access to the Magnite CTV Connector, you need:

  • Access Key
  • Secret Key

To obtain the access key and secret key, contact your Magnite CTV Account Manager.

Scheduling

The Magnite CTV Connector can be scheduled to ingest data once per day at a user-defined hour and timezone.

By default, the connector will run once at 6am PT.

See Daily Scheduling for more information.

Report Types

The following report types are available:

  • adsources-publisher
  • auctions-publisher
  • bids-diagnostics-publisher
  • deals-publisher
  • floors-potential-publisher
  • floors-recorded-publisher
  • publisher-valid-bids

Switchboard Script Syntax

import magnite_ctv_adsources_publisher_raw from {
     type: "magnite_ctv_key:adsources-publisher";
     key: "magnite_ctv_key";
     timezone: "US/Pacific";
     delay_hours: 4;
     dimensions: [
               "adSource",
               "adSourceAssignedUser",
               "adSourceId",
               "adSourcePriority",
               "adSourceStatus",
               "adSourceType",
               "adUnit",
               "appBundleId",
               "brand",
               "channel",
               "country",
               "currency",
               "day",
               "environmentType",
               "hour",
               "marketplace",
               "marketplaceId",
               "month",
               "nameInAppStore",
               "platform",
               "platformFamily",
               "playerSize",
               "publisher",
               "quarter",
               "supply",
               "supplyDomain",
               "supplySeat",
               "week",
               "year"];
     metrics: [
               "avgAdSourceExecTime",
               "avgFloorPrices",
               "badBehaviorBids",
               "bidsNoAdMarkup",
               "bidsTimeout",
               "bidsTrumped",
               "fills",
               "fixedPriceErrors",
               "generalErrors",
               "grossRevenue",
               "impressions",
               "invalidBids",
               "netCpm",
               "netRevenue",
               "rtbErrors",
               "tries",
               "urlErrors"];
     } using {
               "marketplace": string;
               "supply": string;
               "platformId": integer;
               "publisherIdLink": integer;
               "adUnitIdLink": integer;
               "channelId": integer;
               "nameInAppStore": string;
               "month": string;
               "currency": string;
               "bidsTimeout": integer;
               "adSourceAssignedUser": string;
               "year": integer;
               "appBundleId": string;
               "playerSizeCode": string;
               "invalidBids": integer;
               "generalErrors": integer;
               "avgFloorPrices": float;
               "monthId": integer;
               "platform": string;
               "currencyId": integer;
               "netRevenue": float;
               "supplyIdLink": integer;
               "adSourceIdLink": integer;
               "adSourceStatus": string;
               "adSourceTypeId": integer;
               "avgAdSourceExecTime": integer;
               "supplySeatIdLink": integer;
               "channel": string;
               "week": datetime;
               "adSourcePriority": string;
               "rtbErrorNBRWithBids": integer;
               "brand": string;
               "marketplaceIdLink": string;
               "adSourceType": string;
               "adSource": string;
               "supplyDomain": string;
               "tries": integer;
               "brandIdLink": integer;
               "bidsNoAdMarkup": integer;
               "bidsTrumped": integer;
               "adUnit": string;
               "day": datetime;
               "playerSize": string;
               "marketplaceId": string;
               "fixedPriceErrors": integer;
               "publisher": string;
               "platformFamilyId": integer;
               "supplySeat": string;
               "hour": integer;
               "platformFamily": string;
               "environmentType": string;
               "fills": integer;
               "badBehaviorBids": integer;
               "adSourceId": integer;
               "grossRevenue": float;
               "netCpm": float;
               "adSourceStatusId": integer;
               "country": string;
               "impressions": integer;
               "quarter": float;
               "adSourcePriorityId": integer;
               "urlErrors": integer;
     };

Parameters

Parameter

Description

Required/Optional?

type

A list of requested types.

  • adsources-publisher
  • auctions-publisher
  • bids-diagnostics-publisher
  • deals-publisher
  • floors-potential-publisher
  • floors-recorded-publisher
  • publisher-valid-bids

Required

dimensions

A list of requested dimensions.

  • adSource (string)
  • adSourceAssignedUser (string)
  • adSourceId (integer)
  • adSourcePriority (string)
  • adSourceStatus (string)
  • adSourceType (string)
  • adUnit (string)
  • appBundleId (string)
  • brand (string)
  • channel (string)
  • country (string)
  • currency (string)
  • day (datetime)
  • environmentType (string)
  • hour (integer)
  • marketplace (string)
  • marketplaceId (string)
  • month (string)
  • nameInAppStore (string)
  • platform (string)
  • platformFamily (string)
  • playerSize (string)
  • publisher (string)
  • quarter (float)
  • supply (string)
  • supplyDomain (string)
  • supplySeat (string)
  • week (datetime)
  • year (integer)

At least one value is required

metrics

A list of requested metrics.

  • avgAdSourceExecTime (integer)
  • avgFloorPrices (float)
  • badBehaviorBids (integer)
  • bidsNoAdMarkup (integer)
  • bidsTimeout (integer)
  • bidsTrumped (integer)
  • fills (integer)
  • fixedPriceErrors (integer)
  • generalErrors (integer)
  • grossRevenue (float)
  • impressions (integer)
  • invalidBids (integer)
  • netCpm (float)
  • netRevenue (float)
  • rtbErrors (integer)
  • tries (integer)
  • urlErrors (integer)

At least one value is required