Фильтр в тос:

date > "2017-01-01" AND date < "2017-01-12" AND account_id == "886287158147654" AND campaign_name == "[Gta_gp] US gta_gp_video-test_mNF_2016-12-28_US_payers_40-80_f2460"

запрос в athena:

SELECT campaign_id, adset_id, SUM(amount_spend), SUM(clicks), SUM(impressions)
FROM (
	SELECT report.account_id,
		   report.campaign_id,
		   report.campaign_name,
		   report.adset_id,
		   report.adset_name,
		   traftype,
		   report.DATE,
		   adcamp.configured_status AS campaigns_configured_status,
		   adcamp.effective_status AS campaigns_effective_status,
		   countries,
		   behaviors,
		   AGE,
		   created_time,
		   custom_audiences,
		   excluded_custom_audiences,
		   page_types,
		   genders,
		   adset.configured_status AS adset_configured_status,
		   adset.effective_status AS adset_effective_status,
		   COALESCE(adset.bid_amount, 0) AS bid_amount,
		   adset.is_autobid,
		   adset.daily_budget,
		   adins.objective,
		   adins.amount_spend,
		   adins.impressions,
		   adins.clicks,
		   adins.installs,
		   COALESCE(payers_count_1, 0) AS player_count_1,
		   COALESCE(payers_count_2, 0) AS player_count_2,
		   COALESCE(payers_count_3, 0) AS player_count_3,
		   COALESCE(payers_count_4, 0) AS player_count_4,
		   COALESCE(payers_count_5, 0) AS player_count_5,
		   COALESCE(payers_count_6, 0) AS player_count_6,
		   COALESCE(payers_count_7, 0) AS player_count_7,
		   COALESCE(payers_count_15, 0) AS player_count_15,
		   COALESCE(payers_count_30, 0) AS player_count_30,
		   COALESCE(payers_count_45, 0) AS player_count_45,
		   COALESCE(payers_count_60, 0) AS player_count_60,
		   COALESCE(payers_count_90, 0) AS player_count_90,
		   COALESCE(payers_count_120, 0) AS player_count_120,
		   COALESCE(payers_count_150, 0) AS payers_count_150,
		   COALESCE(payers_count_total, 0) AS payers_count_total,
		   COALESCE(revenue_1_days, 0.0) AS revenue_1_days,
		   COALESCE(revenue_2_days, 0.0) AS revenue_2_days,
		   COALESCE(revenue_3_days, 0.0) AS revenue_3_days,
		   COALESCE(revenue_4_days, 0.0) AS revenue_4_days,
		   COALESCE(revenue_5_days, 0.0) AS revenue_5_days,
		   COALESCE(revenue_6_days, 0.0) AS revenue_6_days,
		   COALESCE(revenue_7_days, 0.0) AS revenue_7_days,
		   COALESCE(revenue_15_days, 0.0) AS revenue_15_days,
		   COALESCE(revenue_30_days, 0.0) AS revenue_30_days,
		   COALESCE(revenue_45_days, 0.0) AS revenue_45_days,
		   COALESCE(revenue_60_days, 0.0) AS revenue_60_days,
		   COALESCE(revenue_90_days, 0.0) AS revenue_90_days,
		   COALESCE(revenue_120_days, 0.0) AS revenue_120_days,
		   COALESCE(revenue_150_days, 0.0) AS revenue_150_days,
		   COALESCE(tutorial_passed_count, 0) AS tutorial_passed_count,
		   COALESCE(revenue_current_total, 0.0) AS revenue_current_total
	FROM marketing_system.fb_ads_calc_params report
	  LEFT JOIN marketing_system.fb_ad_campaign adcamp
			 ON report.account_id = adcamp.account_id
			AND report.campaign_id = adcamp.campaign_id
	  LEFT JOIN marketing_system.fb_ad_set adset
			 ON report.account_id = adset.account_id
			AND report.campaign_id = adset.campaign_id
			AND report.adset_id = adset.adset_id
	  JOIN marketing_system.fb_ads_insights adins
			 ON report.account_id = adins.account_id
			AND report.campaign_id = adins.campaign_id
			AND report.adset_name = adins.adset_name
			AND report.campaign_name = adins.campaign_name
			AND report.adset_id = adins.adset_id
			AND report.date = adins.date
)
WHERE campaign_name='[Gta_gp] US gta_gp_video-test_mNF_2016-12-28_US_payers_40-80_f2460' and
	date BETWEEN timestamp '2017-01-02 00:00:00.000' AND timestamp '2017-01-12 00:00:00.000'
	and  account_id = '886287158147654'
GROUP BY campaign_id, adset_id