Amobee

Amobee reports are supported through the Switchboard SFTP Connector. To ensure that any restatements are ingested, we recommend using a 14-day lookback period (by setting the lookback_days parameter to 14).

Sample Switchboard Script

import amobee from {
    type: "sftp_ng";
    pattern: "/amobee/Amobee*standard*-YYYYMMDD.csv";
    datetime_pattern: "*-YYYYMMDD.csv";
    key: "amobee_sftp_key";
    lookback_days: 14;
    period_hours: 1;
} using {
    filename: string;
    Day: datetime;
    Campaign_Name: string;
    Operative_Order_ID: string;
    Operative_Line_Item_ID: string;
    Rate: string;
    Meredith_Product_Name: string;
    Platform: string;
    Site_Name: string;
    Video_Duration: string;
    Ad_Set_Name: string;
    Creative_Name: string;
    Post_ID: string;
    Ad_Account_Name: string;
    Ad_Account_ID: string;
    Spend: string;
    Billable_Metric: string;
    Metrics_Impressions: string;
    CTR: string;
    Page_Views: string;
    Page_View_Rate: string;
    Paid_Clicks_to_Play: string;
    Meredith_Engagements: string;
    Meredith_Engagement_Rate: string;
    Total_Saves: string;
    Total_Social_Shares: string;
    Total_Social_Comments: string;
    Total_Social_Reactions: string;
    Total_Closeups_PIN: string;
    TW_Engagements: string;
    Social_Follows_TW: string;
    Media_Engagements: string;
    All_Clicks: string;
    View_Content: string;
    Photo_Views_FB: string;
    Page_Mentions: string;
    Page_Likes_FB: string;
    Page_Engagement_FB: string;
    Website_Actions_FB: string;
    Canvas_AVG_View_Percent: string;
    Canvas_AVG_View_Time: string;
    Video_Views: string;
    Video_Views_25: string;
    Video_Views_50: string;
    Video_Views_75: string;
    Video_Fully_Played: string;
    VCR: string;
    VVR: string;
    ThruPlays: string;
    Video_10_Second_Video_Views: string;
    Video_Views_30s: string;
    Video_Avg_Duration_Seconds: string;
    Video_Starts_TW: string;
    Total_Impressions_PIN: string;
    Earned_Video_Views_25_PIN: string;
    Earned_Video_Views_50_PIN: string;
    Earned_Video_Views_75_PIN: string;
    Earned_Video_Fully_Paid_PIN: string;
    Total_Video_Completions_PIN: string;
    VCR_PIN_Paid: string;
    Total_VCR_PIN: string;
    Total_VVR_PIN: string;
    Total_Save_Rate_PIN: string;
    Total_Clickthrough_Rate_PIN: string;
    Total_Closeup_Rate_PIN: string;
    CPM: string;
    Cost_Per_Page_View: string;
    CPVV: string;
    CPV_PIN_Total: string;
    CPV_PIN_Paid: string;
    Cost_Per_Total_Saves_PIN: string;
    Cost_Per_Total_Clickthrough_PIN: string;
    Cost_Per_Total_Closeups_PIN: string;
};