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;
};