class TimeframeMonths: THREE = "THREE" SIX = "SIX" TWELVE = "TWELVE" TWENTY_FOUR = "TWENTY_FOUR" ALL_TIME = "ALL_TIME" class FivetranEnvironments: DEV_SNOWFLAKE = "partial_lakhs" QA_SNOWFLAKE = "adorned_litter" STAGE_SNOWFLAKE = "patron_enlistment" PROD_SNOWFLAKE = "movable_closing" class TiktokReportTypes: REPORT_TYPES = '' class FacebookReports: publisher_platform_daily_report = { "table_name": "publisher_platform_daily_report", "config_type": "Custom", "fields": [ "cost_per_conversion", "adset_name", "unique_actions", "adset_id", "video_p100_watched_actions", "actions", "clicks", "cost_per_unique_click", "unique_link_clicks_ctr", "unique_outbound_clicks_ctr", "labels", "inline_link_click_ctr", "cost_per_outbound_click", "inline_post_engagement", "cost_per_thruplay", "video_avg_time_watched_actions", "account_id", "cost_per_unique_action_type", "cost_per_inline_link_click", "cpm", "unique_outbound_clicks", "cpp", "outbound_clicks", "frequency", "account_name", "unique_inline_link_clicks", "spend", "reach", "unique_inline_link_click_ctr", "cost_per_action_type", "ctr", "cost_per_inline_post_engagement", "video_p75_watched_actions", "impressions", "action_values", "unique_ctr", "cost_per_unique_inline_link_click", "campaign_id", "inline_link_clicks", "objective", "video_30_sec_watched_actions", "campaign_name", "video_thruplay_watched_actions", "video_p25_watched_actions", "cost_per_unique_outbound_click", "outbound_clicks_ctr", "video_p50_watched_actions", "unique_clicks", "video_play_actions", "conversions", "cpc" ], "breakdowns": ["publisher_platform"], "action_breakdowns": ["action_type"], "aggregation": "Day", "action_report_time": "impression", "click_attribution_window": "DAY_7", "view_attribution_window": "DAY_1" } country_daily_report = { "table_name": "country_daily_report", "config_type": "Custom", "fields": [ "cpp", "video_p25_watched_actions", "campaign_id", "unique_clicks", "video_play_actions", "conversions", "cost_per_unique_action_type", "inline_link_clicks", "frequency", "video_thruplay_watched_actions", "cost_per_action_type", "cost_per_inline_link_click", "cost_per_conversion", "outbound_clicks", "video_p75_watched_actions", "clicks", "objective", "actions", "cost_per_thruplay", "cost_per_outbound_click", "cpm", "account_id", "unique_inline_link_click_ctr", "inline_post_engagement", "cost_per_unique_click", "reach", "outbound_clicks_ctr", "cost_per_inline_post_engagement", "adset_name", "adset_id", "cost_per_unique_outbound_click", "unique_inline_link_clicks", "video_30_sec_watched_actions", "labels", "inline_link_click_ctr", "spend", "video_p50_watched_actions", "unique_ctr", "unique_actions", "action_values", "unique_link_clicks_ctr", "unique_outbound_clicks", "unique_outbound_clicks_ctr", "video_p100_watched_actions", "video_avg_time_watched_actions", "campaign_name", "impressions", "cost_per_unique_inline_link_click", "cpc", "account_name", "ctr" ], "breakdowns": ["country"], "action_breakdowns": ["action_type"], "aggregation": "Day", "action_report_time": "impression", "click_attribution_window": "DAY_7", "view_attribution_window": "DAY_1" } age_gender_daily_report = { "table_name": "age_gender_daily_report", "config_type": "Custom", "fields": [ "cpp", "cost_per_conversion", "video_p100_watched_actions", "inline_link_clicks", "video_p50_watched_actions", "cost_per_unique_inline_link_click", "video_avg_time_watched_actions", "unique_outbound_clicks", "cost_per_inline_link_click", "cpm", "unique_inline_link_click_ctr", "clicks", "unique_outbound_clicks_ctr", "cpc", "objective", "reach", "cost_per_thruplay", "video_p25_watched_actions", "conversions", "inline_link_click_ctr", "account_name", "unique_inline_link_clicks", "cost_per_unique_action_type", "ctr", "unique_actions", "campaign_name", "adset_id", "cost_per_outbound_click", "cost_per_action_type", "labels", "actions", "cost_per_unique_outbound_click", "account_id", "unique_link_clicks_ctr", "video_play_actions", "inline_post_engagement", "action_values", "adset_name", "unique_clicks", "impressions", "spend", "cost_per_unique_click", "unique_ctr", "campaign_id", "video_30_sec_watched_actions", "video_p75_watched_actions", "outbound_clicks", "cost_per_inline_post_engagement", "video_thruplay_watched_actions", "frequency", "outbound_clicks_ctr" ], "breakdowns": ["gender", "age"], "action_breakdowns": ["action_type"], "aggregation": "Day", "action_report_time": "impression", "click_attribution_window": "DAY_7", "view_attribution_window": "DAY_1" } link_url_asset_daily_report = { "table_name": "link_url_asset_daily_report", "config_type": "Custom", "fields": [ "video_p25_watched_actions", "cpp", "unique_clicks", "campaign_id", "conversions", "video_play_actions", "cost_per_unique_action_type", "inline_link_clicks", "frequency", "video_thruplay_watched_actions", "cost_per_action_type", "cost_per_inline_link_click", "cost_per_conversion", "video_p75_watched_actions", "outbound_clicks", "clicks", "objective", "actions", "cost_per_thruplay", "cost_per_outbound_click", "cpm", "unique_inline_link_click_ctr", "account_id", "inline_post_engagement", "cost_per_unique_click", "reach", "outbound_clicks_ctr", "cost_per_inline_post_engagement", "adset_name", "adset_id", "cost_per_unique_outbound_click", "unique_inline_link_clicks", "video_30_sec_watched_actions", "labels", "inline_link_click_ctr", "spend", "unique_actions", "unique_ctr", "video_p50_watched_actions", "action_values", "unique_outbound_clicks", "unique_link_clicks_ctr", "video_p100_watched_actions", "unique_outbound_clicks_ctr", "video_avg_time_watched_actions", "campaign_name", "impressions", "cost_per_unique_inline_link_click", "cpc", "account_name", "ctr" ], "breakdowns": ["link_url_asset"], "action_breakdowns": ["action_type"], "aggregation": "Day", "action_report_time": "impression", "click_attribution_window": "DAY_7", "view_attribution_window": "DAY_1" } ad_publisher_platform_position_daily_report = { "table_name": "ad_publisher_platform_position_daily_report", "config_type": "Custom", "fields": [ "cost_per_conversion", "adset_name", "ad_name", "unique_actions", "adset_id", "ad_id", "video_p100_watched_actions", "actions", "clicks", "cost_per_unique_click", "unique_link_clicks_ctr", "unique_outbound_clicks_ctr", "labels", "inline_link_click_ctr", "cost_per_outbound_click", "inline_post_engagement", "cost_per_thruplay", "video_avg_time_watched_actions", "account_id", "cost_per_unique_action_type", "cost_per_inline_link_click", "cpm", "unique_outbound_clicks", "cpp", "outbound_clicks", "frequency", "account_name", "unique_inline_link_clicks", "spend", "reach", "unique_inline_link_click_ctr", "cost_per_action_type", "ctr", "cost_per_inline_post_engagement", "video_p75_watched_actions", "impressions", "action_values", "unique_ctr", "cost_per_unique_inline_link_click", "campaign_id", "inline_link_clicks", "objective", "video_30_sec_watched_actions", "campaign_name", "video_thruplay_watched_actions", "video_p25_watched_actions", "cost_per_unique_outbound_click", "outbound_clicks_ctr", "video_p50_watched_actions", "unique_clicks", "video_play_actions", "conversions", "cpc" ], "breakdowns": ["publisher_platform", "platform_position"], "action_breakdowns": ["action_type"], "aggregation": "Day", "action_report_time": "impression", "click_attribution_window": "DAY_7", "view_attribution_window": "DAY_1" } ad_publisher_platform_daily_report = { "table_name": "ad_publisher_platform_daily_report", "config_type": "Custom", "fields": [ "cost_per_conversion", "adset_name", "ad_name", "unique_actions", "adset_id", "ad_id", "video_p100_watched_actions", "actions", "clicks", "cost_per_unique_click", "unique_link_clicks_ctr", "unique_outbound_clicks_ctr", "labels", "inline_link_click_ctr", "cost_per_outbound_click", "inline_post_engagement", "cost_per_thruplay", "video_avg_time_watched_actions", "account_id", "cost_per_unique_action_type", "cost_per_inline_link_click", "cpm", "unique_outbound_clicks", "cpp", "outbound_clicks", "frequency", "account_name", "unique_inline_link_clicks", "spend", "reach", "unique_inline_link_click_ctr", "cost_per_action_type", "ctr", "cost_per_inline_post_engagement", "video_p75_watched_actions", "impressions", "action_values", "unique_ctr", "cost_per_unique_inline_link_click", "campaign_id", "inline_link_clicks", "objective", "video_30_sec_watched_actions", "campaign_name", "video_thruplay_watched_actions", "video_p25_watched_actions", "cost_per_unique_outbound_click", "outbound_clicks_ctr", "video_p50_watched_actions", "unique_clicks", "video_play_actions", "conversions", "cpc" ], "breakdowns": ["publisher_platform"], "action_breakdowns": ["action_type"], "aggregation": "Day", "action_report_time": "impression", "click_attribution_window": "DAY_7", "view_attribution_window": "DAY_1" } google_reports = [ { "config_type": "Custom", "fields": [ "metrics.absolute_top_impression_percentage", "customer.currency_code", "customer.descriptive_name", "customer.time_zone", "metrics.active_view_cpm", "metrics.active_view_ctr", "metrics.active_view_impressions", "metrics.active_view_measurability", "metrics.active_view_measurable_cost_micros", "metrics.active_view_measurable_impressions", "metrics.active_view_viewability", "ad_group.id", "ad_group.name", "ad_group.status", "segments.ad_network_type", "ad_group_ad.ad.type", "metrics.all_conversions_from_interactions_rate", "metrics.all_conversions_value", "metrics.all_conversions", "metrics.average_cost", "metrics.average_cpc", "metrics.average_cpe", "metrics.average_cpm", "metrics.average_cpv", "metrics.average_page_views", "metrics.average_time_on_site", "ad_group.base_ad_group", "campaign.base_campaign", "ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text", "campaign.id", "campaign.name", "campaign.status", "metrics.clicks", "metrics.conversions_from_interactions_rate", "metrics.conversions_value", "metrics.conversions", "metrics.cost_micros", "metrics.cost_per_all_conversions", "metrics.cost_per_conversion", "metrics.cross_device_conversions", "metrics.ctr", "segments.date", "segments.day_of_week", "metrics.engagement_rate", "metrics.engagements", "customer.id", "ad_group_ad.ad.id", "metrics.impressions", "metrics.interaction_rate", "metrics.interaction_event_types", "metrics.interactions", "segments.month", "ad_group_ad.status", "metrics.top_impression_percentage", "metrics.value_per_all_conversions", "metrics.value_per_conversion", "metrics.value_per_current_model_attributed_conversion", "metrics.video_quartile_p100_rate", "metrics.video_quartile_p25_rate", "metrics.video_quartile_p50_rate", "metrics.video_quartile_p75_rate", "metrics.video_view_rate", "metrics.video_views", "metrics.view_through_conversions", "segments.week", "segments.year" ], "report_type": "ad_group_ad", "table": "ad_performance_report" }, { "config_type": "Custom", "fields": [ "metrics.absolute_top_impression_percentage", "customer.currency_code", "customer.descriptive_name", "customer.time_zone", "metrics.active_view_cpm", "metrics.active_view_ctr", "metrics.active_view_impressions", "metrics.active_view_measurability", "metrics.active_view_measurable_cost_micros", "metrics.active_view_measurable_impressions", "metrics.active_view_viewability", "ad_group.id", "ad_group.name", "ad_group.status", "ad_group.type", "segments.ad_network_type", "metrics.all_conversions_from_interactions_rate", "metrics.all_conversions_value", "metrics.all_conversions", "metrics.average_cost", "metrics.average_cpc", "metrics.average_cpe", "metrics.average_cpm", "metrics.average_cpv", "metrics.average_page_views", "ad_group.base_ad_group", "campaign.base_campaign", "campaign.bidding_strategy", "campaign.bidding_strategy_type", "campaign.id", "campaign.name", "campaign.status", "metrics.clicks", "ad_group.display_custom_bid_dimension", "metrics.conversions_from_interactions_rate", "metrics.conversions_value", "metrics.conversions", "metrics.cost_micros", "metrics.cost_per_all_conversions", "metrics.cost_per_conversion", "ad_group.cpc_bid_micros", "ad_group.cpm_bid_micros", "ad_group.cpv_bid_micros", "metrics.cross_device_conversions", "metrics.ctr", "segments.date", "segments.day_of_week", "ad_group.effective_target_roas", "ad_group.effective_target_roas_source", "metrics.engagement_rate", "metrics.engagements", "customer.id", "metrics.impressions", "metrics.interaction_rate", "metrics.interaction_event_types", "metrics.interactions", "segments.month", "metrics.phone_impressions", "metrics.phone_calls", "metrics.phone_through_rate", "metrics.relative_ctr", "ad_group.effective_target_cpa_micros", "ad_group.effective_target_cpa_source", "metrics.top_impression_percentage", "metrics.value_per_all_conversions", "metrics.value_per_conversion", "metrics.value_per_current_model_attributed_conversion", "metrics.video_quartile_p100_rate", "metrics.video_quartile_p25_rate", "metrics.video_quartile_p50_rate", "metrics.video_quartile_p75_rate", "metrics.video_view_rate", "metrics.video_views", "metrics.view_through_conversions", "segments.week", "segments.year" ], "report_type": "ad_group", "table": "adgroup_performance_report" }, { "config_type": "Custom", "fields": [ "ad_group.base_ad_group", "ad_group.id", "ad_group.name", "ad_group.status", "ad_group_criterion.age_range.type", "ad_group_criterion.bid_modifier", "ad_group_criterion.criterion_id", "ad_group_criterion.effective_cpc_bid_micros", "ad_group_criterion.effective_cpc_bid_source", "ad_group_criterion.effective_cpm_bid_micros", "ad_group_criterion.effective_cpm_bid_source", "ad_group_criterion.status", "campaign.base_campaign", "campaign.bidding_strategy", "campaign.bidding_strategy_type", "campaign.id", "campaign.name", "campaign.status", "customer.currency_code", "customer.descriptive_name", "customer.id", "customer.time_zone", "metrics.active_view_cpm", "metrics.active_view_ctr", "metrics.active_view_impressions", "metrics.active_view_measurability", "metrics.active_view_measurable_cost_micros", "metrics.active_view_measurable_impressions", "metrics.active_view_viewability", "metrics.all_conversions", "metrics.all_conversions_from_interactions_rate", "metrics.all_conversions_value", "metrics.average_cost", "metrics.average_cpc", "metrics.average_cpe", "metrics.average_cpm", "metrics.average_cpv", "metrics.clicks", "metrics.conversions", "metrics.conversions_from_interactions_rate", "metrics.conversions_value", "metrics.cost_micros", "metrics.cost_per_all_conversions", "metrics.cost_per_conversion", "metrics.cross_device_conversions", "metrics.ctr", "metrics.engagement_rate", "metrics.engagements", "metrics.impressions", "metrics.interaction_event_types", "metrics.interaction_rate", "metrics.interactions", "metrics.value_per_all_conversions", "metrics.value_per_conversion", "metrics.video_quartile_p100_rate", "metrics.video_quartile_p25_rate", "metrics.video_quartile_p50_rate", "metrics.video_quartile_p75_rate", "metrics.video_view_rate", "metrics.video_views", "metrics.view_through_conversions", "segments.ad_network_type", "segments.date", "segments.day_of_week", "segments.month", "segments.week", "segments.year" ], "report_type": "age_range_view", "table": "age_range_performance_report" }, { "config_type": "Custom", "fields": [ "metrics.absolute_top_impression_percentage", "customer.currency_code", "customer.descriptive_name", "customer.time_zone", "metrics.active_view_cpm", "metrics.active_view_ctr", "metrics.active_view_impressions", "metrics.active_view_measurability", "metrics.active_view_measurable_cost_micros", "metrics.active_view_measurable_impressions", "metrics.active_view_viewability", "segments.ad_network_type", "metrics.all_conversions_from_interactions_rate", "metrics.all_conversions_value", "metrics.all_conversions", "campaign_budget.amount_micros", "metrics.average_cost", "metrics.average_cpc", "metrics.average_cpe", "metrics.average_cpm", "metrics.average_cpv", "metrics.average_page_views", "campaign.base_campaign", "campaign.bidding_strategy", "bidding_strategy.name", "campaign.bidding_strategy_type", "campaign.campaign_budget", "campaign.id", "campaign.name", "campaign.status", "metrics.clicks", "metrics.conversions_from_interactions_rate", "metrics.conversions_value", "metrics.conversions", "metrics.cost_micros", "metrics.cost_per_all_conversions", "metrics.cost_per_conversion", "metrics.cost_per_current_model_attributed_conversion", "metrics.cross_device_conversions", "metrics.ctr", "segments.date", "campaign.end_date", "metrics.engagement_rate", "metrics.engagements", "customer.id", "campaign_budget.has_recommended_budget", "metrics.impressions", "metrics.interaction_rate", "metrics.interaction_event_types", "metrics.interactions", "metrics.invalid_click_rate", "metrics.invalid_clicks", "campaign.maximize_conversion_value.target_roas", "segments.month", "campaign_budget.period", "campaign_budget.recommended_budget_amount_micros", "metrics.relative_ctr", "campaign.start_date", "metrics.top_impression_percentage", "campaign_budget.total_amount_micros", "metrics.value_per_all_conversions", "metrics.value_per_conversion", "metrics.value_per_current_model_attributed_conversion", "metrics.video_quartile_p100_rate", "metrics.video_quartile_p25_rate", "metrics.video_quartile_p50_rate", "metrics.video_quartile_p75_rate", "metrics.video_view_rate", "metrics.video_views", "metrics.view_through_conversions", "segments.week" ], "report_type": "campaign", "table": "campaign_group_performance_report" }, { "config_type": "Custom", "fields": [ "customer.currency_code", "customer.descriptive_name", "customer.time_zone", "ad_group.id", "ad_group.name", "ad_group.status", "segments.ad_network_type", "metrics.all_conversions_from_interactions_rate", "metrics.all_conversions_value", "metrics.all_conversions", "metrics.average_cost", "metrics.average_cpc", "metrics.average_cpe", "metrics.engagements", "metrics.engagement_rate", "metrics.average_cpm", "metrics.average_cpv", "ad_group.base_ad_group", "campaign.base_campaign", "ad_group_criterion.bid_modifier", "campaign.bidding_strategy", "campaign.bidding_strategy_type", "campaign.id", "campaign.name", "campaign.status", "metrics.clicks", "metrics.conversions_from_interactions_rate", "metrics.conversions_value", "metrics.conversions", "metrics.cost_micros", "metrics.cost_per_all_conversions", "metrics.cost_per_conversion", "ad_group_criterion.effective_cpc_bid_source", "ad_group_criterion.effective_cpm_bid_micros", "ad_group_criterion.effective_cpm_bid_source", "ad_group_criterion.gender.type", "metrics.cross_device_conversions", "metrics.ctr", "segments.date", "segments.day_of_week", "customer.id", "ad_group_criterion.criterion_id", "metrics.impressions", "metrics.interaction_rate", "metrics.interaction_event_types", "metrics.interactions", "segments.month", "ad_group_criterion.status", "metrics.value_per_all_conversions", "metrics.value_per_conversion", "metrics.video_view_rate", "metrics.video_views", "metrics.view_through_conversions", "segments.week", "segments.year", "metrics.video_quartile_p100_rate", "metrics.video_quartile_p25_rate", "metrics.video_quartile_p50_rate", "metrics.video_quartile_p75_rate", "metrics.active_view_cpm", "metrics.active_view_ctr", "metrics.active_view_impressions", "metrics.active_view_measurability", "metrics.active_view_measurable_cost_micros", "metrics.active_view_measurable_impressions", "metrics.active_view_viewability" ], "report_type": "gender_view", "table": "gender_performance_report" }, { "config_type": "Custom", "fields": [ "customer.currency_code", "customer.descriptive_name", "customer.time_zone", "ad_group.id", "ad_group.name", "ad_group.status", "segments.ad_network_type", "metrics.all_conversions_from_interactions_rate", "metrics.all_conversions_value", "metrics.all_conversions", "metrics.average_cost", "metrics.average_cpc", "metrics.average_cpm", "metrics.average_cpv", "campaign.id", "campaign.name", "campaign.status", "metrics.clicks", "metrics.conversions_from_interactions_rate", "metrics.conversions_value", "metrics.conversions", "metrics.cost_micros", "metrics.cost_per_all_conversions", "metrics.cost_per_conversion", "geographic_view.country_criterion_id", "metrics.cross_device_conversions", "metrics.ctr", "segments.date", "segments.day_of_week", "customer.id", "metrics.impressions", "metrics.interaction_rate", "metrics.interaction_event_types", "metrics.interactions", "segments.month", "metrics.value_per_all_conversions", "metrics.value_per_conversion", "metrics.video_view_rate", "metrics.video_views", "metrics.view_through_conversions", "segments.week", "segments.year" ], "report_type": "geographic_view", "table": "geo_performance_report" }, { "config_type": "Custom", "fields": [ "campaign.status", "detail_placement_view.target_url", "campaign.name", "ad_group.name", "segments.date", "customer.descriptive_name", "customer.currency_code", "metrics.conversions", "campaign.id", "ad_group.id", "metrics.clicks" ], "report_type": "detail_placement_view", "table": "final_url_report" } ]