TRUSTX

Switchboard supports ingestion of daily TRUSTX programmatic metrics reports via email-based ingestion. Learn more about email based data ingestion.

Scheduling

Email based reports can be scheduled to run at regular intervals, or at specific hours of the day. By default, the connector will run once a day at 6am PT. See Hourly Scheduling for more information.

Sample Switchboard Script

import trustx_raw from {
    type: "s3_ng";
    pattern: "s3://switchboard-customer-bucket/email-ingest/trustx/YYYYMMDD_*.csv";
    datetime_pattern: "*/YYYYMMDD_*";
    key: "switchboard_customer_bucket_credential";
} using {
    filename: string;
    ad_unit: integer;
    ad_unit_name: string;
    country: string;
    country_name: string;
    dsp: integer;
    dsp_name: string;
    buyer_id: string;
    buyer_id_name: string;
    landing_page_domain: string;
    creative_size: string;
    day: datetime;
    total_traffic: integer;
    bid_offers: integer;
    yes_bids: integer;
    no_bids: integer;
    imps_served: integer;
    imps: integer;
    imps_viewable: float;
    billable_event: integer;
    bid_ecpm: float;
    adv_spend: float;
    adv_ecpm_sll_imps: float;
    adv_ecpm: float;
    pub_payout: float;
    pub_ecpm_all_imps: float;
    pub_ecpm: float;
};