FACEBOOK_CUSTOM_REPORTS = [ { "action_breakdowns": ["action_video_type", "action_type"], "action_report_time": "impression", "aggregation": "Day", "click_attribution_window": "DAY_7", "config_type": "Custom", "engaged_view_attribution_window": "NONE", "fields": [ "adset_name", "spend", "ad_id", "cost_per_action_type", "video_p25_watched_actions", "inline_link_click_ctr", "cpm", "ad_name", "estimated_ad_recallers", "impressions", "cost_per_inline_link_click", "inline_link_clicks", "cpc", "reach", "actions", "ctr", "frequency", "account_id", "video_thruplay_watched_actions", ], "level": "ad", "table_name": "fansifter_ad", "use_unified_attribution_setting": True, "view_attribution_window": "DAY_1", }, { "action_breakdowns": ["action_video_type", "action_type"], "action_report_time": "impression", "aggregation": "Day", "breakdowns": ["country"], "click_attribution_window": "DAY_7", "config_type": "Custom", "engaged_view_attribution_window": "NONE", "fields": [ "adset_name", "spend", "ad_id", "cost_per_action_type", "video_p25_watched_actions", "inline_link_click_ctr", "cpm", "ad_name", "estimated_ad_recallers", "impressions", "cost_per_inline_link_click", "inline_link_clicks", "cpc", "reach", "actions", "ctr", "frequency", "account_id", "video_thruplay_watched_actions", ], "level": "ad", "table_name": "fansifter_ad_by_country", "use_unified_attribution_setting": True, "view_attribution_window": "DAY_1", }, ] TIKTOK_CUSTOM_REPORTS = [ { "aggregate": "daily", "dimensions": ["country_code", "ad_id"], "metrics": [ "video_views_p50", "comments", "reach", "follows", "clicks_on_music_disc", "video_views_p25", "impressions", "video_views_p75", "shares", "video_views_p100", "spend", "clicks", "video_play_actions", "engaged_view", "profile_visits", "engaged_view_15s", "video_watched_2s", "conversion", "video_watched_6s", "likes", "download_start", "complete_payment", "add_billing", "on_web_order", "result", "purchase", "achieve_level", "add_payment_info", "login", "initiate_checkout", "app_install", "in_app_ad_click", "checkout", "registration", "onsite_add_billing", "average_video_play", ], "report_type": "auction_basic_ad_report", "table_name": "fansifter_ad_by_country", }, { "aggregate": "daily", "dimensions": ["ad_id"], "metrics": [ "on_web_order", "video_views_p50", "comments", "reach", "follows", "clicks_on_music_disc", "video_views_p25", "impressions", "video_views_p75", "shares", "video_views_p100", "spend", "clicks", "engaged_view", "profile_visits", "video_watched_2s", "engaged_view_15s", "conversion", "video_watched_6s", "likes", "onsite_add_billing", "download_start", "add_billing", "login", "result", "complete_payment", "purchase", "add_payment_info", "app_install", "registration", "initiate_checkout", "in_app_ad_click", "checkout", "achieve_level", "average_video_play", "average_video_play_per_user", ], "report_type": "auction_basic_ad_report", "table_name": "fansifter_ad", }, ] GOOGLE_CUSTOM_REPORTS = [ { "table": "fansifter_ad", "report_type": "ad_group_ad", "fields": [ "metrics.conversions_value", "metrics.conversions", "metrics.interactions", "ad_group_ad.ad.id", "metrics.interaction_event_types", "campaign.id", "metrics.impressions", "metrics.view_through_conversions", "ad_group.id", "metrics.clicks", "customer.id", "metrics.cost_per_conversion", "metrics.cost_micros", "segments.date", "metrics.video_trueview_views", "metrics.video_quartile_p25_rate", "metrics.video_quartile_p50_rate", "metrics.video_quartile_p75_rate", "metrics.video_quartile_p100_rate", ], }, { "table": "fansifter_ad_group_by_country", "report_type": "geographic_view", "fields": [ "metrics.conversions", "metrics.interactions", "metrics.interaction_event_types", "campaign.id", "metrics.impressions", "metrics.view_through_conversions", "ad_group.id", "metrics.all_conversions", "metrics.clicks", "geographic_view.country_criterion_id", "metrics.cost_micros", "segments.date", "metrics.video_trueview_views", ], }, ]