Xandr (AppNexus)

import appnexus_network_analytics from {
    type: "appnexus_ng";
    key: "appnexus_key";
    report_type: "network_analytics";
    dimensions : [
       "day",
       "buyer_member_name",
       "advertiser_name",
       "deal_name",
       "brand_name"];
    metrics: [
       "imps",
       "clicks",
       "ctr",
       "total_convs",
       "convs_rate",
       "revenue",
       "rpm",
       "total_network_rpm",
       "cost",
       "cpm",
       "profit"];
} using {
    date: datetime;
    buyer_member_name: string;
    advertiser_name: string;
    deal_name: string;
    brand_name: string;
    imps: integer;
    clicks: integer;
    ctr: float;
    total_convs: integer;
    convs_rate: float;
    revenue: float;
    rpm: float;
    total_network_rpm: float;
    cost: float;
    cpm: float;
    profit: float;
};

download t from {
            type: "appnexus_ng";
            key: "appnexus_key";
            report_type: "network_device_analytics";
            dimensions: ["day","connection_type","imp_type"];
            metrics: ["imps","clicks","cost","cpm","booked_revenue","profit"];
} using {*};

download t from {
    type: "appnexus_ng";
    key: "appnexus_key";
    report_type: "publisher_analytics";
    dimensions: ["day","publisher_id"];
    metrics: ["clicks"];
    publisher_id: 2041265;    \\ <-- New parameter for publisher_analytics report
} using {*};

import seller_brand_review from {
    type: "appnexus_ng";
    key: "appnexus_key";
    report_type: "seller_brand_review";
    dimensions: [
        "month",
        "day",
        "buyer_member_id",
        "placement_id",
        "placement_name",
        "publisher_id",
        "geo_country",
        "geo_country_name",
        "imp_type_id",
        "creative_id",
        "site_id",
        "site_name",
        "brand_id",
        "brand_name",
        "payment_type",
        "revenue_type",
        "width",
        "height",
        "publisher_code",
        "site_code",
        "placement_code",
        "buyer_member_name",
        "media_type",
        "media_type_id",
        "publisher_name",
        "deal_id",
        "deal_name",
        "deal_code",
        "brand_offer_category_id",
        "brand_offer_category_name",
        "creative_audit_status_id",
        "creative_audit_status",
        "size"];
    metrics: [
        "imps",
        "clicks",
        "cost",
        "revenue",
        "booked_revenue",
        "reseller_revenue",
        "profit",
        "cpm",
        "total_convs",
        "convs_rate",
        "ctr",
        "rpm",
        "convs_per_mm",
        "imps_viewed",
        "view_measured_imps",
        "view_rate"];
} using {
    month: datetime;
    day: datetime;
    buyer_member_id: integer;
    placement_id: integer;
    placement_name: string;
    publisher_id: integer;
    geo_country: string;
    geo_country_name: string;
    imp_type_id: integer;
    creative_id: integer;
    site_id: integer;
    site_name: string;
    brand_id: integer;
    brand_name: string;
    payment_type: string;
    revenue_type: string;
    width: integer;
    height: integer;
    publisher_code: string;
    site_code: string;
    placement_code: string;
    buyer_member_name: string;
    media_type: string;
    media_type_id: integer;
    publisher_name: string;
    deal_id: integer;
    deal_name: string;
    deal_code: string;
    brand_offer_category_id: integer;
    brand_offer_category_name: string;
    creative_audit_status_id: integer;
    creative_audit_status: string;
    size: string;
    imps: integer;
    clicks: integer;
    cost: float;
    revenue: float;
    booked_revenue: float;
    reseller_revenue: float;
    profit: float;
    cpm: float;
    total_convs: integer;
    convs_rate: float;
    ctr: float;
    rpm: float;
    convs_per_mm: float;
    imps_viewed: integer;
    view_measured_imps: integer;
    view_rate: float;
};

import seller_fill_report from {
    type: "appnexus_ng";
    key: "appnexus_key";
    report_type: "seller_fill_and_delivery_network";
    dimensions: ["call_type",
       "day",
       "deal_id",
       "deal_name",
       "geo_country",
       "geo_country_name",
       "hour",
       "mobile_application_id",
       "month",
       "placement_id",
       "placement_name",
       "publisher_id",
       "publisher_name",
       "seller_member_id",
       "seller_member_name",
       "site_id",
       "site_name",
       "site_domain",
       "supply_type"];
    metrics: [
        "bid_sent_no_responses",
        "defaults",
        "default_no_responses",
        "filtered_requests",
        "imps_kept",
        "imps_resold",
        "psas_or_blanks",
        "seller_revenue",
        "total_ad_requests",
        "total_ad_responses",
        "video_default_errors",
        "video_player_errors"];
} using {
    call_type: string;
    day: datetime;
    deal_id: integer;
    deal_name: string;
    geo_country: string;
    geo_country_name: string;
    hour: datetime;
    mobile_application_id: string;
    month: datetime;
    placement_id: integer;
    placement_name: string;
    publisher_id: integer;
    publisher_name: string;
    seller_member_id: integer;
    seller_member_name: string;
    site_id: integer;
    site_name: string;
    site_domain: string;
    supply_type: string;
    bid_sent_no_responses: integer;
    defaults: integer;
    default_no_responses: integer;
    filtered_requests: integer;
    imps_kept: integer;
    imps_resold: integer;
    psas_or_blanks: integer;
    seller_revenue: float;
    total_ad_requests: integer;
    total_ad_responses: integer;
    video_default_errors: integer;
    video_player_errors: integer;
};

import seller_site_domain from {
    type: "appnexus_ng";
    key: "appnexus_key";
    report_type: "seller_site_domain";
    dimensions: [
        "month",
        "day",
        "seller_member_id",
        "seller_member_name",
        "content_category_id",
        "content_category_name",
        "site_id",
        "site_name",
        "site_domain",
        "placement_id",
        "placement_name",
        "publisher_id",
        "publisher_name",
        "imp_type_id",
        "imp_type_name",
        "audit_type_id",
        "audit_type_name",
        "exposed_for_resale_id",
        "exposed_for_resale",
        "domains_exposed_id",
        "domains_exposed",
        "operating_system_id",
        "operating_system_name",
        "supply_type",
        "mobile_application_id",
        "mobile_application_name",
        "fold_position_id",
        "fold_position",
        "age_bucket",
        "age_bucket_id",
        "gender",
        "is_remarketing"];
    metrics: [
        "imps",
        "clicks",
        "network_revenue",
        "imps_viewed",
        "view_measured_imps",
        "view_rate",
        "view_measurement_rate"];
} using {
    month: datetime;
    day: datetime;
    seller_member_id: integer;
    seller_member_name: string;
    content_category_id: integer;
    content_category_name: string;
    site_id: integer;
    site_name: string;
    site_domain: string;
    placement_id: integer;
    placement_name: string;
    publisher_id: integer;
    publisher_name: string;
    imp_type_id: integer;
    imp_type_name: string;
    audit_type_id: integer;
    audit_type_name: string;
    exposed_for_resale_id: integer;
    exposed_for_resale: string;
    domains_exposed_id: integer;
    domains_exposed: string;
    operating_system_id: integer;
    operating_system_name: string;
    supply_type: string;
    mobile_application_id: string;
    mobile_application_name: string;
    fold_position_id: integer;
    fold_position: string;
    age_bucket: string;
    age_bucket_id: string;
    gender: string;
    is_remarketing: boolean;
    imps: integer;
    clicks: integer;
    network_revenue: float;
    imps_viewed: integer;
    view_measured_imps: integer;
    view_rate: float;
    view_measurement_rate: float;
};