1SELECT LEFT(event_date, 6) Month, event_name event, campaign, Count(DISTINCT user_pseudo_id) clicks
2FROM `tc-da-1.turing_data_analytics.raw_events`
3WHERE (campaign LIKE 'NewYear%' AND event_date LIKE '202101%' AND event_name = 'page_view') OR (campaign LIKE 'BlackFriday%' AND event_date LIKE '202011%' AND event_name = 'page_view')
4GROUP BY 1,2,3
5ORDER BY 1,3