select sum(clicks_counts) as clicks_count,
    sum(engagements_counts) as engagements_counts,
	sum(impressions_counts) as distinct_impressions_counts,
	sum(impressions_dups_counts) as duplicate_impressions_count,
	sum(impressions_counts) + sum(impressions_dups_counts) as total_impressions_counts,
	sum(conversions_counts) as conversions_counts,
	sum(views_counts) as views_count,
	sum(geo_events_counts) as geo_events_counts,
	sum(poi_visits_counts) as poi_visits_counts,
	sum(id_syncs_counts) as id_syncs_counts,
	sum(text_clicks_counts) as text_clicks_counts
from collation_hourly_v6_3_counts
group by event_date;