Beachfront

Beachfront is a video ad management platform. The Beachfront connector automates reporting on ad performance, including revenue and impression metrics.

• Prerequisites
• Scheduling
• Parameters
• Sample Switchboard Script

Prerequisites

To configure access to the Beachfront connector, you need:

• API Token

To obtain the API token:

• Log in to the Dashboard.
• Go to Settings and select API.

NOTE: If the Generate Token option is unavailable, request API access from your Beachfront Account Manager.

Scheduling

The Beachfront 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

keys string list

required

at least one of the following values:

• account (string, interchangeable with ‘company’)
• day (datetime)
• country (string)
• company (string, interchangeable with ‘account’)
• inventory (string)
• domain (string)
• marketplace (string)
• publisher (string)
• playerSize (string)
• platform (string)

metrics string list

required

at least one of the following values

• clicks (float)
• cpm (float)
• impressions (integer)
• revenue (float)

fetch_by_domain boolean

optional

Sample Switchboard Script

download beachfront_raw from {
    type: "beachfront";
    key: "beachfront_key"; 
    fetch_by_domain: false;
    keys: ["day", "bundle", "country", "account", "inventory", "marketplace", "playerSize", "platform"];
    metrics: ["clicks","cpm", "impressions", "revenue"]; 
    timezone: "US/Pacific";
    delay_hours: 4;
} using {
        day: datetime;
        "bundle": string;
        country: string;
        inventory: string;
        marketplace: string;
        account: string;
        playerSize: string;
        platform: string;
        clicks: integer;
        impressions: integer;
        revenue: float;
        cpm: float;
};

table beachfront is select
    <<raw.$c as "$c" for c in raw,
    processing_datetime() as switchboard_processing_time
from beachfront_raw as raw;

upload beachfront to {
    type: "bigquery:load";
    project: "x";
    dataset: "x";
    table: "beachfront_YYYYMMDD";
    key: "x";
    primary_source_name: "beachfront_raw";
    truncate: true;
};