MediaGrid

The Switchboard MediaGrid connector provides automated ingestion of header bidding reports.

• Prerequisites
• Scheduling
• Parameters
• Sample Switchboard Script

Prerequisites

To configure access to the MediaGrid Connector, you need:

• Project Id
• API Key

To obtain an API Key contact your MediaGrid Account Manager.

Scheduling

The MediaGrid 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.

Parameters

dimensions string list

required

allowed values include:

• app.bundle
• bad_request_reason
• broker_id
• ccpa
• client_ab_test_group
• demand_source_new
• dsp.creative_id
• gdpr.status
• gdpr.version
• granularity_day
• granularity_hour
• granularity_month
• granularity_quarter
• granularity_week
• granularity_year
• grid_dsp_id
• hour
• is_amp
• publisher.ad_unit_id
• publisher.domain
• publisher.media_type
• publisher.size
• seat_id
• supply_bid_amount_bucket
• user_languages
• user.agent.browser.name
• user.agent.browser.version
• user.agent.device.maker
• user.agent.device.model
• user.agent.device.type
• user.agent.os.name
• user.agent.os.version
• user.geo.country
• user.geo.region
• user.is_matched

metrics string list

required

allowed values include:

• bid_cpm
• bid_rate
• imps
• media_revenue_cpm
• pub_payout
• win_rateyes_bids

project string

required

A string containing the MediaGrid project.

report_timezone numeric

optional

A numeric offset from UTC time. Acceptable values are -12 to 12

slicer string

required

A string containing the MediaGrid account name.

Sample Switchboard Script

import mediagrid from {
    type: "mediagrid";
    key: "mediagrid_key";
    slicer: "publisher_name";
    project: "publisher_project";
    metrics: ["avails","bid_rate","bid_cpm", "imps", "media_revenue_cpm", "pub_payout", "win_rate"];
    dimensions: ["publisher.domain", "granularity_week","granularity_day","publisher.ad_unit_id"];
    report_timezone: 0;
} using { 
    report_datetime: datetime;
    'Publisher Domain': string;
    'Week': string;
    'Day': datetime;
    'Ad Unit': integer;
    'Avails':  integer;
    'Bid Rate': float;
    'Bid eCPM': float;
    'Imps': integer;
    'Media Revenue eCPM': float;
    'Net Media Revenue': float;
    'Win Rate': float;
};